Have an account?
Skip to Content
Build your own quiz
Suggestions for you
15 questions
Show Answers
See Preview
- 1. Multiple Choice
What is the full form of DBMS?
Data of Binary Management System
Database Management System
Database Management Service
Data Backup Management System
- 2. Multiple Choice
What is a database?
Organized collection of information that cannot be accessed, updated, and managed
Collection of data or information without organizing
Organized collection of data or information that can be accessed, updated, and managed
Organized collection of data that cannot be updated
- 3. Multiple Choice
What is DBMS?
DBMS is a collection of queries
DBMS is a high-level language
DBMS is a programming language
DBMS stores, modifies and retrieves data
- 4. Multiple Choice
Which type of data can be stored in the database?
Image oriented data
Text, files containing data
Data in the form of audio or video
All of the above
- 5. Multiple Choice
Which of the following is not a type of database?
Hierarchical
Network
Distributed
Decentralized
- 6. Multiple Choice
Which of the following is a function of the DBMS?
Storing data
Providing multi-users access control
Data Integrity
- 7. Multiple Choice
Which of the following is not a function of the database?
Managing stored data
Manipulating data
Security for stored data
Analysing code
- 8. Multiple Choice
he top level of the hierarchy consists of ______ each of which can contain _____
Schemas, Catalogs
Schemas, Environment
Environment, Schemas
Catalogs, Schemas
- 9. Multiple Choice
Which of the following is not the utility of DBMS?
i) Backup ii) Loading iii) Process Organization iv) File organization
i, ii, and iv
i, ii and iii
i, iii and iv
i, ii, iii, and iv
- 10. Multiple Choice
What happens if a piece of data is stored in two places in the db?
Storage space is wasted & Changing the data in one spot will cause data inconsistency
It can be more easily accessed
Changing the data in one spot will cause data inconsistency
Storage space is wasted
- 11. Multiple Choice
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
- 12. Multiple Choice
Which command is used to remove a relation from an SQL?
Drop table
Delete
Purge
Remove
- 13. Multiple Choice
The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
Data and the DBMS
Application and SQL
Database application and the database
The user and the software
- 14. Multiple Choice
Which of the following is correct according to the technology deployed by DBMS?
Pointers are used to maintain transactional integrity and consistency
Cursors are used to maintain transactional integrity and consistency
Locks are used to maintain transactional integrity and consistency
Triggers are used to maintain transactional integrity and consistency
- 15. Multiple Choice
Which of the following establishes a top-to-bottom relationship among the items?
Relational schema
Network schema
Hierarchical schema
All of the mentioned
- Answer choicesTagsAnswer choicesTags