DD Quiz !

1.  Who are the primary users of a database system?

• Database administrators    

• Application programmers

• End users

• All of the mentioned

What is the primary purpose of a Database Management System (DBMS)?

• To manage computer hardware resources

• To manage computer software resources

• To manage networks and communication protocols

• To manage data and provide an interface to users

Which of the following is not a database language?

• DDL

• DML

• DCL

• DBA

What is one of the main advantages of using a DBMS approach?

• Improved data security

• Improved data sharing and integration

• Improved data consistency

• All the above

Which classification of DBMS stores data in tables with rows and columns?

• Hierarchical DBMS        

• Network DBMS

• Relational DBMS

• Object-oriented DBMS

Which level of the 3-schema architecture is closest to the physical storage of data?

• Internal schema

• Logical schema

• Conceptual schema

• External schema

Which component of a database system is responsible for translating high-level queries into low-level instructions?

• Transaction manager

• Query optimizer

• Buffer manager

• Disk space manager

What is the purpose of a query in a database?

• To retrieve some data

• To update some data

• To generate a report

• To share the database

What type of interface presents the user with lists of options called menus? 

• Forms-Based Interface

• Menu-Based Interface

• Graphical-User Interface

• Natural Language Interface

What type of interface includes commands for creating accounts, setting system parameters, and granting account authorization?

• Forms-Based Interface

• Menu-Based Interface

• Graphical-User Interface

• Interfaces for the DBA