出自:Oracle认证

You want to use RMAN to create compressed backups.  Which statement is true about the compression algorithms that RMAN can use？（）
A: The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B: The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C: The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D: Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（）  
A: To indicate the location of the auxiliary-instance online redo logs.
B: To indicate the location of the target database datafiles.
C: To indicate the location of the auxiliary-instance control file and online redo logs.
D: To indicate the location of the auxiliary-instance database datafiles.
E: This is not a valid parameter when duplicating a database.
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?（）
A:Differential incremental backup
B:Different incremental backup 
C:Cumulative backup 
D:Cumulative incremental backup
Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users？（）
A:IGNORE=Y
B:DIRECT=Y
C:CONSISTENT=Y
D:BUFFER=Y
In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this：   1） Mount the database  2） Take the data file offline  3） Bring the data file online  4） Use the RMAN SWITCH TO command to switch the image copy  5） Apply the archived redo logs  6） Open the database  7） Use the RMAN RESTORE TO command to switch to the image copy   Which two options illustrate the correct sequence of steps that you could follow？（）
A: 2， 6， 4， 5， 3
B: 1， 2， 4， 5， 3， 6
C: 1， 2， 4， 6， 3
D: 1， 2， 7， 5， 3， 6
In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  
A: Setting a nonzero value for SGA_TARGET
B: Configuring Automatic Shared Memory Management
C: Configuring Automatic Memory Management
D: Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E: None of the above
（）可用于返回会话中的日期和时间。
A:months_between（）
B:next_day（）
C:current_date（）
D:localtimestamp（）
Which client requests to the database can be captured as a part of the workload capture?（）
A:flashback query
B:distributed transactions
C:logging in and logging out of sessions
D:all DDL statements having bind variables
E:direct path load of data from external files
A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）  
A: Do nothing.
B: Restart the database.
C: Perform recovery on the database.
D: Restore the alert log from the last backup.
Given: Under which three circumstances will the code on line 37 be executed?（）
A:The instance gets garbage collected.
B:The code on line 33 throws an exception.
C:The code on line 35 throws an exception.
D:The code on line 31 throws an exception.
E:The code on line 33 executes successfully.
In which cases is reference partitioning effective in enhancing performance？（）  
A: It is effective only in partition pruning.
B: It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C: It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D: It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
A UNIX user named Bob wants to replace his chess program with a new one， but he is not sure where theold one is installed.  Bob is currently able to run a Java chess program starting from his home directory /home/bob using thecommand： java -classpath /test：/home/bob/downloads/*.jar games. Chess Bob’s CLASSPATH is set （at login time） to： /usr/lib：/home/bob/classes：/opt/java/lib：/opt/java/lib/*.jar What is a possible location for the Chess.class file？（）
A:/test/Chess.class
B:/home/bob/Chess.class
C:/test/games/Chess.class
D:/usr/lib/games/Chess.class
E:/home/bob/games/Chess.class
In a new installation of Oracle Database 11g， you perform these activities： 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories.  Which optioncorresponds to the type of activities you performed（）
A:Oracle Managed Files
B:Oracle Grid Architecture
C:Optimal Flexible Architecture
D:Oracle database architecture
E:Automatic Storage Management
Given: What is the output?（）
A:42
B:420
C:462
D:42042
E:Compilation fails.
F:An exception is thrown at runtime.
The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）
A:statistics recommendations
B:SQL Profile recommendations
C:Index-related recommendations
D:restructuring of SQL recommendations
Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）
A: SET_ATTRIBUTE_NULL
B: ALTER_JOB
C: ALTER_JOB_PARAMETERS
D: ALTER
E: SET_ATTRIBUTE
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）
A: The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B: The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C: Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
D: The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.
What methods of point-in-time recovery are available？（）
A: Change-based
B: Cancel-based
C: Time-based
D: Sequence number-based
E: Transaction number-based
View the Exhibit.  One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table.  Which statement is true？（）
A:You must recover all data files to the required system change number （SCN）.
B:You must recover all data files， except those that are offline， to the required SCN .
C:You must recover all data files belonging to the USERS tablespace to the required SCN.
D:You cannot recover all data files because segment space management is performed manually for the undo tablespace.
Given: What is the result?（）
A:7
B:49
C:343
D:Compilation fails.
E:An exception is thrown at runtime.
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）
A:Data blocks have to be written more frequently by DBWR. 
B:Redo blocks have to be written more frequently by LGWR. 
C:You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. 
D:You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）
A: RBAL
B: CKPT
C: SMON
D: PMON
E: MMON
F: CTWR
G: DBWR
In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）
A:partitioning recommendations
B:statistics collection recommendations
C:index creation recommendations
D:materialized view recommendations
E:materialized view log recommendations
Exhibit，View the Exhibit and examine the Resource Manager settings for the groups at different levels. Which two effects would be the result of this setting？ （）
A: The members of LOW_GROUP would get more priority than those of OTHER_GROUPS.
B: The members of SYS_GROUP would get most of the CPU allocation at level 1.
C: The members of LOW_GROUP would get most of the CPU allocation because it has CPU allocation at two different levels.
D: The members of LOW_GROUP would get no CPU allocation at level1 if the members of OTHER_GROUPS are using all the CPU at level 2.
E: The members of SYS_GROUP would get no CPU allocation at level 1 if the members of OTHER_GROUPS are using all the CPU at level 2.
You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）
A:STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B:STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C:STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D:STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
Where can subqueries be used?（）
A:field names in the SELECT statement 
B:the FROM clause in the SELECT statement 
C:the HAVING clause in the SELECT statement
D:the GROUP BY clause in the SELECT statement 
E:the WHERE clause in only the SELECT statement 
F:the WHERE clause in SELECT as well as all DML statements
当需要查询当前活动进程的信息时，可以使用（）视图。
A:V$PROCESS
B:V$SESS_IO
C:V$SESSION_WAIT
D:V$LATCH
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06：00 p.m.， you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03：00 p.m. What would you do to recover the table？（）
A: use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
B: restore the entire database from the most recent backup and open it
C: recover the table by using the Flashback Table feature
D: perform point-in-time recovery to recover the table
Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）
A:The user must be granted the database administrator （DBA） privilege.
B:The user must be listed in the password file for the authentication.
C:No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D:Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）
A:Oracle Net Manager
B:Listener Control utility
C:Database Configuration Assistant
D:Oracle Net Configuration Assistant
首页 <上一页 151 152 153 154 155 下一页> 尾页