Oracle Interview Question and Answers

16. What is a User_exit?
  Calls the user exit named in the user_exit_string. Invokes a 3Gl program by name which has been properly linked into your current oracle forms executable.
17. What is schema?
  A schema is collection of database objects of a user.
18. What are Roles?
  Roles are named groups of related privileges that are granted to users or other roles.
19. What are the dictionary tables used to monitor a database spaces ?
 
  • DBA_FREE_SPACE
  • DBA_SEGMENTS
  • DBA_DATA_FILES
20. What is a SNAPSHOT?
  Snapshots are read-only copies of a master table located on a remote node which is periodically refreshed to reflect changes made to the master table.
Page 4 of 12 123 456789101112