Question 1

The ____ statement allows you to change column values in existing rows in a table.

Accepted Answer

A)  SELECT 
B)  INSERT 
C)  MERGE 
D)  UPDATE 
A)  SELECT 
B)  INSERT 
C)  MERGE 
D)  UPDATE

Question 2

Database changes are undone using a(n)____________________ statement.

Accepted Answer

The answer of Database changes are undone using a(n)____________________ statement....

Question 3

DDL statements make permanent changes to the database and cannot be undone (rolled back).

Accepted Answer

A) True 
 B)False

Question 4

The ____ parameter for the SET TRANSACTION forces all queries to see a snapshot of data prior to the start of a transaction,regardless of how many DML statements are within a transaction.

Accepted Answer

A)  READ ONLY 
B)  ISOLATION LEVEL READ COMMITTED 
C)  USE ROLLBACK SEGMENT 
D)  READ WRITE 
A)  READ ONLY 
B)  ISOLATION LEVEL READ COMMITTED 
C)  USE ROLLBACK SEGMENT 
D)  READ WRITE

Question 5

A transaction starts whenever a DML statement is issued.

Accepted Answer

A) True 
 B)False

Question 6

A ____ INSERT statement adds to more than a single table,using a single INSERT statement.

Accepted Answer

A)  single table 
B)  non-conditional multiple-table 
C)  conditional multiple table 
D)  non-conditional single table 
A)  single table 
B)  non-conditional multiple-table 
C)  conditional multiple table 
D)  non-conditional single table

Question 7

The ____________________ statement makes pending changes permanent for an existing transaction in the current session.

Accepted Answer

The answer of The ____________________ statement makes pending changes permanent...

Question 8

Describe the syntax for the single table INSERT statement.

Accepted Answer

This is the syntax for the single table

Question 9

The SET TRANSACTION statement is mandatory for any given transaction.

Accepted Answer

A) True 
 B)False

Question 10

Typically,directory objects are used for external tables.

Accepted Answer

A) True 
 B)False

Question 11

Database changes are permanently stored to a database using the ____ statement.

Accepted Answer

A)  UPDATE 
B)  ROLLBACK 
C)  COMMIT 
D)  INSERT 
A)  UPDATE 
B)  ROLLBACK 
C)  COMMIT 
D)  INSERT

Question 12

The ____________________ statement allows existing rows in a table to be changed.

Accepted Answer

The answer of The ____________________ statement allows existing rows in...

Question 13

You can populate an external table using Oracle 10g DML commands.

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ statement removes pending changes (not yet committed)for an existing transaction in the current session.

Accepted Answer

The answer of The ____________________ statement removes pending changes (not...

Question 15

What does ROLLBACK do?

Accepted Answer

The ROLLBACK statement does the followin

Question 16

External tables are read-only,but requiring read and write privileges in the directory they are created in.

Accepted Answer

A) True 
 B)False

Question 17

An external table can be created and loaded using a(n)____ subquery clause.

Accepted Answer

A)  LIKE 
B)  AS 
C)  EQUAL 
D)  IN 
A)  LIKE 
B)  AS 
C)  EQUAL 
D)  IN

Question 18

Data warehouses might benefit from the use of external tables.

Accepted Answer

A) True 
 B)False

Question 19

You can change data in tables using ____ statements.

Accepted Answer

A)  Data Definition Language (DDL) 
B)  SELECT 
C)  LIKE 
D)  Data Manipulation Language (DML) 
A)  Data Definition Language (DDL) 
B)  SELECT 
C)  LIKE 
D)  Data Manipulation Language (DML)

Question 20

A transaction is only complete when a COMMIT or ROLLBACK statement is executed or the ____ DDL statement executes.

Accepted Answer

A)  DROP TABLE 
B)  SELECT * 
C)  MERGE 
D)  CREATE TABLE 
A)  DROP TABLE 
B)  SELECT * 
C)  MERGE 
D)  CREATE TABLE

The ____ statement allows you to change column values in existing rows in a table.

Database changes are undone using a(n)____________________ statement.

DDL statements make permanent changes to the database and cannot be undone (rolled back).

The ____ parameter for the SET TRANSACTION forces all queries to see a snapshot of data prior to the start of a transaction,regardless of how many DML statements are within a transaction.

A transaction starts whenever a DML statement is issued.

A ____ INSERT statement adds to more than a single table,using a single INSERT statement.

The ____________________ statement makes pending changes permanent for an existing transaction in the current session.

Describe the syntax for the single table INSERT statement.

The SET TRANSACTION statement is mandatory for any given transaction.

Typically,directory objects are used for external tables.

Database changes are permanently stored to a database using the ____ statement.

The ____________________ statement allows existing rows in a table to be changed.

You can populate an external table using Oracle 10g DML commands.

The ____________________ statement removes pending changes (not yet committed)for an existing transaction in the current session.

What does ROLLBACK do?

External tables are read-only,but requiring read and write privileges in the directory they are created in.

An external table can be created and loaded using a(n)____ subquery clause.

Data warehouses might benefit from the use of external tables.

You can change data in tables using ____ statements.

A transaction is only complete when a COMMIT or ROLLBACK statement is executed or the ____ DDL statement executes.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 10: Basic Data Management

The ____ statement allows you to change column values in existing rows in a table.

Database changes are undone using a(n)____________________ statement.

DDL statements make permanent changes to the database and cannot be undone (rolled back).

The ____ parameter for the SET TRANSACTION forces all queries to see a snapshot of data prior to the start of a transaction,regardless of how many DML statements are within a transaction.

A transaction starts whenever a DML statement is issued.

A ____ INSERT statement adds to more than a single table,using a single INSERT statement.

The ____________________ statement makes pending changes permanent for an existing transaction in the current session.

Describe the syntax for the single table INSERT statement.

The SET TRANSACTION statement is mandatory for any given transaction.

Typically,directory objects are used for external tables.

Database changes are permanently stored to a database using the ____ statement.

The ____________________ statement allows existing rows in a table to be changed.

You can populate an external table using Oracle 10g DML commands.

The ____________________ statement removes pending changes (not yet committed)for an existing transaction in the current session.

What does ROLLBACK do?

External tables are read-only,but requiring read and write privileges in the directory they are created in.

An external table can be created and loaded using a(n)____ subquery clause.

Data warehouses might benefit from the use of external tables.

You can change data in tables using ____ statements.

A transaction is only complete when a COMMIT or ROLLBACK statement is executed or the ____ DDL statement executes.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

The Basics of Querying a Database

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters