QUESTION 177
Which three actions can you perform on an existing table containing data? (Choose three.)

QUESTION 178
View the exhibit for the structure of the STUDENTand FACULTYtables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

QUESTION 179
Which two tasks can be performed by using Oracle SQL statements? (Choose two.)

QUESTION 180
View the exhibits and examine the structures of the COSTS and PROMOTIONS tables.
Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
(SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

QUESTION 181
Which three statements are true about multiple row subqueries?

QUESTION 182
Evaluate the following SQL commands:

The command to create a table fails. Identify the reason for the SQL statement failure.

QUESTION 183
View the Exhibit and examine the structure of the PRODUCTS table.

You must display the category with the maximum number of items.
You issue this query:

What is the result?

QUESTION 184
Which two statements are true regarding constraints?

QUESTION 185
Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS tables:

You want to generate a list of all department IDs that do not exist in the COURSE_DETAILStable.
You execute the SQL statement:

What is the outcome?

QUESTION 186
Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries:
(Choose three.)

QUESTION 187
View the exhibit and examine the structure of ORDERSand CUSTOMERStables.
ORDERS
Name
Null? Type
ORDER_ID NOT NULL NUMBER(4)
ORDER_DATE NOT NULL DATE
ORDER_MODE VARCHAR2(8)
CUSTOMER_ID NOT NULL NUMBER(6)
ORDER_TOTAL NUMBER(8, 2)
CUSTOMERS
Name Null? Type
CUSTOMER_ID NOT NULL NUMBER(6)
CUST_FIRST_NAME NOT NULL VARCHAR2(20)
CUST_LAST_NAME NOT NULL VARCHAR2(20)
CREDIT_LIMIT NUMBER(9,2)
CUST_ADDRESS VARCHAR2(40)
Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

QUESTION 188
Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?

QUESTION 189
Which three statements are true? (Choose three.)

QUESTION 190
You need to allow user ANDREW to:
1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table.
2. GRANT tha permission to other users.
Which statement will do this?

QUESTION 191
Evaluate the following ALTER TABLEstatement:
ALTER TABLE orders
SET UNUSED (order_date);
Which statement is true?