Database Storage & Design Chapter 10b 1 True Aacsb Information Technology Difficulty Easy Lo Understand The Purpose And Role

Database Processing, 15e (Kroenke)

Online Chapter 10B: Managing Databases with Oracle Database

1) Oracle Database provides only one method for creating a database.

2) The Oracle Database Configuration Assistant is the easiest tool to use when you are creating

an Oracle database.

3) When creating a new database in Oracle Database, two new account passwords are

automatically created in the database.

4) The Oracle Enterprise Manager Database Express 12c is a Web-based Oracle Database

administration utility.

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

tablespace.

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

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

8) In Oracle Database security, a System Privilege is the right to execute general tasks such as

performing some action on the database data.

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

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

11) The Oracle Database GUI tool used for application development is the Oracle SQL

Developer.

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

13) Oracle Database supports the ON UPDATE CASCADE constraint.

14) When using Oracle Database, a sequence is an object that generates a sequential series of

unique numbers.

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

16) The NextVal method provides the next value in a sequence.

17) The CurrVal method provides the current value in a sequence.

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

19) Oracle Database XE is built on an older version of Oracle Database.

20) Oracle Database XE should be installed by your DBA and should not be attempted by a user.

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

22) The Oracle Database FORMAT_DATE function can be used to make sure that Oracle

Database interprets date data correctly.

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

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

25) The Oracle Database GUI is the Oracle SQL Browser.

26) The Oracle Database Enterprise Manager Database Express provides graphical facilities for

managing databases.

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

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

29) With Oracle Database, stored procedures can be invoked remotely.

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

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

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

33) The PL/SQL keywords FOR, WHILE, and LOOP are used to create blocks of code that

repeat until an ending condition is reached.

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

35) The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code

structure is running.

36) 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.

37) 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.

38) You can include single line comments in an Oracle Database stored procedure by starting

each comment line with the /* symbol.

39) Oracle Database triggers are PL/SQL or Java procedures that are invoked when specified

database activity occurs.

40) All Oracle Database triggers work at the row level.

41) Oracle Database triggers BEFORE and AFTER are placed on tables, while the INSTEAD

OF trigger is placed on views.

8

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

called row triggers.

43) INSTEAD OF triggers are placed on views.

44) SOONER and LATER triggers are placed on tables.

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

triggers.

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

triggers.

47) Oracle Database uses a System Change Number (SCN) to identify before images in rollback

segments to prevent dirty reads.

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

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

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

level isolation.

51) With Oracle Database, you can change the default transaction isolation for all transactions in

a session by using the SET TRANSACTION ISOLATION LEVEL statement.

52) Control files, as used by Oracle Database’s backup and recovery features, contain records of

database changes.

53) In the event of an application failure, Oracle Database uses the in-memory rollback segments

and OnLine ReDo files to recover.

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

55) In Oracle Database recovery facilities, control files are small files that describe the name,

contents, and locations of various files used by Oracle Database.

56) In Oracle Database recovery facilities, OnLine ReDo files are maintained on disk and

contain the rollback segments from recent database changes.

57) In Oracle Database recovery facilities, OnLine ReDo files are backup log files maintained

separately and not necessarily on disk media.

58) 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.

59) The type of failure that occurs when Oracle Database is unable to write to a physical file is

called a media failure.

60) In Oracle Database backup and recovery facilities, a consistent backup is one in which all

uncommitted changes have been removed from the datafiles.

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

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

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

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

65) Which of the following commands does Oracle Database not support?

A) CREATE TABLE

B) CREATE CONSTRAINT

C) ON DELETE CASCADE

D) ON UPDATE CASCADE

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

67) Which method returns the next value in a sequence?

A) CountVal

B) Next

C) UpVal

D) NextVal

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

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