A script abc.sql must be executed to perform a job.
A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql
What will happen upon execution?

• A.The command fails because the script must refer to the full path name
• B.The command succeeds and HR will be connected to the orcl and abc.sql databases
• C.The command fails and reports an error because @ is used twice
• D.The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

• A.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• B.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers
• C.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• D.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• E.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

• A.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B.SYSDATE can be queried only from the DUAL table
• C.CURRENT_DATE returns the current date and time as per the session time zone
• D.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.The extents of a segment must always reside in the same datafile
• B.Segments can span multiple tablespsaces
• C.A segment can span multiple data files in some tablespaces
• D.A smallfile tablespace might be bigger than a bigfile tablespace
• E.A segment's blocks can be of different sizes
• F.A segment might have only one extent
• G.All tablespaces may have one or more data files

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• B.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• C.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• D.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• E.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• F.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.

Comment: *

Name: *

Email: *

Verification: *