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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. Examine the list of possible steps required to perform the task: 1.Create a PDB named emp_pdb1. 2.Export the hr_pdb1 PDB by using the full clause. 3.Open the emp_pdb1 PDB. 4. Mount the emp_pdb1 PDB. 5. Synchronize the emp_pdb1 PDB in restricted mode. 6.Copy the dump file to the Data Pump directory. 7.Create a Data Pump directory in the emp_pdb1 PDB. 8
A. 2, 1, 3, 7, 6, and 8
B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
C. 2, 1, 3, 7, 6, 9, and 8
D. 2, 1, 3, 5, 7, 6, and 8
عرض الإجابة
اجابة صحيحة: C
السؤال #2
For which three pieces of information can you use the RMAN list command?
A. stored scripts in the recovery catalog
B. available archived redo log files
C. backup sets and image copies that are obsolete
D. backups of tablespaces
E. backups that are marked obsolete according to the current retention policy
عرض الإجابة
اجابة صحيحة: ABD
السؤال #3
Which two statements are true when row-archival management is enabled?
A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter
B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active
C. The row archival visibility session parameter defaults to all rows
D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query
E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active
عرض الإجابة
اجابة صحيحة: BC
السؤال #4
The following parameters are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLV
A. 2, 4, 5
B. 2, 1, 4, 3, 5
C. 1, 2, 3, 4, 5
D. 1, 2, 4, 5
عرض الإجابة
اجابة صحيحة: ABE
السؤال #5
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
A. when the duplicate
B. when you perform active database duplication on a database with flashback disabled
C. when you specify set encryption before the duplicate
D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
E. when you perform active database duplication on a database that has read-only tablespaces
عرض الإجابة
اجابة صحيحة: A
السؤال #6
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
A. Tables or table partitions can be recovered by using an auxiliary instance only
B. Tables or table partitions with a foreign key cannot be recovered
C. Tables or table partitions can be recovered only when the database is in mount state
D. Tables or table partitions from the system and sysauxtablespaces cannot be recovered
E. Tables with not null constraints cannot be recovere
عرض الإجابة
اجابة صحيحة: ACD
السؤال #7
In which three scenarios is media recovery required?
A. when a tablespace is accidentally dropped from a database
B. when archived redo log files are lost
C. when data files are lost
D. when one of the online redo log members is corrupted
E. when all control files are lost
عرض الإجابة
اجابة صحيحة: AD
السؤال #8
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps: 1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS(‘SH’, 'CUSTOMERS')from dual statement. 2. Execute the dbms_stats.seed_col_usage (null,‘SH’,500) procedure. 3.Execute the required queries on the customers table. 4.Issue the select dbms_stats.reportwcol_usage(‘SH’, 'customers') from dual statement. Identify the correct sequence of ste
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
عرض الإجابة
اجابة صحيحة: BD
السؤال #9
Examine the initialization parameter that is set in the PFILE: DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/' You execute the following command to create theCDB1. container database (CDB): SQL>CREATE DATABASE CDB1 DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE undotbsl ENABLE PLUGGABLE DATABASE SEED SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYS AUX DATAFILES SIZE 100M; Which three statements are true?
A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively
B. The files created for both the root and seed databases use Oracle Managed Files (OMF)
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted
D. It sets the users tablespace as the default for both the root and seed databases
E. undotbs1 is used as the undo tablespace for both the root and seed databases
F. It creates a multitenant container database with the root database opened and the seed database mounted
عرض الإجابة
اجابة صحيحة: B
السؤال #10
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?
A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
B. Setting the target tablespace to read-only after the segments are moved
C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS percent used
D. Taking the target tablespace offline after the segments are moved
E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
عرض الإجابة
اجابة صحيحة: D
السؤال #11
Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2 While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used. What happens at the next log switch?
A. The database instance hangs and the redo log files are not overwritten
B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available
C. The database instance is shutdown immediately
D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success
عرض الإجابة
اجابة صحيحة: B

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

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

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

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


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