1Z0-054 Exam Questions

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the datab...

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the datab...

You are a DBA in ABC Corp. You are working on an online transaction processing (OLTP) system.The applications running on the database use connection pooling to connect to the datab...

View the Exhibit and examine the output for the WRC command-line utility that you executed to estimate the number of replay clients.Identify three prerequisites for completing the...

Examine the output of the following query: SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps, 2 a.immediate_gets,a.immediate_misses,b.pid 3 FROM v$latch a, v$latchholder b, v$latc...

Examine the output of the following query: SQL> SELECT c.name,a.addr,a.gets,a.misses,a.sleeps, 2 a.immediate_gets,a.immediate_misses,b.pid 3 FROM v$latch a, v$latchholder b, v$latc...

Examine the output of the query given below: SQL> SELECT mutex_type, location, sum(gets), sum(sleeps) FROM v$mutex_sleep_history GROUP BY mutex_type, location; MUTEX_TYPE LOCATION...

Examine the query output shown below: SQL> SELECT sum(pins), sum(reloads), sum(reloads)/sum(pins) FROM v$librarycache; SUM(PINS) SUM(RELOADS) SUM(RELOADS)/SUM(PINS) ---------- ----...

You work as a DBA for a company and manage an online transaction processing (OLTP) system. You received complaints about the performance degradation of SQL statements executed by t...

You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic W...

You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic W...

You work as a DBA for a company and you have the responsibility of managing one of its online transaction processing (OLTP) systems. The database encountered performance-related pr...

You work on an online transaction processing (OLTP) database in which the SALES table has 10,000 rows but only four distinct products are sold. View the Exhibit named HIST to check...

You work on an online transaction processing (OLTP) database in which the SALES table has 10,000 rows but only four distinct products are sold. View the Exhibit named HIST to check...

You are working for a company that uses huge applications to manage its customer details. During your regular performance checks, you executed the following query: SQL> show parame...

You work for a company as a DBA. The company has an application to manage the details of its business and customer base. However, application users complain that updating the SALES...

You work for a small manufacturing company as a DBA. The company has various applications to manage the details of its business and customer base. The company has only one sales ou...

You work as a DBA for a company and as a performance improvement measure, you implemented the result cache in your database. Many users in the company say that performance has impr...

In which case is the database buffer cache NOT used?

Which two statements are true about the database buffer cache? (Choose two.)

You work as a DBA for a company and as a performance improvement measure, you implemented the result cache in your database. View the Exhibit named SETTING and note the result cach...

You work as a DBA and you have the responsibility of managing a large online transaction processing (OLTP) system. You used the following query during the performance tuning activi...

You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used the following query during the performance tuning activity:...

You work as a DBA and have the responsibility of managing a large online transaction processing (OLTP) system. You used three queries to check the database performance as shown in...

Examine the following information from the AWR report: Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Call Time -------------------------------------- ---------...

Which two symptoms related to the database buffer cache together indicate that there are many full table scans happening? (Choose two.)

What indicates that the rate of writing data blocks to the disk is very slow?

You work as a database administrator to manage an online transaction processing (OLTP) system.The application code was recently tuned for optimum performance and users acknowledged...

You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS...

You are working on an online transaction processing (OLTP) system. You are investigating the reasons for performance degradation in the database. View the Exhibit named TOP5EVENTS...

You observed very low cache-hit ratio in your database as shown below: SQL> SELECT (1-((phy.value-phyd.value) / (cur.value + con.value))) * 100 2 "Cache Hit ratio" 3 FROM v$sysstat...

You are working in an online transaction processing (OLTP) environment. You received many complaints from users about degraded performance. Your senior DBA asked you to execute the...

View the Exhibit and analyze the content of V$BUFFER_POOL_STATISTICS. Why does the query on the EMP table not access buffers from the keep pool?

You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events: Average Event Total Seconds Total Wait Name Waits Waiting Ti...

You queried V$SYSTEM_EVENT in your online transaction processing (OLTP) environment to check the following wait events: Event Total Seconds Total Average Wait Name Waits Waiting Ti...

The users in your online transaction processing (OLTP) environment complain that the query response time has increased considerably. On investigation, you find that the Program Glo...

View the Exhibit and examine the content of the V$PGA_TARGET_ADVICE_HISTOGRAM view. What would you infer from this?

The users in your online transaction processing (OLTP) environment complain that the query response time has increased considerably. You checked the Program Global Area (PGA)- rela...

The users in your online transaction processing (OLTP) environment complain that the response time of the application has increased dramatically.To investigate the problem, view th...

You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their applicat...

You work in an online transaction processing (OLTP) environment and users are experiencing slow response time on their queries. These users connect as FINANCE to run their applicat...

View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE are not matching with the TABLESPACE_SIZE value. What would you conclude from this?

View the Exhibit and examine the content. ALLOCATED_SPACE and FREE_SPACE indicate that a large amount of space is allocated to the temporary tablespace that is being used.Which act...

Examine the output of the following query: SQL> SELECT tablespace_name, tablespace_size, allocated_space, free_space 2 FROM DBA_TEMP_FREE_SPACE; TABLESPACE_NAME TABLESPACE_SIZE ALL...

You are working on a database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as...

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view. The Shared Pool was shrunk when the Default Buffer Cache required more memory. Why did the Java Pool not shri...

View the Exhibit and examine the content of the V$SGA_RESIZE_OPS view. You executed the following command to increase the size of the Large Pool: SQL> ALTER SYSTEM SET large_pool_s...

You are hired by ABC Pvt Ltd., and assigned the task of managing one of its development databases. The company has recently upgraded this database to Oracle Database 11g from Oracl...

You work for ABC Pvt Ltd. The company has recently upgraded one of its development databases to Oracle Database 11g from Oracle Database 10g. You noticed that the System Global Are...

View the Exhibit and analyze the output of a query executed on the V$MEMORY_RESIZE_OPS view. Why do INITIAL_SIZE, TARGET_SIZE, and FINAL_SIZE columns have the value zero for some o...