DATA BASE HOLISTIC COC QUESTIONS FOR LEVEL -4

1. Program is an exception with an exception handler of place in a program where you

want to handle the problem?

A. Body B. Try C. Catch D. Throw

2. Which one of the following is not true about the role and functions of management?
A. Good and services B. staffing C. communication D. planning
3. The entity relationship (E-R) model
a. Entities are represents by circle
b. It corresponds to row
c. It represents conceptual view
d. Attributes are represented by rectangle
4. The name for memory location where you store some data is called

a. Operators b. Expression c. Data type d. Variables

5. Running out of space on the drive used to store backup’s .All of the servers use the
same network location what you can do to save space with your backups while
maintaining the same number of backups
a. Use full backups
b. Use compressed backups
c. Use data compression
d. Use third-parity tools
6. Criteria that could not be considered when evaluating or assessing requirement
analysis?

A. Correctness C. Need assessment

B. Speed D. Consistency

7. Two concurrent transactions are active in your system. The first transaction
modifies data in table. The second transaction sees those modification before they are
actual committed to the data base. The first transaction then rolls back the
modifications .Type of data problem occurred

a. Phantom read c. Dirty read

b. Repeatable read d. No repeatable read

8. A laboratory testing procedure in which one test is done simultaneously on multiple

spacemen’s

A. Test B. Test case D. Batch test

scripting C. Scheduling

9. The issue that applies only to multi-user system is?

a. Concurrency c. System d. Durability

b. Media recovery recovery

10. While listing limitation of File Processing System identify the wrong statement?

A. Difficult in accessing data C. Data isolation and integrity

B. Concurrent access is possible

set by :-Mr.YEMAN YOSEF. Telegram. Jemal josef 09-93-67-91-57

DATA BASE HOLISTIC COC QUESTIONS FOR LEVEL -4
D. Data redundancy and
inconsistency

11. What are ACID property of transaction?

a. Atomicity – consistency-isolation –data base
b. Atomicity – consistency- inconsistency – durability
c. Atomicity – consistency-isolation-durability
d. Automatically - consistency-isolation-durability
12. Step-by-step sequence of activity or course of action (with definite start and end
point) that must be followed in the same order to correctly perform a task?
a. procedures
b. activities
c. practices
d. operational
13. a relation is a_________
a. subset of Cartesian product of a list of attributes
b. subset of Cartesian product of a list of domains
c. subset of Cartesian product of a list of tuples
d. subset of Cartesian product of a list of relations
14. Let say you are going to produce design document to design part of your organization.
Which one of the following is the correct order?
A. Introduction=>proposed software structure=>design goal=> data model
B. Introduction=>proposed software structure=>data model=>design goal
C. Introduction=>data model=> design goal=>proposed software structure
D. Introduction=> design goal=> proposed software structure=> data model
15. Which one of the following is the basic form of grant statement?
A. Grant ‘privilege list’ on ‘relation name or view name’ on ‘user/ role list;
B. Grant ‘privilege list ‘on ‘user/ role list’ to ‘relation name or view name;
C. Grant ‘privilege list’ on ‘relation name or view name ’to‘ user/ role list;
D. Grant ‘privilege list’ to ‘user/ role list;
16. What is the roll of rollback command?
a. saving the change made in database
b. to cancel any change in database made during the current transaction
c. save with delete made in database
d. update the transaction
17. If the maximum cardinality is equal to 1 in both direction of the relationship then , it
is classified as :

A. many -to – B. one -to -many D. one –to-one

many C. optional

18. Which one is true about sub queries?

a. sub queries is used order by clause
b. sub queries is used multiple columns
c. sub queries is used to return data that will be used in the main query
d. sub queries must be enclosed with in brackets
19. Which one is true about guidelines to create data model?
a. Identify the different data components, consider raw data and processed data

set by :-Mr.YEMAN YOSEF. Telegram. Jemal josef 09-93-67-91-57

DATA BASE HOLISTIC COC QUESTIONS FOR LEVEL -4
b. no repeat the step to optimize the model
c. test the model with similar scenarios
d. identify the relationship between the similar data components
20. The removal of transitivity of should be fulfilled with

A. second normal form C. fourth normal form

B. first normal form D. third normal form

21. How you understand hierarchical data model?

