In the first semester of a degree program in a university, each student has to study five pre-selected courses. The relationship between student and course is:

• A) One to one
• B) Many to many
• C) Many to one
• D) Recursive relationship

A specific record of a relation is accessed through:

• A) Random key
• B) Arbitrary Key
• C) Secondary Key
• D) Primary Key

Which of the following operator is used to select the certain columns from a table?

• A) Conjugate operator
• B) Cartesian operator
• C) Select operator
• D) Project operator

A cell of a table is the intersection of row and a ________.

• A) Tuple
• B) Degree
• C) Column
• D) Record

If an entity STUDENT has four attributes named as Roll No., NAME, DATE_OF_BIRTH and ADDRESS then which of the following attribute is most suitable for Primary Key?

• A) NAME
• B) DATE_OF_BIRTH
• C) ADDRESS
• D) Roll No.

Which of the following option is true for union commutative?

• A) B∩A=BUA
• B) A∩B=AUB
• C) AUB=A∩B
• D) AUB=BUA

A manufacturer manufactures 100 motor bikes in a month. The relationship between manufacturer and motor bikes is:

• A) One to one
• B) Many to many
• C) One to many
• D) Recursive relationship

Which of the two data models were used before the relational data model?

• A) Flat Data model and Hierarchical Data Model
• B) Object Oriented and Flat Data Model
• C) Hierarchical and Network Data Model
• D) Network and Object Oriented Data Model

Consider the following two sets: STD Name = [Ali, Hassan] Course Name = {Eng, Math, Phy} Then the Cartesian product of STD Name and Course Name (i.e. STD Name x Course Name) will be equal to:

• A) {(Ali, Math), (Ali, Phy), (Hassan, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
• B) {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
• C) {(Ali, Eng), (Hassan, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
• D) {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Phy), (Ali, Math), (Hassan, Eng)}

If relation M has C tuples and relation N has D tuples, then their Cartesian product will have _________ tuples.

• A) CUD
• B) C*D
• C) C∩D
• D) C^D

While converting Entity-Relationship Diagram to Relational Data Model, each entity type is converted into:

• A) Attribute
• B) Relation
• C) Relationship
• D) Object

Suppose a relation named STUDENT contains attributes St_name, St_cgpa, cur_semester and st_roll. Which of the following query will be used to SELECT all those student records having cgpa greater than 3.0?

• A) Ωcgpa>3.0 (STUDENT)
• B) σcgpa>3.0 (STUDENT)
• C) σcgpa>3.0 (STUDENT)
• D) €cgpa>3.0 (STUDENT)

If there are two relations X and Y then the difference of these two relations (i.e. X-Y) will be set of tuples that ________________.

• A) Do not appear in both X and Y
• B) Appear in Y but not in X
• C) Appear in X but do not appear in Y
• D) Appear in both X and Y

In a table, column represents __________.

• A) Data
• B) Instances
• C) Records
• D) Attributes

In many to many relationship, a third table is created for the relationship. It is known as _______.

• A) Associative entity type
• B) Regular entity type
• C) Strong entity type
• D) Naming entity type

If a teacher teaches multiple courses in a university then the relationship between teacher and course is:

• A) Many to one
• B) Recursive relationship
• C) One to many
• D) One to one

In relational data model, composite attributes need to be represented as:

• A) Entity type
• B) Recursive relationship
• C) Separate relation
• D) Objects

Rows of the table in the relational database are identified by __________.

• A) Serial number
• B) Row name
• C) Header
• D) Key values

Suppose a relation named EMPLOYEE contains attributes Emp_name, Emp_designation, Emp_address and Emp_salary. Which of the following query will be used to SELECT all those employees whose designation is Admin officer?

• A) ռ designation = ‘Admin officer’ (EMPLOYEE)
• B) α designation = ‘Admin officer’ (EMPLOYEE)
• C) σ designation = ‘Admin officer’ (EMPLOYEE)
• D) ϕ designation = ‘Admin officer’(EMPLOYEE)

Which of the following are unary operators?

• A) SELECT and CARTESIAN
• B) PROJECT and CARTESIAN
• C) UNION and PROJECT
• D) SELECT and PROJECT