Page 81 of 95
Ans : A
39. Datadictionary can span across multiple Tablespaces
a] TRUE
b] FALSE
Ans : B
40. What is a DATABLOCK
a] Set of Extents
b] Set of Segments
c] Smallest Database storage unit
d] None of the above
Ans : C
41. Can an Integrity Constraint be enforced on a table if some
existing
table data does not satisfy
the constraint
a] Yes
b] No
Ans : B
42. A column defined as PRIMARY KEY can have NULL's
a] TRUE
b] FALSE
Ans : B
43. A Transaction ends
a] Only when it is Committed
b] Only when it is Rolledback
c] When it is Committed or Rolledback
d] None of the above
Ans : C
44. A Database Procedure is stored in the Database
a] In compiled form
b] As source code
c] Both A & B
d] Not stored
Ans : C
45. A database trigger doesnot apply to data loaded before the
definition
of the trigger
a] TRUE
b] FALSE
Ans : A
46. Dedicated server configuration is
a] One server process - Many user processes
b] Many server processes - One user process
c] One server process - One user process
d] Many server processes - Many user processes
Ans : C
|
|