Assessment Test
1. Which of the following components is not part of an Oracle instance?
A. System Global Area
B. Server Process
C. Database Writer
D. System Monitor
2. Your organization has purchased an application that uses an Oracle database as the repository for application data. Your job is to install and configure the Oracle Database 10g software on the server. Which of the following should you do first?
A. Create mount points and directories using the OFA model.
B. Mount the Oracle CD and start the Oracle Universal Installer.
C. Review the installation guides and release notes to familiarize yourself with the install process.
D. Work with the Unix system administrator to configure kernel parameters.
3. All the following are examples of DML commands except which item?
A. INSERT
B. CREATE
C. UPDATE
D. DELETE
4. Assuming the ON DELETE CASCADE option was not used to define the constraint, what is the potential impact of a foreign key constraint on a DELETE statement?
A. The foreign key constraint can prevent the delete if deleting the row violates the relationship defined in the foreign key.
B. The foreign key constraint ensures that the user has the correct privileges on a table before the row is deleted.
C. The foreign key is ignored if the delete removes only one row.
D. Foreign key has no impact on DELETE statements.
5. You are a database administrator with databases in New York, Hong Kong, and London. You want to administer all your databases from a central console using Grid Control. Which of the following commands do you issue when using Grid Control?
A. emctl start grid
B. emctl start dbconsole
C. emctl start agent
D. isqlplusctl start
6. The lead DBA has requested that you set up a database that requires minimal disk management for a large data warehouse that is being implemented. He wants you to use a DBCA with and utilize one of the predefined templates. Which of the following combinations addresses this request?
A. Data Warehouse template with raw devices
B. Transactional template with file system disk management
C. Data Warehouse template with raw disk management
D. Data Warehouse template with the Automated Storage Management (ASM) disk option
7. You have created a database using DBCA and not saved the template definition. You now want to copy the database and all the data using the DBCA. Which of the following is the first step?
A. Create a new empty database using scripts, and import the data into the new database using the DBCA.
B. Use DBCA template management, and create a database template from an existing database with structure as well as data.
C. Choose the template of the previously created database created from the templates list and create the database.
D. Copy the datafiles from the existing database to a new location, and then use the DBCA to copy the database.
8. You are in the middle of an emergency drill at your organization. There is little time to notify database users, and you need to stop the Oracle database processes as quickly as possible. Which of the following would you perform?
A. SHUTDOWN ABORT
B. SHUTDOWN TRANSACTIONAL
C. SHUTDOWN
D. SHUTDOWN IMMEDIATE
E. None of the above
9. Where would you look to see if a tablespace is offline?
A. dba_tablespaces
B. v$tablespace
C. v$database
D. dba_datafile_status
10. Which of the following objects share the same namespace and therefore cannot have the same name?
A. Tables and sequences
B. Tables and indexes
C. Tables and tablespaces
D. Tables and constraints
11. Which of the following is not a valid column name?
A. 1ST_ID
B. CUST#
C. ADDRESS1
D. EXCEPTION
12. Oracle Advanced Security provides all the following except:
A. Database profiles
B. Data encryption
C. Checksumming
D. Biometrics option
13. You have just issued the command lsnrctl stop LISTENER. Which of the following statements are not true? (Choose all that apply.)
A. New connections to the default listener will not succeed.
B. Existing client connections will not be affected.
C. Only new dedicated connections will fail
D. Existing shared server connections will be dropped.
14. You issue the following command from the database server: sqlplus scott/tiger and receive the following error message: ORA-01034: Oracle not available. What is the state of the Oracle database:
A. The database is open but in restricted mode.
B. The instance is started but is in MOUNT mode.
C. The database and the instance are not started.
D. The instance is started in NOMOUNT mode.
15. You connect to the database using the command sqlplus scott/tiger@abc.com:1522/orcl. To which database are you connecting?
A. abc.com
B. tiger
C. orcl
D. scott
E. None of the above
16. You are administering an Oracle database using Shared Server. The LARGE_POOL_SIZE is 50MB. You issue the command ALTER SYSTEM SET LARGE_POOL_SIZE = 100M SCOPE=MEMORY. You then shut down and restart the database. What will the LARGE_POOL_SIZE be?
A. 50MB
B. 100MB
C. The default LARGE_POOL_SIZE
D. The LARGE_POOL_SIZE as you have set it in the Oracle SPFILE that you are using
17. You have decided to implement connection pooling and set a timeout limit of 20 minutes for idle connections. You also want to support 500 concurrent connections with a maximum of 1500 sessions per dispatcher. Which of the following commands will accomplish this?
A. Dispatchers = "(PRO=TCP)(DIS=5)(POO=ON)(TICK=20)(CONN=500)(SESS=1500)"
B. Dispatchers = "(PRO=TCP)(DIS=5)(POO=ON)(TICK=2)(CONN=500)(SESS=1500)"
C. Dispatchers = "(PRO=TCP)(DIS=5)(POO=ON)(TICK=20)(CONN=1500)(SESS=500)"
D. Dispatchers = "(PRO=TCP)(DIS=5)(POOLING=ON)(TICK=20)(CONN=500)(SESS=1500)"
18. You issue the command lsnrctl services. What pieces of information can you see regarding shared server connections for each dispatcher listed? (Choose all that apply.)
A. Established connections
B. Refused connections
C. Idle connections
D. Current connections
E. All the above
19. What status would you expect to see when querying V$DISPATCHER for a dispatcher that is not currently servicing any client requests?
A. IDLE
B. WAIT
C. SLEEP
D. READY
E. None of the above
20. Which of the following statements sets the password for user simon to alakazaam?
A. alter user simon password alakazaam;
B. update user simon set password=alakazaam;
C. alter user simon identified by alakazaam;
D. set password=alakazaam for simon;
21. Which privilege allows the grantee to place the database in NOARCHIVELOG mode?
A. sysdba
B. root
C. dba
D. operator
22. Which of the following statements removes user brent together with all his schema objects from the database?
A. drop user brent;
B. delete from dba_users where username='BRENT';
C. alter system remove user brent cascade;
D. drop user brent cascade;
23. Which of the following parameters directs Data Pump export to capture the table definitions for, but not the contents of the tables owned by user sacagawea?
A. owner= sacagawea rows=no
B. schemas= sacagawea content=metadata_only
C. owner= sacagawea content=metadata_only
D. tablespaces= sacagawea data=no
24. Which of the following is not a valid Data Pump export mode?
A. JAVA
B. SCHEMA
C. TABLE
D. TABLESPACE
25. After updating a table, what must you execute to make the changes permanent?
A. COMMIT
B. SAVEPOINT
C. Nothing. When the updates complete, the changes are permanent.
D. SAVE WORK
26. When a table is updated, where is the before-image information (which can be used for undoing the changes) stored?
A. Temporary segment
B. Redo log buffer
C. Undo buffer
D. Undo segment
27. Which of the following will not implicitly begin a transaction?
A. INSERT
B. UPDATE
C. DELETE
D. SELECT FOR UPDATE
E. None of the above; they all implicitly begin a transaction.
28. Select the invalid statements from the following regarding undo segment management. (Choose all that apply.)
A. ALTER SYSTEM SET UNDO_TABLESPACE = ROLLBACK;
B. ALTER DATABASE SET UNDO_TABLESPACE = UNDOTBS;
C. ALTER SYSTEM SET UNDO_MANAGEMENT = AUTO;
D. ALTER SYSTEM SET UNDO_MANAGEMENT = MANUAL;
29. The following table shows two concurrent transactions. Which statement about the result returned in Session 1 at 8:30 is true? Choose the best answer.

