When executing the massload command to load catalog data into a WebSphere Commerce database on a remote DB2 server，which of the following can be used as valid values for the -method command line parameter？（）A、createB、importC、loadD、sqlimportE、update

第1题：

When executing a SQL workload，you choose to generate execution plans only， without collecting execution statistics.  Which two statements describe the implications of this？（）

• A、 It produces less accurate results of the comparison analysis.
• B、 It automatically calls the SQL Tuning Advisor for recommendations.
• C、 It shortens the time of execution and reduces the impact on system resources.
• D、 Only the changes in the execution plan，and not performance regression，are detected.

第2题：

Which file contains the attributes used to setup a new user account when executing ‘mkuser’ without any flags？（）

• A、/etc/security/user
• B、/etc/security/passwd
• C、/etc/security/mkuser.sys
• D、/etc/security/mkuser.default

第3题：

To increase the availability of an Advanced Replication environment， you can add a new master to a replication group without quiescing the group. This is achieved（）.

• A、Only when the new master site already has existing replication groups. 
• B、By issuing a single command to create, populate, and activate the new master. 
• C、When the master definition site is not the same for all of the master groups. 
• D、Without impacting end users who are executing data manipulation language (DML) commands on the replicated tables.

第4题：

Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt：   RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；   After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）

• A、 when you change the name of a datafile
• B、 when you drop a table from the database
• C、 when you take an export of the database
• D、 when you back up the database using OS utilities
• E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
• F、 when you issue a BACKUP command from inside the RMAN run block

第5题：

Which Scheduler view（s） can be queried to see which jobs are currently executing？（）

• A、 DBA_SCHEDULER_JOB_RUN_DETAILS
• B、 DBA_SCHEDULER_RUNNING_JOBS
• C、 DBA_SCHEDULER_CURRENT_JOBS
• D、 DBA_SCHEDULER_JOBS
• E、 DBA_SCHEDULER_EXECUTING_JOBS

第6题：

You previously secured your listener with an encrypted password. However， you need to set a new password for security reasons. What is the correct method for setting a new encrypted password for the listener using the Listener Control utility？（）

• A、 executing the SET PASSWORD command and then the SAVE_CONFIG command
• B、 executing the CHANGE_PASSWORD command and then the SAVE_CONFIG command
• C、 executing the CHANGE_PASSWORD command and then the SET PASSWORD command
• D、 executing the SET PASSWORD command， then the CHANGE_PASSWORD command and finally， the  SAVE_CONFIG command

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

How can a directory named /dir1 be excluded during a restore of files backed up by name with the backup command？（）

• A、By using the restore -x option followed by /dir1
• B、By adding an entry in the /etc/restore.exclude file
• C、By using the restore -i option to enter interactive mode and executing the command：delete /dir1
• D、By using the restore -i option when running restore to specify a text file containing ’/dir1’ as one of the lines in it.

第14题：

Which of the following best describes Simultaneous Multi-threading （SMT）？（）

• A、A POWER5 microprocessor feature that allocates two processors to each application
• B、A Workload Manager feature that allows two processing threads to be executing on a single processor
• C、An AIX v5.2 feature that allows two processing threads to be executing on a single processor concurrently
• D、A POWER5 microprocessor feature that allows two processing threads to be executing on a single processor concurrently

第15题：

What is true about a background engine? （）(Choose two.)

• A、It is a server-side PL/SQL procedure.
• B、When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.
• C、It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).
• D、It would fail if another background engine process is started to handle the same type of activities within the same item type.
• E、During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.

第16题：

Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

• A、 The queries that are currently executing will abort and an error message will be returned to the user.
• B、 The queries that are currently executing will execute normally but future queries will not executed.
• C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
• D、 The currently executing and future queries will execute normally， but will be slower

第17题：

Which Scheduler view(s) can be queried to see which jobs are currently executing? （）

• A、DBA_SCHEDULER_JOB_RUN_DETAILS
• B、DBA_SCHEDULER_RUNNING_JOBS DBA
• C、DBA_SCHEDULER_CURRENT_JOBS
• D、DBA_SCHEDULER_JOBS DBA
• E、DBA_SCHEDULER_EXECUTING_JOBS

第18题：

Which statement about using RMAN stored scripts is true?（）

• A、To create and execute an RMAN stored script, you must use a recovery catalog.
• B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
• C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
• D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

第19题：

第20题：

第21题：

第22题：

第23题：