Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 161:

  You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?

  A. The collection level for the AWR should be set to BASIC.
  B. The moving window size must be less than Undo Retention.
  C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
  D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.
  D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.

• Question 162:

  Observe the following warning in an RMAN session of your database instance:

  WARNING: new failures were found since last LIST FAILURE command

  Which statement describes the scenario that must have produced this warning?

  A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
  B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR).
  C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE
  D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE command was executed.
  C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository (ADR) since the last LIST FAILURE

• Question 163:

  You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?

  A. The tuned plan is not added to the SQL plan baseline.
  B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.
  C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.
  D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.
  C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

• Question 164:

  You executed the following PL/SQL block successfully:

  VARIABLE tname VARCHAR2(20)

  BEGIN

  dbms_addm.insert_finding_directive (NULL, DIR_NAME=>'Detail CPU Usage1, FINDING_NAME=>'CPU Usage1,

  MIN_ACTIVE_SESSIONS=>0,MIN_PERC_IMPACT=>90);

  :tname := 'database ADDM task4';

  dbms_addm.analyze_db(:tname, 150,162);

  END;

  /

  Then you executed the following command:

  SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL; The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis____.

  A. with the CPU Usage finding if it is less than 90
  B. without the CPU Usage finding if it is less than 90
  C. with the CPU Usage finding for snapshots below 90
  D. with the CPU Usage finding for snapshots not between 150 and 162
  B. without the CPU Usage finding if it is less than 90

• Question 165:

  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.
  D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

• Question 166:

  You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?

  A. Enable Flashback Data Archive for the tables.
  B. Enable supplemental logging for the database.
  C. Specify undo retention guarantee for the database.
  D. Create Flashback Data Archive on the tablespace on which the tables are stored.
  E. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.
  A. Enable Flashback Data Archive for the tables.

• Question 167:

  You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

  A. the SQL text
  B. the execution plan
  C. the execution context Do- the execution frequency
  D. the system change number (SCN)
  A. the SQL text
  C. the execution context Do- the execution frequency
  D. the system change number (SCN)

• Question 168:

  You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?

  A. It is a list of remote database links stored in the XML file that are available to the users of the database.
  B. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
  C. It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
  D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
  B. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

• Question 169:

  Evaluate the following command:

  SQL> CREATE TABLE design_data (id NUMBER,

  doc CLOB)

  LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);

  Which statement is true regarding the above command?

  A. The LOB values are automatically compressed.
  B. The LOB values are cached by default in the buffer cache.
  C. The LOB values are automatically stored in encrypted mode.
  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

• Question 170:

  You opened the encryption wallet and then Issued the following command:

  SQL>CREATE TABLESPACE securespace DATAFILE '/home/user/oradata/secureOI .dbf SIZE 150M ENCRYPTION USING '3DES1681 DEFAULT STORAGE(ENCRYPT);

  Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.

  What is the outcome?

  A. It creates the table and encrypts the data in it.
  B. It generates an error because the wallet is closed
  C. It creates the table but does not encrypt the data in it.
  D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
  B. It generates an error because the wallet is closed