Deck 11: Managing Databases With Oracle Database

Question 1

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

Answer 1

True

Question 2

The NextVal method provides the next value in a sequence.

Answer 2

True

Question 3

The Oracle Enterprise Manager Database Express 12c is a Web-based Oracle Database administration utility.

Answer 3

True

Question 4

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

Question 5

Among its many functions,SQL*Plus is also a programming language.

Question 6

The CurrVal method provides the current value in a sequence.

Question 7

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

Question 8

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

Question 9

Oracle Database supports the ON UPDATE CASCADE constraint.

Question 10

An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related tables,views,and other similar objects.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

The Oracle Database Enterprise Manager Database Express provides graphical facilities for managing databases.

Question 22

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

Question 23

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 24

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

Question 25

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

Question 26

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

Question 27

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 28

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

Question 29

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

Question 30

You can use the Edit Table table editor to create an index in Oracle Database.

Question 31

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

Question 32

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

Question 33

All Oracle Database triggers work at the row level.

Question 34

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

Question 35

The Oracle Database GUI is the Oracle SQL Browser.

Question 36

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

Question 37

With Oracle Database,stored procedures can be invoked remotely.

Question 38

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

Question 39

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

Question 40

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

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

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)ORACLE
B)SYS
C)INTERNAL
D)DBA

Question 43

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 44

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

Question 45

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

Question 46

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 47

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

Question 48

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

Question 49

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

A)The Oracle Enterprise Manager Database Express
B)The Oracle SQL*Plus command utility program
C)The Oracle Database Configuration Assistant
D)The Oracle SQL Developer

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

INSTEAD OF triggers are placed on views.

Question 56

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 57

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

Question 58

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

Question 59

SOONER and LATER triggers are placed on tables.

Question 60

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

Question 61

Which of the following commands does Oracle Database not support?

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

Question 62

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

Question 63

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);

Question 64

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

Question 65

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

Question 66

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

Question 67

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

A)Namespace
B)Filespace
C)Tablespace
D)Dataspace

Question 68

The Oracle Database PL/SQL block structure begins with ________.

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

Question 69

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

Question 70

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/13');
B)SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY'));
C)INSERT INTO T3 VALUES (101,'Smith','02/10/2013');
D)INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/13','DD/MM/YY'));

Question 71

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

A)The Oracle Enterprise Manager Database Express
B)The Oracle SQL*Plus command utility program
C)The Oracle SQL Developer
D)The Oracle DBA Manager

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

Which method returns the next value in a sequence?

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

Question 78

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)

Question 79

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

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

Question 80

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