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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which four actions are possible during an Online Data file Move operation? (Choose four.)
A. Creating and dropping tables in the data file being moved
B. Performing file shrink of the data file being moved
C. Querying tables in the data file being moved
D. Performing Block Media Recovery for a data block in the data file being moved
E. Flashing back the database
F. Executing DML statements on objects stored in the data file being moved
عرض الإجابة
اجابة صحيحة: B
السؤال #2
You want to schedule a job to rebuild a table’s indexes after a bulk insert, which must be scheduled as soon as a file containing data arrives on the system. What would you do to accomplish this?
A. Create a file watcher and an event-based job for bulk insert and then create another job to rebuild indexes on the table
B. Create a file watcher for the bulk inserts and then create a job to rebuild indexes
C. Create a job array and add a job for bulk insert and a job to rebuild indexes to the job array
D. Create an event-based job for the file arrival event, then create a job for bulk insert, and then create a job to rebuild indexes
عرض الإجابة
اجابة صحيحة: AEG
السؤال #3
You ran this command on a source database: $> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept On the target database, you run this command: $> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLES=emp_dept Which two statements are true? (Choose two.)
A. The expdp operation exports all rows for tables contained in the defining query of the EMP_DEPT view
B. The impdp operation creates separate tables for each table contained in the defining query of the EMP_DEPT view
C. The expdp operation exports all rows that are displayed when querying the EMP_DEPT view with no filter
D. The impdp operation creates EMP_DEPT as a table
E. The expdp operation exports the table definitions for tables that are queried in the EMP_DEPT view
F. The impdp operation creates EMP_DEPT as a view
عرض الإجابة
اجابة صحيحة: BC
السؤال #4
To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G What is the result when you start up the database instance?
A. It results in an error because these parameter settings are invalid
B. One 64G flash cache file will be used
C. Two 64G flash cache files will be used
D. Two 32G flash cache files will be use
عرض الإجابة
اجابة صحيحة: B
السؤال #5
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 SGA
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
عرض الإجابة
اجابة صحيحة: D
السؤال #6
Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)
A. It records checkpoint information in the control file
B. It frees unused temporary segments
C. It kills sessions that exceed idle time
D. It registers database services with all local and remote listeners known to the database instance
E. It frees resources held by abnormally terminated processes
عرض الإجابة
اجابة صحيحة: D
السؤال #7
You executed the following command to create a password file in the database server: $ orapwd file = orapworcl entries = 5 ignorecase=N Which statement describes the purpose of the above password file?
A. It records usernames and passwords of users when granted the DBA role
B. It contains usernames and passwords of users for whom auditing is enabled
C. It is used by Oracle to authenticate users for remote database administrator
D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
عرض الإجابة
اجابة صحيحة: B

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

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

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

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


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