OCP-1Z0-052-V8.02-47题

ocp-v13-683

Your production database it functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production

OCP-1Z0-053-V12.02-683题

683. Your production database it f unctional on the SHOST1 host. Y ou are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the pro

OCP-1Z0-052-V8.02-44题

44. Your database is functional with a peak load for the last one hour. You want to preserve the performance statistics collected during this period to be used for comparison when you analyze the pe

47.Your database instance is functional for the past one month. The Automatic Workload Repository (A

47.Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. You receive a complaint about the poor performance o

OCP-1Z0-052-V8 02-47题

OCP-1Z0-052-V8 02-47题

OCP-1Z0-052-V8.02-82题

82. You are managing an Oracle Database 11g database with the following backup strategy: 1) On Sunday, an incremental level 0 tape backup is performed. 2) Monday through Saturday, a cumulative i

OCP-1Z0-052-V8.02-81题

81. You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental back

OCP-1Z0-052-V8.02-162题

162. You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using th

OCP-1Z0-052-V8.02-129题

129. A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL> connect smith/smith Connected. SQL> SELECT * FROM v$session; SELECT * FROM v$session * ERRO

OCP-1Z0-052-V8.02-149题

149. You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true a

OCP-1Z0-052-V8.02-7题

7. You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database: 1: SGA is allocated. 2: Control fi

OCP-1Z0-052-V8.02-13题

13. You have executed this command to change the size of the database buffer cache: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered. To verify the change in size, you executed this

OCP-1Z0-052-V8.02-14题

14. 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 a

OCP-1Z0-052-V8.02-63题

63. Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0 LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database? (Choo

OCP-1Z0-052-V8.02-17题

17. Note the functionalities of various background processes: 1: Perform recovery at instance startup. SMON 2: Free the resources used by a user process when it fails. PMON 3: Cleanup the databas

OCP-1Z0-052-V8.02-6题

6. Note the following points describing various utilities in Oracle Database 11g: 1: It enables the high-speed transfer of data from one database to another. 2: It provides a complete solution f

OCP-1Z0-052-V8.02-183题

183. The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:  CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dna

OCP-1Z0-052-V8.02-139题

139. Which two statements are true regarding a tablespace? (Choose two.) A.It can span multiple databases.  B.It can consist of multiple data files. C.It can contain blocks of different sizes. D.I

OCP 1Z0 052 V8 02 63题

OCP 1Z0 052 V8 02 63题