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

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 are types of segments in an Oracle Database? (Choose three.)

• A.undo
• B.index
• C.stored procedures
• D.sequences
• E.tables
• F.clusters

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

• A.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
• B.Partition key columns cannot be dropped.
• C.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
• D.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
• E.A column that is set to UNUSED still counts towards the limit of 1000 columns per table
• F.A DROP COLUMN command can be rolled back

Comment: *

Name: *

Email: *

Verification: *