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 C5 NUMBER (2);
C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0);
D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);
71) Which of the following is a GUI tool for application development with Oracle Database?
A) The Oracle Enterprise Manager Database Express
B) The Oracle SQL*Plus command utility program
C) The Oracle SQL Developer
D) The Oracle Database Configuration Assistant
72) Which of the following tasks cannot be done using the Oracle SQL Developer GUI features?
A) See the structure of a table
B) Add and remove columns from a table
C) Insert and delete data from a table
D) Create a new tablespace
73) 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) Physical Design editor
74) The Oracle tool used to copy data into a database table from a spreadsheet is called the
________.
A) Spreadsheet Wizard
B) Data Import Wizard
C) Database Configuration Assistant
D) Enterprise Manager Database Express
75) One limitation of the Oracle Data Import Wizard is that it ________.
A) does not allow addition of a new primary key column
B) does not allow data to be imported into an existing table
C) does not allow import of “date” type data
D) only allows import of data from Microsoft Excel, no other formats
76) During the data import process in Oracle, if some of the spreadsheet cells in a column of the
source data are empty, ________.
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
77) Copying spreadsheet data into a database is part of a larger data warehousing process known
as ________.
A) import/export
B) spreadsheet conversion
C) extract, transform, and load
D) data verification
78) The Oracle Database variant of SQL with additional procedural language components is
________.
A) T-SQL
B) PL/SQL
C) My/SQL
D) MS/SQL
79) The Oracle Database PL/SQL block structure begins with ________.
A) DECLARE
B) BEGIN
C) IF…THEN…ELSE…END IF
D) LOOP
80) 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
81) 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
82) The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements if some
condition is true is ________.
A) DECLARE
B) BEGIN
C) IF…ELSE…END IF
D) LOOP
83) 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) END;
84) Which of the following Oracle Database PL/SQL statements is not used to create a block of
code that repeats while some condition is true?
A) FOR
B) WHILE
C) BEGIN
D) LOOP
85) 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 be written in C++.
86) Which of the following is true about stored procedures in Oracle Database?
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.
87) Which of the following can Oracle Database not support?
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
88) In Oracle Database, which of the following prefixes is only available to triggers?
A) :current
B) := same
C) :new
D) := current
89) Which type of trigger is commonly used to update views?
A) BEFORE triggers
B) AFTER triggers
C) SELECT triggers
D) INSTEAD OF triggers
90) Which of the following does not describe a user-defined function?
A) It computes a numeric value
B) It can be called by name from within an SQL statement
C) It may have input parameters passed to it
D) It returns an output value to the calling statement
91) Based on the table below, a function to compute a 10% late penalty on a customer’s balance
would have how many input parameters?
CUSTOMER
CustNo
CustName
Balance
SalesRepNo
9870
Winston
500
345
8590
Gonzales
350
434
7840
Harris
800
654
4870
Miles
100
345
A) 0
B) 1
C) 2
D) it doesn’t matter
92) Which of the following is not a transaction isolation level supported by Oracle Database?
A) Read Committed
B) Serializable
C) Repeatable Read
D) Read Only
93) Which of the following is the default transaction isolation level offered by Oracle Database?
A) Read Committed
B) Serializable
C) Repeatable Read
D) Read Only
94) In Oracle Database, to achieve transaction level consistency, which level of transaction
isolation must be used?
A) Read Committed
B) Serializable
C) Repeatable Read
D) Read-only
95) Which of the following is true of Oracle Database when the isolation level is set to
Serializable?
A) It will update any row having an SCN greater than the Transaction SCN.
B) It will delete any row having an SCN greater than the Transaction SCN.
C) It will read any row having an SCN greater than the Transaction SCN.
D) It will wait for a blocking transaction to release an exclusive lock.
96) Which of the following Oracle Database ReDo files are stored on disk and contain the
rollback segments from recent database changes?
A) OnLine ReDo files
B) Active ReDo files
C) OffLine ReDo files
D) Archive ReDo files
97) For which of the following types of failure would Oracle Database use OnLine ReDo files as
part of a recovery effort?
A) Instance failure
B) Application failure
C) Media failure
D) Logic failure
98) For which of the following types of failure would Oracle Database use Offline ReDo files as
part of a recovery effort?
A) Instance failure
B) Application failure
C) Media failure
D) Logic failure
99) What is SQL*Plus?
100) What is SQL Developer?
101) What is the Database Configuration Assistant (DBCA)?
102) What is the Oracle Enterprise Manager Database Express?
103) Explain sequences and their relationship to surrogate keys. Include an example.
104) Explain the Oracle Database PL/SQL Block Structure.
105) Explain the Oracle Database PL/SQL control-of-flow statements.
106) Explain the Oracle Database PL/SQL cursor statements.
107) Briefly describe how Oracle Database implements serializable transaction isolation. Include
an example.
108) Briefly explain the different types of files used by the Oracle Database recovery facilities.