In a table, column represents __________.

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

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)

In intersection operation, which of the following is selected?

• A) Tuples of single relation only
• B) Tuples of first relation
• C) Tuples common in both relations
• D) Tuples of second relation

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)

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, Eng), (Ali, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
• B) {(Ali, Math), (Ali, Phy), (Hassan, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}
• C) {(Ali, Eng), (Ali, Math), (Ali, Phy), (Hassan, Phy), (Ali, Math), (Hassan, Eng)}
• D) {(Ali, Eng), (Hassan, Math), (Ali, Phy), (Hassan, Eng), (Hassan, Math), (Hassan, Phy)}

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

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

What is the basic component/structure of Relational Data Model?

• A) Schema
• B) Relation
• C) Tuple
• D) Model

Which of the following are unary operators?

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

In relational database, each cell of a table cannot have __________ .

• A) Numeric values
• B) Unique values
• C) String values
• D) Multiple values

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

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

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) Roll No.
• B) NAME
• C) ADDRESS
• D) DATE_OF_BIRTH

A specific record of a relation is accessed through:

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

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

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

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

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

Column of the table in the relational database are identified by ___________.

• A) Serial number
• B) Key
• C) Name
• D) Value

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

A relation is in second normal form if and only if ______________ and all the non key attributes are fully functionally dependent on the key.

• A) It has multivalued attributes
• B) It is not in first normal form
• C) It has inconsistent data
• D) It is in first normal form

The only time we are concerned about 2nd Normal Form is when ___________.

• A) Primary key contains redundant values
• B) Primary key consists of single attribute
• C) Primary key is composite
• D) Primary key contains non-unique values

A table is in the 2nd Normal Form if there is no___________.

• A) Functional dependency
• B) Reflexive dependency
• C) Transitive dependency
• D) Partial dependency

Suppose A → B, then which of the following is valid Functional dependency for augmentation?

• A) AB → C
• B) A → C
• C) AD → B
• D) AC → BC