DBMS XII

Which of the following is an example of a DBMS

• PHP

• SQL

• Microsoft Office

• Oracle

DBMS enables users to  

• create a database

• for storing data only

• both create and manipulate a database

• manipulate a database

Data items grouped together for storage purposes are called a

• Record

• List

• Data

• String

Who developed the relational database model?

• Charles Babbage                

• Bill Gates                  

• E.F. Codd                

• Elon Musk

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

• UPDATE

• ALTER

• TRUNCATE

• CHANGE

A relation with no partial dependencies are in

• 1NF

• 2NF

• 3NF

• 4NF

A relation with no transitive dependencies are in

• 1NF

• 2NF

• 3NF

• 4NF

    If all the non key attributes are functionally dependent on the primary key, the relation will be in

• 1NF

• 2NF

• 3NF

• 4NF

       Key to create a relationship between the two tables is called.

• Primary key

• Secondary key

• Foreign key

• Alternate key

Data redundancy occurs

• when the same piece of data exists in multiple places.

• when there is mismatch of data.

• when there is NULL values.

• when there is multiple values for an attribute.