DBMS Quiz

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 teaches,instructor where instructor_id=course_id;

• Select name, course_id from instructor natural join teaches;

• Select name, course_id from instructor;

• Select course_id from instructor join teaches;

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

• DML(Data Manipulation Language)

• Query

• Relational Schema

• DDL(Data Definition 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)

• DDL(Data Definition Language)

• Query

• Relational Schema

Which one of the following given statements possibly contains the error?

• select * from emp where empid = 10003;

• select empid from emp where empid = 10006;

• select empid from emp;

• select empid where empid = 1009 and Lastname = 'GELLER';

A RDBMS consists a collection of ?

• Tables

• Fields

• Records

• Keys

The term attribute refers to a ___________ of a table.

• Record

• Tuple

• Column

• Key

In relational model, the row of table is known to be ?

• Relation

• Entity field

• Tuple

• Attribute

Address field of a person should not be part of primary key, since it is likely to ?

• Dependent

• Too long

• Changed

• Not changed

The relational model is concerned with ?

• Data structure and Data integrity

• Data Manipulation

• Both A and B

• None of these

Which is the false statement from the following ?

• A veiw is a named derived table

• A name relation is variable

• A veiw is a named reation and is virtual

• None of these