WorksheetsDatabase
Total questions: 15
Worksheet time: 6mins
What is the full form of DBMS?
Data of Binary Management System
Database Management System
Database Management Service
Data Backup Management System
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
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
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
Which of the following is not a type of database?
Hierarchical
Network
Distributed
Decentralized
Which of the following is a function of the DBMS?
Storing data
Providing multi-users access control
Data Integrity
Which of the following is not a function of the database?
Managing stored data
Manipulating data
Security for stored data
Analysing code
he top level of the hierarchy consists of ______ each of which can contain _____
Schemas, Catalogs
Schemas, Environment
Environment, Schemas
Catalogs, Schemas
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
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
______________ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
Which command is used to remove a relation from an SQL?
Drop table
Delete
Purge
Remove
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
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
Which of the following establishes a top-to-bottom relationship among the items?
Relational schema
Network schema
Hierarchical schema
All of the mentioned
