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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN
A. Only 1
B. Only 2
C. Only 3
D. 3 and 1
E. 1 and 2
عرض الإجابة
اجابة صحيحة: B
السؤال #2
Which two actions does an incremental checkpoint perform? (Choose two.)
A. It signals CKPT to write the checkpoint position to the data file headers
B. It writes the checkpoint position to the data file headers
C. It advances the checkpoint position in the checkpoint queue
D. It writes the checkpoint position to the control file
عرض الإجابة
اجابة صحيحة: AC
السؤال #3
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows: SQL> INSERT INTO cust VALUES(101, 'JACK'); 1 row created. SQL> INSERT INTO cust VALUES(102, 'SMITH'); 1 row created. As a DBA, you execute the following command from another session: ALTER TABLESPACE sales READ ONLY; Which statement is true regarding the effect of this command on the transaction in Scott's session?
A. The command fails as a transaction is still pending
B. The transaction in Scott's session is rolled back and the tablespace becomes readonly
C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction
D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode
عرض الإجابة
اجابة صحيحة: D
السؤال #4
A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN. You lost all control files due to media failure. Given the steps to recover from the error in random order: 1. Shut down the instance, if it is not already down. 2. Restore the control file from autobackup to a new location. 3. Start the database instance to NOMOUNT state. 4. Recover the database to the point
A. 1, 3, 2, 6, 7, 4, 5
B. 1, 3, 7, 2, 6, 4, 5
C. 1, 3, 2, 4, 5
D. 1, 2, 6, 4, 5
E. 1, 6, 2, 4, 5
عرض الإجابة
اجابة صحيحة: AE
السؤال #5
Which two are prerequisites for performing a flashback transaction? (Choose two.)
A. Flashback Database must be enabled
B. Undo retention guarantee for the database must be configured
C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction
D. Supplemental logging must be enabled
E. Recycle bin must be enabled for the database
F. Block change tracking must be enabled tor the database
عرض الإجابة
اجابة صحيحة: BDE
السؤال #6
The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that: HR then opens a second session. Which two operations wait when executed in HR’s second session? (Choose two.)
A. LOCK TABLE employees IN EXCLUSIVE MODE;
B. INSERT INTO employees(empno,ename) VALUES (1289, ‘Dick’);
C. SELECT job FROM employees WHERE job=’CLERK’ FOR UPDATE OF empno;
D. SELECT empno,ename FROM employees WHERE job=’CLERK’;
E. INSERT INTO employees(empno,ename,job) VALUES (2001,’Harry’,’CLERK);
عرض الإجابة
اجابة صحيحة: DE
السؤال #7
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
A. All AWR tables belong to the SYSTEM schema
B. The AWR data is stored in memory and in the database
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views
E. AWR contains system wide tracing and logging information
عرض الإجابة
اجابة صحيحة: BE
السؤال #8
Your database instance has started using an SPFILE. Examine the RMAN configuration settings: You execute the command: RMAN> BACKUP AS COPY TABLESPACE TEST; Which three types of files are backed up by using this command? (Choose three.)
A. online redo log files
B. control file
C. SPFILE
D. archived redo log files
E. data file(s)
F. PFILE
عرض الإجابة
اجابة صحيحة: ABE

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

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

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

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


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