a. can be represented as a tree graph with records appearing as node
b. representing modern file processing
c. allow node to have more than one parent
d. Relationship represented by a rectangle
22. A UNION query is which of the following?
a. combines the output from no more than two queries and does not include the same
number of columns
b. combines the output from no more than two queries and must include same
number of columns
c. combines the output from multiple queries and does not include the same number
of columns
d. combines the output from multiple queries and must include the same number of
columns
23. The database language that allows you to access or maintain data in data base

a. DDL b. DCL c. DMM d. DML

24. Create table manager (ID numeric, Name varchar(20),budget numeric, Detail
varchar(30)), in order to ensure that the value of budget non- negative which of the
following should used?

A. Alter (budget<0)
B. Check (budget>0)
C. Alter (budget>0)
D. Check (budget<0)
25. Two tables can be connected with the UNION operator if they are compatible with
each other. This means
A. Have the same number of but different data type
B. have different number of column but the same data type
C. have the same number of columns and data type
D. have different number of columns and data type
26. The latest database design model is?

A. Relational C. object D. hierarchical

B. Network oriented

27. You are the administrator of a SQL server 2000 computer that contains a database
users report that queries to this database respond slowly. You use system monitor to
examine the subsystems on your server and receives the result shown in the exhibit.
You need to modify the server to accelerate query response time. What should you
do?

set by :-Mr.YEMAN YOSEF. Telegram. Jemal josef 09-93-67-91-57

DATA BASE HOLISTIC COC QUESTIONS FOR LEVEL -4
a. Add a faster network adapter c. Increase the amount of RAM
b. Add an additional processor d. Upgrade to faster disk subsystem

28. Which one of the following statement allows the user to enter data at the keyboard?

A. cin>>current pay C. cout>> current pay

B. cout<< current pay D. cin<< current pay

29. Which of the following queries is correct about the following output?

Pub ID Number of
1 4
2 2
3 3
Query output 1
A. SELECT PubID,COUNT(*)FROM BOOKS GROUP BY PubID HAVING
COUNT(*)=2
B. SELECT PubID,COUNT(*)AS[Number of books] FROM BOOKS GROUP BY
PubID HAVING COUNT(*)>2
C. SELECT PubID,COUNT(*)AS[Number of books] FROM BOOKS ORDERED BY
PubID HAVING COUNT(*)>=2
D. SELECT PubID,COUNT(*)AS[Number of books] FROM BOOKS GROUP BY
PubID HAVING COUNT(*)>=2
30. Which one of the following is not important in order to increase the performance of
database?
A. use less memory
B. use high speed connection between database components
C. use more powerful CPUs
D. use more RAM capacity
31. A type of query that is placed with in a WHERE or HAVING clues of another query
called?
A. Mult-query B. sub-query C. master query D. supper query
32. Is giving specific information about person’s current behavior in order to help him/her
either continue the behavior or modify the behavior?

A. conclusion C. opinion
B. suggestion D. feedbacks

33. ODBC stands for ________________

A. oriented database connection C. offline data base connection

B. open database connection D. none of above

34. Which of the following is true concerning system information in an RDBMS?

A. This information cannot be accessed by using SQL
B. this information often cannot be updated by user
C. this information often can be updated by user
D. RDBMS stores a database definition information in secondary storage devices
35. Which of the following is considered as SQL server level principal?

A. Windows Domain Login B. SQL Server Login

set by :-Mr.YEMAN YOSEF. Telegram. Jemal josef 09-93-67-91-57

DATA BASE HOLISTIC COC QUESTIONS FOR LEVEL -4
C. Application role D. SQL server

36. Which of the following defines mixed role application?

a. connections can be made using only window accounts
b. connections can be made using only database users
c. connections can be made using only SQL server Logins
d. connections to SQL server can be made with either windows accounts or with
SQL Server logins
37. Which type of file contains data and database objects such as table and index?

A. file group C. log files

B. binary files D. data files

38. Information for an organization gathered

A. Imaging business form C. Interviewing end users

B. Stealing the organization document D. guessing business rules

39. Which one of the following declaration in supper class is accessible in sub class ?

A. int a; C. public int a;

B. private int a; D. show int a;

40. During modeling your data entity relationship is applied at_____?

a. application and security c. physical refinement

b. schema refinement d. conceptual database

41. which is a reserved word in java programming language

A. native C. references
B. supper classes D. method

42. UML stands for_______________

A. universal modeling language C. unified modeling language

B. united modeling language D. uni modeling language

43. The ability to create new class from existing class is ?

A. Polymorphism C. encapsulation
B. inheritance D. abstraction

set by :-Mr.YEMAN YOSEF. Telegram. Jemal josef 09-93-67-91-57