Question 1

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Accepted Answer

A) True 
 B)False  True

Question 2

Oracle Database does not require the use of Archive ReDo files for instance recovery.

Accepted Answer

A) True 
 B)False  True

Question 3

The Oracle tool used to copy data into a database table from a spreadsheet is called the ________.

Accepted Answer

A) Spreadsheet Wizard 
B) Data Import Wizard 
C) Database Configuration Assistant 
D) Enterprise Manager Database Express 
A) Spreadsheet Wizard 
B) Data Import Wizard 
C) Database Configuration Assistant 
D) Enterprise Manager Database Express B

Question 4

The prefix :new is used to make final values of columns available to insert and update triggers.

Accepted Answer

A) True 
 B)False

Question 5

Explain the Oracle Database PL/SQL control-of-flow statements.

Accepted Answer

The Oracle Database PL/SQL control-of-fl

Question 6

Briefly describe how Oracle Database implements serializable transaction isolation.Include an example.

Accepted Answer

Whenever a transaction begins,Oracle Dat

Question 7

If T3 is a table with three columns C1,C2,and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/03 into a row in table T3 while making sure that it is formatted correctly as shown?

Accepted Answer

A) SET INTO T3 VALUES (101,'Smith','02/10/13'); 
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY')); 
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2013'); 
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY')); 
A) SET INTO T3 VALUES (101,'Smith','02/10/13'); 
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY')); 
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2013'); 
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY'));

Question 8

The default isolation level in Oracle Database is Read Committed,which provides statement level isolation.

Accepted Answer

A) True 
 B)False

Question 9

With Oracle Database,data must be entered at the Oracle Database command prompt.

Accepted Answer

A) True 
 B)False

Question 10

Based on the table below,a function to compute a 10% late penalty on a customer's balance would have how many input parameters? CUSTOMER

Accepted Answer

A) 0 
B) 1 
C) 2 
D) it doesn't matter 
A) 0 
B) 1 
C) 2 
D) it doesn't matter

Question 11

Which of the following is true of Oracle Database when the isolation level is set to Serializable?

Accepted Answer

A) It will update any row having an SCN greater than the Transaction SCN. 
B) It will delete any row having an SCN greater than the Transaction SCN. 
C) It will read any row having an SCN greater than the Transaction SCN. 
D) It will wait for a blocking transaction to release an exclusive lock. 
A) It will update any row having an SCN greater than the Transaction SCN. 
B) It will delete any row having an SCN greater than the Transaction SCN. 
C) It will read any row having an SCN greater than the Transaction SCN. 
D) It will wait for a blocking transaction to release an exclusive lock.

Question 12

Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following tasks cannot be done using the Oracle SQL Developer GUI features?

Accepted Answer

A) See the structure of a table 
B) Add and remove columns from a table 
C) Insert and delete data from a table 
D) Create a new tablespace 
A) See the structure of a table 
B) Add and remove columns from a table 
C) Insert and delete data from a table 
D) Create a new tablespace

Question 14

What is SQL*Plus?

Accepted Answer

SQL*Plus is a character-based command li

Question 15

In Oracle Database security,a System Privilege is the right to execute general tasks such as performing some action on the database data.

Accepted Answer

A) True 
 B)False

Question 16

The prefix :old is used to make previous values of columns available to update and delete triggers.

Accepted Answer

A) True 
 B)False

Question 17

The Oracle Database GUI is the Oracle SQL Browser.

Accepted Answer

A) True 
 B)False

Question 18

The NextVal method provides the next value in a sequence.

Accepted Answer

A) True 
 B)False

Question 19

Explain sequences and their relationship to surrogate keys.Include an example.

Accepted Answer

A sequence is an Oracle Database object

Question 20

The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is ________.

Accepted Answer

A) DECLARE 
B) BEGIN 
C) IF...ELSE...END IF 
D) END; 
A) DECLARE 
B) BEGIN 
C) IF...ELSE...END IF 
D) END;

Exam 11: Managing Databases With Oracle Database

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Oracle Database does not require the use of Archive ReDo files for instance recovery.

The Oracle tool used to copy data into a database table from a spreadsheet is called the ________.

The prefix :new is used to make final values of columns available to insert and update triggers.

Explain the Oracle Database PL/SQL control-of-flow statements.

Briefly describe how Oracle Database implements serializable transaction isolation.Include an example.

If T3 is a table with three columns C1,C2,and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/03 into a row in table T3 while making sure that it is formatted correctly as shown?

The default isolation level in Oracle Database is Read Committed,which provides statement level isolation.

With Oracle Database,data must be entered at the Oracle Database command prompt.

Based on the table below,a function to compute a 10% late penalty on a customer's balance would have how many input parameters? CUSTOMER

Which of the following is true of Oracle Database when the isolation level is set to Serializable?

Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.

Which of the following tasks cannot be done using the Oracle SQL Developer GUI features?

What is SQL*Plus?

In Oracle Database security,a System Privilege is the right to execute general tasks such as performing some action on the database data.

The prefix :old is used to make previous values of columns available to update and delete triggers.

The Oracle Database GUI is the Oracle SQL Browser.

The NextVal method provides the next value in a sequence.

Explain sequences and their relationship to surrogate keys.Include an example.

The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is ________.

Introduction

Introduction to Structured Query Language

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2014

Managing Databases With Mysql 5.6

The Web Server Environment

Big Data, Data-Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the IDEF1X Standard

E-R Diagrams and the UML Standard

Getting Started With Mysql Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers, PHP, and the Netbeans IDE

Business Intelligence Systems

Big Data

Filters