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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server: What should you do to resolve the error?
A. Add network_link = devdb
B. Add the SYSTEM user to the schemas option
C. Change the dumpfile option value to schema
D. Replace the schemas option with network_1ink = devdb
E. Replace the dumpfile option with network_1ink = devdb
عرض الإجابة
اجابة صحيحة: ADE
السؤال #2
A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows: What happens when the FAILGRP1 failure group is corrupted?
A. Mirroring of allocation units occurs within the FAILGRP2 failure group
B. Transactions that are using the diskgroup fail
C. ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group
D. Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is starte
عرض الإجابة
اجابة صحيحة: ABE
السؤال #3
In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data: $> sqlldr hr/hr table=employees Which two statements are true about this command? (Choose two.)
A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist
B. It fails because the SQL *Loader control file location is not specified
C. It fails because the SQL *Loader data file location is not specified
D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database
E. It succeeds even if the HR user does not have the CREATE DIRECTORY privileg
عرض الإجابة
اجابة صحيحة: C
السؤال #4
You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed. You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas. What must you run to achieve this?
A. SQL Access Advisor with a SQL tuning set
B. Automatic Database Diagnostic Monitor (ADDM) report
C. SQL Tuning Advisor
D. SQL Access Advisor with a hypothetical workload
E. SQL Performance Analyzer
عرض الإجابة
اجابة صحيحة: C
السؤال #5
Which two services may you see on the My Service Dashboard page? (Choose two.)
A. Network Cloud Service
B. User Cloud Service
C. Compute Cloud Service
D. Database Cloud Service
عرض الإجابة
اجابة صحيحة: ABC
السؤال #6
Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).
A. Grant the APEX_PUBLIC_USER role to the SYSMAN user
B. Use the DBMS_XDB_CONFIG
C. Install Oracle HTTP Server
D. Configure at least one dispatcher for the TCP/IP protocol
E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Expres
عرض الإجابة
اجابة صحيحة: BD
السؤال #7
You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)
A. Perform a rolling upgrade
B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA)
C. Perform a direct upgrade by manually running the catctl
D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database
E. Upgrade your current database to Oracle Database release 10
عرض الإجابة
اجابة صحيحة: BCE
السؤال #8
In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to media failure. In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)
A. One control file copy is intact so the spfile is changed to refer to only one copy
B. One control file copy is intact and damaged control file copies have to be restored to the default location
C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually
D. All copies of the control file are damaged and the auto backed up control file is used for recovery
E. One control file copy is intact and damaged control file copies have to be restored to a non-default locatio
عرض الإجابة
اجابة صحيحة: D
السؤال #9
Which three statements are true about windows? (Choose three.)
A. Only one window can be open at any given time
B. Consumer groups are associated with windows
C. Windows work with job classes to control resource allocation
D. The database service name must be provided during windows creation
E. Windows can automatically start job or change resource allocation among jobs for various time periods
عرض الإجابة
اجابة صحيحة: ADE
السؤال #10
Examine this command executed on a client that is remote from the database server. SQL> CONNECT hr/hr@orcl Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)
A. An orcl TNS entry must be defined in the client-side and server-side tnsnames
B. An orcl TNS entry must be defined in the client-side tnsnames
C. A service name must be defined to the listener that matches the service name in the orcl TNS entry
D. An orcl TNS entry must be defined in the server-side tnsnames
E. The service name orcl must be defined to the listener
عرض الإجابة
اجابة صحيحة: AB
السؤال #11
Examine the following steps: ADBA grants the CREATE TABLE system privilege with ADMIN OPTION to the user SIDNEY. SIDNEY grants the CREATE TABLE system privilege to the HR user. Which statement is true?
A. SIDNEY can revoke the CREATE TABLE system privilege only from HR, to whom he granted it
B. HR can grant the CREATE TABLE system privilege to other users
C. Neither SIDNEY nor HR can create new tables if the DBA revokes the CREATE TABLE privilege from SIDNEY
D. HR still retains the CREATE TABLE system privilege if the DBA revokes the CREATE TABLE privilege from SIDNEY
عرض الإجابة
اجابة صحيحة: ABEG

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

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

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

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


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