DBMS MCQ-2

image_pdfimage_print

1)Locking may cause which of the following problems?
a)Deadlock
b)Versioning
c)Versioning & deadlock
d)Erroneous updates
e)Erroneous updates and deadlock

2)Which of the following are placeholders for literal values in a SQL query being sent to the database?
a)reduction and resolution variables
b)resolution variables
c)reduction variables
d)assimilation variables
e)bind variables

3)What is meant by type in RDBMS?
a)Domain
b)Range
c)Named set of value
d)Both a and c
e)None of these

4)What are the function of DCL?
a)handling the authorization aspects of data
b)permitting the user to control who has access to see or manipulate data within the database
c)both a and b
d)a only
e)None of these

5)Which database level is closest to the users?
a)External
b)Internal
c)Physical
d)Conceptual
e)None of these

6)Fifth Normal Form is concerned with
a)Functional dependency
b)Multi-valued Dependency
c)Join Dependency
d)Domain Key
e)None of these

7)In E-R diagram, the term cardinality is a synonym for the term………
a)Attributes
b)Degree
c)Entities
d)Cartesian
e)None of these

8)Rows of a relation are called:
a)Relation
b)Tuples
c)Data Structures
d)An entity
e)None of these

9)An Oracle server index———
a)Is a schema object
b)Is used to speed up the retrieval of rows by using a pointer
c)Is independent of the table its indexes
d)All of the above
e)None of these

10)In Oracle, what is the default number of transactions that MAXTRANS is set to if not specified?
a)512
b)10
c)40
d)1
e)255

Answers:
1)a
2)e
3)d
4)c
5)a
6)c
7)b
8)b
9)d
10)e