1Z0-043 Exam Questions
192 real 1Z0-043 exam questions with expert-verified answers and explanations. Page 4 of 4.
- Question #158
Which six files are maintained in the Flash Recovery Area? (Choose six.)
- Question #159
Consider the following scenario: You have a directory, data, under the disk group tdgroup You want to create an alias for one of the data files and you execute the following comman...
- Question #160
View the Exhibit. One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you...
- Question #161
You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?
- Question #162
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
- Question #163
You want to enforce a company's business policy on several objects by using a single policy function. Which two types of policies can be assigned to the policy_type argument in the...
- Question #164
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?
- Question #165
View the Exhibit and examine the characteristics of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS table...
- Question #166
What are the prerequisites for enabling Flashback Database? (Choose all that apply.)
- Question #167
Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database? (Choose...
- Question #168
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)
- Question #169
The database is running in ARCHIVELOG mode and the FORMAT option is not configured in RMAN for disk backups. You configured the flash recovery area location and size by using the D...
- Question #170
You have created a resource plan, PROD_DB_PLAN, that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource p...
- Question #171
You want an ASM instance to manage the files of your database. To achieve this objective, you specify the following parameters in the parameter file of the database: INSTANCE_TYPE...
- Question #172
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?...
- Question #173
From the V$SESSION_LONGOPS view, you find that some of the database users have long- running queries that consume a lot of CPU time. This causes performance problems for other user...
- Question #174
You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you confi...
- Question #175
In your Automatic Storage Management (ASM) instance, one of the nonempty disk groups, DGROUP1, is no longer required and you want this disk group to be removed. You execute the fol...
- Question #176
View the Exhibit and examine the properties of the USERS tablespace. You execute the following statement to shrink the TRANS table existing on the USERS tablespace: SQL> ALTER TABL...
- Question #177
Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error, you decided to perform an incomplete recovery. Which two tasks would you be requi...
- Question #178
Which two statements regarding compressed backups in Recovery Manager (RMAN) are true? (Choose two.)
- Question #179
You lost the PRODSTD tablespace, which was read-only. The tablespace was read-only when the last backup was taken. How would you recover the tablespace?
- Question #180
The loss of the control file forced you to re-create the control file. After re-creating it and opening the database, you find that some of the data files are named as MISSINGnnnnn...
- Question #181
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS...
- Question #182
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); Which two statements are correct? (Choose two.)
- Question #183
Which two statements are correct regarding the Flashback Versions Query feature? (Choose two.)
- Question #184
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configure...
- Question #185
You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? (Choose two.)
- Question #186
You are managing a database for which incremental backups can be very time consuming. In order to perform optimized incremental backups you enable the block change tracking feature...
- Question #187
You configured the large pool for Oracle backup and restore operations. As a result, which component would require less memory?
- Question #188
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are perfo...
- Question #189
You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group...
- Question #190
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering...
- Question #191
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to...
- Question #192
The EMPLOYEES table is stored in the USERS tablespace. You need to check if the EMPLOYEES table is affected by the block corruption found in the USERS tablespace. Which option woul...
- Question #193
A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this...
- Question #194
Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs with...
- Question #195
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE...
- Question #196
You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?
- Question #197
You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface: SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP( CONSUMER_GR...
- Question #200
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from th...
- Question #201
You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery M...