SQL INTERVIEW QUESTION & ANSWERS
| 51. |
What are the differences between an SQL agent and an SQL implementation? |
| |
An SQL agent is any structure that causes SQL statements to be executed. The SQL agent is bound to the SQL client within the SQL implementation. An SQL implementation is a processor that executes SQL statements according to the requirements of the SQL agent.
The SQL implementation includes one SQL client and one or more SQL servers. The SQL client establishes SQL connections with the SQL servers and maintains data related to interactions with the SQL agent and the SQL servers. An SQL server manages the SQL session that takes place over the SQL connection and executes SQL statements received from the SQL client. |
| 52. |
What command creates a grouping or collection of tables, views, and privileges? |
| |
The CREATE SCHEMA statement |
| 53. |
What are the three basic operations of a cursor outside of declaring the cursor? |
| |
There are some basic operations of a cursor outside of declaring the cursor are : - OPEN
- FETCH
- CLOSE
|
| 54. |
What are the types of cursor? |
| |
There are two types of cursors are :
- Implicit cursors
- Explicit cursors
|
| |
Posted by Raja. (Jul 25, 2014) |
| |
There are three types of cursors are :
1. Implicit cursors
2. Explicit cursors
3. Ref cursors. |
| 55. |
Mention two drawbacks of SQL? |
| |
- SQL statements can be executed only one at a time.
- Every time to execute a SQL statement, a call is made to Oracle engine, thus it results in an increase in database overheads.
- While processing an SQL statement, if an error occurs, Oracle generates its own error message, which is sometimes difficult to understand.
- If a user wants to display some other meaningful error message, SQL does not have provision for that.
|
