1Z0-053 | All About Actual 1Z0-053 braindumps
Q231. Evaluate the following SQL statement used to create the PRODUCTS table:
CREATE TABLE products
(product_id NUMBER(3) PRIMARY KEY,
product_desc VARCHAR2(25),
qty NUMBER(8,2),
rate NUMBER(10,2),
total_value AS ( qty * rate))
PARTITION BY RANGE (total_value)
(PARTITION p1 VALUES LESS THAN (100000),
PARTITION p2 VALUES LESS THAN (150000),
PARTITION p3 VALUES LESS THAN (MAXVALUE))
COMPRESS FOR ALL OPERATIONS;
Which statement is true regarding this command?
A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
Answer: D
Q232. What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)
A. selection of SQL plan baselines
B. partitioning of tables and indexes
C. creation of index-organized tables
D. creation of bitmap, function-based, and B-tree indexes
E. optimization of materialized views for maximum query usage and fast refresh
Answer: BDE
Q233. You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.
Which two statements are true about this backup operation? (Choose two.)
A. Backup compression should be enabled
B. Parallelism for the channel should be set to 2
C. All the files must be backed up as backup sets
D. The backup may be stored either on disk or on media with media manager
Answer: CD
Q234. What command would you issue to enable automated backups of control files?
A. alter database controlfile autobackup on
B. alter system controlfile autobackup on
C. configure controlfile autobackup on
D. enable controlfile autobackup
Answer: C
Q235. What methods are available to recover lost control files? (Choose all that apply.)
A. Backup control file.
B. Emergency control file.
C. The create controlfile command.
D. The restore controlfile SQL*Plus command.
E. No backup is required. The database will re-create the control file when it is discovered to be lost.
Answer: CD
Q236. Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)
A. until time
B. until change
C. until sequence
D. until SCN
E. until commit
Answer: ACD
Q237. What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag='gold_copy' plus archivelog
tag='gold_copy' delete input;
Backup database tag='silver_copy' plus archivelog
tag='silver_copy' delete input;
A. Attempting to restore silver_copy will fail.
B. Attempting to restore gold_copy will fail.
C. Both backups will be available for restore without question.
D. Attempting to restore gold_copy may or may not succeed.
E. You will not be able to restore either gold_copy or silver_copy.
Answer: D
Q238. Which background process coordinates the rebalance activity for disk groups?
A. ORBn
B. OSMB
C. RBAL
D. ASMn
Answer: C
Q239. What does the minimize load database parameter mean when backing up a database?
A. RMAN will attempt to make the backup run as fast as possible without any IO limitations.
B. RMAN will automatically restrict the number of channels in use to one.
C. RMAN will spread the backup IO over the total duration stated in the backup command.
D. RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.
E. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.
Answer: C
Q240. The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.
View the Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
Exhibit:
A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.
Answer: AD