Online Access Free 1z1-417 Exam Questions

Which two would automatically create an entry inV$SQL_MONITOR?

• A.any SQL statement run
• B.a statement that consumes at least 1 second of CPU or I/O time.
• C.any DML statement
• D.any DDL statement
• E.a parallelized SQL statement
• F.a statement that consumes at least 5 second of CPU or I/O time.

Which issue can be avoided by configuring the PCTFREE parameter?

• A.sort operations on disk
• B.table fragmentation, and has been superseded by Automatic Storage Management
• C.column fragmentation
• D.row chaining and setting it has been superseded by Automatic Segment Space Management
• E.keeping a reserve area for backup

Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

• A.A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer has SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.
• B.A customer says that he or she doesn't use Enterprise Manager, but you learn that the customer routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.
• C.A customer says that he or she doesn't use theEnterprise Manager, but you learn that the customer usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.
• D.A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set toDIAGNOSTIC +TUNING.
• E.The customer has Enterprise Manager installed on a separate server and regularly accesses the Databasehome page of some of its Enterprise Edition databases from its console.

Identify four problems automatically diagnosed by Automatic Database Diagnostics Monitor (ADDM).

• A.Mean Time to recover (MTTR) setting
• B.log buffer sizing
• C.Less Time to recover (LTTR) setting
• D.log file problematic naming
• E.oversized SGA or PGA
• F.undersized SGA or PGA
• G.log file sizing

When planning an Oracle Database architecture, which are three caching functionalities that would improve application response time and speed up query processing?

• A.Database Smart Flash Cache
• B.Oracle In-Memory DBSTATS Cache
• C.Result Cache
• D.Mega Cache
• E.Oracle In-Memory Database Cache