ITPub博客

577.What methods are available to recover lost control files? (Choose all that apply.)A. Backup control file.B. Emergency control file.C. The create controlfile command.D. The restore controlfile SQL*Plus command.E. No backup is required. The database will re-create the control file when it is ...

571.Which files are required for a full recovery of the database in ARCHIVELOG mode? (Choose three.)A. Database datafilesB. Online redo logsC. Archived redo logsD. Backup control fileE. Control file from a backupAnswer: ACD在归档记录模式下数据库的完整恢复需要哪些文件？完全恢复总是需要在线...

570.What methods of point-in-time recovery are available? (Choose all that apply.)A. Change-basedB. Cancel-basedC. Time-basedD. Sequence number-basedE. Transaction number-basedAnswer: ABCD时间点的恢复方法有哪些？Change-based application allows you to recover the database to a specific SCN....

568.Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)A. Database datafilesB. Control filesC. Archived redo logsD. Online redo logsE. Flashback logsAnswer: ABD你需要哪些文件执行在非归档记录模式下的数据库的完全恢复？非...

558.Which view provides information on the backup status of the datafiles in the database?A. V$BACKUPB. V$BACKUP_STATUSC. V$BACKUP_DATAFILED. V$DATAFILE_BACKUPE. V$TABLESPCE_BACKUPAnswer: A哪个视图提供在数据库中的数据文件的备份状态的信息？SQL> select table_name from dict where table_name...

543.As the DBA, you run the following query on your ASM instance.What is the implication of the results of the query? (Choose two.)SQL> select group_number, name, state from v$ASM_DISKGROUP;GROUP_NUMBER NAME STATE0 DGROUP1 DISMOUNTED2 DGROUP2 MOUNTED3 DGROUP3 MOUNTEDA. The DGROUP1 disk group ...

530.When an ASM instance receives a SHUTDOWN NORMAL command, what command does it pass on to all database instances that rely on the ASM instances disk groups?A. TRANSACTIONALB. IMMEDIATEC. ABORTD. NORMALE. None of the aboveAnswer: E当ASM实例接收一个正常关闭命令，它传递什么命令给依赖于ASM实...

529.Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?A. ASM_DISKMOUNTB. ASM_DISKGROUPC. ASM_DISKSTRINGD. ASM_MOUNTGROUPAnswer: B参考：http://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#OSTMG10141哪一个...

522.The NLS_LANGUAGE parameter specifies the default conventions to be used for which of the following globalization elements?A. Languages for server messagesB. Day and month names and abbreviationsC. Symbols to represent a.m., p.m., AD, and BCD. Affirmative and negative response strings (YES, N...

521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur?A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B. The job affinity is to a service and one node in th...

481.Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.B. It performs the first 10000 I/O requests or 2,500...

479.Which two statements about workload capture and replay TM operations are true? (Choose two.)A. The clients must be created manually on the test machines to perform more realistic testing.B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for wor...

478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshotsAnswer: AC确定两个直接来源，从那里SQL计划可以加载到SQL计划基线。A、游标缓存C、SQL...

477.Which of the following is not a valid linguistic sort element?A. Accent expansionB. Canonical equivalenceC. Reverse secondary sortingD. Ignorable charactersE. Character rearrangementAnswer: A参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch5lingsort.htm#NLSPG276下列哪项不...

474.Which NLS parameter directly governs linguistic searches?A. NLS_SEARCH_LB. NLS_SORTC. NLS_SEARCHD. NLS_SORT_LE. None of the aboveAnswer: B参考：http://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams155.htm#REFRN10127哪种国家语言支持参数直接支配语言搜索？Linguistic searches ...

469.Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?A. NLS_SORT = BINARYB. NLS_SORT = BINARY_AIC. NLS_SORT = BINARY_CID. NLS_SORT = BINARY_AI_CIE. Binary sorts are case insensitive and accent insensitive by default.Answer: B...

466.What can you determine about the following linguistic sorts based only on their names?1. GERMAN2. FRENCH_MA. 1 is a monolingual sort.B. 2 is a monolingual sort.C. 1 is case insensitive.D. Both 1 and 2 are case insensitive.E. Case sensitivity is unknown.Answer: A参考：http://docs.oracle...

461.The NLS_SORT parameter sets the default sort method for which of the following operations?(Choose all that apply.)A. WHERE clauseB. ORDER BY clauseC. BETWEEN clauseD. NLSSORT functionE. NLS_SORT functionAnswer: AD国家语言支持排序参数设置默认的排序方式为以下哪些操作？The NLS_SORT parame...

460.Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)A. A must contain all of the characters defined in B.B. A must be Unicode.C. The encoded values in A must match the encoded values in B for ...

459.What elements of globalization can be explicitly defined using the NLS_LANG environment variable?(Choose all that apply.)A. NLS_LANGUAGEB. NLS_SORTC. NLS_CALENDARD. NLS_CHARACTERSETE. NLS_TERRITORYAnswer: ADE参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG...