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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Which two statements are true about the rules of precedence for operators? (Choose two.)
A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
B. NULLS influence the precedence of operators in an expression
C. The + binary operator has the highest precedence in an expression in a SQL statement
D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
E. Multiple parentheses can be used to override the default precedence of operators in an expression
عرض الإجابة
اجابة صحيحة: BCF
السؤال #2
In which three situations does a new transaction always start? (Choose three.)
A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
B. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
C. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
D. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
E. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfullyin the same session
F. when issuing a DML statement after a DML statement failed in the same session
عرض الإجابة
اجابة صحيحة: ABF
السؤال #3
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)
A. two or more instances on separate servers all associated with one database
B. one instance on one server associated with one database
C. one instance on one server associated with two or more databases on the same server
D. one instance on one server not associated with any database
E. one instance on one server associated with two or more databases on separate servers
عرض الإجابة
اجابة صحيحة: ABF
السؤال #4
A database is configured to use automatic undo management with temporary undo enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?
A. in the undo tablespace
B. in the SYSAUX tablespace
C. in the SGA
D. in the PGA
E. in the temporary tablespace
عرض الإجابة
اجابة صحيحة: DE
السؤال #5
Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
A. The Oracle Net Configuration Assistant is only used when running the Oracle installer
B. Oracle Net Manager can be used to centrally configure listeners on any database server target
C. The lsnrctl utility requires a listener
D. Oracle Net Manager can be used to locally configure naming methods on a database server
E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
F. Enterprise Manager Cloud Control can be used to centrally configure net service names for any databaseserver target
عرض الإجابة
اجابة صحيحة: BDE
السؤال #6
Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)
A. External table files can be used for other external tables in a different database
B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
D. They cannot be partitioned
E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
F. They support UPDATEs but not INSERTs and DELETEs
عرض الإجابة
اجابة صحيحة: AE
السؤال #7
Which three statements are true about a self-join? (Choose three.)
A. The ON clause must be used
B. The query must use two different aliases for the table
C. It must be an equi join
D. It must be an inner join
E. The ON clause can be used
F. It can be an outer join
عرض الإجابة
اجابة صحيحة: B
السؤال #8
Which three statements are true about inner and outer joins? (Choose three.)
A. A full outer join returns matched and unmatched rows
B. An inner join returns matched rows
C. Outer joins can only be used between two tables per query
D. A full outer join must use Oracle syntax
E. Outer joins can be used when there are multiple join conditions on two tables
F. A left or right outer join returns only unmatched rows
عرض الإجابة
اجابة صحيحة: ADE
السؤال #9
A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command: $ sqlplus hr/hr@orcl @abc.sql What will happen upon execution?
A. The command succeeds and HR will be connected to the orcl and abc
B. The command succeeds and HR will be connected to the orcl database instance, and the abc
C. The command fails because the script must refer to the full path name
D. The command fails and reports an error because @ is used twice
عرض الإجابة
اجابة صحيحة: A
السؤال #10
Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?
A. INTERSECT
B. UNION ALL
C. UNION
D. SUBTRACT
E. MINUS
عرض الإجابة
اجابة صحيحة: AB
السؤال #11
Examine the description of the EMPLOYEES table: Which query is valid?
A. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
عرض الإجابة
اجابة صحيحة: CE

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

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

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

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


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