Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in DBMS. It will be very useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.
- If both data and database administration exist in an organization, the database administrator is responsible for which of the following?
A. Data modeling
B. Metadata
C. Database design
D. All of the Above
Answer
C. Database design - SQL stands for ________
A. Structured Question Language
B. Sequential Question Language
C. Structured Query Language
D. Sequential Query Language
Answer
C. Structured Query Language - A DBMS that combines a DBMS and an application generator is ________
A. DB2
B. SQL Server
C. Microsoft Access
D. Oracle
Answer
C. Microsoft Access - The following are components of a database except__________
A. reports
B. index
C. metadata
D. user data
Answer
A. reports - DBMS acts as an interface between what two components of an enterprise-class database system?
A. The user and the database application
B. Database application and the database
C. Database application and SQL
D. Data and the database
Answer
B. Database application and the database - The following are functions of a DBMS except ________
A. creating databases
B. creating and processing forms
C. administrating databases
D. processing data
Answer
B. creating and processing forms - Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
A. Rollback
B. Reprocess transactions
C. Switch to duplicate database
D. Rollforward
Answer
A. Rollback - The tuples of the relations can be of ________ order.
A. Any
B. Same
C. Sorted
D. Constant
Answer
A. Any - An application where only one user accesses the database at a given time is an example of a(n) ________
A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer
A. single-user database application - A ________ in a table represents a relationship among a set of values.
A. Column
B. Key
C. Row
D. Entry
Answer
C. Row
AffairsCloud Recommends Oliveboard Mock Test
AffairsCloud Ebook - Support Us to Grow
Govt Jobs by Category
Bank Jobs Notification