1Z0-007 무료 덤프문제 온라인 액세스

The ORDERS table has these columns:

The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retrieve orders with an inclusive total that ranges between 100.00 and 2000.00 dollars? (Choose two.)

• A.SELECT customer_id, order_id, order_total FROM orders WHERE order_total >= 100 and order_total <= 2000;
• B.SELECT customer_id, order_id, order_total FROM orders WHERE order_total BETWEEN 100 and 2000;
• C.SELECT customer_id, order_id, order_total FROM orders HAVING order_total BETWEEN 100 and 2000;
• D.SELECT customer_id, order_id, order_total FROM orders RANGE ON order_total (100 AND 2000) INCLUSIVE;
• E.SELECT customer_id, order_id, order_total FROM orders WHERE order_total >= 100 and <= 2000;

Which is an /SQL*Plus command?

• A.DESCRIBE
• B.SELECT
• C.DELETE
• D.UPDATE
• E.INSERT
• F.RENAME

Which statement creates a new user?

• A.CREATE USER susan IDENTIFIED BY blue;
• B.CREATE USER susan;
• C.CREATE OR REPLACE USER susan;
• D.CREATE OR REPLACE USER susan IDENTIFIED BY blue;
• E.CREATE NEW USER susan IDENTIFIED by blue;
• F.CREATE NEW USER susan DEFAULT;

The CUSTOMERS table has these columns:

The CUSTOMER_ID column is the primary key for the table.
Which two statements find the number of customers? (Choose two.)

• A.SELECT COUNT(customer_id) FROM customers;
• B.SELECT COUNT(customers) FROM customers;
• C.SELECT TOTAL(*) FROM customers;
• D.SELECT TOTAL(customer_name) FROM customers;
• E.SELECT COUNT(*) FROM customers;
• F.SELECT TOTAL(customer_id) FROM customers;

Examine the description of the MARKS table:

SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.
Examine this SELECT statement based on the MARKS table:
SELECT subj1+subj2 total_marks, std_id
FROM marks
WHERE subj1 > AVG (subj1) AND subj2 > AVG(subj2)
ORDER BY total_marks;
What is the result of the SELECT statement?

• A.The statement returns an error at the WHERE clause.
• B.The statement returns an error at the SELECT clause.
• C.The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
• D.The statement returns an error at the ORDER BY clause.