DBMS B.Tech Quiz

Consider the entities ‘hotel room’, and ‘person’ with a many to many relationship ‘lodging’ as shown below:

If we wish to store information about the rent payment to be made by person (s) occupying different hotel rooms, then this information should appear as an attribute of

• Person
  
  
  

• Hotel Room

• Lodging

• None of these

_____ is given as the logical design of the database, while the snapshot of the data in the database at a point in time is__________

• Database relation, attribute

• Database schema, attribute domain

• Database schema, database instance

• Attribute domain, attribute value

Which is the maximum number of super keys for the relation schema R(X,Y,Z,W) with X as the key?

• 12

• 6

• 8

• 9

What is the command used to remove a relation from an SQL database?

• 1. Remove table

• 1. Update table

• 1. Drop table

• 1. Delete table

What is “AS” clause in SQL used for?

• 1. Selection Operation

• 1. Join Operation

• 1. Projection Operation

• 1. Rename Operation

What refers to the completeness and the correctness of the data in a database?

• 1. Data integrity

• 1. Data security

• 1. Data independence

• 1. Data constraint

What do ODBC stand for?

• 1. Oriented database connection

• 1. Offline database connection

• 1. Open database connection

• 1. None of these

_________ are the commands used to control access over objects in relational database.

• 1. GRANT & REVOKE

• 1. QUE & QUIST

• 1. CASCADE & MVD

• 1. None of the above

Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?

• Diamonds with double/bold border

• Rectangles with double/bold border

• Ovals with double/bold border

• Ovals that contain underlined identifiers

Given the basic ER and relational models, which of the following is INCORRECT?

• An attribute of an entity can have more than one value.

• An attribute of an entity can be composite.

• In a row of a relational table, an attribute can have more than one value.

• In a row of a relational table, an attribute can have exactly one value or a NULL value.