More SQL Questions with Answers

Select the Correct 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] Lock table

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