Online Access Free 1Z0-050 Practice Test

What are the advantages of variable extent size support for large ASM files? (Choose two.)

• A.Fewer extent pointers are needed to describe the file and less memory is required to
  manage the extent maps in the shared pool.
• B.It improves performance in the extended cluster configuration by reading from a local copy of an extent.
• C.It improves resync operations when the disk comes online after being taken offline for maintenance purposes.
• D.This feature enables faster file opens because of the reduction in the amount of memory that is required to store file extents.

Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?

• A.Local and global indexes are maintained automatically during the operation.
• B.It does not require additional storage because the operation is done online.
• C.It can be done at the table level or partition level.
• D.It cannot be done in parallel.

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A.Automatic undo management must be enabled.
• B.Database must be running in archivelog mode.
• C.Undo retention guarantee must be enabled.
• D.The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

• A.Cursor cache
• B.Stored outline
• C.SQL Tuning Set
• D.Automatic Workload Repository (AWR) snapshots

Evaluate the following block of code
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(
acl => lmycompany-com-permissions.xmll1
principal => 'ACCTJvlGR1,
is_grant => TRUE,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(
acl => 'mycompany-com-permissions.xml',
host => ".mycompany.com');
END;
What is the outcome of the above code?

• A.It produces an error because a fully qualified host name needs to be specified.
• B.It produces an error because the range of ports associated with the hosts has not been specified.
• C.It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
• D.It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges