Which two statements are true about the rules of precedence for operators? (Choose two.)

• A.The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B.NULLS influence the precedence of operators in an expression
• C.The + binary operator has the highest precedence in an expression in a SQL statement
• D.Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E.Multiple parentheses can be used to override the default precedence of operators in an expression

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle recovery and data protection solutions? (Choose two.)

• A.Data Recovery Advisor can be used to validate backup strategies.
• B.Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
• C.RMAN can be used to roll back committed transactions.
• D.Oracle Data Guard can prevent data loss caused by a site failure.
• E.RMAN can be used to FLASHBACK a database.

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 online redo logs are opened
• B.The online data files are opened
• C.The alert log records the execution details
• D.The Oracle background processes are started
• E.The initialization parameter file is read
• F.The control file is read

Comment: *

Name: *

Email: *

Verification: *

You want to apply the principle of Least Privilege in all your live databases.
One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.
Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?
(Choose three.)

• A.analysis of all privileges used by all users including administrative users in the database
• B.analysis of all privileges used by all users but excluding administrative users in the database
• C.analysis of privileges that a user has on their own schema objects that they did not use
• D.analysis of privileges that a user has on their own schema objects that they did use
• E.analysis of privileges granted directly to a role that are then used by a user who has been granted that role
• F.analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *