1Z0-043 Exam Questions
192 real 1Z0-043 exam questions with expert-verified answers and explanations. Page 3 of 4.
- Question #108
In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control...
- Question #109
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? (Choose all that apply)
- Question #110
Consider the following command to add a new disk group called "tdgroupA" with two failover groups: CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK '/device...
- Question #111
Your business has departmental reports that are generated every day. Each department must use the same set of queries, but access a different subset of data in the tables, dependin...
- Question #112
You execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN: BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN( SIMPLE_PLAN => 'pr...
- Question #113
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)
- Question #114
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?
- Question #115
Which statement is true regarding the creation of nested plans using Resource Manager?
- Question #116
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to...
- Question #117
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could...
- Question #118
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table: ERROR at line 1: ORA-01654: unable t...
- Question #119
Consider the following scenario: You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following comm...
- Question #120
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your quer...
- Question #121
You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m.the current log sequence number was 369. Also...
- Question #122
You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?
- Question #123
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following: (a) high availability of data (b) faster primary...
- Question #124
You are using Oracle Database 10g. The log LOG_ARCHIVE_FORMAT parameter is set to ' LOG%t_%_s_%r.dbf'. Why is %r used in the file name format?
- Question #125
View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the Flashback Versions Query, you find that the first two updates are not l...
- Question #126
View the Exhibit. You have more than one table in the recycle bin having the same original name, DEPT2. You do not have any table with the name DEPT2 in your schema. You executed t...
- Question #127
Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?
- Question #128
In an Oracle 10g database, the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which compone...
- Question #129
You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance, you not...
- Question #130
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate...
- Question #131
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager (RMAN) to perform backups. Which two backups would you be...
- Question #132
You are working in an online transaction processing (OLTP) environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE...
- Question #133
Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?
- Question #134
In your production database, you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct? (Choose two)
- Question #135
By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: (a) list o...
- Question #136
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup? (Cho...
- Question #137
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one o...
- Question #138
You observe that the senior database administrator always uses the following command when connecting to Recovery Manager (RMAN), and then starts executing commands to backup the da...
- Question #139
You disabled the Flashback Database feature by using the following command: SQL> ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback lo...
- Question #140
The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without...
- Question #141
You have a disk group, DGROUP1, with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group: ALTER DISKGROUP dgroup1 ADD TEMPLA...
- Question #142
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in t...
- Question #143
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for t...
- Question #144
Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p. m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which ta...
- Question #145
What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery? (Choose two)
- Question #146
While creating a scheduler window using the DBMS_SCHEDULER package, a user logged in as DBMGR gets the error message insufficient privileges? Which two commands would you use to re...
- Question #147
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD.The default format of which two data types would be affected by this setting? (C...
- Question #148
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? (Choose four)
- Question #149
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the databa...
- Question #150
Which statement is true while creating subplans using Resource Manager?
- Question #151
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? (Choose two)
- Question #152
In your test database, you have created the ORDERS table as an index-organized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on th...
- Question #153
A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does...
- Question #154
Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREA...
- Question #155
You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash re...
- Question #156
Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choose three.)
- Question #157
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?