1Z0-043 Exam

Quality and Value for the 1Z0-043 Exam

Test4pass Practice Exams for Oracle 1Z0-043 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1Z0-043 Exam

If you prepare for the exam using our Test4pass testing engine, we guarantee your success in the first attempt. If you do not pass the 10g DBA 1Z0-043 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1Z0-043 Downloadable, Printable Exams (in PDF format)

Our Exam 1Z0-043 Preparation Material provides you everything you will need to take your 1Z0-043 Exam. The 1Z0-043 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

1Z0-043 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Oracle 1Z0-043 Exam will provide you with free 1Z0-043 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 1Z0-043 Exam:100% Guarantee to Pass Your 10g DBA exam and get your 10g DBA Certification.

Hot KeyWords On 1Z0-043 test

We collect some hot keywords about this exam:
Test4pass , Pass 4 Sure , Test in Side ,Pass Guide ,Test King 1Z0-043 exam | 1Z0-043 pdf exam | 1Z0-043 braindumps | 1Z0-043 study guides | 1Z0-043 trainning materials | 1Z0-043 simulations | 1Z0-043 testing engine | 1Z0-043 vce | 1Z0-043 torrent | 1Z0-043 dumps | free download 1Z0-043 | 1Z0-043 practice exam | 1Z0-043 preparation files | 1Z0-043 questions | 1Z0-043 answers.

How to pass your 1Z0-043 exam

You can search on Search Engine and Find Best IT Certification site: Test4pass.com - Find the Method to succeed 1Z0-043 test,The safer.easier way to get 10g DBA Certification .

��
��
Exam : Oracle 1Z0-043
Title : Oracle Database 10g: Administration II


1. 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 the recycle bin.
Which statement is correct?
A. You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
B. You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
C. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
D. You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
Answer: A

2. Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance then gradually returns to normal levels.
Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)
A. increase the number of checkpoint processes
B. define the POWER option while adding or removing the disks
C. increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D. increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
E. increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process
Answer: BE

3. You executed the following command in Recovery Manager (RMAN):
RMAN> RESTORE CONTROLFILE;
Which operation must you perform before this command is executed?
A. back up the control file to trace
B. bring database to the MOUNT state
C. open a connection to the RMAN recovery catalog, which contains the RMAN metadata for the target database
D. set the database ID (DBID), but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
Answer: C

4. 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 the following command:
PURGE TABLE dept2;
Which statement is correct in this scenario?
A. All the tables having the same original name as DEPT2 will be purged from the recycle bin.
B. The table with dropscn = 1928151 (oldest dropscn) will be purged from the recycle bin.
C. The table with dropscn = 1937123 (most recent dropscn) will be purged from the recycle bin.
D. None of the tables will be purged because there are multiple entries with the same original name in the recycle bin.
Answer: B

5. You execute the following command to enable a session in resumable mode:
SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;
What is the impact of a timeout on the statements being suspended?
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
Answer: C

6. Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement.
What was the first step that was needed in the process to achieve this objective?
A. The user must have been granted the DBA role.
B. The user must have been granted the switch privilege as a part of a role.
C. The user must have been granted the Resource Manager administrator privilege.
D. The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
Answer: D

7. 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 = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A maximum of 3 GB can be allocated to shared pool.
B. The value for SGA_TARGET can be increased up to a maximum of 14 GB.
C. A total of 14 GB memory will be allocated to the automatically tuned memory components.
D. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE.
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters.
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB.
Answer: BE

8. 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 you use?
A. LogMiner
B. the DBNEWID utility
C. the DBVERIFY utility
D. the ANALYZE command
E. the RMAN REPORT command
F. the RMAN CROSSCHECK command
G. the RMAN BLOCKRECOVER command
Answer: D

9. 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? (Choose two.)
A. DATE
B. TIMESTAMP
C. INTERVAL YEAR TO MONTH
D. INTERVAL DAY TO SECOND
E. TIMESTAMP WITH LOCAL TIME ZONE
Answer: BE

10. You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approach would you take to solve the problem?
A. flash back the database
B. import the temporary tablespace from the last export
C. restore all the data files and temporary files from the last full database backup and perform a recovery
D. not perform a recovery, but create a new temporary tablespace, make it the default temporary tablespace and then drop the old tablespace
Answer: D

11. Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)
A. Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.
B. You can flash back a dropped table provided row movement has been enabled on the table.
C. If you drop an index before dropping its associated table, then the recovery of the index is not supported when you flash back the dropped table.
D. When you execute the DROP TABLESPACE ?INCLUDING CONTENTS command, the objects in the tablespace are placed in the recycle bin.
E. When a dropped table is moved to the recycle bin, only the table is renamed to a system-generated name; its associated objects and constraints are not renamed.
F. If you drop a table that is protected by the recycle bin, then associated bitmap-joined indexes and materialized view logs are also stored in the recycle bin.
Answer: AC

12. 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 database with the RESETLOGS option? (Choose two.)
A. This operation resets the SCN for the database.
B. This operation creates a new incarnation of the database.
C. This operation moves all the redo log files to a different location.
D. This operation deletes the old redo log files and creates new redo log files.
E. This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
Answer: BE

13. You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:
RMAN> BACKUP TABLESPACE DETTBS;
Under which conditions would this command execute successfully? (Choose all that apply.)
A. The database is in NOMOUNT state.
B. The database is in ARCHIVELOG mode and the tablespace is online.
C. The database is in ARCHIVELOG mode and the tablespace is offline.
D. The database is in NOARCHIVELOG mode and the tablespace is online.
E. The database is in NOARCHIVELOG mode and the tablespace is offline.
Answer: BCE

14. These are the details about V$FLASHBACK_DATABASE_STAT:
SQL> DESC V$FLASHBACK_DATABASE_STAT
name Null? Type
------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? (Choose two.)
A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
Answer: CD