The database can _______ space within an index block.

• A) Reuse
• B) Delete
• C) Insert
• D) Update

_________ is the smallest unit of storage that Oracle Database can use or allocate.

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

Exceptions can be raised explicitly by the programmer by using the command _________.

• A) RAISE
• B) EXCEPTION HANDLER
• C) EXCEPTION
• D) EXCEPTION CODE

A tablespace is a logical storage container for_______.

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

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) 50%
• C) 40%
• D) 80%

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

________ are the basic unit of data storage in an Oracle Database.

• A) Index
• B) Data
• C) Tables
• D) Views

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

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

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

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

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

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

A ________ is a logical representation of one or more tables.

• A) Segment
• B) Index
• C) Block
• D) View

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

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

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

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

Front end programming can be changed without affecting____________ programming.

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

You do not need a ___________ or the UNLIMITED TABLESPACE system privilege to create a table in a cluster.

• A) Table
• B) Index
• C) Cluster
• D) Tablespace quota

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

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

Unlike an ordinary (heap-organized) table, data for an _________ is stored in a B-tree index structure in a primary key sorted manner.

• A) Alter table
• B) Clustered table
• C) Index-organized table
• D) Partitioned Table

A/an __________ derives its data from the tables on which it is based.

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

An ________________ is a view that contains multiple tables in the top-level FROM clause of the SELECT statement, and is not restricted by the WITH READ ONLY clause.

• A) Add join view
• B) Update join view
• C) Edit join view
• D) Updatable join view

____________ code is executed on server without any network overhead.

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