Hide Notes 

Slide 1: Ourexam provides candidates real questions and answers to help you pass your test at the first time, you can find Microsoft, IBM, HP, CompTIA ,Apple certifications etc. In order to celebrate the following Christmas Day, Ourexam offers you the biggest promotion, each exam will be sold at 58USD, some products will especially at 29USD. Furthermore, new registered members will gain 60 bonus points. Act now and seize this good chance.
Slide 2: The safer , easier way to help you pass any IT exams. Exam : 1Z0-043 Title : Oracle database 10g:Administration ii Version : Demo 1 / 11
Slide 3: The safer , easier way to help you pass any IT exams. 1. 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 2. 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 3. 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 4. You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET = 10GB 2 / 11
Slide 4: The safer , easier way to help you pass any IT exams. 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 5. 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 6. 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 7. You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace: RMAN> BACKUP TABLESPACE DETTBS; 3 / 11
Slide 5: The safer , easier way to help you pass any IT exams. 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 8. 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 9. 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 10. 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. 4 / 11
Slide 6: The safer , easier way to help you pass any IT exams. ANSWER: BE 11. 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 12. 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 13. 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? 5 / 11
Slide 7: The safer , easier way to help you pass any IT exams. 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 14. 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 15. View the Exhibit and examine the Flashback SCNs. A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery, you chose 2004343 as the Flashback SCN. Which two statements are correct in this scenario? (Choose two.) A.Only the row with DEPARTMENT_ID 290 would be flashed back. B.The rows with DEPARTMENT_ID 290 and 300 would be flashed back. C.The rows with DEPARTMENT_ID 290 and 280 would be flashed back. D.You would have taken the USERS tablespace offline before starting the Flashback Table operation. E.You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation. ANSWER: BE 6 / 11
Slide 8: The safer , easier way to help you pass any IT exams. 16. 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 command, the System Change Number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state and the resultant changes are not what you had desired. So, you need to reverse the effects of the FLASHBACK TABLE command while ensuring that: a) No other user data in the database is affected. b) The operation takes the minimum possible time. Which option would you choose? A.use the ROLLBACK command with SCN 663571 B.perform Flashback Transaction Query with SCN 663571 C.execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571 D.execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571 ANSWER: D 17. You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); Which two statements are correct? (Choose two.) A.The FLASHBACK TABLE statement will not be written to the alert log file. B.The changes made to the EMP table since the specified time will be undone. C.The EMP table that was dropped by mistake from the database will be restored. D.The FLASHBACK TABLE statement will be executed within a single transaction. E.The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. F.The list of transactions that have modified the EMP table since the specified time will be displayed. ANSWER: BD 18. Why would you use the following FLASHBACK TABLE command? FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); A.to undo the changes made to the EMP table since the specified time B.to restore the EMP table that was wrongly dropped from the database C.to view the transactions that have modified the EMP table since the specified time D.to view the changes made to the EMP table for one or more rows since the specified time E.to recover the EMP table to a point in time in the past by restoring the most recent backup ANSWER: A 19. For which two SQL statements can you use the Flashback Table feature to revert a table to its 7 / 11
Slide 9: The safer , easier way to help you pass any IT exams. previous state? (Choose two.) A.UPDATE TABLE B.CREATE CLUSTER C.TRUNCATE TABLE D.ALTER TABLE MOVE E.INSERT INTO...VALUES F.ALTER TABLE...DROP COLUMN G.ALTER TABLE...DROP PARTITION ANSWER: AE 20. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected? A.perform point-in-time recovery B.perform a Flashback Table operation to restore the table to the state it was in two days ago C.perform a Flashback Database operation to restore the database to the state it was in two days ago D.perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery ANSWER: D 21. 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 listed. What could be the reason? A.The row movement is not enabled on the table. B.The first two updates were not explicitly committed. C.The Flashback Versions Query lists only the most recent update. D.The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed. ANSWER: D 22. Which two statements are correct regarding the Flashback Versions Query feature? (Choose two.) A.You can use this feature to identify the versions of V$ views. B.You can use this feature to identify the versions of external and fixed tables. C.You can use this feature for a table only if row movement is enabled for the table. 8 / 11
Slide 10: The safer , easier way to help you pass any IT exams. D.You can use this feature to identify the committed versions of the rows, but not the uncommitted versions. E.You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table. ANSWER: DE 23. 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) a list of changes made along with the transaction identifier of each change b) the necessary SQL statements to undo the erroneous changes Which option would you choose? A.RMAN only B.Flashback Table only C.Flashback Versions Query only D.Flashback Database and Flashback Transaction Query E.Flashback Versions Query and Flashback Transaction Query ANSWER: E 24. You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output? A.It would return information regarding only the last committed transaction. B.It would return only the active transactions in all the undo segments in the database. C.It would return only the committed transactions in all the undo segments in the database. D.It would return both active and committed transactions in all the undo segments in the database. E.It would return information regarding the transactions that began and were committed in the last 30 minutes. ANSWER: D 25. By using the transaction identifier provided by _____ for a particular row change, you can use the Flashback Transaction Query to see the operation performed by the transaction. A.Flashback Table B.Flashback Database C.Flashback Versions Query D.the RMAN REPORT command E.the DBA_PENDING_TRANSACTIONS view 9 / 11
Slide 11: The safer , easier way to help you pass any IT exams. ANSWER: C 26. There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database? A.the DBNEWID utility B.the DBVERIFY utility C.the ANALYZE command D.the RMAN REPORT command E.the RMAN CROSSCHECK command F.the CHECK_OBJECT procedure of the DBMS_REPAIR package ANSWER: B 27. 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 would you use? A.the DBNEWID utility B.the ANALYZE command C.the RMAN LIST command D.the RMAN REPORT command E.the RMAN CROSSCHECK command F.the RMAN BLOCKRECOVER command ANSWER: B 28. The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed? A.The Oracle database will not perform block checking for any of the data blocks. B.The Oracle database will perform block checking for the default permanent tablespace only. C.The Oracle database will perform block checking for the data blocks in all user tablespaces. D.The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only. E.The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces. ANSWER: D 29. The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes? A.The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent. B.DBWn and the direct loader will calculate a checksum and store it in the cache header of every data 10 / 11
Slide 12: The safer , easier way to help you pass any IT exams. block when writing it to disk. C.The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent. D.The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent. E.The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent. ANSWER: A 30. Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning, while querying the user1.employees table, you receive the following error message: 01578: ORACLE data block corrupted (file # 5, block # 51) ORA-01110: data file 5: '/u01/app/oracle/oradata/orcl/example01.dbf' You need to rectify the corruption while ensuring the following: The data file should remain online. The mean time to recover (MTTR) should be minimal. You are not using a backup control file, and all the archived logs are accessible. Which option would you choose? A.flash back the corrupted blocks B.use the DBMS_REPAIR package C.use the RMAN TSPITR command D.use the RMAN BLOCKRECOVER command E.use the RESTORE DATABASE and RECOVER DATABASE commands F.investigate the time at which the corruption occurred and perform a point-in-time recovery ANSWER: D 11 / 11
Slide 13: 1. Follow our site updates on Twitter 2. Join us on Facebook. Thanks you for reading exam demo. Should you have any questions or require any further information, please do not hesitate to contact us. Sales: sales@ourexam.com Support: support@ourexam.com