1Z1-050 by Oracle Actual Free Exam Q&As

Question 1

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state. B. The optimizer selects the new plan for the execution of the SQL statement. C. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost. D. The optimizer adds the new plan to the SQL plan baseline as an accepted plan. E. The optimizer adds the new plan to the plan history.

Discussion 0

Correct Answer: C,E Vote an answer

Question 2

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)
SQL>STARTUP UPGRADE

A. It enables all system triggers. B. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run. C. It ensures that all job queues remain active during the upgrade process. D. It allows only SYSDBA connections.

Discussion 0

Correct Answer: B,D Vote an answer

Question 3

You are in the process of creating a virtual private catalog in your Oracle Database 11 g database. The PROD1 , PROD and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who own the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11 g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1; Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?

A. They produce an error because you need to connect to the target database to execute this packaged procedure. B. They produce an error because PROD1 and PROD2 databases belong to the older version. C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure. D. They execute and create a virtual catalog for pre-Oracle 11 g clients.

Discussion 0

Correct Answer: D Vote an answer

Question 4

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

What is the reason for this error?

A. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command. B. There are new failures recorded in the Automatic Diagnostic Repository (ADR). C. The failure ID has not been mentioned in the command for data file 5. D. Another repair session is running concurrently.

Discussion 0

Correct Answer: D Vote an answer

Question 5

To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN
dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,lTASK1l);
END;
/
BEGIN
dbms_advisor.set_task_parameter(lTASK1l,lANALYSIS_SCOPElllALLl);
dbms_advisor.set_task_parameter(lTASK1,,,MODE,llCOMPREHENSIVEl);
END;
/
BEGIN
dbms_advisor.execute_task('TASK1');
dbms_output.put_line(dbms_advisor.get_task_script('TASK11));
END;
/
The blocks of code execute successfully; however, you do not get the required outcome.
What could be the reason?

A. A template needs to be associated with the task. B. The partial or complete workload scope needs to be associated with the task. C. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task. D. A workload needs to be associated with the task.

Discussion 0

Correct Answer: D Vote an answer

Question 6

Evaluate the following command and Its output:
SQL>SELECT * FROM dba_temp_free_space;
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
LMTEMP 250609664 101048576 149561088
Which two statements correctly interpret the output? (Choose two.)

A. FREE_SPACE indicates only the space that is currently unallocated. B. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated. C. FREE_SPACE indicates only the space that is currently allocated and available for reuse. D. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse. E. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.

Discussion 0

Correct Answer: B,D Vote an answer

Question 7

You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)

A. The execution plan and execution statistics are computed for each SQL statement in the STS. B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics. C. Every SQL statement in the STS is considered only once for execution. D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS .GATHER_TABLE_STATS('SHI ,'SALES1 ,GRANUU\RITY=>'GLOBALl);
You need statistics to be collected more quickly. What can you do to achieve this?

A. Set the INCREMENTAL value to TRUE for the partition table. B. Increase the value of STALE_PERCENT for the partition table. C. Set DYNAMIC_SAMPLING to level 4. D. Set the STATISTICS_LEVEL parameter to BASIC.

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which statement describes the effect of table redefinition on the triggers attached to the table?

A. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table. B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table ' C. All triggers on the table remain valid. D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.

Discussion 0

Correct Answer: B Vote an answer

Question 10

You need to create a partitioned table to store historical data and you Issued the following command:
CREATE TABLE purchas_interval
PARTITION BY RANGE (time_id)
INTERVAL (NUMTOYMINTERVAL(1 ,'month1)) STORE IN (tbs1 ,tbs2,tbs3)
PARTITION p1 VALUES LESS THAN(TO_DATE('1-1-2005I, 'dd-mm-yyyy')),
PARTITION p2 VALUES LESS THAN(TO_DATE('1-1-2007', 'dd-mm-yyyy')))
AS
SELECT *
FROM purchases
WHERE time_id < TO_DATE('1-1-2007'l'dd-mm-yyyy');
What is the outcome of the above command?

A. It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of |_| one month each B. It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions. C. It returns an error because the number of tablespaces (TBS1 ,TBS2,TBS3)specified does not match the number of range partitions (P1 ,P2) specified. D. It returns an error because the range partitions P1 and P2 should be of the same range.

Discussion 0

Correct Answer: A Vote an answer

Question 11

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

A. The plans in the SQL plan baseline are verified and accepted plans. B. The plan baselines are stored temporarily in the memory as long as the database instance is running. C. The plans generated for every SQL statement are stored in the SQL plan baseline by default. D. The plans can be manually loaded to the SQL plan baseline. E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 12

Following is the list of locations in random order where oranfstab can be placed.
1 ./etc/mtab 2 .$ORACLE_HOME/dbs/oranfstab 3 ./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?

A. 2,3, 1 B. 1,2,3 C. 3,2, 1 D. 1,3,2

Discussion 0

Correct Answer: A Vote an answer

Question 13

Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)

A. changing the database storage to ASM-managed storage B. database and operating system upgrades C. multiplexing of the control file D. adding the redo log member to the database

Discussion 0

Correct Answer: A,B Vote an answer

Question 14

Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

A. SQL statements based on the AWR top SQL identification B. SQL statements that are part of the available SQL Tuning Set (STS) only C. SQL statements that are available in the cursor cache and executed by a user other than SYS D. SQL statements that are part of the AWR baseline only

Discussion 0

Correct Answer: A Vote an answer

Oracle Database 11g: New Features for Administrators - 1Z1-050 Exam Practice Test