1z0-061 Exam Dumps | You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary

Valid 1z0-061 Dumps shared by ExamDiscuss.com for Helping Passing 1z0-061 Exam! ExamDiscuss.com now offer the newest 1z0-061 exam dumps, the ExamDiscuss.com 1z0-061 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1z0-061 dumps with Test Engine here:

Access 1z0-061 Dumps Premium Version
(340 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 28/300

You need to write a SQL statement that returns employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
Which statement accomplishes this task?

A. SELECT a.emp_name, a.sal, b.dept_id, MAX(sal) FROM employees a, departments b WHERE a.dept_id = b.dept_id AND a.sal < MAX(sal) GROUP BY b.dept_id;

B. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) b WHERE a.dept_id = b.dept_id AND a.sal < b.maxsal;

C. SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a WHERE a.sal < (SELECT MAX (sal) maxsal FROM employees b GROUP BY dept_id);

D. SELECT emp_name, sal, dept_id, maxsal FROM employees, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) WHERE a.sal < maxsal;

Question List (300q): Question 1: Which two statements are true regarding the USING and ON cla...; Question 2: View the Exhibit and examine the structure of the customers ...; Question 3: The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMB...; Question 4: Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three...; Question 5: You issue the following command to alter the country column ...; Question 6: View the Exhibit and examine the structure of the PRODUCTS, ...; Question 7: What is true of using group functions on columns that contai...; Question 8: Examine the structure of the PROMOTIONS table: (Exhibit) The...; Question 9: View the Exhibit and examine the structure of the products t...; Question 10: You need to generate a list of all customer last names with ...; Question 11: The STUDENT_GRADES table has these columns: (Exhibit) Which ...; Question 12: View the Exhibit and examine the data in the PROJ_TASK_DETAI...; Question 13: Examine the structure of the employees table. (Exhibit) You ...; Question 14: Evaluate the following two queries: Exhibit: (Exhibit) Exhib...; 1 commentQuestion 15: In the customers table, the CUST_CITY column contains the va...; Question 16: See the Exhibit and examine the structure of ORD table: Exhi...; Question 17: View the Exhibit and examine the structure of the products t...; Question 18: You issued the following command: SQL> DROP TABLE employe...; Question 19: Examine the statement: GRANT select, insert, update ON stude...; Question 20: View the Exhibit and examine the structure of the customers ...; Question 21: Which one is a system privilege?...; Question 22: Which statement is true regarding the COALESCE function?...; Question 23: Examine this statement: SELECT student_id, gpa FROM student_...; Question 24: Examine the types and examples of relationships that follow:...; Question 25: View the Exhibit and examine the description of SALES and PR...; Question 26: View the Exhibit and examine the structure of the customers ...; Question 27: You want to create a table employees in which the values of ...; Question 28: You need to write a SQL statement that returns employee name...; Question 29: Examine the structure and data of the CUSTJTRANS table: CUST...; Question 30: Examine the structure of the EMP_DEPT_VU view: (Exhibit) Whi...; Question 31: Which two statements are true regarding views? (Choose two.)...; Question 32: A data manipulation language statement _____....; Question 33: Which two statements are true regarding working with dates? ...; Question 34: View the Exhibit for the structure of the student and facult...; Question 35: View the Exhibit and examine the structure of the PROMOTIONS...; Question 36: You issue the following command to drop the products table: ...; Question 37: You need to display the date 11-Oct-2007 in words as 'Eleven...; Question 38: You want to display 5 percent of the employees with the high...; Question 39: Top N analysis requires _____ and _____. (Choose two.)...; Question 40: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...; Question 41: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 42: Examine the structure and data in the PRICE_LIST table: Name...; Question 43: View the Exhibit and examine the structure of ORDERS and CUS...; Question 44: View the Exhibit and examine the structure of the PROMOTIONS...; Question 45: You work as a database administrator at ABC.com. You study t...; Question 46: The PART_CODE column in the SPARES table contains the follow...; Question 47: See the Exhibit and examine the structure and data in the IN...; Question 48: You need to design a student registration database that cont...; Question 49: You need to list the employees in DEPARTMENT_ID 30 in a sing...; Question 50: What is true about sequences?; Question 51: Examine the data in the PROMO_BEGIN_DATE column of the promo...; Question 52: Which four are attributes of single row functions? (Choose f...; Question 53: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 54: Evaluate the following SQL statements: Exhibit: (Exhibit) Wh...; Question 55: You work as a database administrator at ABC.com. You study t...; Question 56: View the Exhibit and examine the data in the costs table. (E...; Question 57: You work as a database administrator at ABC.com. You study t...; Question 58: The user Sue issues this SQL statement: GRANT SELECT ON sue....; Question 59: View the Exhibit and examine the structure of the PRODUCTS t...; Question 60: View the Exhibit and examine the structure of the PRODUCTS t...; Question 61: Examine the structure of the orders table: (Exhibit) You wan...; Question 62: Examine the structure and data of the CUST_TRANS table: (Exh...; Question 63: Which view should a user query to display the columns associ...; Question 64: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 65: View the Exhibit and examine the data in the PROMO_CATEGORY ...; Question 66: The user Alice wants to grant all users query privileges on ...; Question 67: Which two statements are true regarding indexes? (Choose two...; Question 68: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...; Question 69: View the Exhibit and examine the structure of the SALES and ...; Question 70: You created an ORDERS table with the following description: ...; Question 71: Which SQL statement would you use to remove a view called EM...; Question 72: View the Exhibit and examine the structure of the product, c...; Question 73: In which two cases would you use an outer join? (Choose two....; Question 74: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 75: View the Exhibit and examine the description for the PRODUCT...; Question 76: Which three SQL statements would display the value 1890.55 a...; Question 77: In which four clauses can a sub query be used? (Choose four....; Question 78: What is true about updates through a view?...; Question 79: You need to produce a report for mailing labels for all cust...; Question 80: The EMPLOYEES table has these columns: LAST NAME. VARCHAR2(3...; Question 81: Which two statements about sub queries are true? (Choose two...; Question 82: View the Exhibits and examine the structures of the PROMOTIO...; Question 83: Which two statements are true regarding tables? (Choose two....; Question 84: Examine the data in the CUST_NAME column of the customers ta...; Question 85: Which statements are true regarding the FOR UPDATE clause in...; Question 86: Which two statements are true regarding single row functions...; Question 87: You want to display the date for the first Monday of the nex...; Question 88: View the Exhibit and examine the data in the PROMOTIONS tabl...; Question 89: View the Exhibit and examine the structure of the promotions...; Question 90: Which SQL statement returns a numeric value?...; Question 91: See the Exhibit and examine the structure of the PROMOTIONS ...; Question 92: The CUSTOMERS table has these columns: The CUSTOMER_ID colum...; Question 93: Examine the structure of the transactions table: (Exhibit) Y...; Question 94: Which statement adds a constraint that ensures the CUSTOMER_...; Question 95: Evaluate these two SQL statements: SELECT last_name, salary,...; Question 96: You need to extract details of those products in the SALES t...; Question 97: Which two statements about creating constraints are true? (C...; Question 98: You need to calculate the number of days from 1st January 20...; Question 99: Evaluate the following query: SELECT INTERVAL '300' MONTH, I...; Question 100: Which constraint can be defined only at the column level?...; Question 101: Evaluate the following SQL statement: SQL> SELECT cust_id...; Question 102: Which two statements are true regarding constraints? (Choose...; Question 103: View the Exhibit and evaluate the structure and data in the ...; 1 commentQuestion 104: Examine the data in the ename and hiredate columns of the em...; Question 105: View the Exhibit and examine the structure of the PROMOTIONS...; Question 106: View the exhibit and examine the description for the SALES a...; Question 107: You are currently located in Singapore and have connected to...; Question 108: You need to modify the STUDENTS table to add a primary key o...; Question 109: Evaluate this SQL statement: SELECT e.emp_name, d.dept_name ...; Question 110: View the Exhibit and examine the structure of the PRODUCTS t...; Question 111: You need to create a table named ORDERS that contain four co...; Question 112: Which three tasks can be performed using SQL functions built...; 1 commentQuestion 113: Examine the structure proposed for the TRANSACTIONS table: (...; Question 114: You want to display 5 percent of the rows from the sales tab...; Question 115: Examine the structure of the INVOICE table: Exhibit: (Exhibi...; Question 116: Using the customers table, you need to generate a report tha...; Question 117: Which two statements are true regarding single row functions...; Question 118: Which three statements are true regarding sub queries? (Choo...; Question 119: YOU need to display the date ll-oct-2007 in words as 'Eleven...; Question 120: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 121: Which SQL statements would display the value 1890.55 as $1, ...; Question 122: Which object privileges can be granted on a view?...; Question 123: You are currently located in Singapore and have connected to...; Question 124: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 125: EMPLOYEES and DEPARTMENTS data: EMPLOYEES (Exhibit) DEPARTME...; Question 126: Which three statements are true about multiple-row sub queri...; Question 127: You own a table called EMPLOYEES with this table structure: ...; Question 128: Which statement is true regarding the INTERSECT operator?...; Question 129: Evaluate the SQL statement: SELECT LPAD (salary, 10, '*') FR...; Question 130: You are the DBA for an academic database. You need to create...; Question 131: Which statement correctly describes SQL and /SQL*Plus?...; Question 132: Which three statements/commands would cause a transaction to...; Question 133: Which two statements complete a transaction? (Choose two)...; Question 134: Which substitution variable would you use if you want to reu...; Question 135: Which two statements are true about constraints? (Choose two...; Question 136: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...; Question 137: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...; Question 138: Which statements are correct regarding indexes? (Choose all ...; Question 139: Examine the structure of the sales table: (Exhibit) Evaluate...; Question 140: Evaluate the following query: (Exhibit) What would be the ou...; Question 141: The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...; Question 142: The customers table has the following structure: (Exhibit) Y...; Question 143: You want to display the date for the first Monday of the nex...; Question 144: View the Exhibits and examine products and sales tables. (Ex...; Question 145: Examine the data in the LIST_PRICE and MIN_PRICE columns of ...; Question 146: Which two statements are true regarding the count function?...; Question 147: See the Exhibit and examine the structure of the PROMOSTIONS...; Question 148: You need to create a table for a banking application. One of...; Question 149: Which object privileges can be granted on a view?...; Question 150: Examine the structure of the EMPLOYEES and DEPARTMENTS table...; Question 151: Examine the structure of the SHIPMENTS table: (Exhibit) You ...; Question 152: Examine the structure of the customers table: (Exhibit) CUST...; Question 153: What is true about the WITH GRANT OPTION clause?...; Question 154: Examine the structure of the PROMOS table: (Exhibit) You wan...; Question 155: You want to create an ORD_DETAIL table to store details for ...; Question 156: Which two statements are true regarding the DELETE and TRUNC...; Question 157: View the Exhibit and examine the structure of the products t...; Question 158: Evaluate the following CREATE SEQUENCE statement: CREATE SEQ...; Question 159: Which SQL statement accepts user input for the columns to be...; Question 160: Examine the structure proposed for the transactions table: (...; Question 161: Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(...; Question 162: View the Exhibit and examine the description for the CUSTOME...; Question 163: View the Exhibits and examine the structures of the products...; Question 164: Examine the data in the CUST_NAME column of the CUSTOMERS ta...; Question 165: Which describes the default behavior when you create a table...; Question 166: Evaluate the following SQL statement: (Exhibit) Which statem...; Question 167: See the Exhibits and examine the structures of PRODUCTS, SAL...; Question 168: Examine the structure of the PROMOS table: (Exhibit) You wan...; Question 169: Which three statements are true regarding subqueries? (Choos...; Question 170: Examine the structure of the employees table: (Exhibit) Ther...; Question 171: View the Exhibit and examine the structure of CUSTOMERS tabl...; Question 172: Which two are true about aggregate functions? (Choose two.)...; Question 173: Which normal form is a table in if it has no multi-valued at...; Question 174: Which SQL statement displays the date March 19, 2001 in a fo...; Question 175: Examine the statement: Create synonym emp for hr.employees; ...; Question 176: See the exhibit and examine the structure of the CUSTOMERS a...; Question 177: You want to create a sales table with the following column s...; Question 178: Examine the structure of the TRANSACTIONS table: Name Null T...; Question 179: Which are iSQL*Plus commands? (Choose all that apply.)...; Question 180: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 181: View the Exhibits and examine the structures of the products...; Question 182: Evaluate the following SQL statements: Exhibit: (Exhibit) Yo...; Question 183: View the Exhibit and examine the structure and data in the I...; Question 184: Where can sub queries be used? (Choose all that apply)...; Question 185: Evaluate the following SQL commands: (Exhibit) The command t...; Question 186: Examine the structure of the STUDENTS table: (Exhibit) You n...; Question 187: What is true regarding sub queries?...; Question 188: Examine the description of the EMPLOYEES table: EMP_ID NUMBE...; Question 189: Which best describes an inline view?...; Question 190: View the Exhibit and examine the data in the products table....; Question 191: Evaluate this SQL statement: SELECT ename, sal, 12*sal+100 F...; Question 192: Which four are valid Oracle constraint types? (Choose four.)...; Question 193: Which three are true? (Choose three.)...; Question 194: Which two statements are true about sequences created in a s...; Question 195: Which two statements are true regarding the ORDER BY clause?...; Question 196: A SELECT statement can be used to perform these three functi...; Question 197: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 198: Examine the following SQL commands: (Exhibit) Which statemen...; Question 199: Examine the structure of the products table: (Exhibit) You w...; Question 200: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 201: SLS is a private synonym for the SH.SALES table. The user SH...; Question 202: The DBA issues this SQL command: CREATE USER Scott IDENTIFIE...; Question 203: Here is the structure and data of the CUST_TRANS table: Exhi...; Question 204: Which is an iSQL*Plus command?; Question 205: Which is the valid CREATE [TABLE statement?...; Question 206: See the structure of the PROGRAMS table: (Exhibit) Which two...; Question 207: You issue the following query: SQL> SELECT AVG(MAX(qty)) ...; Question 208: Examine the description of the CUSTOMERS table: (Exhibit) Th...; Question 209: Which are /SQL*Plus commands? (Choose all that apply.)...; Question 210: View the Exhibit and examine the data in the EMPLOYEES table...; Question 211: View the Exhibit and examine the structure of the PRODUCTS t...; Question 212: The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMB...; Question 213: Which two statements are true about WHERE and HAVING clauses...; Question 214: View the Exhibit and examine the structure of the PROMOTIONS...; Question 215: Examine the structure and data in the PRIC E_LIST table: Nam...; Question 216: Which is an iSQL*Plus command?; Question 217: You are granted the CREATE VIEW privilege. What does this al...; Question 218: Which four are types of functions available in SQL? (Choose ...; Question 219: User Mary has a view called EMP_DEPT_LOC_VU that was created...; Question 220: Which two statements are true regarding constraints? (Choose...; Question 221: Which statement is true regarding sub queries?...; Question 222: Examine the data in the CUSTOMERS table: (Exhibit) You want ...; Question 223: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 224: Which two statements are true regarding subqueries?...; Question 225: Evaluate the following query: SQL> SELECT TRUNC(ROUND(156...; Question 226: Which two statements are true regarding sub queries? (Choose...; Question 227: View the Exhibit and examine the structure of the ORDERS and...; Question 228: View the Exhibit and examine the structure of the promotions...; Question 229: Which statement is true regarding the UNION operator?...; Question 230: The following data exists in the PRODUCTS table: PROD_ID PRO...; Question 231: You work as a database administrator at ABC.com. You study t...; Question 232: View the Exhibit and examine the data in the PROMO_NAME and ...; Question 233: The SQL statements executed in a user session as follows: Ex...; Question 234: Which three statements are true regarding sub queries? (Choo...; Question 235: What does the FORCE option for creating a view do?...; Question 236: Exhibit contains the structure of PRODUCTS table: (Exhibit) ...; Question 237: Evaluate the following SQL statements: DELETE FROM sales; Th...; Question 238: View the Exhibit to examine the description for the SALES ta...; Question 239: Which is a valid CREATE TABLE statement?...; Question 240: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBE...; Question 241: What is true about sequences?; Question 242: Evaluate the following SQL statement: (Exhibit) Which statem...; Question 243: You work as a database administrator at ABC.com. You study t...; Question 244: View the Exhibit and examine the data in the PROMOTIONS tabl...; Question 245: Examine the data in the ORD_ITEMS table: (Exhibit) Evaluate ...; Question 246: You need to display the first names of all customers from th...; Question 247: Which three statements are true regarding the data types in ...; Question 248: View the Exhibit and evaluate structures of the SALES, PRODU...; Question 249: The DBA issues this SQL command: CREATE USER scott IDENTIFIE...; Question 250: Evaluate the following SQL statements: Exhibit: (Exhibit) Ex...; Question 251: View the Exhibit and examine the structure of the PRODUCTS t...; Question 252: Which statement is true regarding the default behavior of th...; Question 253: View the Exhibit and examine the structure of ORDERS and CUS...; Question 254: View the Exhibit and examine the data in the employees table...; Question 255: The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) P...; Question 256: You need to produce a report where each customer's credit li...; Question 257: Which statements are true regarding the WHERE and HAVING cla...; Question 258: View the Exhibit and examine the structure of the PROMOTIONS...; Question 259: View the Exhibit and examine the description for the CUSTOME...; Question 260: View the Exhibit and examine the structure of the SALES tabl...; Question 261: Which statement adds a column called salary to the employees...; Question 262: Examine the structure of the MARKS table: Exhibit: (Exhibit)...; Question 263: You execute the following commands: (Exhibit) For which subs...; Question 264: Which three statements are true regarding views? (Choose thr...; Question 265: You need to perform these tasks: 1. Create and assign a MANA...; Question 266: Which tasks can be performed using SQL functions that are bu...; Question 267: See the Exhibit and examine the structure of the SALES, CUST...; Question 268: View the Exhibit and examine the structure of the PROMOTIONS...; Question 269: View the Exhibit; examine the structure of the PROMOTIONS ta...; Question 270: Which constraint can be defined only at the column level?...; Question 271: The STUDENT_GRADES table has these columns: STUDENT_ID. NUMB...; Question 272: The CUSTOMERS table has these columns: (Exhibit) A promotion...; Question 273: You need to create a table with the following column specifi...; Question 274: For which action can you use the TO_DATE function?...; Question 275: Which statement is true regarding synonyms?...; Question 276: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBE...; Question 277: What are two reasons to create synonyms? (Choose two.)...; Question 278: The PRODUCTS table has the following structure: (Exhibit) Ev...; Question 279: View the Exhibit and examine the structure and data in the I...; Question 280: View the Exhibit and examine the data in the promotions tabl...; Question 281: Which statement describes the ROWID data type?...; Question 282: Which statement is true regarding transactions? (Choose all ...; Question 283: Examine the create table statements for the stores and sales...; Question 284: Examine the description of the EMP_DETAILS table given below...; Question 285: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 286: The ORDERS TABLE belongs to the user OE. OE has granted the ...; Question 287: View the Exhibit and examine the structure of the PROMOTIONS...; Question 288: Evaluate the SQL statement DROP TABLE DEPT: Which four state...; Question 289: Which arithmetic operations can be performed on a column by ...; Question 290: Examine the data in the ORD_ITEMS table: ORD_NO ITEM_NO QTY ...; Question 291: Which two statements are true regarding savepoints? (Choose ...; Question 292: View the Exhibit and examine the structure of the CUSTOMERS ...; Question 293: Examine the SQL statement that creates ORDERS table: CREATE ...; Question 294: View the Exhibit and examine the structures of the employees...; Question 295: Which create table statement is valid? (Exhibit)...; Question 296: Which two statements are true regarding constraints?...; Question 297: Examine these statements: CREATE ROLE registrar; GRANT UPDAT...; Question 298: You need to calculate the number of days from 1st Jan 2007 t...; Question 299: View the Exhibit and examine the structure of CUSTOMERS and ...; Question 300: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...

Question 28/300

LEAVE A REPLY

Download PDF File