Which two statements are true about single row functions? (Choose two.)

• A.TRUNC : can be used to combine any number of values
• B.MOD : returns the quotient of a division operation
• C.CONCAT : can be used to combine any number of values
• D.CEIL : can be used for positive and negative numbers
• E.FLOOR : returns the smallest integer greater than or equal to a specified number

Comment: *

Name: *

Email: *

Verification: *

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

• A.The Oracle background processes are started
• B.The online redo logs are opened
• C.The initialization parameter file is read
• D.The online data files are opened
• E.The control file is read
• F.The alert log records the execution details

Comment: *

Name: *

Email: *

Verification: *

Examine this command:

Which two statements are true? (Choose two.)

• A.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• B.The file is renamed and stored in the same location
• C.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
• D.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• E.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.It terminates
• B.It is paused and can be resumed
• C.You can reattach to it and monitor it
• D.It continues to run in the background
• E.You can no longer monitor it

Comment: *

Name: *

Email: *

Verification: *

You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1. Be stored in a format supporting date arithmetic without using
conversion functions
2. Store a loan period of up to 10 years
3. Be used for calculating interest for the number of days the loan
remains unpaid
Which data type should you use?

• A.INTERVAL YEAR TO MONTH
• B.TIMESTAMP WITH LOCAL TIMEZONE
• C.TIMESTAMP
• D.INTERVAL DAY TO SECOND
• E.TIMESTAMP WITH TIMEZONE

Comment: *

Name: *

Email: *

Verification: *