Oracle 1Z0-050 問題集

質問 1：
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?
A. Compute the baseline statistics.
B. Decrease the window size for the baseline.
C. Decrease the expiration time for the baseline.
D. Take an immediate AWR snapshot.
正解：A

質問 2：
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It is created by default with the window size being equal to the AWR retention time.
B. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
C. It does not allow you to change the moving window size,
D. Adaptive threshold functionalities use it by default to compute statistics.
正解：A,D

質問 3：
Examine the following PL/SQL block:
DECLARE
my_plans plsjnteger;
BEGIN
My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =>
?9twu5t2dn5xd?;
END;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
A. It is not loaded with the ACCEPTED status.
B. It is loaded with the ACCEPTED status.
C. It is not loaded with the ENABLED status.
D. It is loaded with the FIXED status.
正解：B

質問 4：
Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
A. It can be used to backup all data on ASM disks.
B. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
C. It can be used to re-create the ASM disk group with its attributes.
D. It can be used to recover the damaged ASM disk group along with the data.
正解：B,C

質問 5：
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(lsh\ 'customers^be1, '(countryjd, 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 histogram to hold skewed information about the data in the columns.
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
D. It creates a virtual hidden column in the CUSTOMERSjDBE table.
正解：D

質問 6：
Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)
A. SQL Access Advisor
B. Segment Advisor
C. Optimizer statistics gathering
D. Automatic SQL Tuning Advisor
E. Automatic Database Diagnostics Monitor
正解：B,C,D

質問 7：
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)
A. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
B. Use Data Pump to transfer the existing data to a new encrypted tablespace.
C. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.
D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.
正解：A,B,C

質問 8：
In which two aspects does hot patching differ from conventional patching? (Choose two.)
A. It consumes more memory compared with conventional patching.
B. It does not require down time to apply or remove unlike conventional patching.
C. It can be installed and uninstalled via OPatch unlike conventional patching.
D. It takes more time to install or uninstall compared with conventional patching.
E. It is not persistent across instance startup and shutdown unlike conventional patching.
正解：A,B