Oracle Interview Questions And Answers


Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert

Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel

Oracle Interview Questions And Answers


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