Scribd
Upload
58 views

Datadmin Quiz1 - 02072015

The document is a quiz about database administration concepts. It contains 20 multiple choice questions testing knowledge of topics like the role of a DBA, database security, backup and recovery, SQL statements, database design, and components of a database management system. The questions cover foundational concepts for understanding how databases are structured and maintained.

Uploaded by

Johann Sano
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
58 views

Datadmin Quiz1 - 02072015

The document is a quiz about database administration concepts. It contains 20 multiple choice questions testing knowledge of topics like the role of a DBA, database security, backup and recovery, SQL statements, database design, and components of a database management system. The questions cover foundational concepts for understanding how databases are structured and maintained.

Uploaded by

Johann Sano
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

DATADMIN QUIZ 1

Name: _____________________________________________ Score: _______

1. ______A resource that supervises both the database and the use of the DBMS.
a. DBA b. SA c. DBMSA d. none
2. ______A policy that users should access the database only in ways in which they are entitled.
a. Security b. Password policy c. Access privileges d. none
3. ______A policy that gives access restriction ensure the database is secure.
a. Security b. Password policy c. Access privileges d. none
4. ______It entails database can be harmed from hardware and software malfunctions, and outside forces like flood
and power outages.
a. Recovery b. Backup c. Disaster planning d. Archives
5. ______Data that are usually kept in a mass-storage device like a disk, tape, CD or DVD.
a. Recovery b. Backup c. Master files d. Archives
6. ______It is a smallest unit of data in a database.
a. Identifier b. Data Item c. Data Aggregate d. none
7. ______The lowest level of abstraction describes how the data is actually stored.
a. Physical level b. Logical Level c. View Level d. none
8. _____Which SQL statement is used to insert new data in a database?
a. INSERT NEW b. ADD RECORD c. ADD NEW d. INSERT INTO
9. ______A type of keys that data item uniquely identifies a record.
a. Primary key b. Foreign key c. Secondary key d. none
10. ______It is a collection of entities that have similar characteristics.
a. Reality b. Entity Class c. Metadata d. none
11. ______One advantages of DBMS, is cost saving measures can be done by combining all of an organization’s
operational data into a single database.
a. Improved Security b. Sharing of Data c. Economy of Scale d. none
12. _______One disadvantages of DBMS, additional storage space and peripheral.
a. Complexity b. Cost of DBMS c. Additional Hardware Cost d. none
13. _____What does SQL stand for?
a. Structured Query Language b. Structured Question Language
c. Strong Question Language d. None
14. _____Additional responsibility of DBA that he gives knowledge transfer on the DBMS and how to access the
database.
a. Training b. Giveback c. HELP d. DBMS support
15. _____A DBA responsibility for tuning the design and or making changes that improve system performance.
a. Training b. Giveback c. Database design d. DBMS support
16. _____The DBA is charged with all aspects of a DBMS, including selection and management.
a. Training b. Giveback c. HELP d. DBMS support
17. _____It establishes naming convention for database, tables, fields and data integrity rules.
a. Meaning b. Glossary c. Data dictionary d. Terms
18. ______It is a collection of unprocessed facts.
a. Information b. Data c. Records d. none
19. ______It is software that enables the user to define, create, and maintain the database.
a. DBMS b. File c. Ms Word d. none
20. ______It is an individual object, concept or event about which the organization chooses to collect or store data.
a. Reality b. Entity c. key d. none

You might also like