Deck 11: Managing Databases With Oracle Database 11g

Question 1

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

Answer 1

False

Question 2

With Oracle Database,data must be entered at the Oracle Database command prompt.

Answer 2

False

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

The CurrVal method provides the current value in a sequence.

Question 10

The NextVal method provides the next value in a sequence.

Question 11

The Oracle Enterprise Manager 11g Database Control is a Web-based Oracle Database administration utility.

Question 12

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

Question 13

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Question 14

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

Question 15

Oracle Database supports the ON UPDATE CASCADE constraint.

Question 16

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

Question 17

The Oracle Database GUI tool used for application development is the Oracle SQL Developer.

Question 18

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Question 19

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

Question 20

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.

Question 21

With Oracle Database,stored procedures can be invoked remotely.

Question 22

The PL/SQL keywords FOR,WHILE,and LOOP are used to create blocks of code that repeat until an ending condition is reached.

Question 23

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

Question 24

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.

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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.

Question 31

The Oracle Database GUI is the Oracle SQL Browser.

Question 32

The PL/SQL keyword ISTHERE is used to look for the existence of a condition.

Question 33

Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.

Question 34

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

Question 35

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

Question 36

The Oracle Database GUI provides graphical facilities for managing databases.

Question 37

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

Question 38

In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.

Question 39

All Oracle Database triggers work at the row level.

Question 40

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

Question 41

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

Question 42

In Oracle Database recovery facilities,OnLine ReDo files are maintained on disk and contain the rollback segments from recent database changes.

Question 43

The prefix :old is used with values of columns available to update and delete triggers.

Question 44

Oracle Database does not require the use of Archive ReDo files for instance recovery.

Question 45

In Oracle Database backup and recovery facilities,a consistent backup is one in which all uncommitted changes have been removed from the datafiles.

Question 46

The prefix :new is used with values of columns available to insert and update triggers.

Question 47

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

A)SYSTEM
B)SYS
C)INTERNAL
D)A and B
E)A,B and C

Question 48

SOONER and LATER triggers are placed on tables.

Question 49

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.

Question 50

INSTEAD OF triggers are placed on views.

Question 51

Which of the following is the easiest tool for creating a database with Oracle Database?

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

Question 52

The Read Only transaction isolation level is unique to Oracle Database.

Question 53

The default isolation level in Oracle Database is Read Committed,which provides statement level isolation.

Question 54

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

Question 55

With Oracle Database,you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.

Question 56

Oracle Database only reads committed changes,and therefore dirty reads are not possible.

Question 57

Oracle Database uses a System Change Number (SCN)to identify before images in rollback segments to prevent dirty reads.

Question 58

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

Question 59

In Oracle Database recovery facilities,control files are small files that describe the name,contents,and locations of various files used by Oracle Database.

Question 60

The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

Question 61

Which of the following is a GUI tool for application development with Oracle Database?

A)The Oracle Enterprise Manager 11g Database Control
B)The Oracle SQL*Plus command utility program
C)The Oracle SQL Developer
D)A and B
E)A,B and C

Question 62

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?

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 63

Which of the following tasks can be done using the Oracle SQL Developer?

A)See the structure of a table
B)Add and remove columns from a table
C)Insert and delete data from a table
D)A and B
E)A,B and C

Question 64

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

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 C

Question 65

Which of the following commands does Oracle Database not support?

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

Question 66

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

A)Edit Table table editor
B)Edit Index index editor
C)Edit Schema schema editor
D)A and B
E)A,B and C

Question 67

Which method returns the next value in a sequence?

A)CountVal
B)Next
C)UpVal
D)NextVal
E)Append

Question 68

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

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

Question 69

The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is:

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

Question 70

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?

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 71

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?

A)C1 only
B)C2 only
C)C3 only
D)C1 and C2
E)C1,C2,and C3

Question 72

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

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

Question 73

The Oracle Database PL/SQL block structure begins with:

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

Question 74

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

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 75

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

A)T-SQL.
B)PL/SQL.
C)My/SQL.
D)MS/SQL.
E)SQL.

Question 76

Which of the following Oracle Database PL/SQL statements is used to create a block of code that repeats while some condition is true?

A)FOR
B)WHILE
C)LOOP
D)A and B
E)A,B and C

Question 77

The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is:

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

Question 78

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:

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

Question 79

Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related table,view,and other similar objects?

A)Namespace
B)Filespace
C)Tablespace
D)A and B
E)A,B and C

Question 80

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

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.