Online Access Free 1Z0-045 Practice Test

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 command:
ALTER DISKGROUP tdgroupA
ADD ALIAS '+tdgroupA/data/datafile.dbf'
FOR '+tdgroupA.231.45678';
Which task would be accomplished by the command?

• A.The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA.231.45678 file.
• B.The command creates a copy of the +tdgroupA.231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
• C.The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
• D.The command creates a file, datafile.dbf, in +tdgroupA/data and removes the references for +tdgroupA.231.45678 from the data dictionary views.
• E.The command drops the file +tdgroupA.231.45678.

What is the Character Set Scanner?

• A.a package (DBMS_CSS) that searches the database for invalid strings
• B.a separate program that searches for strings that require Unicode conversion if you want to support multiple languages
• C.a separate program that identifies character data loss if you change the character sets of the database
• D.a separate program that searches the database for invalid strings

Which two statements are true regarding the use of UTF-16 encoding? (Choose two.)

• A.Asian characters are represented in three characters
• B.enables easier loading of multinational data
• C.uses a fixed-widthmultibyte encoding sequence
• D.European characters are represented in one or two bytes
• E.uses a variable-widthmultibyte encoding sequence

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 -Sstartmydb.sql
• B.sqlplus -S @startmydb.sql
• C.sqlplus /NOLOG @startmydb.sql
• D.sqlplus @startmydb.sql

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 -Sstartmydb.sql
• B.sqlplus -S @startmydb.sql
• C.sqlplus /NOLOG @startmydb.sql
• D.sqlplus @startmydb.sql