Question 1

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 2

What is SQL*Plus?

Accepted Answer

SQL*Plus is a character-based command li...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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
E)  UPDATE triggersF) A) and B)
G) None of the above D

Question 5

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 CF) B) and D)
G) D) and E)

Question 6

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 UncommittedF) B) and C)
G) A) and B) B

Question 7

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)  Administrative failure
C)  Media failure
D)  Logic failure
E)  Application failureF) A) and D)
G) C) and D)

Question 8

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 9

Which of the following is a tool for managing an existing Oracle Database database?

Accepted Answer

A)  The Oracle Enterprise Manager 11g Database Control
B)  The Oracle SQL*Plus command utility program
C)  The Oracle Database Configuration Assistant
D)  A and B
E)  A,B and CF) All of the above
G) A) and D)

Question 10

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.F) A) and D)
G) A) and E)

Question 11

Briefly describe how Oracle Database implements serializable transaction isolation.

Accepted Answer

Whenever a transaction begins,Oracle Dat...

Question 12

In the event of an application failure,Oracle Database uses the in-memory rollback segments and OnLine ReDo files to recover.

Accepted Answer

A) True 
 B)False

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

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)  A and B
E)  A,B and CF) A) and D)
G) B) and C) A

Question 15

The Oracle database PL/SQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test is:

Accepted Answer

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

Question 16

The NextVal method provides the next value in a sequence.

Accepted Answer

A) True 
 B)False

Question 17

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 18

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.
E)  SQL.F) A) and B)
G) B) and C)

Question 19

Which method returns the next value in a sequence?

Accepted Answer

A)  CountVal
B)  Next
C)  UpVal
D)  NextVal
E)  AppendF) All of the above
G) B) and D)

Question 20

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.F) B) and E)
G) A) and D)

Exam 11: Managing Databases With Oracle Database 11g

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.

Correct AnswerverifiedShow Answer

What is SQL*Plus?

Correct AnswerverifiedSQL*Plus is a character-based command li...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Which type of trigger is commonly used to update views?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is a tool for managing an existing Oracle Database database?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Briefly describe how Oracle Database implements serializable transaction isolation.

Correct AnswerverifiedWhenever a transaction begins,Oracle Dat...View AnswerShow Answer

In the event of an application failure,Oracle Database uses the in-memory rollback segments and OnLine ReDo files to recover.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

The Oracle database PL/SQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test is:

Correct AnswerverifiedShow Answer

The NextVal method provides the next value in a sequence.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which method returns the next value in a sequence?

Correct AnswerverifiedShow Answer

Which of the following can Oracle Database not support?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
SQL*Plus is a character-based command li...
View Answer

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Whenever a transaction begins,Oracle Dat...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified