Question 1

SOONER and LATER triggers are placed on tables.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) They are programs. 
B) They can have parameters. 
C) They can be invoked remotely. 
D) They can return values. 
E) They can be written in C++. 
A) They are programs. 
B) They can have parameters. 
C) They can be invoked remotely. 
D) They can return values. 
E) They can be written in C++.

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is:

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Use the Edit Table table editor to create an index in Oracle Database.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

Briefly explain the different types of files used by the Oracle Database recovery facilities.

Accepted Answer

The first type of file is the datafile.D

Question 10

What is SQL Developer?

Accepted Answer

SQL Developer is the GUI tool that is in

Question 11

Each Oracle Database tablespace has one or more datafiles associated with it.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

The Oracle SQL Developer has no facility for executing SQL statements.

Accepted Answer

A) True 
 B)False

Question 14

What is the Oracle Enterprise Manager 11g Database Control?

Accepted Answer

The Oracle Enterprise Manager 11g Databa

Question 15

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/03'); 
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY')); 
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2003'); 
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY')); 
E) Any of the above will work correctly. 
A) SET INTO T3 VALUES (101,'Smith','02/10/03'); 
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY')); 
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2003'); 
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/03','DD/MM/YY')); 
E) Any of the above will work correctly.

Question 16

Among its many functions,SQL*Plus is also a text editor.

Accepted Answer

A) True 
 B)False

Question 17

When creating tables,Oracle Database automatically converts the SQL standard data type "int" into:

Accepted Answer

A) number (38,0). 
B) integer (32). 
C) number (5,0). 
D) integer (16). 
E) number (64,0). 
A) number (38,0). 
B) integer (32). 
C) number (5,0). 
D) integer (16). 
E) number (64,0).

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

Accepted Answer

A) True 
 B)False

Exam 11: Managing Databases With Oracle Database 11g

SOONER and LATER triggers are placed on tables.

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

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

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

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is:

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

Use the Edit Table table editor to create an index in Oracle Database.

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

Briefly explain the different types of files used by the Oracle Database recovery facilities.

What is SQL Developer?

Each Oracle Database tablespace has one or more datafiles associated with it.

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

The Oracle SQL Developer has no facility for executing SQL statements.

What is the Oracle Enterprise Manager 11g Database Control?

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?

Among its many functions,SQL*Plus is also a text editor.

When creating tables,Oracle Database automatically converts the SQL standard data type "int" into:

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

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.

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

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

Managing Databases With SQL Server 2008 R2

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

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 2010

the Semantic Object Model

Data Structures for Database Processing

Getting Started With Web Servers php and the Eclipse PDT

Filters