Adama PTC DBA-III COC EXAM

An illustrated image depicting database administration concepts, featuring elements like servers, databases, and programmers in an office setting.

Adama PTC DBA-III COC Exam Quiz

Test your knowledge and mastery of database administration with our comprehensive quiz designed for aspiring and current professionals in the field. This quiz encompasses various aspects of database management, ensuring a well-rounded evaluation of your skills.

Key Features:

36 thought-provoking questions
Multiple choice and checkbox formats
Focus on database concepts and practical scenarios

36 Questions9 MinutesCreated by AnalyzingData247

1. The only possible way or recovering your files after your office is damaged by a Natural Disaster like Earthquake

From external Hard disk

From Different Partition of the hard disk

On site backup

Off Site backup

2. Business Rule can be determined by which one of the following?

Properties

Table

Column

None

3. Fifth Normal Form

Partial Dependency

Functional dependency

Join Dependency

Transitive Dependency

4. What would you do if the user of a database is abusing the Rule Of database usage?

I will advise him

Sweep

Assign Responsibility

Strengthen

5. To which one of the following is checkpoint related?

Security Measure

Recovery Measure

Back up recovery

None

6. The process of removing redundancy from a database is.

Duplicate

Normalization

Backup

Recovery

7. A Visual study of a person, process, object in its stage is

Observation

Survey

Questionnaire

Interview

8. __________ Is a count function which store values

Group

Values

Column

Table

9. ___________ Is used to filter Queries

AND

Where Clause

None

10. A leader should do which one of the following in his work place

The problem the organization should exaggerated

The goal of the organization should be discussed

Documenting Tools

None

12. How do you imply that you are following while your friend is talking?

By nodding and making eye contact

By looking at your cell phone

By Looking out of the window

By chatting with your colleagues

13. Open Database Consistency

OCBD

OCDB

OBDC

DBOC

14. Weak entity is represented by

Double outlined ellipse

Double outlined Square

Double outlined Diamond

Double outlined rectangle

15. An entity which has a limited number of attribute to make a table is

Weak entity

Simple Entity

Strong Entity

None

16. An entity that does not exist without the existence of the parent table, but the identifier of the parent table should be identified in the entity.

ID-Dependent Entity

ID-Independent Entity

Weak Entity

Strong Entity

17. A data type which is used to accept Serial Number and used as a identifier key. (Primary key)

Intiger

Auto number

Varchar

Char

18. 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?

One - to - One relationship

Has no relationship

Many - to – Many relationship

One - to - Many relationship

19. Which SQL expression is syntactically incorrect?

SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;

SELECT FROM EMPLOYEE;

SELECT NAME FROM EMPLOYEE;

SELECT * FROM EMPLOYEE

20. Indexes are created in most RDBMSs to:

Provides a quicker way to store data.

Increase the cost of implementation

Provide rapid random and sequential access to base-table data

D. Decrease the amount of disk space utilized.

21. A power failure occurred while the database was operating. Unfortunately, the UPS did not function properly and did not stop the SQL server in a proper manner. Once power comes back, what do you have to do to your server to recover the transactions that have been committed but not check pointed?

You need to back up the transaction log, restore the Database from the last full Database backup, and then restore all the transaction logs

Nothing. SQL Server will recover automatically, rolling back pending transactions and rolling forward committed ones.

Nothing. All transactions since the last checkpoint are lost, the effects of the others are in the Database.

Run ROLL FORWARD ALL TRANSACTIONS

22. You created foreign key constraints and need to update the value in the referencing column. If the values in the referenced column are updated which referential integrity command should be used.

ON UPDATE RESTRICT

ON UPDATE NO ACTION

ON UPDATE CASCADE

ON UPDATE SET DEFAULT

23. 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?

Create Database Wizard

Import and Export Wizard

Copy Database Wizard

Create form design Wizard

24. In the relational model, cardinality is termed as:

A number of tuples.

A number of attributes.

A number of tables.

A number of constraints.

25 Relational calculus is a

Data definition language.

High-level language

Procedural language

Non- Procedural language.

26. The view of total database content is

Conceptual view.

Internal view.

External view.

Physical View

27. Cartesian product in relational algebra is

A Unary operator

A Binary operator

A Ternary operator.

Not defined.

28. DML is provided for

Description of the logical structure of a database.

The addition of new structures in the database system.

Manipulation & processing of the database.

Definition of a physical structure of the database system.

29. ‘AS’ clause is used in SQL for

Selection operation

Rename operation

Join operation

Projection operation

30. ODBC stands for

Object Database Connectivity.

Oral Database Connectivity

Oracle Database Connectivity

Open Database Connectivity

31 Architecture of the database can be viewed as

Two levels.

Four levels.

Three levels.

One levels

32. In a relational model, relations are termed as

Tuples

Attributes

Tables

Row

33. The database schema is written in

HLL

DML

DDL

DCL

34. In the architecture of a database system external level is the

Physical level

Logical level.

Conceptual level

View level.

35. An entity set that does not have sufficient attributes to form a primary key is a

Strong entity set

Weak entity set

Simple entity set

Primary entity set

36. In Hierarchical model records are organized as

Graph

List

Links

Tree

Adama PTC DBA-III COC EXAM

Adama PTC DBA-III COC Exam Quiz

More Quizzes