Question 1

What is SQL*Plus?

Accepted Answer

SQL*Plus is a character-based command line utility program,and it allows users to enter SQL*Plus commands after an "SQL>" command prompt.SQL commands such as CREATE TABLE can be entered and run in SQL*Plus.SQL*Plus has been a very popular utility for Oracle Database users.

Question 2

The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.

Accepted Answer

A) True 
 B)False  True

Question 3

The CurrVal method provides the current value in a sequence.

Accepted Answer

A) True 
 B)False  True

Question 4

Oracle Database supports the ON UPDATE CASCADE constraint.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

With Oracle Database,stored procedures cannot use a cursor variable,so another method must be used to access a table on a row by row basis.

Accepted Answer

A) True 
 B)False

Question 7

SOONER and LATER triggers are placed on tables.

Accepted Answer

A) True 
 B)False

Question 8

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 COLUMN C5 NUMBER (2); 
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); 
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0); 
E) ALTER TABLE T2 ADD C5 NUMBER (2); 
A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2); 
B) ALTER TABLE T2 ADD COLUMN C5 NUMBER (2); 
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); 
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0); 
E) ALTER TABLE T2 ADD C5 NUMBER (2);

Question 9

The Oracle Database GUI provides graphical facilities for managing databases.

Accepted Answer

A) True 
 B)False

Question 10

Explain sequences and their relationship to surrogate keys.

Accepted Answer

A sequence is an Oracle Database object

Question 11

An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related table,view,and other similar objects.

Accepted Answer

A) True 
 B)False

Question 12

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?

Accepted Answer

A) OnLine ReDo files 
B) Active ReDo files 
C) OffLine ReDo files 
D) Archive ReDo files 
E) All of the above 
A) OnLine ReDo files 
B) Active ReDo files 
C) OffLine ReDo files 
D) Archive ReDo files 
E) All of the above

Question 14

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 15

The default file extension for text files created for SQL Developer is .sql.

Accepted Answer

A) True 
 B)False

Question 16

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 
E) C1,C2,and C3 
A) C1 only 
B) C2 only 
C) C3 only 
D) C1 and C2 
E) C1,C2,and C3

Question 17

In Oracle Database recovery facilities,OnLine ReDo files are backup log files maintained separately and not necessarily on disk media.

Accepted Answer

A) True 
 B)False

Question 18

You can include single line comments in an Oracle Database stored procedure by starting each comment line with the /* symbol.

Accepted Answer

A) True 
 B)False

Question 19

When creating a new database in Oracle Database,two new account passwords are automatically created in the database.

Accepted Answer

A) True 
 B)False

Question 20

Oracle Database triggers BEFORE and AFTER are placed on tables,while the INSTEAD OF trigger is placed on views.

Accepted Answer

A) True 
 B)False

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

What is SQL*Plus?

The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.

The CurrVal method provides the current value in a sequence.

Oracle Database supports the ON UPDATE CASCADE constraint.

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

With Oracle Database,stored procedures cannot use a cursor variable,so another method must be used to access a table on a row by row basis.

SOONER and LATER triggers are placed on tables.

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 GUI provides graphical facilities for managing databases.

Explain sequences and their relationship to surrogate keys.

An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related table,view,and other similar objects.

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes?

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.

The default file extension for text files created for SQL Developer is .sql.

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?

In Oracle Database recovery facilities,OnLine ReDo files are backup log files maintained separately and not necessarily on disk media.

You can include single line comments in an Oracle Database stored procedure by starting each comment line with the /* symbol.

When creating a new database in Oracle Database,two new account passwords are automatically created in the database.

Oracle Database triggers BEFORE and AFTER are placed on tables,while the INSTEAD OF trigger is placed on views.

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