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

What is a CPK

  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

AI Explanation

To answer this question, you need to understand the different mechanisms available in PL/SQL for storing table data for multiple rows.

Option A) Cursor - A cursor is used to process individual rows returned by a SQL query. It is not the best choice for storing table data for multiple rows in a PL/SQL variable.

Option B) Varchar2 - Varchar2 is a data type used to store character strings. It is not suitable for storing table data for multiple rows.

Option C) PL/SQL table - A PL/SQL table is a collection type that can hold data of the same type. It can be used to store table data for multiple rows. However, it is not the best choice for this task.

Option D) Table of records - This is the correct answer. A table of records is a collection type that can hold multiple rows of data, with each row being a record type. It is specifically designed for bulk data operations and is the best mechanism for storing table data for multiple rows in a PL/SQL variable.

Option E) Record - A record is a composite data type that can hold multiple fields, but it is not designed for storing table data for multiple rows.

The correct answer is D) Table of records. This option is correct because it identifies the mechanism best suited for storing table data for multiple rows in a PL/SQL variable.

What is the maximum number of sub programs allowed inside a package

  1. 12

  2. 256

  3. 1024

  4. Unlimited


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

Maximum number of coulmns allowed in a table

  1. 256

  2. 128

  3. 512

  4. 1000


Correct Option: D

Maximum number of columns allowed inside an index

  1. 12

  2. 256

  3. 128

  4. 32


Correct Option: D

Which of the following is DDL Statement

  1. Truncate

  2. Merge

  3. Revoke

  4. Grant


Correct Option: A

Select the incorrect Oracle Select Statement

  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

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

we can select while LOCk is on a rows

  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