Proper study guides for Refresh Oracle Oracle Database 11g: Administration II certified begins with Oracle 1Z0-053 preparation products which designed to deliver the Validated 1Z0-053 questions by making you pass the 1Z0-053 test at your first time. Try the free 1Z0-053 demo right now.
2021 Jul oracle 1z0-053 exam dumps:
Q101. Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?
A. It returns space usage of only BasicFile LOB chunks.
B. It returns space usage of only SecureFile LOB chunks.
C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
Answer: B
Q102. The DB_BLOCK_CHECKING initialization parameter is set to OFF.
Which block checking would be performed?
A. The Oracle database will perform block checking for the index blocks only
B. The Oracle database will not perform block checking for any of the data blocks
C. The Oracle database will perform block checking for the default permanent tablespace only
D. The Oracle database will perform block checking for the data blocks in all user tablespaces
E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
Answer: E
Q103. Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
Answer: BC
Q104. Evaluate the following block of code:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (
acl => 'mycompany-com-permissions.xml',
principal => 'ACCT_MGR',
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 and RESOLVE privileges.
D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
Answer: C
Q105. Choose the correct order to package and upload data for an incident to Oracle Support.
A. Schedule, create new package, view manifest, view contents
B. Create new package, view manifest, view contents, schedule
C. Schedule, create new package, view contents, view manifest
D. Create new package, view contents, view manifest, schedule
E. None of the above.
Answer: D
Update ocp exam 1z0-053 dumps:
Q106. Which statements are true regarding the Query Result Cache? (Choose all that apply.)
A. It can be set at the system, session, or table level.
B. It is used only across statements in the same session.
C. It can store the results from normal as well as flashback queries.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
Answer: AC
Q107. Which type of backup must be performed first with an incremental backup?
A. Level 1
B. Level 0
C. Level 2
D. Level 3
Answer: B
Q108. Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.
Which tool or utility would you use to start the listener?
A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant
Answer: B
Q109. You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''
Which statement regarding the above command is correct?
A. It will create the tablespace TEMP1 in group G1.
B. It will create the tablespace TEMP1 in group G3.
C. It will not add the tablespace TEMP1 to any group.
D. It will create the tablespace TEMP1 in the default group.
Answer: C
Q110. You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?
A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE.
B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent to the PGA.
C. The database instance starts, but Automatic Memory Management is disabled.
D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.
Answer: B