السؤال #1

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria

B. Oracle DBCA templates can store only logical structure and not database files

C. New templates can only be created by modifying an existing user-created template

D. The Data Warehouse template is most suitable when transaction response time is the key criterion

E. Oracle DBCAtemplates can be used to create new databases and duplicate existing databases

عرض الإجابة

اجابة صحيحة: A

السؤال #2

Which two are trueabout changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT

B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT

C. After the change, only one undo tablespace can exist in CDB$ROOT

D. After the change, any user with the required privilege can create an undo tablespace in the PDBs

E. Undo tablespaces existing in PDBs must be dropped before the change

F. After the change, each existing PDB has to be reopened for the new undo mode to take effect

عرض الإجابة

اجابة صحيحة: BC

السؤال #3

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck. Which three are true about diagnosing and tuning these problems? (Choose three.)

A. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then both read and write I/O are likely bottlenecks

B. Setting DBWR_IO_SLAVES to a non zero value can improve backup performance when using synchronous I/O

C. If an RMAN BACKUP VALIDATE command takes noticeably less than an actual backup, then write I/O is a likely bottleneck

D. If an RMAN BACKUP VALIDATE command takes roughly the same time as an actual backup, then read I/O is a likely bottleneck

E. Data files with a high value in V$BACKUP_SYNC_IO

F. Setting DBWR_IO_SLAVESto a non zero value can improve backup performance when usingasynchronous I/O/ G

عرض الإجابة

اجابة صحيحة: DFG

السؤال #4

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: * 1. Install the SALES_APP application, including the commontables, in the application root. * 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. * 3. Create an application seed. * 4. Install the SALES_APP application in the application seed. * 5. Create the SALES_APP1 and SALES_APP2 a

A. 3,4,1,6,8

B. 1,5,6

C. 1,3,5,6,7

D. 1,3,5,7

E. 2,5,6

عرض الإجابة

اجابة صحيحة: FG

السؤال #5

Which two are true about automatic block repair? (Choose two.)

A. Automatic block repair can repair blocks with no standby database if DB_BLOCK_CHECKING = TRUE

B. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database

C. Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases

D. It is not possible for media corrupt blocks

E. Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database

عرض الإجابة

اجابة صحيحة: BDE

السؤال #6

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A. It can berun only manually

B. It is part of the DBMS_ADVISOR package

C. It can recommend changes to improve the statistics gathering process

D. It always analyzes all schemas in the database

E. It runs automatically every night by default

F. It is part of theDBMS_STATS package

عرض الإجابة

اجابة صحيحة: DEF

السؤال #7

Examine this configuration: * 1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. * 2.ORCL uses disk group +FRAfor the Fast Recovery Area. * 3. LISTENER is the listener for ORCL. * 4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart. 5.All components are currently shut down. You execute this command: What is the outcome?

A. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENERare started

B. Only the ORCL database instance is started

C. Only the ORCL database and the ASM instances are started

D. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started

E. Only the ORCL database instance and the +DATA and +FRA disk groups are started

عرض الإجابة

اجابة صحيحة: ABD

السؤال #8

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time

B. FLASHBACK drop requires thatthe RECYCLEBIN parameter be set to ON

C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON

D. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked

E. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time

F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between twopoints in time

عرض الإجابة

اجابة صحيحة: BEFH

السؤال #9

You are managing this configuration: CDB1is a container database. PDB1andPDB2are two pluggable databases inCDB1. USER1.EMPis a table inPDB1andUSER2.DEPTis a table inPDB2. CDB1userSYSexecutes these commands after connecting successfully toPDB2: Which two are true? (Choose two.)

A. The inserts on USER1

B. The inserts on USER1

C. The insert on USER2

D. The insert on USER2

E. The inserts on USER1

F. The insert on USER2

عرض الإجابة

اجابة صحيحة: DEF

عرض الإجابات بعد التقديم

يرجى إرسال البريد الإلكتروني الخاص بك والواتس اب للحصول على إجابات الأسئلة.

ملحوظة: يرجى التأكد من صلاحية معرف البريد الإلكتروني وWhatsApp حتى تتمكن من الحصول على نتائج الاختبار الصحيحة.

بريد إلكتروني:

رقم الواتس اب/الهاتف:

لا تريد أن تفوت شيئا؟

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان

عرض الإجابات بعد التقديم

لا تريد أن تفوت شيئا؟

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع! احصل الان

عرض الإجابات بعد التقديم

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان