Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Which type of trigger is commonly used to update views?

Accepted Answer

A) BEFORE triggers 
B) AFTER triggers 
C) SELECT triggers 
D) INSTEAD OF triggers 
A) BEFORE triggers 
B) AFTER triggers 
C) SELECT triggers 
D) INSTEAD OF triggers

Question 3

The GUI tool for creating a new index is the Oracle SQL Developer ________.

Accepted Answer

A) Edit Table table editor 
B) Edit Index index editor 
C) Edit Schema schema editor 
D) Physical Design editor 
A) Edit Table table editor 
B) Edit Index index editor 
C) Edit Schema schema editor 
D) Physical Design editor

Question 4

Which of the following can Oracle Database not support?

Accepted Answer

A) Triggers that are fired when a user logs in to the database 
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 
A) Triggers that are fired when a user logs in to the database 
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

Question 5

The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

Accepted Answer

A) True 
 B)False

Question 6

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 
A) OnLine ReDo files 
B) Active ReDo files 
C) OffLine ReDo files 
D) Archive ReDo files

Question 7

Copying spreadsheet data into a database is part of a larger data warehousing process known as ________.

Accepted Answer

A) import/export 
B) spreadsheet conversion 
C) extract,transform,and load 
D) data verification 
A) import/export 
B) spreadsheet conversion 
C) extract,transform,and load 
D) data verification

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

In Oracle Database security,a Role can have many system privileges.

Accepted Answer

A) True 
 B)False

Question 10

Sequences are most often used to provide values for surrogate keys.

Accepted Answer

A) True 
 B)False

Question 11

SOONER and LATER triggers are placed on tables.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is true about stored procedures in Oracle Database?

Accepted Answer

A) They cannot invoke other procedures. 
B) They must include the data type and length of parameters. 
C) They can raise exceptions. 
D) They do not contain variables. 
A) They cannot invoke other procedures. 
B) They must include the data type and length of parameters. 
C) They can raise exceptions. 
D) They do not contain variables.

Question 13

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 14

Which of the following commands does Oracle Database not support?

Accepted Answer

A) CREATE TABLE 
B) CREATE CONSTRAINT 
C) ON DELETE CASCADE 
D) ON UPDATE CASCADE 
A) CREATE TABLE 
B) CREATE CONSTRAINT 
C) ON DELETE CASCADE 
D) ON UPDATE CASCADE

Question 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

During the data import process in Oracle,if some of the spreadsheet cells in a column of the source data are empty,________.

Accepted Answer

A) you must put some data in them before importing 
B) you must not specify this column as a foreign key later 
C) you must ensure the data type for this column is numeric 
D) you must check the "Nullable" box in the wizard 
A) you must put some data in them before importing 
B) you must not specify this column as a foreign key later 
C) you must ensure the data type for this column is numeric 
D) you must check the "Nullable" box in the wizard

Question 19

Control files,as used by Oracle Database's backup and recovery features,contain records of database changes.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 11: Managing Databases With Oracle Database

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

Which type of trigger is commonly used to update views?

The GUI tool for creating a new index is the Oracle SQL Developer ________.

Which of the following can Oracle Database not support?

The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

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

Copying spreadsheet data into a database is part of a larger data warehousing process known as ________.

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

In Oracle Database security,a Role can have many system privileges.

Sequences are most often used to provide values for surrogate keys.

SOONER and LATER triggers are placed on tables.

Which of the following is true about stored procedures in Oracle Database?

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

Which of the following commands does Oracle Database not support?

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

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

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

During the data import process in Oracle,if some of the spreadsheet cells in a column of the source data are empty,________.

Control files,as used by Oracle Database's backup and recovery features,contain records of database changes.

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

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