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

What is a U K

  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

What is the maximum parsed size of the PL/SQL block

  1. 64K

  2. 128K

  3. 256K

  4. Unlimited


Correct Option: A

What command will you use to encrypt a PL/SQL block

  1. COMPILE DEBUG

  2. WRAP

  3. ENCRYPT

  4. COMPILE


Correct Option: B

how many distinct triggers can be created on the table

  1. 12

  2. 4

  3. 2

  4. Unlimited


Correct Option: A
  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

Which of the following is a DML Statement

  1. Truncate

  2. Merge

  3. Revoke

  4. Grant


Correct Option: B

Select Incorrect Oracle Group Function

  1. floor

  2. sum

  3. variance

  4. stddev


Correct Option: D
  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
- Hide questions