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.
-
The operation of eliminating columns in a table done by _______ operation.
A. Restrict
B. Project
C. Union
D. Divide -
The way a particular application views the data from the database that the application uses is a __________
A. module
B. relational model
C. schema
D. sub schema -
Related fields in a database are grouped to form a _________
A. data file
B. data record
C. menu
D. bank -
___________is a condition specified on a database schema and restricts the data that can be stored in an instance of the database.
A. Key Constraint
B. Check Constraint
C. Foreign key constraint
D. Integrity constraint -
The descriptive property possessed by each entity set is _________
A. Entity
B. Attribute
C. Relation
D. Model -
The database environment has all of the following components except __________
A. users
B. separate files
C. database
D. database administrator -
The view of total database content is ___________
A. Conceptual view
B. Internal view
C. External view
D. Physical view -
The _________ refers to the way data is organized in and accessible from DBMS.
A. database hierarchy
B. data organization
C. data sharing
D. data model -
A _____ allows to make copies of the database periodically to help in the cases of crashes & disasters.
A. Recovery utility
B. Backup Utility
C. Monitoring utility
D. Data loading utility -
The main task carried out in the __________ is to remove repeating attributes to separate tables.
A. First Normal Form
B. Second Normal Form
C. Third Normal Form
D. Fourth Normal Form
Source: Jobsnews