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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which three are true about the SQL Tuning Advisor? (Choose three.)
A. It checks each query being analyzed for stale statistics
B. It checks each query being analyzed for missing statistics
C. It only recommends syntactic changes to SQL statements
D. It can recommend semantic changes to SQL statements
E. It considers all SQLstatements being analyzed by the advisor task as a group
F. It builds SQL profiles for each poorly performing SQL statement to prevent regressions
عرض الإجابة
اجابة صحيحة: C
السؤال #2
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)
A. A PDB snapshot is always a full copy of the source PDB
B. A PDB snapshot is always a sparse copy of the source PDB
C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems
D. A PDB snapshot depends on a storage snapshot which can be stored on any file system
E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems
F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system
عرض الإجابة
اجابة صحيحة: ACF
السؤال #3
Which two are true about the character sets used in an Oracle database? (Choose two.)
A. Single-byte character sets provide betterperformance than multibyte character sets
B. Unicode enables information from any language to be stored using a single character set
C. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA)
D. Single-byte character sets always use 7-bit encoding schemes
E. Multibyte character sets allow more efficient space utilization than single byte character sets
F. Single-byte character sets always use 8-bit encoding schemes
عرض الإجابة
اجابة صحيحة: AE
السؤال #4
Which four are true about RMAN backup sets? (Choose four.)
A. A backup piece can belong to only one backup set
B. A data file can be split into multiple sections stored in different backup sets
C. A data file canbe split into multiple sections stored in different backup pieces in the same backup set
D. Blocks from multiple data files can be contained in one backup piece,
E. A backup set can contain only one backup piece
F. A backup set must be written to media
عرض الإجابة
اجابة صحيحة: AB
السؤال #5
A database is configured in ARCHIVELOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)
A. when any archived log from, before, or after the most recent backup is corrupt
B. after losing all copies of the control file
C. after losing an archived log from after the most recent backup
D. after losing an archived log from before the most recent backup
E. after losing the SYSTEM tablespace
عرض الإجابة
اجابة صحيحة: DE
السؤال #6
Examine this output: Which two are true? (Choose two.)
A. Any PDB not specified in the plan will be unable to execute statementsin parallel
B. PDB3 can use all available parallel execution processes at times
C. PDB1 is always limited to 40% of the available system resources regardless of demand
D. Any PDB not specified in the plan will be able to use a maximum of 16
E. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand
F. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand
عرض الإجابة
اجابة صحيحة: CD
السؤال #7
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1. You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT. Which two are always true? (Choose two.)
A. CDB1 and CDB2 must be in shared undo mode
B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege
C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts
D. Cloning HR_ROOT automatically clones HR_PDB1
E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends
عرض الإجابة
اجابة صحيحة: BCE
السؤال #8
Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)
A. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter
B. Addonly the CREATE_FILE_DEST clause to the statement
C. Set only the PDB_FILE_NAME_CONVERT parameter
D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF
E. Enable only OMF
F. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)
عرض الإجابة
اجابة صحيحة: AEFH
السؤال #9
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
A. It recompiles all stored PL/SQL code by using utlrp
B. It empties the RECYCLE BIN
C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade
D. It sets all user tablespaces to “read-only” before starting theupgrade
E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
F. It increases tablespace size, if required, to meet upgrade requirements
عرض الإجابة
اجابة صحيحة: AE

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

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

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

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


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