1Z0-417 Free Practice Test

Which four use cases could Database Replay be used to test for database performance changes?

1. A. a change in operating system versions
2. B. compare Flashback workload
3. C. check a workload from a single instance on an Oracle RAC database
4. D. check a workload after database parameters have been changed
5. E. check a workload from one database release on another database released
6. F. upgrade an application

Correct Answer: BCDE

Which two would automatically create an entry inV$SQL_MONITOR?

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

Correct Answer: CF
Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_monit.htm#TGSQL789

When planning Oracle Database Architecture, which option can be used to reduce the number of Oracle processes waiting in the Operating System run queue and to ensure that database CPU load is healthy?

1. A. Exadata
2. B. Oracle Job Scheduler
3. C. DATABASE_MAXCPUS=YES
4. D. Oracle Database Resource Manager
5. E. DB_RAC_MAXCPU=YES
6. F. Oracle Grid Control

Correct Answer: D
Reference: http://www.oracle.com/technetwork/database/performance/resource-manager- twp-133705.pdf

When managing multiple database instances on a single server, which initialization parameter limits the number of CPU's that an instance can use simultaneously?

1. A. CPU_NUM
2. B. NUM_CPU
3. C. MAX_CPU
4. D. LIMIT_CPU
5. E. CPU_COUNT

Correct Answer: E
Reference: http://docs.oracle.com/html/E25494_01/dbrm008.htm

Which is a true statement about the difference in the functionality of Active Session History (ASH) and SQL Trace/TKPROF?

1. A. ASH provides time based data, SQL Trace/TKPROF does not
2. B. ASH provides detailed session level data, SQL Trace/TKPROF does not
3. C. ASH is always on, SQL Trace/TKPROF is not
4. D. ASH identifies Bind variables that are available, SQL Trace/TKPROF does not
5. E. ASH counts and has occurrence data, SQL Trace/TKPROF does not

Correct Answer: B