1z0-061 Exam Dumps | View the Exhibit and examine the description for the PRODUCTS and SALES table. (Exhibit) PROD

<< Prev Question Next Question >>

Question 196/200

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 for the last three years. Which is the valid DELETE statement?

A. DELETE
FROM products
WHERE prod_id = (SELECT prod_id
FROM sales
WHERE SYSDATE >= time_id - 3*365 );

B. DELETE
FROM products
WHERE prod_id = (SELECT prod_id
FROM sales
WHERE time_id - 3*365 = SYSDATE );

C. DELETE
FROM products
WHERE prod_id IN (SELECT prod_id
FROM sales
WHERE SYSDATE - 3*365 >= time_id);

D. DELETE
FROM products
WHERE prod_id IN (SELECT prod_id
FROM sales
WHERE time_id >= SYSDATE - 3*365 );

Question List (200q): Question 1: Examine the data in the PROMO_BEGIN_DATE column of the promo...; Question 2: For which action can you use the TO_DATE function?...; Question 3: You need to calculate the number of days from 1st Jan 2007 t...; Question 4: Which statement adds a column called salary to the employees...; Question 5: The STUDENT_GRADES table has these columns: (Exhibit) Which ...; Question 6: You need to design a student registration database that cont...; Question 7: You work as a database administrator at ABC.com. You study t...; Question 8: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 9: You need to calculate the number of days from 1st January 20...; Question 10: The SQL statements executed in a user session as follows: Ex...; Question 11: You need to extract details of those products in the SALES t...; Question 12: View the Exhibit and examine the structure of the product, c...; Question 13: Which SQL statement displays the date March 19, 2001 in a fo...; Question 14: Examine the structure of the employees table. (Exhibit) You ...; Question 15: Which statement is true regarding the UNION operator?...; Question 16: Examine the data in the CUST_NAME column of the customers ta...; Question 17: Which statement is true regarding sub queries?...; Question 18: Examine the structure of the orders table: (Exhibit) You wan...; Question 19: Which three statements/commands would cause a transaction to...; Question 20: You need to list the employees in DEPARTMENT_ID 30 in a sing...; Question 21: You are currently located in Singapore and have connected to...; Question 22: View the Exhibits and examine the structures of the products...; Question 23: Evaluate the following SQL statement: SQL> SELECT cust_id...; Question 24: View the Exhibit and examine the structure of the PROMOTIONS...; Question 25: Which two partitioned table maintenance operations support a...; Question 26: Evaluate the following SQL statements: Exhibit: (Exhibit) Wh...; Question 27: Examine the structure of the EMPLOYEES table: (Exhibit) You ...; Question 28: Which two are true about aggregate functions? (Choose two.)...; Question 29: You work as a database administrator at ABC.com. You study t...; Question 30: Which substitution variable would you use if you want to reu...; Question 31: Examine the data in the ename and hiredate columns of the em...; Question 32: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...; Question 33: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 34: Which three tasks can be performed using SQL functions built...; Question 35: View the Exhibit and examine the structure of the promotions...; Question 36: You execute the following commands: (Exhibit) For which subs...; Question 37: View the Exhibit and examine the description for the CUSTOME...; Question 38: Exhibit contains the structure of PRODUCTS table: (Exhibit) ...; Question 39: YOU need to display the date ll-oct-2007 in words as 'Eleven...; Question 40: Which constraint can be defined only at the column level?...; Question 41: You need to display the first names of all customers from th...; Question 42: Which statement is true regarding the default behavior of th...; Question 43: Which two statements are true regarding the ORDER BY clause?...; Question 44: Examine the data in the ORD_ITEMS table: (Exhibit) Evaluate ...; Question 45: Which two statements are true regarding working with dates? ...; Question 46: Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three...; Question 47: Evaluate the following SQL statements: Exhibit: (Exhibit) Ex...; Question 48: View the Exhibit and examine the structure of the PROMOTIONS...; Question 49: Using the customers table, you need to generate a report tha...; Question 50: View the Exhibit and examine the structure of the promotions...; Question 51: Which is the valid CREATE [TABLE statement?...; Question 52: View the Exhibit and examine the structure of ORDERS and CUS...; Question 53: Which two statements are true about constraints? (Choose two...; Question 54: See the structure of the PROGRAMS table: (Exhibit) Which two...; Question 55: View the Exhibit and examine the description of SALES and PR...; Question 56: Evaluate these two SQL statements: SELECT last_name, salary,...; Question 57: You need to display the date 11-Oct-2007 in words as 'Eleven...; Question 58: Examine the structure of the INVOICE table: Exhibit: (Exhibi...; Question 59: The customers table has the following structure: (Exhibit) Y...; Question 60: You want to display 5 percent of the rows from the sales tab...; Question 61: Which two statements are true regarding the USING and ON cla...; Question 62: Which is an iSQL*Plus command?; Question 63: View the Exhibit and examine the structures of the employees...; Question 64: View the Exhibits and examine products and sales tables. (Ex...; Question 65: View the Exhibit for the structure of the student and facult...; Question 66: Examine the structure and data in the PRIC E_LIST table: Nam...; Question 67: View the Exhibit and examine the structure of the PROMOTIONS...; Question 68: You want to create a sales table with the following column s...; Question 69: View the Exhibit and examine the structure of the products t...; Question 70: Evaluate this SQL statement: SELECT e.emp_name, d.dept_name ...; Question 71: Examine the structure of the employees table: (Exhibit) Ther...; Question 72: Which two statements are true regarding the count function?...; Question 73: Which two statements are true regarding constraints?...; Question 74: Evaluate the following query: SQL> SELECT TRUNC(ROUND(156...; Question 75: You need to produce a report where each customer's credit li...; Question 76: Which statement is true regarding the INTERSECT operator?...; Question 77: Where can sub queries be used? (Choose all that apply)...; Question 78: Which two statements complete a transaction? (Choose two)...; Question 79: View the Exhibit and examine the structure of the PROMOTIONS...; Question 80: Examine the structure of the sales table: (Exhibit) Evaluate...; Question 81: You want to display the date for the first Monday of the nex...; Question 82: Here is the structure and data of the CUST_TRANS table: Exhi...; Question 83: You need to create a table with the following column specifi...; Question 84: Which statement is true regarding the COALESCE function?...; Question 85: View the Exhibit and examine the data in the employees table...; Question 86: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 87: View the Exhibit and examine the structure of the SALES tabl...; Question 88: Which one is a system privilege?...; Question 89: View the Exhibit and examine the data in the PROMOTIONS tabl...; Question 90: View the Exhibit and examine the structure of the PROMOTIONS...; Question 91: The PRODUCTS table has the following structure: (Exhibit) Ev...; Question 92: Which two statements are true regarding sub queries? (Choose...; Question 93: View the Exhibit and examine the data in the costs table. (E...; Question 94: See the Exhibit and examine the structure of the SALES, CUST...; Question 95: Which three statements are true regarding the data types in ...; Question 96: Which two statements are true regarding views? (Choose two.)...; Question 97: View the Exhibit to examine the description for the SALES ta...; Question 98: View the Exhibit and examine the structure of ORDERS and CUS...; Question 99: User Mary has a view called EMP_DEPT_LOC_VU that was created...; Question 100: See the Exhibit and examine the structure of the PROMOTIONS ...; Question 101: Examine the structure and data of the CUST_TRANS table: (Exh...; Question 102: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...; Question 103: See the Exhibit and examine the structure of the PROMOSTIONS...; Question 104: View the Exhibit and evaluate the structure and data in the ...; Question 105: Examine the structure of the customers table: (Exhibit) CUST...; Question 106: Which statement is true regarding synonyms?...; Question 107: You want to display 5 percent of the employees with the high...; Question 108: Which two statements about sub queries are true? (Choose two...; Question 109: You need to generate a list of all customer last names with ...; Question 110: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 111: You work as a database administrator at ABC.com. You study t...; Question 112: View the Exhibits and examine the structures of the products...; Question 113: Which statements are correct regarding indexes? (Choose all ...; Question 114: View the Exhibit and examine the data in the PROMO_NAME and ...; Question 115: The COMMISSION column shows the monthly commission earned by...; Question 116: Which normal form is a table in if it has no multi-valued at...; Question 117: The following data exists in the PRODUCTS table: PROD_ID PRO...; Question 118: In the customers table, the CUST_CITY column contains the va...; Question 119: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 120: The ORDERS TABLE belongs to the user OE. OE has granted the ...; Question 121: The DBA issues this SQL command: CREATE USER Scott IDENTIFIE...; Question 122: Evaluate the following SQL statements: Exhibit: (Exhibit) Yo...; Question 123: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 124: In which three situations does a transaction complete?...; Question 125: Examine the description of the EMP_DETAILS table given below...; Question 126: Which two statements are true regarding constraints?...; Question 127: Which statement is true about Enterprise Manager (EM) expres...; Question 128: View the Exhibit and examine the structure of the customers ...; Question 129: Examine the create table statements for the stores and sales...; Question 130: See the Exhibits and examine the structures of PRODUCTS, SAL...; Question 131: Evaluate the following SQL statement: (Exhibit) Which statem...; Question 132: View the Exhibit and evaluate structures of the SALES, PRODU...; Question 133: Which two statements are true regarding subqueries?...; Question 134: View the Exhibit and examine the structure of the customers ...; Question 135: Which statement correctly describes SQL and /SQL*Plus?...; Question 136: What is true about the WITH GRANT OPTION clause?...; Question 137: The EMPLOYEES table has these columns: LAST NAME. VARCHAR2(3...; Question 138: Evaluate the following query: (Exhibit) What would be the ou...; Question 139: You work as a database administrator at ABC.com. You study t...; Question 140: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...; Question 141: Which three statements are true about multiple-row sub queri...; Question 142: View the Exhibit and examine the structure of the PROMOTIONS...; Question 143: Examine these statements: CREATE ROLE registrar; GRANT UPDAT...; Question 144: Examine the structure of the products table: (Exhibit) You w...; Question 145: View the Exhibit and examine the structure of the customers ...; Question 146: Which two statements are true about sequences created in a s...; Question 147: You issue the following command to alter the country column ...; Question 148: View the Exhibit and examine the data in the products table....; Question 149: You are currently located in Singapore and have connected to...; Question 150: The STUDENT_GRADES table has these columns: STUDENT_ID. NUMB...; Question 151: Which two statements are true regarding single row functions...; Question 152: Examine the structure proposed for the transactions table: (...; Question 153: You created an ORDERS table with the following description: ...; Question 154: View the Exhibit and examine the structure of ORD and ORD_IT...; Question 155: See the exhibit and examine the structure of the CUSTOMERS a...; Question 156: Which view should a user query to display the columns associ...; Question 157: View the Exhibit and examine the structure of the PROMOTIONS...; Question 158: You issue the following command to drop the products table: ...; Question 159: You need to perform these tasks: 1. Create and assign a MANA...; Question 160: A SELECT statement can be used to perform these three functi...; Question 161: Which are /SQL*Plus commands? (Choose all that apply.)...; Question 162: Examine the structure and data of the CUSTJTRANS table: CUST...; Question 163: Evaluate the following SQL commands: (Exhibit) The command t...; Question 164: Examine the structure of the transactions table: (Exhibit) Y...; Question 165: You issued the following command: SQL> DROP TABLE employe...; Question 166: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 167: What is true regarding sub queries?...; Question 168: Which two statements are true regarding single row functions...; Question 169: View the Exhibit and examine the structure of the PROMOTIONS...; Question 170: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 171: Which four are types of functions available in SQL? (Choose ...; Question 172: Which two statements are true regarding the USING clause in ...; Question 173: See the Exhibit and examine the structure of ORD table: Exhi...; Question 174: View the Exhibit and examine the structure of the PRODUCTS t...; Question 175: Examine the structure of the MARKS table: Exhibit: (Exhibit)...; Question 176: See the Exhibit and examine the structure and data in the IN...; Question 177: View the Exhibits and examine the structures of the PROMOTIO...; Question 178: The user Alice wants to grant all users query privileges on ...; Question 179: View the Exhibit and examine the structure of the products t...; Question 180: Which object privileges can be granted on a view?...; Question 181: You want to create a table employees in which the values of ...; Question 182: You work as a database administrator at ABC.com. You study t...; Question 183: Evaluate the following SQL statements: DELETE FROM sales; Th...; Question 184: You need to create a table for a banking application. One of...; Question 185: Which is a valid CREATE TABLE statement?...; Question 186: Which three SQL statements would display the value 1890.55 a...; Question 187: Examine the statement: Create synonym emp for hr.employees; ...; Question 188: Evaluate the following SQL statement: (Exhibit) Which statem...; Question 189: View the Exhibit and examine the structure of the products t...; Question 190: Evaluate the following two queries: Exhibit: (Exhibit) Exhib...; Question 191: View the Exhibit and examine the description for the CUSTOME...; Question 192: Which three statements are true regarding sub queries? (Choo...; Question 193: What is true about sequences?; Question 194: Examine the structure of the STUDENTS table: (Exhibit) You n...; Question 195: The PART_CODE column in the SPARES table contains the follow...; Question 196: View the Exhibit and examine the description for the PRODUCT...; Question 197: You want to create an ORD_DETAIL table to store details for ...; Question 198: Examine the types and examples of relationships that follow:...; Question 199: Which create table statement is valid? (Exhibit)...; Question 200: View the Exhibit and examine the data in the promotions tabl...

Question 196/200

LEAVE A REPLY

Download PDF File