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

نصائح اجتياز امتحان الشهادة

آخر أخبار الامتحانات ومعلومات الخصم

برعاية وحديثة من قبل خبرائنا

نعم، أرسل لي النشرة الإخبارية

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M; Which statement is true?
A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B. It succeeds only if memory is available from the autotuned components if SG
C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
عرض الإجابة
اجابة صحيحة: ABD
السؤال #2
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?
A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs
B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root
C. The command will, create a common user whose description is contained in the root and each PD
D. The schema for the common user C # # A_ADMIN can be different in each container
E. The command will create a user in the root container only because the container clause is not use
عرض الإجابة
اجابة صحيحة: D
السؤال #3
You execute the following PL/SQL: Which two statements are true?
A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accesse
B. FGA is enabled for the PRODUCTS
C. FGA is enabled for all DML operations by JIM on the PRODUCTS
D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial
عرض الإجابة
اجابة صحيحة: AD
السؤال #4
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?
A. Decreasing PCTUSED
B. Decreasing PCTFREE
C. Increasing the number of DBWN process
D. Using Automatic Segment Space Management (ASSM)
E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation
عرض الإجابة
اجابة صحيحة: CE
السؤال #5
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp. A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1: ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ ORA-27037: unable to obtain file status Identify two ways to rectify the error.
A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error
B. Shut down the database instance, restore the temp01
C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online
D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS
E. Shut down the database instance and then restart the CDB and PDBs
عرض الإجابة
اجابة صحيحة: B

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

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

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

بريد إلكتروني:
رقم الواتس اب/الهاتف:


Copyright © 2024. Designer by SPOTO Official Website. All Rights Reserved.