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

السؤال #1

Evaluate the following statement. INSERT ALL WHEN order_total < 10000 THEN INTO small_orders WHEN order_total > 10000 AND order_total < 20000 THEN INTO medium_orders WHEN order_total > 200000 AND order_total < 20000 THEN INTO large_orders SELECT order_id, order_total, customer_id FROM orders; Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

A. They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause

B. They are evaluated by the first WHEN claus

C. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses

D. They are evaluated by the first WHEN claus

E. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses

F. The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true

عرض الإجابة

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

السؤال #2

Examine the following query: SQL> SELECT prod_id, amount_sold FROM sales ORDER BY amount_sold FETCH FIRST 5 PERCENT ROWS ONLY; What is the output of this query?

A. It displays 5 percent of the products with the highest amount sold

B. It displays the first 5 percent of the rows from the SALES table

C. It displays 5 percent of the products with the lowest amount sold

D. It results in an error because the ORDER BY clause should be the last clause

عرض الإجابة

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

السؤال #3

Evaluate the following SQL statement: SELECT product_name || 'it's not available for order' FROM product_information WHERE product_status = 'obsolete'; You received the following error while executing the above query: ERROR ORA-01756: quoted string not properly terminated What would you do to execute the query successfully?

A. Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string

B. Enclose the literal character string in the SELECT clause within the double quotation marks

C. Do not enclose the character literal string in the SELECT clause within the single quotation marks

D. Use escape character to negate the single quotation mark inside the literal character string in the SELECT clause

عرض الإجابة

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

السؤال #4

View the exhibit and examine the structure of the EMPLOYEES table. You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees. Which SQL statement would you execute?

A. SELECT m

B. SELECT m

C. SELECT m

D. SELECT m

عرض الإجابة

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

السؤال #5

View the Exhibit and examine the structure of the PRODUCTS table. (Choose the best answer.) You must display the category with the maximum number of items. You issue this query: SQL > SELECT COUNT(*), prod_category_id FROM products GROUP BY prod_category_id HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM porducts); What is the result?

A. It generates an error because = is not valid and should be replaced by the IN operator

B. It executes successfully but does not give the correct output

C. It executes successfully and gives the correct output

D. It generate an error because the subquery does not have a GROUP BY clause

عرض الإجابة

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

السؤال #6

View the Exhibit and examine the structure of CUSTOMERS table. Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "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') "NEW CREDIT"FROM customers;

عرض الإجابة

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

السؤال #7

You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. (Choose two.) Which two SQL statements would create the required table?

A. CREATE TABLE employees(employee_id NUMBER,Login_id NUMBER,Employee_name VARCHAR2(100),Hire_date DATE,CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));

B. CREATE TABLE employees(employee_id NUMBER,login_id NUMBER,employee_name VARCHAR2(25),hire_date DATE,CONSTRAINT emp_id_pk PRIMARY KEY (employee_id, login_id));

C. CREATE TABLE employees(employee_id NUMBER CONSTRAINT emp_id_pk PRIMARY KEY, Login_id NUMBER UNIQUE, Employee_name VARCHAR2(25),Hire_date DATE);

D. CREATE TABLE employees(employee_id NUMBER,Login_id NUMBER,Employee_name VARCHAR2(100),Hire_date DATE,CONSTRAINT emp_id_uk UNIQUE (employee_id, login_id);CONSTRAINT emp_id_nn NOT NULL (employee_id, login_id));

E. CREATE TABLE employees(employee_id NUMBER CONSTRAINT emp_id_nn NOT NULL, Login_id NUMBER CONSTRAINT login_id_nn NOT NULL,Employee_name VARCHAR2(100),Hire_date DATE,CONSTRAINT emp_id_ukUNIQUE (employee_id, login_id));

عرض الإجابة

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

السؤال #8

A non-correlated subquery can be defined as . (Choose the best answer.)

A. A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query

B. A set of sequential queries, all of which must return values from the same table

C. A set of sequential queries, all of which must always return a single value

D. A SELECT statement that can be embedded in a clause of another SELECT statement only

عرض الإجابة

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

السؤال #9

Which two statements are true regarding multiple-row subqueries? (Choose two.)

A. They can contain group functions

B. They always contain a subquery within a subquery

C. They use the < ALL operator to imply less than the maximum

D. They can be used to retrieve multiple rows from a single table only

E. They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of the result of the subquery

عرض الإجابة

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

السؤال #10

Which three statements are true regarding single-row functions? (Choose three.)

A. The data type returned, can be different from the data type of the argument that is referenced

B. They can return multiple values of more than one data type

C. They can accept only one argument

D. They can be nested up to only two levels

E. They can be used in SELECT, WHERE, and ORDER BY clauses

F. They can accept column names, expressions, variable names, or a user-supplied constants as arguments

عرض الإجابة

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

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

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

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

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

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

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

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

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

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

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

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

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