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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)
A. You can detach from a data pump export job and reattach later
B. Data pump uses parallel execution server processes to implement parallel import
C. Data pump import requires the import file to be in a directory owned by the oracle owner
D. The master table is the last object to be exported by the data pump
E. You can detach from a data pump import job and reattach later
عرض الإجابة
اجابة صحيحة: CE
السؤال #2
The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance. You execute the following command to create a table: Which two statements are true? (Choose two.)
A. The table is created without a segment because the storage clause is missing
B. A segment is allocated when the first row is inserted in the table
C. A segment is allocated when an index is created for any column in the table
D. The table is created and extents are immediately allocated as per the default storage defined for its tablespace
E. A segment is allocated for the table if the ALTER TABLE… ALLOCATE EXTENT command is issue
عرض الإجابة
اجابة صحيحة: D
السؤال #3
Which two statements are true about the logical storage structure of an Oracle database? (Choose two.)
A. An extent contains data blocks that are always physically contiguous on disk
B. An extent can span multiple segments
C. Each data block always corresponds to one operating system block
D. It is possible to have tablespaces of different block sizes
E. A data block is the smallest unit of I/O in data files
عرض الإجابة
اجابة صحيحة: ADE
السؤال #4
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Exe
A. 6, 5, 4, 7
B. 10, 1, 2, 5, 8
C. 10, 1, 2, 5, 4, 9, 8
D. 10, 1, 5, 8, 10
عرض الإجابة
اجابة صحيحة: B
السؤال #5
Which statement is true about Oracle Net Listener?
A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections
B. A single listener can service only one database instance and multiple remote client connections
C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance
D. The listener
E. The listener
عرض الإجابة
اجابة صحيحة: B
السؤال #6
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?
A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started
B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started
C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration
D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration
عرض الإجابة
اجابة صحيحة: BCD
السؤال #7
You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PDBs) 3. Shuts down the CDB instance 4. Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script? (Choose two.)
A. The seed will be in mount state
B. The seed will be opened read-only
C. The seed will be opened read/write
D. The other PDBs will be in mount state
E. The other PDBs will be opened read-only
F. The PDBs will be opened read/write
عرض الإجابة
اجابة صحيحة: A
السؤال #8
Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output? (Choose three.)
A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only
B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker
C. The C # # A_ADMIN user can perform wallet operations
D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM)
E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus
عرض الإجابة
اجابة صحيحة: BC
السؤال #9
Which three statements are true about Flashback Database? (Choose three.)
A. Flashback logs are written sequentially, and are archived
B. Flashback Database uses a restored control file to recover a database
C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area
D. Flashback Database can recover a database to the state that it was in before a reset logs operation
E. Flashback Database can recover a data file that was dropped during the span of time of the flashback
F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time
عرض الإجابة
اجابة صحيحة: AB
السؤال #10
Which three statements are true about automated maintenance tasks? (Choose three.)
A. They run at predefined time intervals that are intended to occur during a period of low system load
B. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window
C. A maintenance window is automatically extended until all the maintenance tasks defined are completed
D. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks
E. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor
عرض الإجابة
اجابة صحيحة: B

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

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

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

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


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