SQL*PLUS QUESTIONS

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 sqlcommand.

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 transactionas 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 allrows 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 objectfrom 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.

Select theCorrect Answer:

1. An index can have as many as Columns.

a] 255

b] 21

c] 16

2. A number of columns in a table ranges from 1 to ­­­____

a] 255

b] 254

c] 030

d] None of the above

3. The maximum number of components in the Decode expression, including

searches, results and default is

a] No limitation

b] 255

4. ___________is an alternative name for a table, view, sequence, procedure, stored

function, package, snapshot or another synonym.

a] Synonym

b] Data block

c] View

d] None of the above

5. The _________ operator is used in character string comparisons with pattern matching

a] Between.. And

b] Equal operator

c] Set operator

d] Like

6. __________returns only one copy of each set of duplicate rows selected.

a] Unique

b] Distinct

c] Group By

d] None of the above

7. _____________ is used to lock the selected rows

a] Locktable

b] For update of

c] Object privileges

d] Row share

8. _____________Clause restricts the groups of rows returned to those groups for the

specified condition id True

a] Where clause

b] Having Clause

c] Distinct

d] Exists

9. The ________ option is used to return rows in a hierarchial order

a] Connect by start with

b] Order by

10. The ________ function is used to return the number of bytes in the internal

representation of expression

a] Length

b] Vsize

c] LengthLB