Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Oracle Interview Questions and Answers

Related differences

OracleJDK vs OpenJDK

Ques 16. Can a Tablespace hold objects from different Schemes?

Yes

Is it helpful? Add Comment View Comments
 

Ques 17. Can objects of the same Schema reside in different tablespace?

Yes

Is it helpful? Add Comment View Comments
 

Ques 18. What is the use of Control File?

When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.

Is it helpful? Add Comment View Comments
 

Ques 19. Do View contain Data?

Views do not contain or store data.

Is it helpful? Add Comment View Comments
 

Ques 20. What are the Referential actions supported by FOREIGN KEY integrity constraint?

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

©2024 WithoutBook