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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?
A. shutting down the database instance that is being upgraded
B. executing the catctl
C. running the Pre-Upgrade Information Tool
D. copying the listener
عرض الإجابة
اجابة صحيحة: AE
السؤال #2
You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions? (Choose two.)
A. Enable supplemental logging for the database
B. Specify undo retention guarantee for the database
C. Create a Flashback Data Archive in the tablespace where the tables are stored
D. Create a Flashback Data Archive in any suitable tablespace
E. Enable Flashback Data Archiving for the tables that require tracking
عرض الإجابة
اجابة صحيحة: BDE
السؤال #3
Which three statements are true about SQL plan directives? (Choose three.)
A. They are tied to a specific statement or SQL ID
B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan
C. They are used to gather only missing statistics
D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect
E. They instruct the optimizer to create only column group statistics
F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespac
عرض الإجابة
اجابة صحيحة: DE
السؤال #4
Your database is open and the listener LISTENER is up. You issue the command: LSNRCTL> RELOAD What is the effect of RELOAD on sessions that were originally established by LISTENER?
A. Only sessions based on static listener registrations are disconnected
B. Existing connections are not disconnected; however, they cannot perform any operations until the listener completes the re-registration of the database instance and service handlers
C. The sessions are not affected and continue to function normally
D. All the sessions are terminated and active transactions are rolled bac
عرض الإجابة
اجابة صحيحة: ABD
السؤال #5
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: Which two statements are true about redefining the table? (Choose two.)
A. All the triggers for the table are disabled without changing any of the column names or column types in the table
B. The primary key constraint on the EMPLOYEES table is disabled during redefinition
C. VPD policies are copied from the original table to the new table during online redefinition
D. You must copy the VPD policies manually from the original table to the new table during online redefinition
عرض الإجابة
اجابة صحيحة: BD
السؤال #6
Examine the query and its output: What might have caused three of the alerts to disappear?
A. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY
B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query
C. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query
D. The database instance was restarted before the execution of the second quer
عرض الإجابة
اجابة صحيحة: BDE
السؤال #7
Which three statements are true concerning the multitenant architecture? (Choose three.)
A. Each pluggable database (PDB) has its own set of background processes
B. A PDB can have a private temp tablespace
C. PDBs can share the sysaux tablespace
D. Log switches occur only at the multitenant container database (CDB) level
E. Different PDBs can have different default block sizes
F. PDBs share a common system tablespace
عرض الإجابة
اجابة صحيحة: D
السؤال #8
You execute the following piece of code with appropriate privileges: User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)
A. Data is redacted for the EMP
B. Data is redacted for EMP
C. Data is never redacted for the EMP_V
D. Data is redacted for the EMP_V
E. Data is redacted for the EMP_V
عرض الإجابة
اجابة صحيحة: D
السؤال #9
Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager Database Express (EM Express)? (Choose two.)
A. A port number for Oracle HTTP Server must be configured
B. The APEX_PUBLIC_USER role must be granted to SYSMAN
C. A SYSMAN user with SYSDBA privilege must be created
D. At least one TCP/IP dispatcher must be configured
E. The Oracle HTTP Server must be installed
عرض الإجابة
اجابة صحيحة: B
السؤال #10
Which two statements are true? (Choose two.)
A. A role cannot be assigned external authentication
B. A role can be granted to other roles
C. A role can contain both system and object privileges
D. The predefined resource role includes the unlimited_tablespace privilege
E. All roles are owned by the sys user
F. The predefined connect role is always automatically granted to all new users at the time of their creation
عرض الإجابة
اجابة صحيحة: AC
السؤال #11
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: – Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit – Character set: AL32UTF8 – National character set: AL16UTF16 – O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: – Version: Oracle Database 12c Release 1 64-bit – Character Set: AL32UTF8 – National character set: AL16UTF16 – O/S: Oracle Linux 6 64-bit Which technique shoul
A. Transportable database
B. Transportable tablespace
C. Data Pump full export/import
D. The DBMS_PDB package
E. RMAN
عرض الإجابة
اجابة صحيحة: AD
السؤال #12
Identify three valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).
A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED
B. Use the CREATE DATABASE
C. Use the DBMS_PDB package to clone an existing PDB
D. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB
E. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11
عرض الإجابة
اجابة صحيحة: ACE

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

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

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

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


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