ORACLE INTERVIEW QUESTION & ANSWERS
| 36. |
What is the difference between a privilege and a role? |
| |
- A privilege is the authority to perform a certain act or command.
- A role is a collection of privileges and roles that can be assigned to a user.
|
| 37. |
Which keyword can be used in a GRANT command to assign one or more privileges to every user in the database? |
| |
The PUBLIC keyword can be used instead of an individual username or role in a GRANT command to assign one or more privileges to every user in the database. |
| 38. |
What is the different between a fixed and a variable record load file?
|
| |
The fixed record load file has data in columns where the same column in each record has the same length. The variable record datafile has different records where the same column may be
a different length. |
| 39. |
What type of key can be used to enforce referential integrity between two tables in a database? |
| |
A foreign key can be used to enforce referential integrity between two tables.
|
| 40. |
What is a database instance? |
| |
A database instance is a set of memory structure and background processes that access a set of database files. The processes can be shared by all of the users. |
