Database Management Systems

Name of the student

Hall ticket number

Group

• MPCS
• MCCS
• BCOM(CA)

Which of the following is not the type of the data model?

• Relational Data Model
• Object Oriented Model
• Entity-Relationship Model
• Process-based Data Model

What is TRUE about Relational Data Model?

• Tables are used in relational models to represent data and the relationships between them.
• Edgar F. Codd presented this model in 1969.
• Most commercial data processing applications use the relational data model.
• All of the above

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

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 an example of DBMS?

• MySQL
• Microsoft Acess
• IBM DB2
• MS-Excel

______________ is a set of one or more attributes taken collectively to uniquely identify a row/record in a table.

• Primary Key
• Foreign key
• Super key
• Candidate key

Which one of the following is used to define the structure of the relation and relating schemas?

• DML(Data Manipulation Langauge)
• DDL(Data Definition Langauge)
• Query
• Relational Schema