站内搜索
1Z0-052 问题列表
问题
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A
7， 1， 5， 2， 3， 6， 4B
1， 2， 3，7， 5， 6， 4C
7， 1， 4， 5， 2， 3， 6D
1， 7， 5， 4， 2， 3， 6
问题
单选题Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）A
Insert finding directives for ADDM tasks in the future.B
Create a baseline on a pair of snapshots spanning the peak-load period.C
Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.D
Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
问题
单选题in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）A
Optimizer statistics are collected automatically.B
Only timed operating system （OS） statistics and plan execution statistics are collected.C
The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.D
Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
问题
单选题In a new installation of Oracle Database 11g， you perform these activities： 1. Organize software and data on different subdirectories to avoid poor performance. 2. Use consistent naming conventions for database files. 3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed（）A
Oracle Managed FilesB
Oracle Grid ArchitectureC
Optimal Flexible ArchitectureD
Oracle database architectureE
Automatic Storage Management
问题
单选题Which task would you perform before you run Oracle Universal Installer （OUI） in silent or suppressedmode for an installation（）A
Run the root.sh script.B
Create the oraInst.loc file.C
Create the tnsnames.ora file.D
Run the oraintRoot.sh script.
问题
多选题You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays， to tape. Which two statements are true about differential incremental backups（）AThe backup performed on Sundays contains all the blocks that have ever been used in the database.BThe backup performed on Sundays contains all the blocks that have changed since the last level 1backup.CThe backup performed on each working day contains all the blocks that have changed since the lastlevel 0 backup.DThe backup performed on Monday contains all the blocks that have changed since the level 0 backup，and every other working day contains all the blocks that have changed since the level 1 backup.
问题
单选题These are points that describe the contents of different memory components: 1: Descriptive information or metadata about schema objects that are queried by using SQL statements 2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 3: Results of SQL queries and PL/SQL functions 4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 5: The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in theShared Poolif the necessary configurations are done（）A
1 and 2B
2 and 5C
1，3，and 4D
3，4，and 5E
1，2，3，and 4
问题
单选题Which statement is true about loading data using the conventional path of SQL*Loader（）A
Redo is not generated while performing conventional path loads.B
Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.C
No exclusive locks are acquired when the conventional path loads are performed.D
Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.E
INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
问题
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
问题
多选题User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）AGrant the RESOURCE role to SCOTT.BAdd data files to the USERS tablespace.CGrant the CREATE ANY TABLE privilege to SCOTT.DIncrease the space for SCOTT on the USERS tablespace.EIncrease the size of the data file associated with the USERS tablespace
问题
单选题our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A
The command succeeds only if Automatic Memory Management is not enabled.B
The command succeeds， but you need to restart the database for changes to take effect.C
The command returns an error because the size of the redo log buffer cannot be changed dynamically.D
The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）
问题
单选题Identify the memory component from which memory may be allocated for：（） 1. Session memory for the shared server 2. Buffers for I/O slaves 3. Oracle Database Recovery Manager （RMAN） backup and restore operationsA
Large PoolB
Redo Log BufferC
Database Buffer CacheD
Program Global Area （PGA）
问题
单选题Your database instance is configured with automatic undo management and the UNDO_RETENTIONparameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have onthe database（）A
The extents in the undo tablespace retain data until the next full database backup.B
The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.C
The extents containing committed data in the undo tablespace are not overwritten until the instance is shutdown.D
The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten
问题
单选题You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows： Warning （%）： 90 Critical （%）： 95 Which background process is responsible for issuing alerts when the threshold is crossed（）A
System monitor （SMON）B
Process monitor （PMON）C
Memory manager process （MMAN）D
Manageability Monitor process （MMON）
问题
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur（）A
7， 1， 5， 2， 3， 6， 4B
1， 2， 3，7， 5， 6， 4C
7， 1， 4， 5， 2， 3， 6D
1， 7， 5， 4， 2， 3， 6