_____________ data type accepts data of fixed length.

• A) CHAR
• B) TIME
• C) FLOAT
• D) DATE

Which system privilege is required to create a cluster in own schema?

• A) CREATE ANY CLUSTER
• B) CLUSTER RIGHTS
• C) CREATE CLUSTER
• D) CREATE SYSTEM CLUSTER

The ___________ is actually a data dictionary table containing information about dropped objects.

• A) Partitioned Table
• B) Clustered Table
• C) Indexed Table
• D) Recycle bin

A/an_________ provides an optional method of storing table data.

• A) Cluster
• B) Data group
• C) Index
• D) Data block

A PCTFREE setting of 20% prevents the total amount of free space from dropping to 5% of the block, but permits ______ of the block to be free space.

• A) 60%
• B) 40%
• C) 50%
• D) 80%

To create a table in a _______, you must have either the CREATE TABLE or CREATE ANY TABLE system privilege.

• A) Data
• B) View
• C) Index
• D) Cluster

Which system privilege is required to create a cluster in another user's schema?

• A) CREATE ANY CLUSTER
• B) CREATE SYSTEM CLUSTER
• C) CLUSTER RIGHTS
• D) CREATE CLUSTER

______ stores space logically to create logical objects such as Tables, Indexes and other objects.

• A) Database block
• B) Data Dictionary
• C) Index
• D) Tablespace

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

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

A ________ is a set of extents that contains all the data for a logical storage structure within a tablespace.

• A) Index
• B) Block
• C) Data file
• D) Segment

A tablespace is a logical storage container for_______.

• A) Block
• B) Index
• C) Data file
• D) Segments

A/an ______________is a schema object from which multiple users can generate unique integers.

• A) Sequence
• B) Index
• C) View
• D) Order

The code that you write to handle exceptions is called a/an___________.

• A) Exception handler
• B) Exception handling
• C) Exception SQL code
• D) Exception code

_______________ is a binary parameter file that resides on the database server machine.

• A) SPFILE
• B) Log File
• C) Control File
• D) PFILE

Oracle Trace files contain ________________.

• A) Checkpoints data
• B) Transaction data
• C) Diagnostic data
• D) Backup data

Oracle Alert log file is a ____________ file.

• A) WinRar
• B) Text
• C) Binary
• D) PDF

_____________ is a pointer that points to the result of a query.

• A) Indicator
• B) Record
• C) Index
• D) Cursor

A/an_________ is a composite data structure, which means that it is composed of one or more elements.

• A) Cursor
• B) Record
• C) Index
• D) Table

Which parameter is used in SQL Function?

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

_______________ is a text parameter file that resides on the client machine.

• A) PFILE
• B) Log File
• C) Data File
• D) SPFILE