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

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

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

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

Front end programming can be changed without affecting ____________ programming.

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

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

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

PL/SQL function must contain a _____________ .

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

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

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

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

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

Which keyword is not used in PL/SQL procedure?

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

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

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

PL/SQL uses a _______ structured syntax.

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

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

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

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

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

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

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

Which of the following database provide the concept of partitions as tablespaces?

• A) MS Excel
• B) MS Access
• C) Clipper
• D) Oracle

Which of the following archive destination status indicates whether there was a problem accessing the destination?

• A) Valid/Invalid
• B) Active/Inactive
• C) Enabled/Disabled
• D) Archiving/ Non-Archiving

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

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

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

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

The structure consists of two or more pre-allocated files that store all changes made to the database as they occur, known as ______________.

• A) Change store log
• B) Undo Log
• C) Backup Log
• D) Redo Log

_______­­­­­__ determines if the information about the disc location or the service name is specified and valid.

• A) Active/Inactive
• B) Valid/Invalid
• C) Archiving/ Non-Archiving
• D) Enabled/Disabled

To create a new group of redo log files, use the SQL statement ALTER DATABASAE with the ______________ clause with Group number.

• A) ADD LOGFILE
• B) ADD GROUP FILE
• C) ADD REDO LOGFILE
• D) ADD GROUP LOG FILE