DBMS Quiz

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

• DDL(Data Definition Language)

• Relational Schema

• Query

• DML(Data Manipulation Language)

Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

• DML(Data Manipulation Language)

• Relational Schema

• DDL(Data Definition Language)

• Query

The given Query can also be replaced with_______: SELECT name, course_id FROM instructor, teaches WHERE instructor_ID= teaches_ID;

• Select name, course_id from instructor natural join teaches;

• Select course_id from instructor join teaches;

• Select name,course_id from teaches,instructor where instructor_id=course_id;

• Select name, course_id from instructor;

The given Query can be replaced with ____________: SELECT name FROM instructor1 WHERE salary <= 100000 AND salary >= 90000;

• SELECT name FROM instructor! WHERE salary <= 90000 AND salary>=100000;

• SELECT name FROM instructor1 WHERE salary BETWEEN 100000 AND 90000

• SELECT name FROM instructor| WHERE salary BETWEEN 90000 AND 100000;

• SELECT name FROM instructor1 WHERE salary BETWEEN 90000 AND 100000;

What is the purpose of DDL (Data Definition Language) in a database?

• To perform tasks like creating the structure of the relations, deleting relation

• To query information from the database and insert tuples into, delete tuples from, and modify tuples in the database

• To define the structure of the database, like creating, altering, and dropping tables

• To retrieve specific information from the database

Which symbol is used in SQL to represent any sequence of characters?

• &

• _

• %

• $

What is the purpose of DML (Data Manipulation Language) in a database?

• To perform tasks like creating the structure of the relations, deleting relation

• To query information from the database and insert tuples into, delete tuples from, and modify tuples in the database

• To define the structure of the database, like creating, altering, and dropping tables

• To retrieve specific information from the database

Normalisation is:

• Removing all necessary data from a database

• Putting fields from different tables into one big database

• Organising a database to remove repeated entries and increase the accuracy of the data

There are two functional dependencies with the same set of attributes on the left side of the arrow:

A->BC

A->B

This can be combined as

• a) A->BC

• b) A->B

• c) B->C

• d) None of the mentioned

If there is no transitive dependency for non-prime attributes, then the relation must be in

• Second Normal Form.

• Third Normal Form.

• First Normal Form

• Fourth Normal Form.