Important Objectives For Database Management System

1.      In the relational modes, cardinality is termed as : Number of tuples.

2.      Relational calculus is a : Non- Procedural language.

3.      The view of total database content is : Conceptual view.

4.      Cartesian product in relational algebra is-a Binary operator.(It requires two operands)

5.      DML is provided for -manipulation & processing of database.

6.      Data stored in the database is processed or manipulated using data manipulation language commands as its name

7.      ‘AS’ clause is used in SQL for-Rename operation.

8.      ODBC stands for-Open Database Connectivity.

9.      Architecture of the database can be viewed as-three levels.

10.  In a relational model, relations are termed as-Tables.

11.  The database schema is written in-DDL

12.  In the architecture of a database system external level is the-view level.

13.  An entity set that does not have sufficient attributes to form primary key is -weak entity set

14.  In a Hierarchical model records are organized as-Tree.

15.  In tuple relational calculus P1 _ P2 is equivalent to ¬P1 Ú P2. (The logical implication expression A _ B, meaning if A then B,is equivalent to ¬A Ú B)

16.  The language used in application programs to request data from the DBMS is referred to as the-DML

17.  A logical schema-is the entire database.

18.  Related data fields in database are grouped to form :data record(Record is collection of related fields)

19.  The database environment has all of the following components except: Users

20.  The language which has recently become the defacto standard for interfacing application programs with relational database system is- 4GL

21.  The way a particular application views the data from the database that the application uses is a-sub schema.

22.  The DBMS language component which can be embedded in a program is-DML

23.  The relational model feature is that there-is much more data independence than some other database models.

24.  Conceptual design-involves modelling independent of the DBMS.

25.  A method in which records are physically stored in a specified order according to a key field in each record is -hash.(In hash method, a hash function is performed on the key value to determine the unique physical address of the record to store or retrieve)

26.  A subschema expresses-the external view.

27.  Data elements in the database can be modified by changing the data dictionary

28.  An advantage of the database management approach is-data is integrated and can be accessed by multiple programs.

29.  Transaction processing is associated with everything below except-confirming an action or triggering a response.

30.  SET concept is used in :- Network Model

31.  Relational Algebra is-Procedural query Language

32.  Cartesian product-produces the relation that has attributes of R1 and R2

33.  The file organization that provides very fast access to any arbitrary record of a file is Hashed File

34.  Which of the following is correct:

A.    a SQL query automatically eliminates duplicates.

B.     SQL permits attribute names to be repeated in the same relation.

C.    a SQL query will not work if there are no indexes on the relations

D.    None of these                                                                           Ans-D