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

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

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

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

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

خذ اختبارات أخرى عبر الإنترنت
السؤال #1
Evaluate the following SELECT statement and view the exhibit to examine its output: SELECT constraint_name, constraint_type, search_condition, r_constraint_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; CONSTRAINT_NAME CON SEARCH_CONDITION R_CONSTRAINT_NAME DELETE_RULE STATUS ORDER_DATE_NN C "ORDER_DATE" IS NOT NULL ENABLED ORDER_CUSTOMER_ID_NN C "CUSTOMER_ID" IS NOT NULL ENABLED ORDER_MODE_LOV C order _mode in ('direct', 'online') ENABLED ORDER TOTAL MIN C order total >= 0 EN
A. The R_CONSTRAINT_NAME column gives the alternative name for the constraint
B. In the second column, 'c' indicates a check constraint
C. The STATUS column indicates whether the table is currently in use
D. The column DELETE_RULE decides the state of the related rows in the child table when the corresponding row is deleted from the parent table
عرض الإجابة
اجابة صحيحة: AC
السؤال #2
Which two statements are true regarding working with dates? (Choose two.)
A. The RR date format automatically calculates the century from the SYSDATE function but allows the session user to enter the century
B. The RR date format automatically calculates the century from the SYSDATE function and does not allow a session user to enter the century
C. The default internal storage of dates is in character format
D. The default internal storage of dates is in numeric format
عرض الإجابة
اجابة صحيحة: C
السؤال #3
View the Exhibit and examine the structure in the EMPLOYEES tables. Evaluate the following SQL statement: SELECT employee_id, department_id FROM employees WHERE department_id= 50 ORDER BY department_id UNION SELECT employee_id, department_id FROM employees WHERE department_id=90 UNION SELECT employee_id, department_id FROM employees WHERE department_id=10; What would be the outcome of the above SQL statement?
A. The statement would not execute because the positional notation instead of the column name should be used with the ORDER BY clause
B. The statement would execute successfully and display all the rows in the ascending order of DEPARTMENT_ID
C. The statement would execute successfully but it will ignore the ORDER BY clause and display the rows in random order
D. The statement would not execute because the ORDER BY clause should appear only at the end of the SQL statement, that is, in the last SELECT statement
عرض الإجابة
اجابة صحيحة: D
السؤال #4
Examine the structure of the ORDERS table: (Choose the best answer.) You want to find the total value of all the orders for each year and issue this command: SQL> SELECT TO_CHAR(order_date,'rr'), SUM(order_total) FROM orders GROUP BY TO_CHAR(order_date, 'yyyy'); Which statement is true regarding the result?
A. It executes successfully but does not give the correct output
B. It executes successfully but gives the correct output
C. It returns an error because the TO_CHAR function is not valid
D. It return an error because the datatype conversion in the SELECT list does not match the data type conversion in the GROUP BY clause
عرض الإجابة
اجابة صحيحة: C
السؤال #5
View the Exhibit and examine the structure of the ORDERS table. (Choose the best answer.) You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101. Which query would give you the desired result?
A. SELECT order_id, order_date FROM ordersWHERE order_date > ANY(SELECT order_date FROM orders WHERE customer_id = 101);
B. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
C. SELECT order_id, order_date FROM ordersWHERE order_date > ALL(SELECT order_date FROM orders WHERE customer_id = 101);
D. SELECT order_id, order_date FROM ordersWHERE order_date > IN(SELECT order_date FROM orders WHERE customer_id = 101);
عرض الإجابة
اجابة صحيحة: BE
السؤال #6
Which three statements are true about multiple-row subqueries?
A. They can contain a subquery within a subquery
B. They can return multiple columns as well as rows
C. They cannot contain a subquery within a subquery
D. They can return only one column but multiple rows
E. They can contain group functions and GROUP BY and HAVING clauses
F. They can contain group functions and the GROUP BY clause, but not the HAVING clause
عرض الإجابة
اجابة صحيحة: C

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

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

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

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


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