ITPub博客

524.What are three benefits of using ASM? (Choose three.)A. Ease of disk administration and maintenanceB. Load balancing across physical disksC. Software RAID-1 data redundancy with double or triple mirrorsD. Automatic recovery of failed disksAnswer: ABC优点? 对文件而不是逻辑卷进行条带...

523.The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)A. Date formatB. Decimal characterC. Group separatorD. First day of the monthE. None of the aboveF. All of the aboveAnswer: ABC参考：http:/...

519.You notice that a long-running transaction is suspended due to a space constraint, and there is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical transaction is just about to reach the RESUMABLE_TIMEOUT value.Which of these actions is appropriate?A. Abort t...

518.The DBA has chosen to manage SGA and PGA memory separately in an OLTP database because of his unique knowledge of the application. Which of these are good starting points to use when configuring the maximum values for SGA and PGA, based on the amount of memory available on the system?A. 20% SGA...

480.View the Exhibit exhibit1 to examine the series of SQL commands.View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhib...

473.How many different calendars does Oracle 11g support?A. 22B. 7C. 6D. 15E. 2Answer: B参考：http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG215NLS_CALENDAR can have one of the following values:Arabic HijrahEnglish HijrahG...

464.Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)A. ASCIIB. ANSIC. BINARYD. MONOLINGUALE. MULTILINGUALAnswer: BCSQL> show parameter nls_compNAME               &nb...

341.If a backup set is expired, what can you do to correct the problem?A. Change the retention criteria.B. Make the lost backup set pieces available to RMAN again.C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D. Nothing. The backup set p...

339.Why would you run the delete obsolete command? (Choose all that apply.)A. To remove missing backup set pieces physically from diskB. To remove metadata related to backup set pieces in the control file and the recovery catalogC. To mark as deleted records in the control file and the recovery c...

338.You run the following commands:RMAN> list expired backup;RMAN> delete expired backup;What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?A. They will be renamed.B. Nothing will happen to them. The backup set pieces do not exis...

333.Which command would you use to determine what database backups are currently available for restore?A. list database backup;B. report database backup;C. list backup of database;D. list summary backup;E. report backup of database;Answer: CC:\Users\dell>rman target /...

284.Evaluate the following SQL statement used to create the PRODUCTS table:CREATE TABLE products (    product_id NUMBER(3) PRIMARY KEY,    product_desc VARCHAR2(25),    qty  NUMBER(8,2),    rate NUMBER(10,2),&...

266.View the Exhibit to examine the parameters set for your database instance. You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, -&...

265.View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the TPMRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function.A new column PROD_QTY is added to the PRODUCTS table. How does this impact the status...

257.Which client requests to the database can be captured as a part of the workload capture?(Choose all that apply.)A. flashback queryB. distributed transactionsC. logging in and logging out of sessionsD. all DDL statements having bind variablesE. direct path load of data from external filesAn...

 185.A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?A. backup database allB. ...

183.Which of the following RMAN structures can data from a datafile span?A. RMAN backup-set pieces spanning backup setsB. RMAN backup-set pieces within a given backup setC. RMAN backupsD. RMAN channelsE. None of the aboveAnswer: B数据文件可以跨跃RMAN备份集的备份片。

181.Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now n...

24.Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)A. ADR diagnostic filesB. all the optimizer statisticsC. initialization parameter settingsD. PL/SQL functions, procedures, and packages...

23.Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBsC. deduplication, encryption, and compression settings for all SecureFile LOBsD. d...