Bsc DBMS Quiz 2

What do you mean by one to many relationships?

• One class may have many teachers

• One teacher can have many classes

• Many classes may have many teachers

• Many teachers may have many classes

Which attribute among ID, CITY and NAME is most suitable to be used as a primary key?

• NAME

• ID

• CITY

• ID, NAME

The term _____ is used to refer a row

• Record

• Primary key

• Foreign key

• Field

Q.11 It is better to use files than a DBMS when there are

• (A) Stringent real-time requirements.

• (B) Multiple users wish to access the data.

• (C) Complex relationships among data.

• (D) All of the above.

Which command is used to remove a relation from an SQL?

• Drop table

• Delete

• Purge

• Remove

The SQL statement that queries or reads data from a table is ________ .

• SELECT

• READ

• QUERY

• None of these

The SQL keyword BETWEEN is used:

• For ranges

• To limit the columns displayed.

• As a wildcard

• None of these

THE NUMBER datatype is used to store

• Negative Integer

• Positive Integer

• Floating point

• Fixed decimal

Which of the following is used to denote the selection operation in relational algebra?

• Pi (Greek)

• Sigma (Greek)

• Lambda (Greek)

• Omega (Greek)

Consider the relations R(A, B) and S(B, C) and the following four relational algebra queries over R and S:

Where R.B refers to the column B in table R. One can determine that:

• i, ii and iii are the same query

• i, iii and iv are the same query

• ii, iii and iv are the same query

• i, ii and iv are the same query