Free Oracle 1Z0-045 Exam Dumps Questions & Answers

In Oracle 10g, the LogMiner allows storage of a copy of the data dictionary in _____ and _____. (Choose two.)

• A.  a database file
• B.  an operating system flat file
• C.  a nested table in the database
• D.  the supplemental log file
• E.  the online redo log files
• F.  the control file

When enabling a flashback, you must identify the version of the database contents you want to see. Which two options can you use to identify this version? (Choose two.)

• A.  a start and an end SCN
• B.  a transaction ID
• C.  a point in time
• D.  a System Change Number (SCN)
• E.  a start and an end time

You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?

• A.  The USERStablespace is a bigfile tablespace (BFT).
• B.  The Unified Job Scheduler occupant cannot be relocated.
• C.  None of the SYSAUX occupants can be relocated.
• D.  The SYSAUX occupants can be relocated to the SYSTEMtablespace only.

Consider the following configuration:
/devices/D1 is a member of disk group dgroupA. /devices/D2 is a member of disk group dgroupA. /devices/D3 is a member of disk group dgroupA.
You plan to add a new disk, /devices/D4, to the disk group dgroupA and execute the following command:
SQL> ALTER DISKGROUP dgroupA ADD DISK '/devices/D*';
Which task would be accomplished by the command?

• A.  The command would result in an error because no wildcard characters can be used in the disk name.
• B.  The command first detaches all the member disks starting with "D" and then reattaches all of them including the new disk.
• C.  The command adds the new disk, D4, to the disk group.
• D.  The command will be ignored because disks starting with "D" are already members of the disk group.
• E.  The command would result in an error because there is no disk by the name "/devices/D*".

CORRECT TEXT
View the Exhibit and examine the sparsely populated EMP table segment.
You execute the following SQL command: ALTER TABLE emp SHRINK SPACE;
Identify how the data in the segment will be reorganized as a result of the above statement.

• A.  Option
• B.  Option
• C.  Option
• D.  Option