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

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

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

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

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

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

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

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

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) View
• B) Cluster Table
• C) Index
• D) Join

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

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

Which of the following option is not a characteristic of PL/SQL?

• A) Embedded structured programming
• B) Executed on server without any network overhead
• C) Centrally accessible from single database
• D) Performed on client Machine

Which of the following language code is executed on server without any network overhead?

• A) PHP
• B) PL/SQL
• C) Python
• D) C++

Front end programming can be changed without affecting ____________ programming.

• A) Client
• B) Server and client
• C) SQL
• D) Server

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