Category «1Z0-045»

What would you do?

You have the following requirements with respect to optimizer statistics:The statistics should be generated automatically during weekdays (Monday to Friday)between 10:00 p.m. and 7:00 a.m. The objects that need updated statistics the most shouldbe processed first. What would you do? A.Modify the AUTO_TASKS_JOB_CLASS Scheduler class. B.Use the DBMS_STATS.GATHER_DATABASE_STATS procedure with the GATHER AUTO option. C.Not …

Which two statements are correct regarding the mytbs tablespace?

You are working on a database that was created using Oracle Database 10g; the defaulttablespace type property was not changed. You execute the following statement to create atablespace, mytbs:CREATE TABLESPACE mytbs DATAFILE ‘/u1/data/mytbs.dbf’ SIZE 100M;Which two statements are correct regarding the mytbs tablespace? (Choose two.) A.It is asmallfile tablespace. B.It is a locally managedtablespace. C.It …

Which two tasks can you automate while creating the database using the DBCA?

You plan to create a database, PROD, using the Database Configuration Assistant (DBCA).Which two tasks can you automate while creating the database using the DBCA? (Choosetwo.) A.database backups B.user quota increment C.gathering optimizer statistics D.tablespace defragmentation E.data export using conventional export F.data export using Data Pump Show Answer

Which two statements regarding unusable indexes are correct?

Which two statements regarding unusable indexes are correct? (Choose two.) A.You can set SKIP_UNUSABLE_INDEXES to true to skip unusable indexes. B.You do not need to set any parameter because unusable indexes are skipped automatically. C.Your Data Definition Language (DDL) statement shows a warning message when an index is made unusable. D.You can check the alert …

Which two methods can be used to enable a session for resumable space allocation?

You want to execute the following statements in resumable mode:CREATE TABLE … AS SELECTCREATE INDEXCREATE MATERIALIZED VIEWWhich two methods can be used to enable a session for resumable space allocation?(Choose two.) A.Set the RESUMABLE_TIMEOUT initialization parameter to true. B.Set the RESUMABLE_TIMEOUT initialization parameter to a nonzero value. C.Execute the ALTER SESSION ENABLE RESUMABLE statement. D.Execute …