What could be the two reasons for the elimination of the other rows in the output?

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERT view. After 30 minutes, you executed the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts;REASON METRIC_VALUE—————————— ———————-Tablespace [TEST] is [28 perce 28.125nt] full What could be the two reasons for the elimination of the other rows in the output? (Choose two.) A.The threshold alerts are transferred to […]

Read More

Which statement is true about the Tablespace Full alert?

View the Exhibit, and examine the alert messages. You added space to the TEST tablespace to bring the space usage below the threshold value.Which statement is true about the Tablespace Full alert? A.The alert is automatically cleared and sent to the alert history. B.The alert is cleared and transferred to the alert log file. C.The […]

Read More

Which option corresponds to the type of activities performed by you?

While planning to manage more than one database in your system, you perform the followingactivities:1. Organize different categories of files into independent subdirectories.2. Use consistent naming convention for database files.3. Separate administrative information pertaining to each database.Which option corresponds to the type of activities performed by you? A.Oracle Managed Files B.Oracle database architecture C.Optimal Flexible […]

Read More

Which method would you suggest to the bank for achieving this task?

The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in abank. As part of the year-end tax and interest calculation process, all the rows in the table need tobe accessed. The bank authorities want to track access to the rows containing balance amountsexceeding $200,000, and then send an alert message to […]

Read More

What would be your next step to find out recommendations about statistics collection and restructuring of the

You received complaints about the degradation of SQL query performance. You identified top SQLqueries that consume time. What would be your next step to find out recommendations aboutstatistics collection and restructuring of the SQL statement to improve query performance? A.run Segment Advisor B.run the Automatic Workload Repository (AWR) report C.run the Automatic Database Diagnostic Monitor […]

Read More

Which statement is correct in this scenario?

You are working on a database created with the Oracle Database 10g software in which theinitialization parameter COMPATIBLE is set to 10.0.0. The hr_tbs tablespace in the database iscreated as follows:CREATE TABLESPACE hr_tbs DATAFILE ‘/oracle/oradata/hr_tbs.dbf’ SIZE 50M;View the Exhibit to see the properties of the database.Which statement is correct in this scenario? A.All the tablespaces […]

Read More

Which two options can be the solutions to avoid such errors in future?

A user receives the following error while executing a query:ORA-01555: snapshot too oldWhich two options can be the solutions to avoid such errors in future? (Choose two.) A.increase the size of the Database Buffer Cache B.increase the size of the default temporary tablespace C.increase the size of redo log files D.increase the size of the […]

Read More

What are the consequences of executing the SHUTDOWN ABORT command?

What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.) A.The database files are synchronized. B.The database is closed, but the instance is still started. C.The database undergoes automatic media recovery during the next startup. D.Database buffers and redo buffers are not written to the disk. E.Uncommitted changes are not rolled back. Show […]

Read More