Lvl 1 Introduction DBMS (QB)

Which is the false statement ?

• A Database is ordered collection of data.
• A Database is systematic compilation of records in a computer
• DBMS manages the database
• Data helps in making decisions.

In traditional file system ,Two files may be combined into a third file if

• They have a row in common
• They have a field in common
• They have no records with the same value in the common field
• Both (b) and (c)

Data is said to be ________ if same data is copied at many places.

• Redundant
• Concurrent
• Inconsistent
• Controlled

What do you mean by Concurrent access?

• Copies of same data does not match with each other
• Same data is copied at many places
• The access of same data by multiple users at same time
• Both A & B

Data Model is collection of conceptual tools for describing -

• Data
• Data schema
• Consistency
• All of these

Data________ refers to describing the data description, representing data semantics, and describing the consistency constraints that apply to the data.

• Adding
• Modifying
• Modeling
• Refining

Which of the following is not a Data Model?

• Aggregate Model
• Relational Model
• ER Model
• Hierarchical Model

Which of the following is not an example of DBMS?

• MySQL
• Microsoft Acess
• IBM DB2
• Google

Data such as table name, column name, data type, authorized user and user access privileges for any table is called ______for that table.

• Data Isolation
• Data Independence
• Data Integrity
• Meta data

Which of the following is a feature of DBMS?

• Minimum Duplication and Redundancy of Data
• High Level of Security
• Mulitple-user Access
• All of these