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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Examine this description of the TRANSACTIONS table: Which two SQL statements execute successfully? (Choose two.)
A. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;
B. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;
C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;
D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
E. SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;
عرض الإجابة
اجابة صحيحة: BD
السؤال #2
You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonth rrrr’) What is the result?
A. It executes successfully but does not return any result
B. It returns the date for the first Monday of the next month
C. It generates an error
D. It returns the date for the last Monday of the current month
عرض الإجابة
اجابة صحيحة: B
السؤال #3
Which two statements are true about UNDO and REDO? (Choose two.)
A. The generation of UNDO generates REDO
B. DML modifies Oracle database objects and only generates UNDO
C. The generation of REDO generates UNDO
D. DML modifies Oracle database objects and only generates REDO
عرض الإجابة
اجابة صحيحة: BE
السؤال #4
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
A. Column positions must be used in the ORDER BY clause
B. Only column names from the first SELECT statement in the compound query are recognized
C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
D. Each SELECT statement in the compound query must have its own ORDER BY clause
E. Each SELECT statement in the compound query can have its own ORDER BY clause
عرض الإجابة
اجابة صحيحة: ADE
السؤال #5
Which three statements are true about views in an Oracle database? (Choose three.)
A. Views can be updated without the need to re-grant privileges on the view
B. Tables in the defining query of a view must always exist in order to create the view
C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
D. Data Manipulation Language (DML) can always be used on views
E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error G
عرض الإجابة
اجابة صحيحة: BDE
السؤال #6
Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)
A. They can be written by server processes
B. Trace files are written to the Fast Recovery Area (FRA)
C. They can be written by background processes
D. All trace files contain error information that require contacting Oracle Support
E. Trace file names are based on the database name concatenated with a sequential number
عرض الإجابة
اجابة صحيحة: A
السؤال #7
Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)
A. Oracle Managed Files (OMF)
B. Online table segment shrink
C. Online index segment shrink
D. Automatic data file extension (AUTOEXTEND)
E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)
عرض الإجابة
اجابة صحيحة: AC
السؤال #8
Examine these commands: Which two statements are true about the sqlldr execution? (Choose two.)
A. It overwrites data in EMP with data in EMP
B. It uses the database buffer cache to load data
C. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
D. It generates a sql script that it uses to load data from EMP
E. It appends data from EMP
عرض الإجابة
اجابة صحيحة: BDE

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

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

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

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


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