More SQL Questions with Answers

Leave a Comment

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


Post a Comment