RDBMS

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)

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 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 Database Management System is a type of _________software.

• It is a type of system software

• It is a kind of application software

• It is a kind of general software

• Both A and C

The term "FAT" is stands for_____

• File Allocation Tree

• File Allocation Table

• File Allocation Graph

• All of the above

Which one of the following refers to the "data about data"?

• Directory

• Sub Data

• Warehouse

• Meta Data

Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?

• Conceptual Level

• Physical Level

• File Level

• Logical Level

To which of the following the term "DBA" referred?

• Data Bank Administrator

• Database Administrator

• Data Administrator

• None of the above

In general, a file is basically a collection of all related______.

• Rows & Columns

• Fields

• Database

• Records

The term "Data" refers to:

• The electronic representation of the information( or data)

• Basic information

• Row Facts and figures

• Both A and C