DBMS Unit 1

Which of the following is a property of database

• Represents some aspect of the real world

• Logically related collection of data

• Built, and populated with data for a specific purpose

• All the above

A database management system (DBMS) is a collection of programs that enables users to

• create a database

• manipulate a database

• both create and manipulate a database

• for storing data only

The database and DBMS software together is called a ________________

• Database system

• Data Model

• Application Program

• System software

Data about data is normally termed as

• directory

• data bank

• meta data

• super data

Data redundancy occurs

• when the same piece of data exists in multiple places.

• when there is mismatch of data.

• when there is NULL values.

• when there is multiple values for an attribute.

All the _____________ in a table are called fields.

• rows

• columns

• cells

• constraints

The rows in a table are called _______________.

• data

• records

• queries

• output

A database stores a vast amount of data, but _____________ helps us to retrieve the filtered data based upon some conditions.

• forms

• reports

• queries

• all of the above

The database definition or descriptive information is also stored by the DBMS in the form of a _______________

• Data catalog

• excel file

• document file

• pdf file

The statement in SQL which allows to change the definition of a table is

• Alter

• Update

• Create

• Select