Tag: databases

Questions Related to databases

On which data type indexes can not be created.
technology databases

  1. NUMBER

  2. LONG

  3. VARCHAR2

  4. RAW

Show answer
Correct Option: B

what are the minimum values that can be assigned to POSITIVE , NATURAL and SIGNTYPE data types respectively.
technology databases

  1. 1 , 1 and 1

  2. 0 , 1 and 0

  3. 1 , 0 and -1

  4. 0 , 0 and -1

Show answer
Correct Option: C

which of the following is TRUE.
technology databases

  1. NUMBER is the subtype of INTEGER data type

  2. PLS_INTEGER is the subtype of BINARY_INTEGER

  3. POSITIVE data type is defined in SYS package.

  4. None of the above.

Show answer
Correct Option: B

which of the following is TRUE about collections.
technology databases

  1. Only nested tables need initilization.

  2. Index-by tables is a persistent collection

  3. nested tables are known as associative arrays.

  4. VARRAYs hold fixed number of elements

Show answer
Correct Option: D

Which of the following is not a subtype of NUMBER data type.
technology databases

  1. NATURAL

  2. NATURALN

  3. POSITIVE

  4. SIGNTYPE

Show answer
Correct Option: B

Select the correct pseudocolumns
technology databases

  1. CURRVAL

  2. LEVEL

  3. ROWNUM

  4. COUNT

Show answer
Correct Option: A,B,C

Can the ORDER BY clause use column index of the select clause to sort the fetched records.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Choose the functions that can be used with NULL values
technology databases

  1. NVL

  2. NULLIF

  3. DECODE

  4. COALESCE

Show answer
Correct Option: A,B,D

Which clause use CASCADE CONSTRAINTS in the syntax?
technology databases

  1. ALTER TABLE DROP COLUMN

  2. ALTER TABLE DROP CONSTRAINT

  3. ALTER TABLE DISABLE CONSTRAINT

  4. -

Show answer
Correct Option: A

Choose the database objects
technology databases

  1. TABLE

  2. VARCHAR2

  3. SEQUENCE

  4. INDEX

Show answer
Correct Option: A,C,D