CS409 Quiz 1

Q1. In database, key is a single or combination of more than one column which is used to identify _____________ in a table.

1. Rows & columns
2. Rows
3. Cells
4. Columns

Correct answer: Rows

Q2. The format of a primary key decides by ______________.

1. Programmer
2. Organization of the database
3. Database Administrator
4. Database Designer

Correct answer: Database Designer

Q3. "Address" is an example of ___________________ of Employee entity.

1. Derived attribute
2. Key Attribute
3. Composite attribute
4. Simple attribute

Correct answer: Composite attribute

Q4. In ANSI SPARC architecture of DBMS, table creation is performed on ____________.

1. Database level
2. Conceptual level
3. Physical level
4. Conceptual & physical levels

Correct answer: Conceptual level

Q5. In Entity Relationship diagram, the diamond symbol represents ________________.

1. Entity Type
2. Relationship Type
3. Attribute
4. Primary Key

Correct answer: Relationship Type

Q6. The foreign key creates a _______________ between two tables.

1. Internal link
2. Physical link
3. Logical link
4. External link

Correct answer: Logical link

Q7. In Entity Relationship diagram, the multi-valued attribute is represented by ____________.

1. Dotted oval symbol
2. Double oval symbol
3. Oval symbol
4. Oval symbol having line inside

Correct answer: Double oval symbol

Q8. In Entity Relationship diagram, the dotted oval symbol represents ____________.

1. Key attribute
2. Simple attribute
3. Composite attribute
4. Derived attribute

Correct answer: Derived attribute

Q9. Which column can be an appropriate surrogated key for the following RENTAL_PROPERTY table? RENTAL_PROPERTY (PropertyID, PostalCode, Street_no, City_name, Province, Rental_Rate)

1. PropertyID
2. Street_no
3. City_name
4. PostalCode

Correct answer: PropertyID

Q10. Which statement is FALSE for the surrogated key?

1. Surrogated key has artificial values
2. Surrogated key is NOT NULL
3. Surrogated key is supplied by DBMS
4. Surrogated key is of various length

Correct answer: Surrogated key is of various length