DBA LEVEL III COC EXAM: PREPARED BY TECHNIFY TUTOR

1. Student(ID, name, dept name, Credit_ Hr) Using the above information, which attribute can be the primary key for the student table?

A. Name

B. Dept

C. Credit_ Hr

D. ID

2. Using Database management systems is preferable than file system when

A. The number of records is small

B. The Data we need to keep is very secure

C. The speed of accessing data is our first priority

D. The company have no capacity to add new hardware and software

3. Assume that there are two given tables, STUDENT table and COURSE table under the same database name. What will be the possible relationship between those tables?

A. One - to - Many relationship

B. One - to - One relationship

C. Many - to – Many relationship

D. Has no relationship

4. Which SQL expression is syntactically incorrect?

A. SELECT FROM EMPLOYEE;

B. SELECT * FROM EMPLOYEE

C. SELECT NAME FROM EMPLOYEE;

D. SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

5. Which one of the following is not factor that affect work place communication

A. personal behavior

B. Lack of good governance

C. Office location

D. Motivation to work together

6. While gathering data to determine the organization business requirement you might take records of the organization like, annual reports and organizational policies. These kinds of information resources are considered as

A. Tertiary sources

B. Secondary sources

C. Primary sources

D. Informal sources

7. An application where only one user accesses the database at given time is an example of

A. Multiuser database application

B. Single user database

C. E -commerce database application

D. Data mining database application

8. The database administrator wants to fix the database after a failure such as a hard disk malfunction, from where he/she start to make database functional again?

A. From backup

B. From partition D

C. From security

D. From access control

9. You need to bring data from an Access database in to database in SQL Server. You want to perform the task as simply as possible. Which one of the following options best meets the requirements?

A. Copy Database Wizard

B. Import and Export Wizard

C. Create Database Wizard

D. Create form design Wizard

10. You are assigned to lead a small team in your company that manages Database. Identify the wrong statement in leading the team

A. Assign responsibilities to team members

B. Perform all duties of the team by your own

C. Possess necessary leadership skill

D. Understand the team role