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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which three statements are true about using flashback database in a multitenant container database (CDB)? (Choose three.)
A. The root container can be flashed back without flashing back the pluggable databases (PDBs)
B. To enable flashback database, the CDB must be mounted
C. Individual PDBs can be flashed back without flashing back the entire CDB
D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB
E. ACDB can be flashed back specifying the desired target point in time or an SCN, but not a restore poin
عرض الإجابة
اجابة صحيحة: ACD
السؤال #2
Which three statements are true about the purpose of checkpoints? (Choose three.)
A. They ensure that uncommitted transactions are rolled back in case of an instance failure
B. They ensure that all the dirty buffers are written to disk during a normal shutdown
C. They ensure that instance recovery starts in the event of an instance failure
D. They ensure that dirty buffers in the buffer cache are written to disk regularly
E. They reduce the time required for recovery in case of an instance failur
عرض الإجابة
اجابة صحيحة: B
السؤال #3
Which are two ways for a database service to be recognized by a listener in Oracle Database 12c? (Choose two.)
A. Dynamic Registration by the LREG process
B. Dynamic Registration by the SMON process
C. Static registration in the listener
D. Dynamic Registration by the PMON process
E. Static registration in the listener
عرض الإجابة
اجابة صحيحة: AE
السؤال #4
Which two statements are true about variable extent size support for large ASM files? (Choose two.)
A. The metadata used to track extents in SGA is reduced
B. Rebalance operations are completed faster than with a fixed extent size
C. An ASM Instance automatically allocates an appropriate extent size
D. Resync operations are completed faster when a disk comes online after being taken offline
E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent
عرض الإجابة
اجابة صحيحة: ABD
السؤال #5
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)
A. A segment cannot span data files
B. A data file can belong to only one tablespace
C. An extent cannot span data files
D. The size of an Oracle data block in a data file should be the same as the size of an OS block
عرض الإجابة
اجابة صحيحة: AC
السؤال #6
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 SELECT DBMS_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.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence
A. 3, 2, 1, 4
B. 2, 3, 4, 1
C. 4, 1, 3, 2
D. 3, 2, 4, 1
عرض الإجابة
اجابة صحيحة: A
السؤال #7
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A. The ADDM requires at least four AWR snapshots for analysis
B. The ADDM runs after each AWR snapshot is collected automatically by MMON
C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
D. The ADDM analysis provides only diagnostics information but does not provide recommendations
E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
عرض الإجابة
اجابة صحيحة: C
السؤال #8
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
A. It utilizes the OS file system cache
B. A traditional NFS mount is not required when using Direct NFS
C. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver
D. Direct NFS is available only in UNIX platforms
E. Direct NFS can load-balance I/O traffic across multiple network adapters
عرض الإجابة
اجابة صحيحة: AC
السؤال #9
Which statement is true about unified auditing?
A. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace
B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS
C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE
D. The unified audit trail contains audit records only from unified audit policies and AUDIT settings
عرض الإجابة
اجابة صحيحة: A
السؤال #10
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?
A. It executes successfully and creates an UNDO tablespace in HR_PDB
B. It falls and reports an error because there can be only one undo tablespace in a CDB
C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command
D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command
E. It executes successfully but neither tablespace nor the data file is created
عرض الإجابة
اجابة صحيحة: ADE
السؤال #11
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.
A. Missing or stale histogram statistics
B. Undersized shared pool
C. High clustering factor for the indexes
D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
E. Oversized buffer cache
عرض الإجابة
اجابة صحيحة: C
السؤال #12
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)
A. Thread creation must be routed through a dispatcher process
B. The local listener may spawn a now process and have that new process create a thread
C. Each Oracle process runs an SCMN thread
D. Each multithreaded Oracle process has an SCMN thread
E. The local listener may pass the request to an existing process which in turn will create a threa
عرض الإجابة
اجابة صحيحة: AB
السؤال #13
You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For which database users and for which executions is the audit policy now active? Select two.
A. SYS, SYSTEM
B. SCOTT
C. Only for successful executions
D. Only for failed executions
E. Both successful and failed executions
عرض الإجابة
اجابة صحيحة: BC
السؤال #14
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script: SQL > @utlrp.sql Which two actions does the script perform? (Choose two.)
A. Parallel compilation of only the stored PL/SQL code
B. Sequential recompilation of only the stored PL/SQL code
C. Parallel recompilation of any stored PL/SQL code
D. Sequential recompilation of any stored PL/SQL code
E. Parallel recompilation of Java code
F. Sequential recompilation of Java code
عرض الإجابة
اجابة صحيحة: BC
السؤال #15
Which three factors influence the optimizer's choice of an execution plan? (Choose three.)
A. the optimizer_mode initialization parameter
B. operating system (OS) statistics
C. cardinality estimates
D. object statistics in the data dictionary
E. fixed baselines
عرض الإجابة
اجابة صحيحة: BC
السؤال #16
Examine the parameters for a database instance: Which two statements are true? (Choose two.)
A. Undo records for temporary tables are stored in a temporary tablespace
B. Undo records for temporary tables are stored in the undo tablespace and logged in the redo
C. Undo records for temporary tables are stored in the undo tablespace and logged in the redo only for those sessions where temporary undo is enabled
D. No redo is generated for the undo records belonging to temporary tables
E. No redo and undo records are generated for temporary table
عرض الإجابة
اجابة صحيحة: CE

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

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

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

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


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