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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
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 AS "MEMBER ID", due_date AS "DUE DATE", '$2' AS "LATE FEE" FROM BOOKS_TRANSACTIONS
C. SELECT member_id 'MEMBER ID', due_date '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
عرض الإجابة
اجابة صحيحة: D
السؤال #2
Which statement is true about transactions?
A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction
B. Each Data Definition Language (DDL) statement executed forms a single transaction
C. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction
D. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction
عرض الإجابة
اجابة صحيحة: B
السؤال #3
View the Exhibit and examine the structure of the PORDUCT_INFORMATION table. (Choose the best answer.) PRODUCT_ID column is the primary key. You create an index using this command: SQL > CREATE INDEX upper_name_idx ON product_information(UPPER(product_name)); No other indexes exist on the PRODUCT_INFORMATION table. Which query would use the UPPER_NAME_IDX index?
A. SELECT product_id, UPPER(product_name)FROM product_informationWHERE UPPER(product_name) = 'LASERPRO' OR list_price > 1000;
B. SELECT UPPER(product_name)FROM product_information;
C. SELECT UPPER(product_name)FROM product_informationWHERE product_id = 2254;
D. SELECT product_idFROM product_informationWHERE UPPER(product_name) IN ('LASERPRO', 'CABLE');
عرض الإجابة
اجابة صحيحة: AC
السؤال #4
View the Exhibit and examine the structure of the CUSTOMERS table. Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers. Customers with no credit limit should have “Not Available” displayed. Which SQL statement would produce the required result?
A. SELECT NVL (TO_CHAR(cust_credit_limit*
B. SELECT TO_CHAR(NVL(cust_credit_limit*
C. SELECT NVL (cust_credit_limit*
D. SELECT NVL (cust_credit_limit, ‘Not Available’)*
عرض الإجابة
اجابة صحيحة: A
السؤال #5
Which two statements are true regarding constraints? (Choose two.)
A. A constraint is enforced only for an INSERT operation on a table
B. A foreign key cannot contain NULL values
C. The column with a UNIQUE constraint can store NULLS
D. You can have more than one column in a table as part of a primary key
عرض الإجابة
اجابة صحيحة: ACD
السؤال #6
View the Exhibit and examine the data in the PRODUCTS table. (Choose the best answer.) You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure. You issue this query: SQL > SELECT prod_name, prod_category, prod_min_price FROM products Where prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> ' '; Which statement is true?
A. It executes successfully but returns no result
B. It executes successfully and returns the required result
C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid
D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid
عرض الإجابة
اجابة صحيحة: B
السؤال #7
View the Exhibit and examine the structure of the PROMOTION table. You have to generate a report that displays the promo named start data for all promos that started after that last promo in the ‘INTTERNET’ category.
A. Select promo_name, promo_being_date FROM promoptions WHERE promo_being_data > ANY (SELCT promo_being-date FROM promotionsWHERE promo_category = ‘INTERNET’
B. SELECT promo_neme, promo_being_date FROM promotions WHERE promo_being_date > All (SELECT promo_beinjg-date FROM promotionsWHERE promo_category =’INTERNET’ );
C. SELECT promo-name, promo-being _date FROM promotionsWhere promo_being_data >ALL (SELECT MAX (promo_being-date) FROM promotions ) ANDPromo-category =’INTERNET’;
D. SELECT promo-name, promo-being_date FROM promotion WHERE promo-being-date IN (SELECT promo_biing_date FROM promotionsWHERE promo_category=’INTYERNET’);
عرض الإجابة
اجابة صحيحة: AC
السؤال #8
Examine the commands used to create the DEPARTMENT_DETAILS and the COURSE-DETAILS tables: SQL> CREATE TABLE DEPARTMfiNT_D￡TAILS DEPARTMENT_ID NUMBER PRIMARY KEY , DEPARTMEHT_NAME VARCHAR2(50) , HOD VARCHAP2(50)); SQL> CREATE TABLE COURSE-DETAILS (COURSE ID NUMBER PRIMARY KEY , COURS_NAME VARCHAR2 (50) , DEPARTMEHT_ID NUMBER REFERENCES DEPARTMENT_DETAIL You want to generate a list of all department IDs along with any course IDs that may have been assigned to them. Which SQL statement must you use?
A. SELECT d
B. SELECT d
C. course_id FROM dapartment_details d RIGHT OUTER JOIN course_dotails c ON (c
D. SELECT d
E. ccours_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d
F. SELECT d
عرض الإجابة
اجابة صحيحة: A
السؤال #9
View the Exhibit and examine the details of PRODUCT_INFORMATION table. PRODUCT_NAME CATEGORY_ID SUPPLIER_ID Inkjet C/8/HQ 12 102094 Inkjet C/4 12 102090 LaserPro 600/6/BW 12 102087 LaserPro 1200/8/BW 12 102099 Inkjet B/6 12 102096 Industrial 700/ID 12 102086 Industrial 600/DQ 12 102088 Compact 400/LQ 12 102087 Compact 400/DQ 12 102088 HD 12GB /R 13 102090 HD 10GB /I 13 102071 HD 12GB @7200 /SE 13 102057 HD 18.2GB @10000 /E 13 102078 HD 18.2GB @10000 /I 13 102050 HD 18GB /SE 13 102083 HD 6GB /I 13 102072 HD
A. It would not execute because the same column has been used in both sides of the AND logical operator to form the condition
B. It would not execute because the entire WHERE clause condition is not enclosed within the parentheses
C. It would execute and the output would display the desired result
D. It would execute but the output would return no rows
عرض الإجابة
اجابة صحيحة: AE
السؤال #10
Which statement is true regarding the INTERSECT operator?
A. The names of columns in all SELECT statements must be identical
B. It ignores NULL values
C. Reversing the order of the intersected tables alters the result
D. The number of columns and data types must be identical for all SELECT statements in the query
عرض الإجابة
اجابة صحيحة: AB

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

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

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

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


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