Question 1

Which of the following is not a transaction isolation level supported by Oracle Database?

Accepted Answer

A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only 
A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read Only

Question 2

The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related tables,views,and other similar objects?

Accepted Answer

A) Namespace 
B) Filespace 
C) Tablespace 
D) Dataspace 
A) Namespace 
B) Filespace 
C) Tablespace 
D) Dataspace

Question 4

With Oracle Database,stored procedures can be invoked remotely.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?

Accepted Answer

A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2); 
B) ALTER TABLE T2 ADD C5 NUMBER (2); 
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); 
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0); 
A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2); 
B) ALTER TABLE T2 ADD C5 NUMBER (2); 
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); 
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);

Question 6

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is the easiest tool for creating a database with Oracle Database?

Accepted Answer

A) The Oracle Enterprise Manager Database Express 
B) The Oracle SQL*Plus command utility program 
C) The Oracle Database Configuration Assistant 
D) The Oracle SQL Developer 
A) The Oracle Enterprise Manager Database Express 
B) The Oracle SQL*Plus command utility program 
C) The Oracle Database Configuration Assistant 
D) The Oracle SQL Developer

Question 8

One limitation of the Oracle Data Import Wizard is that it ________.

Accepted Answer

A) does not allow addition of a new primary key column 
B) does not allow data to be imported into an existing table 
C) does not allow import of "date" type data 
D) only allows import of data from Microsoft Excel,no other formats 
A) does not allow addition of a new primary key column 
B) does not allow data to be imported into an existing table 
C) does not allow import of "date" type data 
D) only allows import of data from Microsoft Excel,no other formats

Question 9

If you include a slash as the last line in an Oracle stored procedure,the procedure will be compiled and stored when you run the block of code.

Accepted Answer

A) True 
 B)False

Question 10

In Oracle Database backup and recovery facilities,a consistent backup is one in which all uncommitted changes have been removed from the datafiles.

Accepted Answer

A) True 
 B)False

Question 11

What is the Oracle Enterprise Manager Database Express?

Accepted Answer

The Oracle Enterprise Manager Database E

Question 12

Which of the following does not describe a user-defined function?

Accepted Answer

A) It computes a numeric value 
B) It can be called by name from within an SQL statement 
C) It may have input parameters passed to it 
D) It returns an output value to the calling statement 
A) It computes a numeric value 
B) It can be called by name from within an SQL statement 
C) It may have input parameters passed to it 
D) It returns an output value to the calling statement

Question 13

Which of the following is an account name for which you are asked to enter a password when Oracle Database creates a new database?

Accepted Answer

A) ORACLE 
B) SYS 
C) INTERNAL 
D) DBA 
A) ORACLE 
B) SYS 
C) INTERNAL 
D) DBA

Question 14

In Oracle Database,which of the following prefixes is only available to triggers?

Accepted Answer

A) :current 
B) := same 
C) :new 
D) := current 
A) :current 
B) := same 
C) :new 
D) := current

Question 15

For which of the following types of failure would Oracle Database use OnLine ReDo files as part of a recovery effort?

Accepted Answer

A) Instance failure 
B) Application failure 
C) Media failure 
D) Logic failure 
A) Instance failure 
B) Application failure 
C) Media failure 
D) Logic failure

Question 16

Oracle Database supports the ON UPDATE CASCADE constraint.

Accepted Answer

A) True 
 B)False

Question 17

In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.

Accepted Answer

A) True 
 B)False

Question 18

The PL/SQL keyword STOP HERE is used to complete the basic PL/SQL block structure.

Accepted Answer

A) True 
 B)False

Question 19

If the SQL statement SELECT C1,C2,C3
FROM T4
WHERE C2 = 'Smith';
Is frequently executed,which column(s)should be considered for indexing based only on the statement itself?

Accepted Answer

A) C1 only 
B) C2 only 
C) C3 only 
D) C1 and C2 
A) C1 only 
B) C2 only 
C) C3 only 
D) C1 and C2

Question 20

The Oracle Database variant of SQL with additional procedural language components is ________.

Accepted Answer

A) T-SQL 
B) PL/SQL 
C) My/SQL 
D) MS/SQL 
A) T-SQL 
B) PL/SQL 
C) My/SQL 
D) MS/SQL

Exam 11: Managing Databases With Oracle Database

Which of the following is not a transaction isolation level supported by Oracle Database?

The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related tables,views,and other similar objects?

With Oracle Database,stored procedures can be invoked remotely.

Which of the following statements would cause Oracle Database to include a new column named C5,which is a two-digit whole number,to a table named T2?

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Which of the following is the easiest tool for creating a database with Oracle Database?

One limitation of the Oracle Data Import Wizard is that it ________.

If you include a slash as the last line in an Oracle stored procedure,the procedure will be compiled and stored when you run the block of code.

In Oracle Database backup and recovery facilities,a consistent backup is one in which all uncommitted changes have been removed from the datafiles.

What is the Oracle Enterprise Manager Database Express?

Which of the following does not describe a user-defined function?

Which of the following is an account name for which you are asked to enter a password when Oracle Database creates a new database?

In Oracle Database,which of the following prefixes is only available to triggers?

For which of the following types of failure would Oracle Database use OnLine ReDo files as part of a recovery effort?

Oracle Database supports the ON UPDATE CASCADE constraint.

In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.

The PL/SQL keyword STOP HERE is used to complete the basic PL/SQL block structure.

If the SQL statement SELECT C1,C2,C3 FROM T4 WHERE C2 = 'Smith'; Is frequently executed,which column(s)should be considered for indexing based only on the statement itself?

The Oracle Database variant of SQL with additional procedural language components 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