IBPS SO | IT OFFICER QUIZ

DBMS

1. In an ER diagram, entity set is represented by a:
a) Rectangle
b) Ellipse
c) Diamond box
d) Circle

2.The DBMS language component which can be embedded in a program:
a) DDL(data definition language)
b) DML(data manipulation language)
c) DBA(database adminstrator)
d) Query language

3. A relational database developer refers to a record as:
a) A criteria
b) A relation
c) Tuple
d) An attribute

4. The method in which records are physically stored in a specified order according to a key field in each record is:
a) Hash
b) Direct
c) Sequential
d) All of the above

5. Count function in SQL returns the number of:
a) Values
b) Distinct values
c) Groups
d) Columns

6. The method of access which uses key transformation is known as:
a) Direct
b) Hash
c) Random
d) Sequential

7. The statement in SQL which allows to change the definition of a  table is:
a) Alter
b) Update
c) Create
d) Select

8. Relational algebra is:
a) Data definition language
b) Meta language
c) Procedural Query language
d) None of these

9. Key to represent relationship between tables is called:
a) Primary key
b) Secondary key
c) Foreign key
d) None of these

10. DBMS helps to achieve:
a) Data independence
b) Centralized control of data
c) Both A and B
d) None