Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 1:

  You want to perform the following operations for the DATA ASM disk group:

  -Verify the consistency of the disk.

  -Cross-check all the file extent maps and allocation tables for consistency. -Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.

  Which command accomplishes these tasks?

  A. ALTER DISKGROUP data CHECK;
  B. ALTER DISKGROUP data CHECK DISK;
  C. ALTER DISKGROUP data CHECK FILE;
  D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;
  A. ALTER DISKGROUP data CHECK;

• Question 2:

  A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?

  A. It remains valid.
  B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
  C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
  D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.
  A. It remains valid.

• Question 3:

  View the Exhibit to examine the parameter values.

  

  You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?

  A. 90 MB
  B. 272 MB
  C. 362 MB
  D. 1440 MB
  C. 362 MB

• Question 4:

  You are managing an Oracle Database 11 g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

  A. The source database backup must be copied over the net for test database,
  B. The source database must be run in ARCHIVELOG mode if the database is open.
  C. The source database must be shut down cleanly if the database is in mounted state.
  D. A net service name should be set up and a listener configured with the target as well as the source database.
  B. The source database must be run in ARCHIVELOG mode if the database is open.
  C. The source database must be shut down cleanly if the database is in mounted state.
  D. A net service name should be set up and a listener configured with the target as well as the source database.

• Question 5:

  When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

  A. It produces less accurate results of the comparison analysis.
  B. It automatically calls the SQL Tuning Advisor for recommendations.
  C. It shortens the time of execution and reduces the impact on system resources
  D. Only the changes in the execution plan, and not performance regression, are detected.
  A. It produces less accurate results of the comparison analysis.
  C. It shortens the time of execution and reduces the impact on system resources

• Question 6:

  Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

  A. ADR diagnostic files
  B. all the optimizer statistics
  C. initialization parameter settings
  D. PL/SQL functions, procedures, and packages
  E. the table and index definitions and actual data
  B. all the optimizer statistics
  C. initialization parameter settings
  D. PL/SQL functions, procedures, and packages

• Question 7:

  Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

  A. It contains only SQL profiles generated by SQL Tuning Advisor.
  B. It stores plans generated by the optimizer using a stored outline.
  C. It is part of the data dictionary and stored in the SYSAUXtablespace.
  D. It is part of the data dictionary and stored in the SYSTEM tablespace.
  E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
  C. It is part of the data dictionary and stored in the SYSAUXtablespace.
  E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

• Question 8:

  You have applications that have frequently executed queries, and produce small and static result sets. You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter. What is the purpose of this configuration?

  A. to avoid round trips to the server by enabling caching of query results in client memory
  B. to improve performance by storing a copy of the data from the private SQL area of the PGA
  C. to enhance the query performance by creating a cache in the client memory for sorting operations
  D. to avoid the storing of query plans and results in the server by creating a cache in the client memory
  A. to avoid round trips to the server by enabling caching of query results in client memory

• Question 9:

  You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

  A. Create a repeating baseline template.
  B. Insert a finding directive for future ADDM tasks.
  C. Create and populate a SQL Tuning Set from the AWR on every Monday.
  D. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
  A. Create a repeating baseline template.

• Question 10:

  You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)

  A. The KEEP option overrides the configured retention policy.
  B. The KEEP option is an attribute of an individual backup piece.
  C. The backup contains only data files and archived redo log files.
  D. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
  A. The KEEP option overrides the configured retention policy.
  D. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.