DBMS CAT 1

_______stores metadata about the structure of the database, in particular the schema of the database

• Indices

• Data Dictionary

• Data Files

• Database log

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

• Physical Level

• Logical Level

• File Level

• Conceptual Level

Life cycle of data includes the following 4 "A" s

• Acquisition, Arranging,Aggregation, Analysis

• Application,Acquisition, Aggregation, Analysis

• An observation, Acquisition, Aggregation, Analysis

• Appplication, Adoptation, Acquisition, Aggregation

OLTP stands for

• OnLine Transaction Processing

• OffLine Transaction Processing

• OnLine Transaction Procuring

• OnLine Transition Processing

Responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software and hardware resources, controlling its use and monitoring efficiency of operstionserations.

• Database

  users

• Database designers

• Database administrators

• naive users

Schema is also called as

• attributes

• extension

• intension

• keys

The capacity to change the conceptual schema without having to change the external schemas and their associated application programs

• Physical Data Independence

• Logical Data Independence

• Concept level

• Physical level

An attribute or combination of attributes in one table whose values must either match the primary key in another table or be null is called __________

• Primary Key

• composite key

• alternate key

• Foreign key

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.

• 20,4

• 20,3

• 3, 20

• 4,20

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

• One-to-one

• One-to-many

• Many-to-many

• Many-to-one