What are three benefits provided by the enhanced Unicode support?

What are three benefits provided by the enhanced Unicode support? (Choose three.) A.support for the AL24UTFFSS character set B.richer support for more character sets, languages, and territories C.support for fixed-width character encoding D.Unicode support in the database character set Explanation: Show Answer

Read More

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 […]

Read More

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 […]

Read More

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

Read More

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 […]

Read More

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 […]

Read More