INTRODUCTION TO DATABASE SYSTEM QUIZ

Which of the following products implemented the CODASYL DBTG model?

IDMS

R:base

dBase-II

DB2

TRUE ANSWER : ?
YOUR ANSWER : ?

What name is given to the collection of facts, items of information or data which are related in some way?

Directory information

Information provider

Database

Information tree

TRUE ANSWER : ?
YOUR ANSWER : ?

In a relational schema, each tuple is divided into fields called

Domains

All of the listed here

Relations

Queries

TRUE ANSWER : ?
YOUR ANSWER : ?

An entity class is a collection of entities and is described by the structure of the entities in that class.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command(s) is(are) used to redefine an index's future storage allocation

MODIFY INDEX

DO INDEX

REDEFINE INDEX

None of these

ALTER INDEX

TRUE ANSWER : ?
YOUR ANSWER : ?

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

Multimedia

Full media

Graphics media

Hypertext

TRUE ANSWER : ?
YOUR ANSWER : ?

Which command is used to remove a table from the database in SQL?

UNATTACH TABLE

DELETE TABLE

DROP TABLE

ERASE TABLE

TRUE ANSWER : ?
YOUR ANSWER : ?

Which command(s) is(are) used to redefine a column of the table in SQL ?

ALTER TABLE

DEFINE TABLE

MODIFY TABLE

all of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

In SQL, which command(s) is(are) used to create a synonym for a schema object?

CREATE SCHEMA

All of the listed here

CREATE SYNONYM

CREATE SAME

TRUE ANSWER : ?
YOUR ANSWER : ?

Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?

Supertype entity

Archetype entity

Instance entity

Subtype entity

TRUE ANSWER : ?
YOUR ANSWER : ?

↑