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.
D. DivideB. Project
- The way a particular application views the data from the database that the application uses is a __________
B. relational model
D. sub schemaD. sub schema
- Related fields in a database are grouped to form a _________
A. data file
B. data record
D. bankB. data record
- ___________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 constraintD. Integrity constraint
- The descriptive property possessed by each entity set is _________
D. ModelB. Attribute
- The database environment has all of the following components except __________
B. separate files
D. database administratorA. users
- The view of total database content is ___________
A. Conceptual view
B. Internal view
C. External view
D. Physical viewA. Conceptual 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 modelD. 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 utilityB. Backup 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 FormA. First Normal Form