ITPub博客

155.Observe the structure of the table employees: The table contains 8475 records.One of the employees wants to know the names of all employees of the company. For this, he fires the following query:SELECT * FROM EMPLOYEES ORDER BY emp_fname;Since the operation performed on executing the query ca...

96.Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The shrink operation touches every block in the BOOKING tableB. The high-water mark (HWM) for the BOOKING table is shifted from its original positi...

92.You observed the following output for a user session:What do you infer from the preceding output?A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit is exceeded fo...

20.View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output? (Choose two.)Exhibit:A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user b...

613.You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?A. Enable the flash recovery area and specify it as the archived redo log destination.B. Disable the flash recovery area and start the database instance in AR...

622.You need to maintain a record of all transactions on some tables for at least three years.Automatic undo management is enabled for the database.What must you do accomplish this task?A. Enable supplemental logging for the database.B. Specify undo retention guarantee for the databaseC. Create...

637.Which three statements are true about windows? (Choose three.)A. Only one window can be open at any given timeB. Consumer groups are associated with windowsC. Windows work with job classes to control resource allocationD. The database service name must be provided during windows creationE. ...

102.Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGN...

539.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed?A. Issue the ALTER DISKGROUP ... ADD DISK command.B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D. Retrieve the disk from ...

534.How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?A. Issue the ALTER DISKGROUP ... ADD DISK command.B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D. Retrieve the disk from ...

531.When starting up your ASM instance, you receive the following error:ASM实例启动时，您会收到以下错误：SQL> startup pfile=?/dbs/init+ASM.oraASM instance started+Total System Global Area 104611840 bytesFixed Size 1298220 bytesVariable Size 78147796 bytesASM Cache 25165824 bytesORA-15032: no...

105.Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overh...

60.For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to...

563.How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21Answer: COracle 11g支持多少个归档日志目标？应该是31个，10g是支持10个。SQL> select * from v$version;BANNER----------------------------------------------------------...

208.You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level? (Choose two.)A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RE...

496.Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance e...

235.The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration.You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation? (Choose two.)A. Th...

665.Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the datab...

650.Which three tasks can be performed using a duplicate database? (Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log ...

644.View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?A. Because the FRA disk ...