Database

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