Deck 10: Basic Data Management

Question 1

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

Answer 1

True

Question 2

All DDL statements issue an implicit commit.

Answer 2

True

Question 3

The single table INSERT statement is used to insert rows into a single table,some tables,or all of a group of tables.

Answer 3

False

Question 4

The INSERT,UPDATE,and DELETE statements change data in a database and are thus all DDL statements.

Question 5

The non-conditional multiple-table INSERT statement is used to execute all INSERT statements for all rows selected by the subquery.

Question 6

Redo log entries are written before anything else in order to maintain database recoverability.

Question 7

Default settings for the SET TRANSACTION statement are READ WRITE and ISOLATION LEVEL READ COMMITTED.

Question 8

SQL Loader can often be even as much as thousands of times faster in bulk loading data into a database,in comparison to executing a multitude of individually coded INSERT statements.

Question 9

A transaction starts whenever a DML statement is issued.

Question 10

Typically,directory objects are used for external tables.

Question 11

It is important for database administrators to understand how COMMIT and ROLLBACK statements function.

Question 12

In general a properly coded application is likely to contain many more ROLLBACK than COMMIT statements.

Question 13

The SET TRANSACTION statement is mandatory for any given transaction.

Question 14

The UPDATE statement allows you to remove existing rows in a table.

Question 15

The metadata of an external table is stored in the database.

Question 16

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

Question 17

The SQL Loader utility is often called SQL*Loader or SQL*Ldr.

Question 18

Default settings for the LOCK TABLE statement are ROW SHARE and MODE WAIT.

Question 19

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

Question 20

External tables can have all DML statements executed against them.

Question 21

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

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

Question 22

The ____ utilities can easily dump and import data from one or more tables,even entire schemas or a full database,including both data in tables and the table structures themselves.

A) Data Pump import and export
B) PL / SQL
C) SQL Loader
D) SQL*Ldr

Question 23

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

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

Question 24

The locking mode ____ is similar to ROW SHARE,additionally prohibiting a SHARE lock on the table.

A) SHARE ROW EXCLUSIVE
B) SHARE UPDATE
C) ROW EXCLUSIVE
D) MODE

Question 25

The ____ statement creates a label.That label can be used later in a transaction as a point to roll back to.

A) SAVEPOINT
B) ROLLBACK
C) COMMIT
D) SET TRANSACTION

Question 26

The ____ statement lets you remove existing rows from tables.

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

Question 27

The ____ statement is used to add new rows to tables.

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

Question 28

Data warehouses might benefit from the use of external tables.

Question 29

A ____ INSERT statement adds to more than a single table using the same INSERT statement,on a conditional basis.

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

Question 30

____ is used to merge data from a source table into a target table.

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

Question 31

The locking mode ____ prohibits locking of an entire table exclusively,allowing full concurrent multiple user access,with no restrictions on viewing and changing data in the table.

A) SHARE
B) ROW SHARE and SHARE UPDATE
C) ROW EXCLUSIVE
D) EXCLUSIVE

Question 32

A ____ is the most basic storage unit for data in Oracle 10g.

A) column
B) table
C) row
D) record

Question 33

A transaction is completed on execution of a COMMIT or ____ statement,or a disconnection from a session.

A) SELECT
B) ROLLBACK
C) SAVEPOINT
D) INSERT

Question 34

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) READ ONLY
B) ISOLATION LEVEL READ COMMITTED
C) USE ROLLBACK SEGMENT
D) READ WRITE

Question 35

The ____ parameter for the SET TRANSACTION forces all queries to see data as a snapshot at a single point in time regardless of any database changes after the start of execution of each query in a transaction.

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

Question 36

In commercial parlance,a ____ is a business agreement or exchange,usually involving money changing hands.

A) column
B) statement
C) transaction
D) table

Question 37

The locking mode ____ locks a table (or an updatable view),disallowing locking of the table in SHARE mode,and prohibiting changes to the table.

A) SHARE ROW EXCLUSIVE
B) SHARE
C) EXCLUSIVE
D) SHARE UPDATE

Question 38

You can change data in tables using ____ statements.

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

Question 39

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

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

Question 40

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

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

Question 41

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

Question 42

____________________ are two-dimensional storage structures comprised of rows and columns.

Question 43

There are three primary DML statements used to change data in an Oracle database.These statements are INSERT,UPDATE,and ____________________.

Question 44

The locking mode ____________________ prohibits any changes to a locked table,permitting concurrent queries only.

Question 45

The ____________________ utility can be used to rapidly load entire data sets into tables.

Question 46

When using the SET TRANSACTION statement ______________________________ parameter,DML statements within a transaction will fail immediately if a row lock held by another transaction is encountered.

Question 47

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

Question 48

The ____________________ statement permits control of a transaction as a whole from the first DML statement through to a transaction completion statement or event.

Question 49

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

Question 50

You can use ______________________________ statements to create tables,create indexes,and apply constraints.

Question 51

A(n)____________________ statement is commonly known as an upsert in that rows already existing in the target table are updated by source table rows.

Question 52

The ____________________ statement places a lock on an entire table.

Question 53

In relational database terminology a(n)____________________ is a sequence of one or more DML statement-induced database changes,not yet permanently committed to that database.

Question 54

______________________________ statements are used to change data structures such as tables.

Question 55

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

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

Question 56

When using the SET TRANSACTION statement ______________________________ parameter,DML statements within a transaction will wait for a row lock held by other transactions.

Question 57

A(n)____________________ INSERT statement adds to a single table.

Question 58

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

Question 59

The locking mode ____________________ prohibits changes and allows queries only.

Question 60

You could read data from the external table using a(n)____ statement.

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

Question 61

Describe the syntax for the single table INSERT statement.

Question 62

A(n)____________________ is used to create a reference to a file,which is stored externally to an Oracle database.

Question 63

A(n)____________________ contains data in a file outside the database,such as in a text file.

Question 64

Why can DDL statements not be rolled back?

Question 65

What does ROLLBACK do?