站内搜索
1Z0-053 问题列表
问题
单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A
Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B
Capture the plans from the previous version using STS and then load them into the stored outline.C
Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D
Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.
问题
单选题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
deduplication，encryption，and compression settings only for SecureFile CLOBs
问题
多选题Evaluate the following command and its output： SQLSELECT * FROM dba_temp_free_space； TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）AFREE_SPACE indicates only the space that is currently unallocated.BALLOCATED_SPACE indicates only the space currently allocated and in use.CFREE_SPACE indicates only the space that is currently allocated and available for reuse.DALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.EFREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
问题
单选题You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task？（）A
Enable Flashback Data Archive for the tables.B
Specify undo retention guarantee for the database.C
Enable supplemental logging for the database.D
Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E
Create Flashback Data Archive on the tablespace on which the tables are stored.
问题
多选题You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective？（）ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.
问题
多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
问题
多选题Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）AYou can add or remove the trace files to the package.BYou can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.CYou can add SQL test cases to the incident package.DYou cannot create an incremental incident package when the physical files are purged rom the ADR.
问题
多选题Which two client requests are captured during database replay Capture？（）AFlashback queriesBShared server requestsCLogin and logoff activities of sessionsDDirect path load of data from external files by using utilities such as SQL *loaderEData definition language （DDL） and data manipulation language （DML） operations
问题
多选题To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）AMultiple change tracking files can be created for a database.BThe change tracking file must be created after the first level 0 backup.CRMAN does not support backup and recovery of the change tracking file.DThe database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.
问题
单选题You want to set the following Initialization parameters for your database Instance LOG_ARCHIVE_DEBT_1 = ，，LOCATION=/disk1/arch LOG_ARCHIVE_DBST_2 = ，，LOCATION=/disk2/arch LOC_ARCHIVB DBST_3 = ，，LOCATION=/disk3/arch LOG_ARCHIVE DBST_ = ，，LOCATION=/disk3/arch Identify the statement that correctly describes this setting.（）A
The MANDATORY location must be a flash recovery area.B
The optional destinations may not use the flash recovery area.C
This setting is not allowed because the first destination is not set as MANDATORY.D
The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
问题
单选题You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）A
Run Segment AdvisorB
Run the SQL Tuning Advisor (STA)C
Run the Automatic Workload Repository (AWR) reportD
Run the SQL Access Advisor with a hypothetical workload
问题
多选题Which three statements are true regarding persistent lightweight jobs？（）APersistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.BThe user cannot set privileges on persistent lightweight jobs.CPersistent lightweight jobs are useful when users need to create a large number of jobs in a short time.DPersistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.EThe use of a template is mandatory to create persistent lightweight jobs.
问题
多选题ASM supports all but which of the following file types？（）ADatabase filesBSpfilesCRedo-log filesDArchived log filesERMAN backup setsFPassword filesGinit.ora files
问题
单选题You perform a backup using the following BACKUP command： RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE； Which statement is true of this command？（）A
A different procedure is required to restore a database from compressed backupsB
The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.C
Using this command to create backups minimizes the bandwidth consumedD
Using this command to create backups improves the performance of the backup process
问题
单选题You are managing an ASM instance. You previously issued the following statements： ALTER DISKGROUP dg1 DROP DISK disk2； ALTER DISKGROUP dg1 DROP DISK disk3； ALTER DISKGROUP dg1 DROP DISK disk5； You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue？（）A
ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5B
ALTER DISKGROUP dg1 UNDROPC
ALTER DISKGROUP dg1 UNDROP DISKSD
You cannot cancel the pending disk drops