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 52/300
Which four are attributes of single row functions? (Choose four.)
Correct Answer: B,C,D,F
Explanation/Reference:
Explanation:
Manipulate data items, act on each row returned, return one result per row, and accept arguments that can be a column or expression.
Incorrect answer:
A. is not single row attributes
E. functions can accept more than one argument, e.g NVL2
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-5
Explanation:
Manipulate data items, act on each row returned, return one result per row, and accept arguments that can be a column or expression.
Incorrect answer:
A. is not single row attributes
E. functions can accept more than one argument, e.g NVL2
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-5
- 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...
