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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
When is the UNDO_RETENTION parameter value ignored by a transaction?
A. when there are multiple undo tablespaces available in a database
B. when the data file of the undo tablespace is autoextensible
C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
D. when Flashback Database is enabled
عرض الإجابة
اجابة صحيحة: ADF
السؤال #2
You execute the commands: Which two statements are true? (Choose two.)
A. The create user command fails if any role with the name Sidney exists in the database
B. The user Sidney can connect to the database instance but cannot perform sort operations because no space quota is specified for the temp tablespace
C. The user Sidney is created but cannot connect to the database instance because no profile is default
D. The user Sidney can connect to the database instance but requires relevant privileges to create objects in the users tablespace
E. The user Sidney is created and authenticated by the operating system
عرض الإجابة
اجابة صحيحة: DE
السؤال #3
What is the outcome of the SHUTDOWN ABORT command?
A. Pending transactions are committed and the database is closed
B. Dirty buffers in the buffer cache and unwritten redo are not written to the data files and redo log files respectively
C. Uncommitted transactions are rolled back
D. Instance recovery must be requested by the DBA at the next startup
عرض الإجابة
اجابة صحيحة: AB
السؤال #4
You are using RMAN to back up your database. All the data files are in read/write mode. Examine the RMAN configuration parameters: Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)
A. The backup can be used as an incremental level 0 backup
B. The database instance must be shut down to take the backup
C. The database must be in MOUNT state to take the backup
D. The backup consists of blocks that have been formatted
E. The system Change Number (SCN) is the same for all the data files in the backu
عرض الإجابة
اجابة صحيحة: AE
السؤال #5
A database is open READ WRITE and the instance has multiple sessions some of which have active transactions. You execute this command: SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; Which three are true about the active transactions? (Choose three.)
A. They may issue COMMIT OR ROLLBACK statements
B. They are suspended and unable to issue any statements
C. They may continue to issue DML statements
D. They are rolled back automatically
E. They may continue to issue queries
F. They are terminated immediately
عرض الإجابة
اجابة صحيحة: C
السؤال #6
SMD is a smallfile locally managed tablespace with manual segment space management. The SH user receives the following error while inserting data into the sales table: Which three actions can be taken to enable the user to insert data? (Choose three.)
A. altering the data file associated with the SMD tablespace to grow automatically
B. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file
C. changing segment space management for the SMD tablespace to automatic
D. resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size
E. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size
عرض الإجابة
اجابة صحيحة: AD
السؤال #7
Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)
A. The ability of users to audit their own schema objects is not available in the post-migrated database
B. Operating system audit trail is available in the post-migrated database
C. Network auditing is available in the post-migrated database
D. Mandatory auditing of audit administrative actions is available in the post-migrated database
عرض الإجابة
اجابة صحيحة: E
السؤال #8
Backup requirements for a database: * Level 0 backup on Sunday * Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday * Differential incremental level 1 backup on Tuesday, Thursday, and Friday Which three statements are true about the strategy? (Choose three.)
A. Level 0 backup on Sunday contains all the blocks that have been formatted
B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup
C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup
D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup
E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup
عرض الإجابة
اجابة صحيحة: B
السؤال #9
To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.
A. The PGA_AGGREGATE_TARGET parameter is set to zero
B. The STATISTICS_LEVEL parameter is set to BASIC
C. Both the SGA_TARGET and MEMORY_TARGET parameters are set
D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal
عرض الإجابة
اجابة صحيحة: AD
السؤال #10
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER) BEGIN INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END; / GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king; How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure fro
A. Create the CREATE_TEST procedure with definer’s rights
B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure
C. Create the CREATE_TEST procedure with invoker’s rights
D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package
عرض الإجابة
اجابة صحيحة: AC
السؤال #11
Examine the following ALTER command: SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?
A. It cancels all pending disk drops within the disk group
B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation
C. It mounts disks in the disk group for which the drop-disk operation has already been co pleted
D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
E. It adds previously dropped disks back into the disk group
عرض الإجابة
اجابة صحيحة: AB

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

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

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

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


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