DBI 101

QN=1 (6803) A ____ is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and being designed, built and populated with data

• a. Database

• b. Database Instance

• c. Schema

• d. Schema Instance

QN=2 (6801) Choose the most correct statement.

• a. Database is created and maintained by a DMBS

• b. All of the others

• c. Database is a collection of data that is managed by a DBMS

• d. Database is a collection of information that exists over a long period of time

QN=3 (6802) Which of following is never used as a data model?

• a. Hierarchical data model

• b. None of the others

• c. Graph-based data model

• d. Tree-based data model

• e. Relational data model

QN=4 (6817) A ____ is a relation name, together with the attributes of that relation.

• a. schema

• b. database

• c. database instance

• d. schema instance

QN=5 (6824) A ___ is a notation for describing the structure of the data in a database, along with the constraints on that data

• a. data model

• b. database management system

• c. data operation

• d. data manipulation

QN=6 (6827) A _____ is a language for defining data structures

• a. DDL

• b. DML

• c. DCL

• d. None of the others

QN=7 (6834) Which statement is used to remove a relation named R?

• a. DROP TABLE R;

• b. REMOVE TABLE R;

• c. DELETE TABLE R;

• d. TRUNCATE TABLE R;

QN=8 (6829) What is another term for a row in a relational table?

• a. Attribute

• b. Tuple

• c. Field

• d. Relation

QN=9 (7961) Given a relation R(A,B,C,D). Which of the followings is trivial?

• a. A->AB

• b. A->->AB

• c. A->BCD

• d. A->->BCD

QN=12 (7990) Consider the following functional dependenciesa,b -> c,d e,g,h -> f,ja,c -> b,d p,q -> r,se,f,g -> h,i s -> tf,g -> j q -> ug,h -> iWhich of the following best describes the relation R(e,f,g,h,i,j)?

• a. R is in First Normal Form

• b. R is in Second Normal Form

• c. R is in Third Normal Form

• d. R is in Boyce Codd Normal Form