DBMS - Fundamentals

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

• Google

Which of the following is not a feature of DBMS?

• Minimum Duplication and Redundancy of Data

• High Level of Security

• Single-user Access only

• Support ACID Property

Which of the following is known as a set of entities of the same type that share same properties, or attributes?

• Relation set

• Tuples

• Entity set

• Entity Relation model

What does an RDBMS consist of?

• Collection of Records

• Collection of Keys

• Collection of Tables

• Collection of Fields

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

• Primary Key

• Foreign key

• Super key

• Candidate key

_______ indicates the maximum number of entities that can be involved in a relationship.

• Greater Entity Count

• Minimum cardinality

• Maximum cardinality

• ERD

Which of the following is the view level database model

• ER model

• Relational Model

• Table

• File

Which of the following is not Unary operation?

• Select

• Project

• Rename

• Union