EMP.sal%TYPE is an example of __________ data type.

• A) Complex
• B) Subtype
• C) Composite
• D) Scalar

Which of the following is not a parameter of PL/SQL procedure?

• A) IN
• B) OUT
• C) CREATE
• D) IN OUT

Which of the following cannot be performed in PL/SQL procedure?

• A) Declare
• B) Create
• C) Replace
• D) Drop

PL/SQL function must contain a _____________ .

• A) Follow Statement
• B) GOTO Statement
• C) NULL Statement
• D) Return Statement

Which keyword is not used in PL/SQL procedure?

• A) Replace
• B) Create
• C) Begin
• D) Declare

In PL/SQL procedure, how many types of parameters can be used?

• A) 2
• B) 3
• C) 4
• D) 5

Which of the following is a parameter that can be used in PL/SQL function?

• A) OUT
• B) IN OUT
• C) ALL
• D) IN

PL/SQL uses a _______ structured syntax.

• A) Banner
• B) Physical
• C) Block
• D) Logical

A/an ________ is a logical representation of a table or combination of tables.

• A) View
• B) Function
• C) Index
• D) Join

A/an _________ derives its data from the table on which it is based. This table is known as base table.

• A) Function
• B) Join
• C) Index
• D) View

__________ is the basic unit of data storage in an Oracle Database.

• A) Index
• B) Join
• C) Table
• D) Function

You can use views in almost the same way as __________.

• A) Join
• B) Function
• C) Table
• D) Index

A/an ____________ is a collection of column information corresponding to a single record.

• A) Entity
• B) Attribute
• C) Table
• D) Row

A/an _________________ is a schema object that contains an entry for each value that appears in the column of the table or cluster and provides direct, fast access to rows.

• A) Index
• B) Cluster Table
• C) View
• D) Join

To alter an index, your schema must contain the index or you must have the ______________ system privilege.

• A) ANY INDEX ALTER
• B) ALTER ANY INDEX
• C) ALTER PRIVILEGE
• D) ALTER INDEX

Making an index ____________ is an alternative method to make it unusable or dropping it.

• A) MUTE
• B) INVISIBLE
• C) VISIBLE
• D) UNREADABLE

How many types of views are utilized to control table-related information?

• A) 3
• B) 5
• C) 2
• D) 4

_______________ statement is used to change or rebuild an existing index.

• A) ALTER INDEX
• B) REBUILD INDEX
• C) CHANGE INDEX
• D) UPDATE INDEX

Which of the following table statement is used to delete only the table structure from the database?

• A) Drop
• B) Update
• C) Delete
• D) Create