ITPub博客

177-Q112: Which of the following parameters is used to display an entire range of supported languages, as well as all other globalization options?A. V$NLS_LANGUAGESB. NLS_LANGC. NLS_DATABASE_PARAMETERSD. V$NLS_VALID_VALUESE. NLS_INSTANCE_PARAMETERSAnswer: D下列哪一个参...

177-Q111: Which of the following is not a valid setting for LOGGING_LEVEL job Class parameter?A. DBMS_SCHEDULAR.LOGGING_FULLB. DBMS_SCHEDULAR.LOGGING_ONC. DBMS_SCHEDULAR.LOGGING_OFFD. DBMS_SCHEDULAR.LOGGING_RUNSAnswer: B

177-Q109: Which of the following database modes is valid while configuring a database to enable Flashback Database?A. MOUNTB. ARCHIVELOGC. NOMOUNTD. NOARCHIVELOGAnswer: B配置数据库启用闪回数据库，下列哪个数据库模式是有效的？数据库必须运行在归档模式下，在MOUNT状态下，才能...

177-Q105: Which of the following clauses is used when RMAN performs an incomplete database recovery prior to the RECOVER command?A. UNTIL CHANGEB. SET UNTIL TIMEC. SET UNTIL CANCELD. UNTIL CANCELAnswer: BRMAN执行不完全数据库恢复，在RECOVER命令之前，使用下列哪个子句？A...

177-Q101: You work as a Database Administrator for Blue-Well Inc. The company uses an Oracle database. The database contains a resource consumer group named QUERY_USERS. You want to specify the maximum number of active sessions allowed in the QUERY_USERS resource consumer group as twenty. Which o...

177-Q95: Which of the following Dynamic Performance views contain information relevant to SQL Tuning? Each correct answer represents a part of the solution.(Choose all that apply.)A. V$SQLSTATSB. V$SQLAREAC. V$SQL_BIND_DATAD. V$SQLAnswer: A B C D下面的动态性能视图包含SQL调...

177-Q94: Which of the following statements about a recovery catalog are true? Each correct answer represents a complete solution.(Choose two.)A. A recovery catalog should not be created in the target database.B. The information in the recovery catalog is obtained from the target database'...

177-Q93: You work as a Database Administrator for Bell Ceramics Inc. The company uses Oracle database. You createa window (a scheduler object) to change the active resource plan based on defined schedules. There are many parameters, such as WINDOWS_NAME, RESOURCE_PLAN, etc. which can be used whil...

177-Q92: Which of the following statements about conventional tablespaces (non-locally managed tablespaces) are true? Each correct answer represents a part of the solution.(Choose two)A. Conventional tablespaces use data dictionary tables for storage space management.B. Conventional table...

177-Q87: You are creating an incident package to send to Oracle support as follow:What kind of packaging are you using?A. Metalink packagingB. Custom packagingC. Quick packagingD. Detailed packagingAnswer: C

177-Q58: Which of the following database objects are not candidates for RMAN image copies?(Choose all that apply.)A. DatafilesB. Online redo log filesC. Flashback log fileD. Archived redo log filesE. Password filesAnswer: B C ERMAN> backup as copy;RMAN-00571: =...

177-Q49: You need to determine the proper target time for TSPITR. What methods can you use to detemine the correct target time?(Choose all that apply.)A. Flashback DatabaseB. Flashback Version QueryC. Flashback Transaction QueryD. Flashback QueryE. Flashback DropF. Flashba...

177-Q46: Identify the statement that is true about Flashback Data Archive.(Choose the best answer.)A. You can use multiple tablespaces for an archive, and each archive can have its own retention time.B. You can have one archive, and for each tablespace that is part of the archive you can ...

177-Q41: As the DBA, you run this command on the recovery catalog database:SQL> GRANT RECOVERY_CATALOG_OWNER to KMSHELT;What privileges do the user KMSHELT have?A. KMSHELT can create users that own virtual private catalogs.B. KMSHELT can immediately use an existsing virtual catalo...

177-Q38: Which of the following DML operations use a significant portion of the PGA?(Choose all that apply.)A. Hash joinsB. Buffers for bulk load operationsC. Full table scansD. Bitmap mergesE. Bitmap createAnswer: A B D E下列DML操作使用PGA的很大一部分吗？...

177-Q37: You are creating a duplicate (auxiliary) database for testing purpose. Which of the following initialization parameter files can you use on the auxiliary database to specify the filenames on the new database?(Choose all that apply.)A. CONTROL_FILE_NAME_CONVERTB. LOG_FILE_NAME_CON...

 177-Q35:You lose all of the datafiles in your TEMP tablespace after the database shuts down. When the database starts again, what happens?A. The database instance will not start and you must re-create the TEMP tablespace in MOUNT mode.B. The database instance will not start and ...

177-Q34: You want to create an archival backup for historical purposes. Where can you store the archival backup?A. To a disk location outside of the recovery area or a tape groupB. To a disk device or the flash recovery areaC. In the flash recovery area onlyD. To a tape device or ...

177-Q33: Which two dynamic performance views can you use to identify files that need to be backed up, regardless of whether you are in ARCHIVELOG mode or NOARCHIVELOG mode?A. V$DATAFILE and V$LOGFILEB. V$DATAFILE and V$TEMPFILEC. V$LOG and V$LOGFILED. V$DATAFILE and V$CONTROLFILE...

177-Q32: You switch from Automatic Memory Management(AMM) to Automatic Shared Memory Management(ASMM) by executing this statement:alter system set memory_target = 0;Next, you restart the instance and set these values:alter system set sga_max_size = 10gb;alter system set sga_target...