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.
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.
No comments:
Post a Comment