1Z0-053 | All About Real 1Z0-053 examcollection
Q161. Examine the output of the query that you executed to list the objects in the recycle bin:
You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:
SQL> PURGE TABLE sales_tab;
What would be the outcome of this command?
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
Answer: B
Q162. Examine the CREATE DISKGROUP command used to create a disk group:
SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY
DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2;
In which situation would you use this method of disk group creation?
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks
Answer: C
Q163. Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT.PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?
A. The plan baselines are verified with the SQL profiles.
B. All fixed plan baselines are converted into nonfixed plan baselines.
C. All the nonaccepted SQL profiles are accepted into the plan baseline.
D. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
Answer: D
Q164. What will be the result of the following configuration?
Log_archive_dest_1='location=c:oraclearchmydb'
Log_archive_dest_2='location=z:oraclearchmydb'
A. An error will occur during database startup because the second parameter is not valid.
B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C. Archived redo logs will be created in two different locations by the ARCH process.
D. Archived redo logs will be created in two different locations by the LGWR process.
E. Neither parameter setting is valid, so the database will not start up.
Answer: C
Q165. 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
Q166. While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?
A. RECOVER FILE=1201 BLOCK=1968;
B. RECOVER CORRUPTION LIST;
C. RECOVER DATAFILE 1201 BLOCK 1968;
D. RECOVER BLOCK CORRUPTION LIST;
E. None of the above
Answer: BC
Q167. Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?
A. The data file is checked for physical corruption and backed up if found clean.
B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
Answer: D
Q168. If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?
A. The alter database archivelog command will fail.
B. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.
C. The alter database archivelog command will succeed.
D. The alter database archivelog command will ask if you want to make the database consistent first.
E. There is no alter database archivelog command. The correct command is alter database
alterlogging.
Answer: A
Q169. View the Exhibit.
Examine the following command that is executed for the TRANSPORT table in the SH schema:
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id, cust_state_province)') FROM dual;
Which statement describes the significance of this command?
A. It collects statistics into the pending area in the data dictionary.
B. It creates a virtual hidden column in the CUSTOMERS_OBE table.
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
D. It creates a histogram to hold skewed information about the data in the columns.
Answer: B
Q170. When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?
A. INCLUDING DEPENDENCIES
B. INCLUDING DEPENDENCIES CASCADE
C. COMPACT
D. CASCADE
E. None of the above
Answer: D