Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Practice InterviewNew Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

Oracle Interview Questions and Answers

Ques 31. What are the advantages of views?

Ans. - Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.

Is it helpful? Add Comment View Comments
Ques 32. What is an Oracle sequence?
Ans. A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
Is it helpful? Add Comment View Comments
Ques 33. What are synonyms used for?
Ans. - Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.
Is it helpful? Add Comment View Comments
Ques 34. What does a Control file Contain?
Ans. A Control file records the physical structure of the database. It contains the following information.
Database Name
Names and locations of a database's files and redolog files.
Time stamp of database creation.
Is it helpful? Add Comment View Comments

Most helpful rated by users:

©2020 WithoutBook