1Z0-045 무료 덤프문제 온라인 액세스

You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?

• A.It will create thetablespace TEMP1 in the default group.
• B.It will create thetablespace TEMP1 in group G1.
• C.It will throw an error with message 'specified group is not available'.
• D.It will create a new group with a system-generated name and add thetablespace TEMP1 to it.
• E.It will create thetablespace TEMP1 in group G3.
• F.It will not add thetablespace TEMP1 to any group.

Examine this startup script called startmydb.sql:
CONNECT myid/mypwd AS SYSDBA STARTUP EXIT
In Oracle8i, you could have executed this script by invoking Server Manager with the command:
svrmgrl @startmydb.sql
Which alternative command could you use to run the startmydb.sql script with SQL*Plus to start your Oracle 10g database?

• A.sqlplus @startmydb.sql
• B.sqlplus -Sstartmydb.sql
• C.sqlplus -S @startmydb.sql
• D.sqlplus /NOLOG @startmydb.sql

What are three benefits provided by the enhanced Unicode support? (Choose three.)

• A.Unicode support in the database character set
• B.support for fixed-width character encoding
• C.richer support for more character sets, languages, and territories
• D.support for the AL24UTFFSS character set

The Oracle 10g LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)

• A.information in the control file
• B.a Data Dictionary copy stored in an operating system flat file
• C.the current online data dictionary
• D.a Data Dictionary copy stored in the redo log file
• E.separate supplemental log file
• F.redo information stored within the redo vectors of the DML operation

What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?

• A.DBA_ROLLBACK_SEGS
• B.DBA_UNDO_EXTENTS
• C.V$ROLLSTAT
• D.V$TRANSACTION
• E.V$UNDOSTAT