IBPS SO | IT OFFICER QUIZ - 7

DBMS

1. Which of the following is a valid SQL type ?

a. CHARACTER

b. NUMERIC

c. FLOAT

d. None of these

2. Which of the following is an advantage of a view ?

a. Data security

b. Derived columns

c. Hiding of complex queries

d. All of the above

3. Which database level is closest to the users ?

a. External

b. Internal

c. Physical

d. Conceptual

4. A set of possible data values is called ?

a. Attribute

b. Degree

c. Tuple

d. Domain

5. Which of the following is the another name for the weak entity ?

a. Child

b. Owner

c. Dominant

d. All of the above

6. Which of the following database does not physically exist ?

a. Base table

b. Index

c. View

d. None of these

7. Which two files are used during operating DBMS ?

a. Query language and utilities

b. DML and query language

c. Data Dictionary and transaction lag

d. Data Dictionary and Query language

8. ____________ data type can store unstructured data.

a. RAW

b. CHAR

c. NUMERIC

d. VARCHAR

9. Cartesian product in relational algebra is ____________.

a. A unary operator

b. A binary operator

c. A ternary operator

d. None of these

10. In a Hierarchical model records are organised as ?

a. Graph

b. Lists

c. Link

d. Tree

# Answers
1.d
2.d
3.a
4.d
5.a
6.c
7.c
8.a
9.b
10.d