1. What is the difference between file server and a database server ?

A file server just transfers all the data requested by all its client and the client processes the data while a database server runs the query and sends only the query output.

2. What are the responsibilities of a Server ?

• Manage resources optimally across multiple clients.
• Controlling database access and security.
• Protecting the databse and recovering it from crashes.
• Enforcing integrity rules globally.

3. What does the OLTP stands for ?

OLTP stands for On Line Transaction Processing

4. When invoking this procedure, you encounter the error:
ORA-000: Unique constraint(SCOTT.THEATER_NAME_UK) violated.
How should you modify the function to handle this error?

• An user defined exception must be declared and associated with the error code and handled in the EXCEPTION section.
• Handle the error in EXCEPTION section by referencing the error code directly.
• Handle the error in the EXCEPTION section by referencing the UNIQUE_ERROR predefined exception.
• Check for success by checking the value of SQL%FOUND immediately after the UPDATE statement.

5. Where the integrity constraints are stored in data dictionary?

The integrity constraints are stored in USER_CONSTRAINTS.

6. TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ?

Both will result in deleting all the rows in the table EMP..

7. What is the use of CASCADE CONSTRAINTS?

When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.

8. Mutating Table

Mutating Table is a table that is currently being modified by an Insert, Update or Delete statement. Constraining Table is a table that a triggering statement might need to read either directly for a SQL statement or indirectly for a declarative Referential Integrity constraints. Pseudo Columns behaves like a column in a table but are not actually stored in the table. E.g. Currval, Nextval, Rowid, Rownum, Level etc.

9. How is a connection establised by ODBC ?

ODBC uses the description of the datasource available in the ODBC.INI file to load the required drivers to access that particular back end database.

10. What are the two components of ODBC ?

• An ODBC manager/administrator and
• ODBC driver