Category «1z0-042»

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 …

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 …

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 …

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 …

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 …