一、原题 View the Exhibit and examine the structure of CUSTOMERS and GRADES tables. You need to display names and grades of customers who have the highest credit limit. Which two SQL statements would accomplish the task? (Choose two.) A.SELECT custname,…
一、原题 View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the number of times the product has been sold: SQL>SELECT p.prod_name, i.item_cnt FROM (SELECT prod_id, COUNT(*) …
一、原题 Which three statements are true regarding subqueries? (Choose three.) A. Subqueries can contain GROUP BY and ORDER BY clauses. B. Main query and subquery can get data from different tables. C. Main query and subquery must get data from the same …
一、原题 Examine the structure of the PRODUCTS table: Name Null Type PROD_ID NOT NULL NUMBER(4) PROD_NAME VARCHAR2(20) PROD_STATUS VARCHAR2(6) QTY_IN_HAND …
一、原题 Which two statements are true regarding subqueries? (Choose two.) A. A subquery can retrieve zero or more rows. B. Only two subqueries can be placed at one level. C. A subquery can be used only in SQL query statements. D. A subquery can appear o…
一、原题 View the Exhibit and examine the structure of the CUSTOMERS table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table. Evaluat…
一、原题 Examine the structure of the CUSTOMERS table: Name Null Type CUSTNO NOT NULL NUMBER(3) CUSTNAME NOT NULL VARCHAR2(25) CUSTADDRESS VARCHAR2(35) CUST_CREDIT_LIMIT NUMBER…
一、原题 Where can sub queries be used? (Choose all that apply) A. field names in the SELECT statement B. the FROM clause in the SELECT statement C. the HAVING clause in the SELECT statement D. the GROUP BY clause in the SELECT statement E. the WHERE cla…
一、原题 View the Exhibit and examine the structures of the EMPLOYEES and DEPARTMENTS tables. You want to update the EMPLOYEES table as follows: -Update only those employees who work in Boston or Seattle (locations 2900 and 2700). -Set department_id for …
一、原题 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 …
一、原题 View the Exhibit and examine the structure of the PRODUCTS table. Evaluate the following query: SQL> SELECT prod_name FROM products WHERE prod_id IN (SELECT prod_id FROM products WHERE pro…
一、原题 View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? (Choose two.) A. Display the minimum list price for each product status. B. Display all suppliers whose list price is less than 1000. C.…
一、原题 View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values. Which DELETE …
一、原题 View the Exhibit and examine the description for the PRODUCTS and SALES table.PROD_ID is a primary key in the PRODUCTS table and foreign key in the SALES table. You want to remove all the rows from the PRODUCTS table for which no sale was done fo…
一、原题 View the Exhibit and examine the structure of the CUSTOMERS table. NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the CUSTOMERS table. Evaluat…
一、原题 The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require sub queries or joins in order to be performed in a single step? (Choose two.) A. listing the employees who earn the same amount of commissi…
一、原题 View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cust_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer …
一、原题 Which two statements about sub queries are true? (Choose two.) A. A sub query should retrieve only one row. B. A sub query can retrieve zero or more rows. C. A sub query can be used only in SQL query statements. D. Sub queries CANNOT be nested b…