Adama PTC DBA-III COC EXAM
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
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
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
Or
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
11. The quality standard is _______ revise
Assign Responsibility
The use of safety tools
Documenting Tools
Maximizing Password materials
All
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
{"name":"Adama PTC DBA-III COC EXAM", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsMultiple choice and checkbox formatsFocus on database concepts and practical scenarios","img":"https:/images/course1.png"}