Exam Oracle-1z0-050
1.Observe the following PL/SQL block:
BEGIN
dbms_spm.configure(’SPACE_BUDGET_PERCENT’, 30);
END;
Which statement is correct regarding the above PL/SQL block?
A: It reserves 30% of the space in the SYSTEM tablespace for SMB.
B: It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
C: It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.
D: It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.
Correct Answers:? C
2.While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?
A: It updates the existing SQL profiles with current statistics.
B: It makes the statistics information available to GATHER_STATS_JOB.
C: It initiates the statistics collection process by running GATHER_STATS_JOB.
D: It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
Correct Answers:? B
3.Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)
A:It detects changes in SQL execution plans.
B:It produces results that can be used to create the SQL plan baseline.
C:The importance of SQL statements is based on the size of the objects accessed.
D:It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E:It shows only the overall impact on workload and not the net SQL impact on workload.
Correct Answers:? A, B, D
4.You want to take the backup of the USERS tablespace. It has a single data file of 900 MB.. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)
A:The backup piece size will be limited to 300 MB.
B:The operation is accomplished using the default channel available.
C:The RMAN parallelizes the backup although the parallelism is not set for a channel.
D:Three channels for the tape drive must be configured by setting the parallelism to three.
Correct Answers:? A, B
5.You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)
A:It stores only the temporary table but not its indexes.
B:It stores both the temporary table as well as its indexes.
C:It must be a nondefault temporary tablespace for the database.
D:It can be a default or nondefault temporary tablespace for the database.
E:It must be the default temporary tablespace of the user who issues the command.
Correct Answers:? B, D
