SQL Questions with Answers

Fill in the blanks :

1. No of User variables in sql*plus is 1024.

2. User can have 100 many number of variables per sql command.

3. User can have 500 many number of lines (assuming 80 characters per line) per sql command.

4. The size of PL/SQL buffer in Oracle 7 is 2k and in Oracle6 is 512k

5. Start command is used to run the contents of the specified command file.

6. The intersect operator is used to get only those rows that returned by both the query.

7. The Grand command is used to set the System privileges, Object privileges.

8. The Savepoint command is used to identify the point in a transaction to which you can

later Rollback.

9. To perform one of these operations on your current transaction:

* Establish your current transaction as either a read only or a read-write transaction

* Assign your current transaction to a specified rollback segment

The Set Transaction command is used.

10. The to-char function is used to convert the number datatype to a value of varchar2

datatype.

11. The Truncate command is used to remove all rows in a Table or Cluster instantly.

Note : We can not truncate rows from a table which is part of a cluster.

We cannot truncate rows from a table which has a referenced integrity constraint.

12. The Cluster is a schema object that contains one or more tables that have one

or more columns in common.

13. The Create Role command is used to set a set of privileges that can be granted to users

or to other roles.

14. To perform one of these functions on an index,table, or cluster:

* To collect statistics about the object used by the optimizer and store them in the data

dictionary.

* To delete statistics about the object from the data dictionary.

* To validate the structure of the object.

* To identify migrated and chained rows of the table or cluster.

The Analyze Command is used.