ORACLE INTERVIEW QUESTION & ANSWERS
| 81. |
What is a stored procedure? |
| |
A stored procedure is a set of SQL statements that are pre-parsed and stored in the database. When the stored procedure is invoked, only the input and output data is passed; the SQL statements are not transferred or parsed. |
| 82. |
What are some duties of the DBA? |
| |
- Installing software
- Creating databases
- Tablespaces
- Tables
- Views
- Indexes and accounts
- Monitoring space and performance
- Maintaining the integrity of the data in the database are all duties of the DBA.
|
| 83. |
What is the major difference between the clob and blob data types in Oracle Database lOg? |
| |
The clob stores only alphanumeric data, whereas the blob can accommodate any type of data, including sound and video. |
| 84. |
What is a synonym? |
| |
A synonym is another name for a database object. They are very useful when the database has a complex name for an object. |
| 85. |
How do you remove a system privilege from a role? |
| |
Privileges are removed from roles via either Security Manager or the REVOKE command. |
