FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Managing Databases With Oracle Database 11g

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

The first type of file is the datafile.D...

View Answer

Show Answer

Question 52

True/False

Review LaterAdd Note

Review Later

SOONER and LATER triggers are placed on tables.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

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

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?

What is SQL Developer?

The Oracle SQL Developer has no facility for executing 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.

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

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

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

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

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.

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

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

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

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

What is the Oracle Enterprise Manager 11g Database Control?

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

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