SQL Quiz (XII)

The statement in SQL which allows to change the definition of a table is

• Alter

• Update

• Create

• select

Key to represent relationship between tables is called

• Primary key

• Secondary Key

• Foreign Key

• None of these

_______ produces the relation that has attributes of R1 and R2

• Cartesian product

• Difference

• Intersection

• Product

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

• Stringent real-time requirements

• Multiple users wish to access the data

• Complex relationships among data

• All of the above

What is a relationship called when it is maintained between two entities?

• Unary

• Binary

• Ternary

• Quaternary

Which of the following operation is used if we are interested in only certain columns of a table?

• PROJECTION

• SELECTION

• UNION

• JOIN

Which of the following is a valid SQL type?

• CHARACTER

• NUMERIC

• FLOAT

• All of the above

The RDBMS terminology for a row is

• tuple

• relation

• attribute

• degree

The conceptual model is

• dependent on hardware.

• dependent on software.

• dependent on both hardware and software .

• independent of both hardware and software.

What is the full form of SQL?

• Structured Query List

• Structure Query Language

• Sample Query Language

• None of these.