DBMS Interview

The data model which describes how the data is actually stored is

• internal model

• external model

• logical model

• none of these

Data about data is normally termed as

• directory

• data bank

• meta data

• none of the above

A view of database that appears to an application program is known as

• schema

• subschema

• virtual table

• none of the above

Collection of information stored in a database at a particular moment is

• view

• schema

• instance

• none of the above

Data items grouped together for storage purposes are called a :

• Record

• title

• list

• string

Which command is used to remove all rows from a table ?

• Delete

• Remove

• Truncate

• Both [A] and [B]

What is the language used by most of the DBMS for helping their users to access data ?

• High level language

• Query language

• SQL

• 4GL

This is an authorization command of SQL

• Access

• Grant

• Allow

• None of these

Count function in SQL returns the number of

• Values

• Distinct values

• Groups

• Columns

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

• Alter

• Update

• Create

• Select