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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager (EM) Express?

• A.You can use a single instance of EM Express to manage multiple database running on the same server.
• B.By default, EM express is available for a database after database creation using DBCA.
• C.You can shut down a database instance using EM Express.
• D.You cannot start up a database instance using EM Express.
• E.EM Express uses a separate repository database to store target database metadata.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about segment types in an Oracle Database?

• A.Cluster segments may contain data from multiple tables.
• B.Table segments always have two or more extents.
• C.Index segments always have two or more extents.
• D.Temporary segments are only stored in a temporary tablespace.
• E.Undo segments are only stored in an undo tablespace.

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: *

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A.It must be bigger than the largest SMALLFILE tablespace
• B.It will be a dictionary-managed tablespace by default
• C.It will always have a 32K blocksize
• D.AUTOEXTEND is possible for the datafile
• E.Additional data files may not be added

Comment: *

Name: *

Email: *

Verification: *