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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which three are true about Database Point-in-Time Recovery? (Choose three.)
A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery
B. Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery
C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
D. The Database must be in ARCHIVELOG mode
E. The target point for the recovery must bespecified as a stime or System Change Number (SCN)
F. The database must be open RESETLOGS after Database Point-in-Time Recovery
عرض الإجابة
اجابة صحيحة: BDF
السؤال #2
Which three are true about opatchauto? (Choose three.)
A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process
B. It must be invoked by a user with root user privileges
C. Patches are appliedvia opatchauto
D. Users must always input patch plans to opatchauto
E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked
F. It applies patches in nonrolling mode by default
عرض الإجابة
اجابة صحيحة: AEF
السؤال #3
Which two are true about gathering optimizer statistics? (Choose two.)
A. Executing DBMS_STATS
B. Executing DBMS_STATS
C. Executing DBMS_STATS
D. System statistics can be gathered only while connected to CDB$ROOT
E. Executing DBMS_STATS
عرض الإجابة
اجابة صحيحة: BE
السؤال #4
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB
B. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB
C. A new PDB is automatically created when importing a non-CDB into a CDB
D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB
E. Moving data from a PDB to anon-CDB is only possible by using transportable tablespace export and import
F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import
عرض الإجابة
اجابة صحيحة: DE
السؤال #5
Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)
A. using Database Replay
B. using SQL Developer
C. using Oracle Data Pump
D. using operating system file copy utilities
E. using Database Upgrade Assistant
F. using the CREATE TABLE AS SELECT SQLstatement
عرض الإجابة
اجابة صحيحة: ABE
السؤال #6
Examine these actions: * 1. Create a new database for a recovery catalog. * 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. * 3.Configure ARCHIVELOG mode for the catalog database. * 4. Create a user to own the recovery catalog schema with quota on the tablespace that will containthe catalog. * 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. * 6.Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minim
A. 2, 4, 5, 6
B. 1, 2, 3, 4, 5, 6
C. 1, 2, 4, 5
D. 2, 4, 5
E. 1, 3, 4, 5
عرض الإجابة
اجابة صحيحة: DE
السؤال #7
Which three are true in Oracle 19c and later releases? (Choose three.)
A. If the password file location changes, then the new location is used automatically by the Oracle Server
B. Schema Only accounts can be granted administrator privileges
C. All the Oracle-supplied accounts are Schema Only accounts
D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault
E. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user
F. Unified Auditing can be configured to audit only events that are issued directly by an audited user
عرض الإجابة
اجابة صحيحة: BDE
السؤال #8
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces
B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB
C. SPFILEbackups can be created while connected to an application root PDB
D. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB
E. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT
عرض الإجابة
اجابة صحيحة: DEF
السؤال #9
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size byreducing the Shared Pool size
B. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size
C. Automatically tuned and resized System Global Area components will always revertto their initial sizes after an instance restart
D. Automatic Memory Management must be used together with locking the System Global Area into physical memory
E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size
F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems
عرض الإجابة
اجابة صحيحة: BEF
السؤال #10
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
A. All metrics are instance related
B. Cleared statefulalerts are displayed by querying DBA_ALERT_HISTORY
C. A space usage management alert is automatically cleared after the underlying problem is resolved
D. They are generated by SMON when a tablespace is 97% full
E. Metrics are statistical counts for aspecific unit
F. STATISTICS_LEVEL must be set to ALL to generate alerts
عرض الإجابة
اجابة صحيحة: ABF

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

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

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

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


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