Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

Oracle Interview Questions and Answers

Related differences

OracleJDK vs OpenJDK

Ques 31. What are the advantages of views?

- 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?

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?

- 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?

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:

©2024 WithoutBook