Question 1

Which of the following is a GUI tool for application development with Oracle Database?

Accepted Answer

A) The Oracle Enterprise Manager 11g Database Control 
B) The Oracle SQL*Plus command utility program 
C) The Oracle SQL Developer 
D) A and B 
E) A,B,and C 
A) The Oracle Enterprise Manager 11g Database Control 
B) The Oracle SQL*Plus command utility program 
C) The Oracle SQL Developer 
D) A and B 
E) A,B,and C

Question 2

Which of the following can Oracle Database not support?

Accepted Answer

A) Triggers that are fired when SQL commands create new database structures 
B) Triggers that are fired before each row change in a table 
C) Triggers that are fired once when changes are made to rows in a table 
D) Triggers that are fired after each row change in a table 
E) All of the above are supported. 
A) Triggers that are fired when SQL commands create new database structures 
B) Triggers that are fired before each row change in a table 
C) Triggers that are fired once when changes are made to rows in a table 
D) Triggers that are fired after each row change in a table 
E) All of the above are supported.

Question 3

What is the Database Configuration Assistant (DBCA)?

Accepted Answer

The Oracle Database Configuration Assist

Question 4

Oracle Database provides only one method for creating an Oracle Database database.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The type of failure that occurs when Oracle Database itself fails due to an operating system or computer hardware failure is called an instance failure.

Accepted Answer

A) True 
 B)False

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')); 
E) Any of the above will work correctly. 
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')); 
E) Any of the above will work correctly.

Question 8

Which of the following tasks can be done using the Oracle SQL Developer?

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) A and B 
E) A,B,and C 
A) See the structure of a table 
B) Add and remove columns from a table 
C) Insert and delete data from a table 
D) A and B 
E) A,B,and C

Question 9

The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is ________.

Accepted Answer

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

Question 10

Instead of creating a new database instance in Oracle Database,it is preferable to create a new tablespace.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

The Oracle Enterprise Manager 11g Database Control is a Web-based Oracle Database administration utility.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The Oracle Database PL/SQL control-of-fl

Question 14

In Oracle Database,indexes are created using the ALTER command.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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) SYSTEM 
B) SYS 
C) INTERNAL 
D) A and B 
E) A,B,and C 
A) SYSTEM 
B) SYS 
C) INTERNAL 
D) A and B 
E) A,B,and C

Question 17

Oracle Database triggers are PL/SQL or Java procedures that are invoked when specified database activity occurs.

Accepted Answer

A) True 
 B)False

Question 18

The Read Only transaction isolation level is unique to Oracle Database.

Accepted Answer

A) True 
 B)False

Question 19

In Oracle Database,to achieve transaction level consistency,which level of transaction isolation must be used?

Accepted Answer

A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read-only 
E) Read Uncommitted 
A) Read Committed 
B) Serializable 
C) Repeatable Read 
D) Read-only 
E) Read Uncommitted

Question 20

The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.

Accepted Answer

A) True 
 B)False

Exam 10: B: Managing Databases With Oracle Database 11g Release 2

Which of the following is a GUI tool for application development with Oracle Database?

Which of the following can Oracle Database not support?

What is the Database Configuration Assistant (DBCA)?

Oracle Database provides only one method for creating an Oracle Database database.

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

The type of failure that occurs when Oracle Database itself fails due to an operating system or computer hardware failure is called an instance failure.

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?

Which of the following tasks can be done using the Oracle SQL Developer?

The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is ________.

Instead of creating a new database instance in Oracle Database,it is preferable to create a new tablespace.

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

The Oracle Enterprise Manager 11g Database Control is a Web-based Oracle Database administration utility.

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

In Oracle Database,indexes are created using the ALTER command.

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 is an account name for which you are asked to enter a password when Oracle Database creates a new database?

Oracle Database triggers are PL/SQL or Java procedures that are invoked when specified database activity occurs.

The Read Only transaction isolation level is unique to Oracle Database.

In Oracle Database,to achieve transaction level consistency,which level of transaction isolation must be used?

The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.

Introduction

Introduction to Structured Query Language SQL

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

A: Managing Databases With SQL Server 20012

C: Managing Databases With MySQL

The Web Server Environment

Big Data datawarehouse and Business Intelligence Systems

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 Eclipse PDT

Business Intelligence Systems

Filters