0

databases Online Quiz - 106

Description: databases Online Quiz - 106
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. PK

  2. CPK

  3. FK

  4. UK


Correct Option: A
  1. FK

  2. CPK

  3. UK

  4. PK


Correct Option: A

You are developing a PL/SQL block designed for bulk data operations. When attemping to store table data for multiple rows in a PL/SQL variable, which one of the following choices identifies the mechanism best suited for this task (choose one)?

  1. Cursor

  2. Varchar2

  3. PL/SQL table

  4. Table of records

  5. Record


Correct Option: D
  1. COMPILE DEBUG

  2. WRAP

  3. ENCRYPT

  4. COMPILE


Correct Option: B
  1. Truncate

  2. Merge

  3. Revoke

  4. Grant


Correct Option: A
  1. select distinct * from T1

  2. select C1 from T1 order by C2

  3. select distinct C1 from T1

  4. select 12*14 from T1

  5. select C1 AS 'column1",C1 AS 'column2',C2 AS 'column1' from T1.


Correct Option: B
  1. Truncate

  2. Merge

  3. Revoke

  4. Grant


Correct Option: B

We can sort by a column without present in the SELECT List

  1. True

  2. False


Correct Option: A

Select Incorrect Oracle Group Function

  1. floor

  2. sum

  3. variance

  4. stddev


Correct Option: D

which of the following views identify the status of the view in the database

  1. USER_VIEWS

  2. USER_TAB_COLUMNS

  3. USER_TABLES

  4. USER_OBJECTS


Correct Option: D

ROWID is a column datatype

  1. True

  2. False


Correct Option: A

reference to sysdate,nextval,currval is allowed on constraint definition

  1. True

  2. False


Correct Option: A

Which index is automatically created if you enable a UNIQUE KEY or PRIMARY KEY constraint

  1. cluster index

  2. simple index

  3. unique index

  4. functional index


Correct Option: C

We can insert a new column in between two existing columns without altering the table.

  1. True

  2. False


Correct Option: A
- Hide questions