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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
You want execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600. Which two statements are true? (Choose two.)
A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block
C. A resumable statement can be suspended and resumed only once during execution
D. A suspended statement will report an error if no corrective action has taken place during a timeout period
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction
عرض الإجابة
اجابة صحيحة: ABD
السؤال #2
On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)
A. Only the ORD_CUSTOMER_IX1 index created
B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table
C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table
D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true
E. Both the indexes are created and used by the optimizer for queries on the ORDERS table
F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table
عرض الإجابة
اجابة صحيحة: ABE
السؤال #3
Identify three situations in which messages are written to the alert log file. (Choose three.)
A. Rebuilding an index using ALTER INDEX
B. Creating a table returns "ORA-00955: name is already in used by an existing object"
C. Inserting a value into a table returns "ORA-01722: invalid number"
D. Updating a record in a table returns "ORA-00060: deadlock detected while waiting for resource"
E. Inserting a value into a table returns "ORA-00001: unique constraint (SYS
F. Running a query on a table returns "ORA-01578: ORACLE data block corrupted (file # 4, block # 131)"
عرض الإجابة
اجابة صحيحة: B
السؤال #4
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command
D. Take the USERDATA tablespace offline in ACCOUNTS_PDB
عرض الإجابة
اجابة صحيحة: AC
السؤال #5
The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis. What is the most efficient way of diagnosing this problem?
A. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM
B. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report
C. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM
D. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations
عرض الإجابة
اجابة صحيحة: C
السؤال #6
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?
A. Automatic Database Diagnostic Monitor (ADDM)
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer
E. Automatic Workload Repository (AWR) report
عرض الإجابة
اجابة صحيحة: AE
السؤال #7
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
A. execution of SQL statements by users connected with the SYSDBA privilege
B. creation of a fine-grained audit policy
C. configuration of unified auditing mode
D. usage of the AUDIT statement
عرض الإجابة
اجابة صحيحة: DE
السؤال #8
Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following: 1. Parallel execution messages and control structures 2. Local variables for a process 3. Security and resource usage information 4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan 5. SQL execution work areas Which option indicates what is allocated from the large pool in this instance?
A. only 1
B. 1, 2, and 5
C. 1, 2, 3, and 5
D. 1, 2, and 4
عرض الإجابة
اجابة صحيحة: AC
السؤال #9
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)
A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace
B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace
C. All the components may be moved into SYSAUX tablespace
D. All the components may be moved from the SYSAUX tablespac
عرض الإجابة
اجابة صحيحة: ACE
السؤال #10
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution
A. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries
B. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries
C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column
D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries
F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries
عرض الإجابة
اجابة صحيحة: B
السؤال #11
Which statement is true regarding the DEFAULT profile?
A. The values assigned to the resource limits and password parameters in the default profile can be altered
B. A different DEFAULT profile can be created before each user in a database
C. It can be dropped and recreated
D. it must be explicitly assigned to the use
عرض الإجابة
اجابة صحيحة: ABC

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

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

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

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


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