IBPS SO | IT OFFICER QUIZ - 2

DBMS - 2

1. The view of total database content is:
a) Conceptual view
b) Internal view
c) External view
d) Physical view

2. Cartesian product in relational algebra is:
a) Unary operator
b) Binary operator
c) Ternary operator
d) Not defined

3. 'AS' clause in SQL is used for:
a) Selection operation
b) Join operation
c) Rename operation
d) Projection operation

4. ODBC stands for
a) Object database connectivity
b) Oral database connectivity
c) Oracle database connectivity
d) Open database connectivity

5. Architecture of database can be viewed as:
a) Two level
b) Four level
c) Three level
d) One level

6.In a relational model, relations are termed as:
a) Tuples
b) Attributes
c) Tables
d) Rows

7. Database schema is written in:
a) HLL
b) DML
c) DDL
d) DBA

8. In the architecture of database system, external level is the:
a) Physical level
b) Logical level
c) Conceptual level
d)  View level

9. An entity set does not have sufficient attributes to form a primary key is:
a) Strong entity set
b) Weak entity set
c) Simple entity set
d) Primary entity set

10. In a hierarchical models, records are organised as:
a) Graph
b) List
c) Link
d) Tree

Answers:

1. conceptual view

2. binary operator

3. rename operation

4. open database connectiovity

5. 3 level

6, tables

7. DDL

8. view level

9. weak enitity set

10. tree