站内搜索
1Z0-053 问题列表
问题
单选题In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）A
Setting a nonzero value for SGA_TARGETB
Configuring Automatic Shared Memory ManagementC
Configuring Automatic Memory ManagementD
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE
None of the above
问题
单选题Examine the following PL/SQL block： DECLARE my_plans pls_integer； BEGIN my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id= ？9twu5t2dn5xd？； END； Which statement is true about the plan being loaded into the SQL plan baseline by the above command？（）A
It is loaded with the FIXED status.B
It is loaded with the ACCEPTED status.C
It is not loaded with the ENABLED status.D
It is not loaded with the ACCEPTED status.
问题
单选题You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true？（）A
You must have change tracking enabled in your databaseB
Your database must be running in NOARCHIVELOG modeC
To back up a tablespace，it must be in backup modeD
To back up a tablespace，it must first be taken offline
问题
多选题You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel
问题
单选题When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.A
a， b， c， d， e， fB
c， d， a， b， fC
d， c， a， b， fD
d， b， d， c， eE
d， c， a， b， e
问题
多选题Which two statements are correct about database transportation？（）AThe source and target platforms must be the sameBRedo logs，control files and temp files are also transportedCThe transported database must have the same database identifier （DBID） as the source database and cannot be changedDThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transportedERecovery Manager （RMAN） is used to convert the necessary data files of the database if the target platform is different and has different endian format
问题
单选题Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）A
Flashback DropB
Flashback QueryC
Flashback Transaction QueryD
Flashback Versions QueryE
Flashback Table
问题
单选题In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first？（）A
authentication by password fileB
authentication by using certificates over SSLC
authentication by using the Oracle Internet DirectoryD
authentication by using the local OS of the database server
问题
多选题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.)AThe databases configured to use the ASM instance are mountedBThe disk groups are mounted as per the ASM_DISKGROUPS initialization parameterCASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not startedDASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters
问题
多选题Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
问题
单选题In a database with the database character set of US7ASCII and a national character set of UTF-8， which datatypes would be capable of storing Unicode data by default？（）A
VARCHAR2B
CHARC
NVARCHAR2D
CLOBE
LONG
问题
单选题Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener？（）A
Oracle Net ManagerB
Listener Control utilityC
Database Configuration AssistantD
Oracle Net Configuration Assistant
问题
单选题Examine the CREATE DISKGROUP command used to create a disk group: SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?（）A
When two-way disk mirroring is required for the allocation unitsB
When three-way disk mirroring is required for the allocation unitsC
When using hardware mirroring or RAIDD
When disk mirroring is required for the Automatic Storage Management (ASM) disks
问题
多选题You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）AEvery SQL statement in the STS is considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.
问题
单选题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 piece is lost forever.E
Call Oracle support，their assistance is required.