Welcome to download the newest Examwind S10-300 dumps:
Good News! With Oracle 1Z0-050 exam dumps, you will never worry about your Oracle 1Z0-050 exam, all the questions and answers are updated timely by our experts.Also now Flydumps.com is offering free Oracle 1Z0-050 exam VCE player and PDF files for free on their website.
QUESTION 67
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
A. Only a single partitioning key column can be specified.
B. All DML statements must use partition-extended syntax.
C. The same physical attributes must be specified for each partition.
D. Unique local indexes cannot be created on a system-partitioned table.
E. Traditional partition pruning and partitionwise joins are not supported on these tables.
Correct Answer: DE
QUESTION 68
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 plan history.
B. The optimizer selects the new plan for the execution of the SQL statement.
C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
Correct Answer: AE
QUESTION 69
Which two statements about Oracle Direct Network File System (NFS) are true? (Choose two.)
A. It bypasses the OS file system cache
B. A separate NFS interface is required for use across Linux, UNIX, and Windows platforms.
C. It uses the operating system kernel NFS layer for user tasks and network communication modules.
D. File systems need not be mounted by the kernel NFS system when being served through Direct NFS.
E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver.
Correct Answer: AD
QUESTION 70
You are managing an Oracle Database 11 g instance with ASM storage. You lost an ASM disk group
DATA. You have RMAN backup of data as well as ASM metadata backup.
You want to re-create the missing disk group by using the ASMCMD md_restore command. Which of
these methods would you use to achieve this? (Choose all that apply.)
A. Restore metadata in an existing disk group by passing the existing disk group name as an input parameter.
B. Restore the disk group with changed disk group specification, failure group specification, disk group name, and other disk attributes.
C. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, and failure group configurations.
D. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations, and data on the disk group.
Correct Answer: ABC QUESTION 71
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. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.
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. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
Correct Answer: DE QUESTION 72
In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.
You issued the following command:
SQL>SELECT /*+ RESULT_CACHE 7 sale_categoiy, sum(sale_amt) FROM sales
GROUP BY sale_categoiy;
Where would the result of this query be stored?
A. PGA
B. large pool
C. shared pool
D. database buffer cache
Correct Answer: C QUESTION 73
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco1 1/password@catdb RMAN> IMPORT CATALOG rcat1 0/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)
A. They deregister all databases registered in the RCAT10 catalog.
B. They import metadata for all registered databases in the RCAT10 database.
C. They register all the RCATIO-catalog registered databases in the RC011 catalog.
D. They overwrite all stored scripts in the RC011 catalog with the same name as that in the RCAT10 catalog.
Correct Answer: ABC
QUESTION 74
Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans can be manually loaded to the SQL plan baseline.
B. The plans in the SQL plan baseline are verified and accepted plans.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
Correct Answer: ABE
QUESTION 75
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.
Correct Answer: C
QUESTION 76
Which three statements correctly describe the features of the I/O calibration process? (Choose three.)
A. Only one I/O calibration process can run at a time
B. It automates the resource allocation for the Automated Maintenance Tasks.
C. It improves the performance of the performance-critical sessions while running.
D. It can be used to estimate the maximum number of l/Os and maximum latency time for the system.
E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
Correct Answer: ADE
QUESTION 77
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.
Correct Answer: CE
QUESTION 78
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:
ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?
A. It produces an error because data already exists in the table.
B. It produces an error because compression can be enabled at table creation only.
C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
Correct Answer: C
QUESTION 79
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
A. flashback query
B. distributed transactions
C. logging in and logging out of sessions
D. all DDL statements having bind variables
E. direct path load of data from external files
Correct Answer: CD
QUESTION 80
Which two statements are true regarding the SQL Repair Advisor? (Choose two.)
A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
Correct Answer: BD
QUESTION 81
Which setting enables the baselines by default in Oracle Database 11g?
A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
Correct Answer: A
QUESTION 82
Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)
A. Diagnose and repair a data file corruption offline.
B. Diagnose and repair a data file corruption online.
C. Diagnose and repair failures on a standby database.
D. Recover from failures in the Real Application Cluster (RAC) environment.
Correct Answer: CD
QUESTION 83
In which cases is reference partitioning effective in enhancing performance?
A. It is effective only in partition pruning.
B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
Correct Answer: D
QUESTION 84
Your database initialization parameter file has the following entry:
SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?
A. It is enforced only if the password profile is enabled for the user.
B. It locks the user account after the specified number of attempts.
C. It drops the connection after the specified number of login attempts fail for any user.
D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.
Correct Answer: C
QUESTION 85
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?
A. The database must be running in ARCHIVELOG mode.
B. No special setup is required, and the feature is enabled by default.
C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11 g software, provide valid MetaLink credentials and select license agreement.
Correct Answer: E
QUESTION 86
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)
A. Health Monitor checks are always initiated manually when there is some critical error.
B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
Correct Answer: BD
QUESTION 87
a
Oracle 1Z0-050 study materials is a product you can trust for timely, prompt and successful preparation of IT Certifications. Once you go through the Pass4itSure Microsoft certification exam Oracle 1Z0-050 study materials thoroughly, it’s guaranteed that you will pass your Oracle 1Z0-050 exam at the first shot. The Pass4itSure Oracle 1Z0-050 study materials have designed and prepared the training kit for Oracle 1Z0-050 test. It’s designed to be relevant in today’s rapidly changing IT marketplace, Oracle 1Z0-050 study materials help you utilize evolving technologies, Oracle 1Z0-050 study materials you’re troubleshooting skills, and improve your job satisfaction.
Welcome to download the newest Examwind S10-300 dumps: http://www.examwind.com/S10-300.html