session1	time	session2
select sum(order_amt) from orders where order_date > trunc(sysdate);	8:01
	8:09	insert into orders (cust_num, order_date, order_amt) values (19581963, sysdate, 576.12);
	8:10	commit;
select statement above reaches data block where insert from session 2 resides	8:15
select statement completes and results returned to the user	8:30

A. The results include the changes committed by session 2 at 8:10.
B. The results include the changes committed by session 2 at 8:10 if the two sessions were connected as the same user.
C. The results of the query in session 1 do not include the changes committed by session 2 at 8:10.
D. Session 1 instead returns a “Snapshot too old” error message at 8:30; no results are returned to the user, and the query must be resubmitted.
30. The Automatic Workload Repository (AWR) is primarily populated with performance statistics by which Oracle 10g background process?
A. MMNL
B. QMN1
C. MMON
D. MMAN
31. Which of the following advisors is used to determine if the database read-consistency mechanisms are properly configured?
A. Undo Management Advisor
B. SQL Access Advisor
C. SQL Tuning Advisor
D. Memory Advisor
32. You’ve decided to monitor your databases for CPU utilization based on baseline metrics. If you specify that you want a warning alert sent whenever CPU utilization is greater than 50 percent of the baseline and the high value for this metric is 300, when will the alert be sent?
A. Whenever CPU utilization is 250 or less
B. Whenever the CPU utilization is 450 or higher
C. Whenever the CPU utilization is 300 or higher
D. Whenever the CPU utilization is 225 or higher
33. Every evening you use SQL*Loader to perform direct-path loads of data into your company’s data warehouse. Last night the load of the SALES table failed because the tablespace where the SALES table is stored ran out of space. As a result, the indexes on the SALES table are in an unusable state. Which of the following can you use to fix this problem?
A. Drop and re-create the affected indexes.
B. Use the ALTER INDEX … REBUILD command to rebuild the index.
C. Use EM Database Control to rebuild the index.
D. Any of the above will return the index to a usable state.
34. Which backup options are available for databases in NOARCHIVELOG mode? (Choose all that apply.)
A. Online, incremental
B. Offline, incremental
C. Online, full, whole database
D. Offline, full, whole database
35. According to Oracle, how many copies of the control file should you maintain?
A. 1, since Oracle automatically multiplexes control files
B. 2
C. One copy on each Oracle-managed disk device
D. 3
36. Identify the types of backups in the following list that RMAN performs. (Choose all that apply.)
A. Backups to flat files
B. Image copies
C. Data Pump export dumps
D. Backup sets
37. Archived log files can be written to as many as _______ locations. (Choose the best answer.)
A. Ten, but they all have to be local, or they all have to be remote.
B. Ten, with a maximum of five local destinations and five remote destinations
C. Ten total
D. Five total
E. Twenty, a maximum of ten local destinations, and ten remote destinations
38. If a user inadvertently drops a table, this is considered what type of failure?
A. Instance
B. User error
C. Statement
D. User process
39. If the database instance fails, but will not shut down, you must use which command(s) before instance recovery can be performed? (Choose the best answer.)
A. STARTUP NOMOUNT
B. STARTUP MOUNT
C. SHUTDOWN IMMEDIATE; STARTUP FORCE
D. SHUTDOWN ABORT; STARTUP
40. Which of the following is not a valid database state?
A. OPEN
B. SHUTDOWN
C. STARTUP
D. MOUNT
E. NOMOUNT

--------------------------------------------------------

简要分析：

总观错误发生情况

Architecture 1/4 ; Create & Control 3/4 ; Objects 1/3 ; Net Service 0/4 ; Shared Server 2/4 ; Security 3/3 ; PL/SQL 0/3 ; Consistency & Concurrency 4/4 ; Maintenance & Performance 4/4 ; Backup 3/4 ; Recovery 1/3 .

由以上错误发生的情况可以看出，掌握的最弱的当属Security(安全),Consistency & Concurrency(一致与并发) 以及 Maintenance & Performance(维护和性能).

可见以上三项内容估计也是最有难度去理解和掌握的。