خذ اختبارات أخرى عبر الإنترنت

السؤال #1

See the Exhibit and examine the structure of the PROMOTIONS table: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category

A. You issue the following SQL statements: What would be the outcome?

A. It generates an error because multiple conditions cannot be specified for the WHEN clause

B. It executes successfully and gives the required result

C. It generates an error because CASE cannot be used with group functions

D. It generates an error because NULL cannot be specified as a return value

عرض الإجابة

اجابة صحيحة: D

السؤال #2

Examine the structure of the MEMBERS table: NameNull?Type ------------------------------------------------------------ MEMBER_IDNOT NULLVARCHAR2 (6) FIRST_NAMEVARCHAR2 (50) LAST_NAMENOT NULLVARCHAR2 (50) ADDRESSVARCHAR2 (50) CITYVARCHAR2 (25) STATEVARCHAR2 (3) You want to display details of all members who reside in states starting with the letter A followed by exactly one character. Which SQL statement must you execute?

A. SELECT * FROM MEMBERS WHERE state LIKE '%A_*;

B. SELECT * FROM MEMBERS WHERE state LIKE 'A_*;

C. SELECT * FROM MEMBERS WHERE state LIKE 'A_%';

D. SELECT * FROM MEMBERS WHERE state LIKE 'A%';

عرض الإجابة

اجابة صحيحة: AB

السؤال #3

Examine the structure of the BOOKS_TRANSACTIONS table: You want to display the member IDs, due date, and late fee as $2 for all transactions. Which SQL statement must you execute?

A. SELECT member_id AS MEMBER_ID, due_date AS DUE_DATE, $2 AS LATE_FEE FROM BOOKS_TRANSACTIONS;

B. SELECT member_id 'MEMBER ID', due_date 'DUE DATE', '$2 AS LATE FEE' FROM BOOKS_TRANSACTIONS;

C. SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

D. SELECT member_id AS "MEMBER ID", due_date AS "DUE DATE", $2 AS "LATE FEE" FROM BOOKS_TRANSACTIONS;

عرض الإجابة

اجابة صحيحة: A

السؤال #4

Which two statements are true regarding savepoints? (Choose two.)

A. Savepoints may be used to ROLLBACK

B. Savepoints can be used for only DML statements

C. Savepoints are effective only for COMMIT

D. Savepoints are effective for both COMMIT and ROLLBACK

E. Savepoints can be used for both DML and DDL statements

عرض الإجابة

اجابة صحيحة: B

السؤال #5

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. You have the requirement to display PRODUCT_NAME and LIST_PRICE from the table where the CATEGORYJD column has values 12 or 13, and the SUPPLIER_ID column has the value 102088. You executed the following SQL statement: SELECT product_name, list_price FROM product_information WHERE (category_id = 12 AND category_id = 13) AND supplier_id = 102088; Which statement is true regarding the execution of the query?

A. It would not execute because the entire WHERE clause is not enclosed within parentheses

B. It would execute but would return no rows

C. It would not execute because the same column has been used twice with the AND logical operator

D. It would execute and return the desired

عرض الإجابة

اجابة صحيحة: B

السؤال #6

Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

A. The outer query stops evaluating the result set of the inner query when the first value is found

B. It is used to test whether the values retrieved by the inner query exist in the result of the outer query

C. It is used to test whether the values retrieved by the outer query exist in the result set of the inner query

D. The outer query continues evaluating the result set of the inner query until all the values in the result set are processed

عرض الإجابة

اجابة صحيحة: ACE

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

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

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

بريد إلكتروني:

رقم الواتس اب/الهاتف:

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

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان

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

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

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع! احصل الان

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

اجتياز اختبار الممارسة Cisco وPMP وCISA وCISM وAWS بنسبة 100% للبيع!
احصل الان