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 62/150
The EMPLOYEES table has these columns:
LAST NAME. VARCHAR2(35)
SALARY. NUMBER(8, 2)
HIRE_DATE. DATE
Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:
ALTER TABLE EMPLOYEES
MODIFY (SALARY DEFAULT 5000);
What is true about your ALTER statement?
LAST NAME. VARCHAR2(35)
SALARY. NUMBER(8, 2)
HIRE_DATE. DATE
Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:
ALTER TABLE EMPLOYEES
MODIFY (SALARY DEFAULT 5000);
What is true about your ALTER statement?
Correct Answer: B
A change to the DEFAULT value affects only subsequent insertions to the table. Existing rows will not be affected.
Incorrect Answers
A:. Column definitions can be altered to add DEFAULT values.
C:. Column definitions can be altered to add DEFAULT values. It works for columns with a NUMBER data type also.
D:. A change to the DEFAULT value affects only subsequent insertions to the table.
Existing rows will not be affected.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 219-224 Chapter 5: Creating Oracle Database Objects
Incorrect Answers
A:. Column definitions can be altered to add DEFAULT values.
C:. Column definitions can be altered to add DEFAULT values. It works for columns with a NUMBER data type also.
D:. A change to the DEFAULT value affects only subsequent insertions to the table.
Existing rows will not be affected.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 219-224 Chapter 5: Creating Oracle Database Objects
- Question List (150q)
- Question 1: Evaluate the following SQL statements: Exhibit: (Exhibit) Yo...
- Question 2: Evaluate the following query: SELECT INTERVAL '300' MONTH, I...
- Question 3: Evaluate this SQL statement: SELECT e.emp_name, d.dept_name ...
- Question 4: View the Exhibit and examine the structure of the customers ...
- Question 5: View the Exhibit and examine the structure of the SALES and ...
- Question 6: Examine the data in the ORD_ITEMS table: ORD_NO ITEM_NO QTY ...
- Question 7: You issued the following command: SQL> DROP TABLE employe...
- Question 8: You need to display the date 11-Oct-2007 in words as 'Eleven...
- Question 9: You need to perform these tasks: Which set of SQL statements...
- Question 10: View the Exhibit and examine the structure and data in the I...
- Question 11: Which two statements about sub queries are true? (Choose two...
- Question 12: Which create table statement is valid? (Exhibit)...
- Question 13: Examine the SQL statement that creates ORDERS table: CREATE ...
- Question 14: Evaluate the following CREATE SEQUENCE statement: CREATE SEQ...
- Question 15: Examine the structure of the products table: (Exhibit) You w...
- Question 16: Which two are true about aggregate functions? (Choose two.)...
- Question 17: View the Exhibits and examine the structures of the COSTS an...
- Question 18: Which tasks can be performed using SQL functions that are bu...
- Question 19: View the Exhibit and examine the structure of the PROMOTIONS...
- Question 20: View the Exhibit and examine the structure of the PRODUCTS t...
- Question 21: View the Exhibit and examine the structure of the CUSTOMERS ...
- Question 22: The STUDENT_GRADES table has these columns: (Exhibit) Which ...
- Question 23: Examine the structure of the DEPARTMENTS table: (Exhibit) Yo...
- Question 24: View the Exhibit and examine the structure of the PROMOTIONS...
- Question 25: The customers table has the following structure: (Exhibit) Y...
- Question 26: View the Exhibit and examine the structure of the PROMOSTION...
- Question 27: Which statement is true regarding synonyms?...
- Question 28: View the Exhibit and examine the structure of the PROMOTIONS...
- Question 29: See the Exhibits and examine the structures of PRODUCTS, SAL...
- Question 30: The user Sue issues this SQL statement: GRANT SELECT ON sue....
- Question 31: Which statements are correct regarding indexes? (Choose all ...
- Question 32: Which two statements are true about constraints? (Choose two...
- Question 33: The following data exists in the PRODUCTS table: PROD_ID PRO...
- Question 34: You need to display the first names of all customers from th...
- Question 35: View the Exhibit and examine the structure of the customers ...
- Question 36: View the Exhibit and examine the data in the PROMO_NAME and ...
- Question 37: EMPLOYEES and DEPARTMENTS data: EMPLOYEES (Exhibit) DEPARTME...
- Question 38: View the Exhibit and evaluate structures of the SALES, PRODU...
- Question 39: In the customers table, the CUST_CITY column contains the va...
- Question 40: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBE...
- Question 41: You work as a database administrator at ABC.com. You study t...
- Question 42: Which three statements are true about the ALTER TABLE .... D...
- Question 43: Evaluate these two SQL statements: SELECT last_name, salary,...
- Question 44: View the Exhibit and examine the structure of the PRODUCTS t...
- Question 45: View the Exhibit and examine the structure of the CUSTOMERS ...
- Question 46: Which two statements are true regarding the DELETE and TRUNC...
- Question 47: Which two statements are true regarding the USING clause in ...
- Question 48: You work as a database administrator at ABC.com. You study t...
- Question 49: Evaluate the following two queries: (Exhibit) Which statemen...
- Question 50: Which constraint can be defined only at the column level?...
- Question 51: Which two statements are true regarding savepoints? (Choose ...
- Question 52: You work as a database administrator at ABC.com. You study t...
- Question 53: Study this view creation statement: create view dept30 as se...
- Question 54: Evaluate the following SQL commands: (Exhibit) The command t...
- Question 55: Which are /SQL*Plus commands? (Choose all that apply.)...
- Question 56: Which three statements are true regarding subqueries? (Choos...
- Question 57: The following parameter are set for your Oracle 12c database...
- Question 58: View the Exhibit and examine the data in the PROMO_CATEGORY ...
- Question 59: Which statement is true regarding sub queries?...
- Question 60: Which four are valid Oracle constraint types? (Choose four.)...
- Question 61: View the Exhibit and examine the structure of the customers ...
- Question 62: The EMPLOYEES table has these columns: LAST NAME. VARCHAR2(3...
- Question 63: You want to display the date for the first Monday of the nex...
- Question 64: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...
- Question 65: You have created an index with this statement: create index ...
- Question 66: Which three are true? (Choose three.)...
- Question 67: You are currently located in Singapore and have connected to...
- Question 68: You want to create a sales table with the following column s...
- Question 69: The CUSTOMERS table has these columns: (Exhibit) A promotion...
- Question 70: Evaluate the following query: SQL> SELECT TRUNC(ROUND(156...
- Question 71: View the Exhibit and examine the structures of the employees...
- Question 72: View the Exhibit and examine the data in the EMPLOYEES table...
- Question 73: You want to write a query that accepts user input for column...
- Question 74: Which constraint can be defined only at the column level?...
- Question 75: View the Exhibit and examine the structure of the products t...
- Question 76: Examine the structure of the EMPLOYEES table: (Exhibit) Whic...
- Question 77: Examine the structure of the employees table: (Exhibit) Ther...
- Question 78: Study the following exhibit: (Exhibit) Assuming that the seq...
- Question 79: Examine the structure of the EMPLOYEES table: (Exhibit) You ...
- Question 80: Examine the structure of the sales table: (Exhibit) Evaluate...
- Question 81: The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...
- Question 82: Which two partitioned table maintenance operations support a...
- Question 83: View the Exhibit and examine the structure of the PROMOTIONS...
- Question 84: There is a simple view SCOTT.DEPT_VIEW on the table SCOTT.DE...
- Question 85: What are two reasons to create synonyms? (Choose two.)...
- Question 86: View the Exhibit and examine the description of SALES and PR...
- Question 87: View the Exhibits and examine products and sales tables. (Ex...
- Question 88: Evaluate the following SQL statement: SQL> SELECT cust_id...
- Question 89: View the exhibit and examine the description for the SALES a...
- Question 90: View the Exhibit and examine the structure of ORDERS and CUS...
- Question 91: Examine the data in the CUST_NAME column of the customers ta...
- Question 92: Which statements are true regarding the WHERE and HAVING cla...
- Question 93: A SELECT statement can be used to perform these three functi...
- Question 94: Which two statements are true regarding sub queries? (Choose...
- Question 95: Evaluate the following SQL statements: Exhibit: (Exhibit) Wh...
- Question 96: Which two statements are true regarding single row functions...
- Question 97: Examine the structure of the orders table: (Exhibit) You wan...
- Question 98: View the Exhibit and examine the structure of the PROMOTIONS...
- Question 99: A data manipulation language statement _____....
- Question 100: Which three statements are true regarding the data types in ...
- Question 101: Which statement correctly describes SQL and /SQL*Plus?...
- Question 102: Examine the structure of the PRODUCTS table: (Exhibit) You w...
- Question 103: The CUSTOMERS table has these columns: The CUSTOMER_ID colum...
- Question 104: Which SQL statement displays the date March 19, 2001 in a fo...
- Question 105: Examine the structure and data in the PRICE_LIST table: Name...
- Question 106: Which one is a system privilege?...
- Question 107: You need to calculate the number of days from 1st Jan 2007 t...
- Question 108: View the Exhibit and examine the structure of CUSTOMERS tabl...
- Question 109: Evaluate the following SQL statements: DELETE FROM sales; Th...
- Question 110: Which statement is true regarding transactions? (Choose all ...
- Question 111: This statement will fail: create unique bitmap index on empl...
- Question 112: The PART_CODE column in the SPARES table contains the follow...
- Question 113: View the Exhibit and examine the structure of the CUSTOMERS ...
- Question 114: Examine the structure of the EMPLOYEES and DEPARTMENTS table...
- Question 115: View the Exhibit and examine the structure of the SALES tabl...
- Question 116: You need to produce a report for mailing labels for all cust...
- Question 117: View the Exhibit and examine the structure of the CUSTOMERS ...
- Question 118: View the Exhibit and examine the data in the PROMOTIONS tabl...
- Question 119: View the Exhibit and examine the data in the PROJ_TASK_DETAI...
- Question 120: Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(...
- Question 121: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...
- Question 122: Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tab...
- Question 123: View the Exhibit and examine the description for the PRODUCT...
- Question 124: See the Exhibit and examine the structure of the SALES, CUST...
- Question 125: A sequence is created as follows: create sequence seq1 maxva...
- Question 126: View the Exhibit and examine the structure of the CUSTOMERS ...
- Question 127: Examine the structure of the SHIPMENTS table: (Exhibit) You ...
- Question 128: You need to create a table named ORDERS that contain four co...
- Question 129: Which two statements about creating constraints are true? (C...
- Question 130: View the Exhibit; examine the structure of the PROMOTIONS ta...
- Question 131: Sales data of a company is stored in two tables, SALES1 and ...
- Question 132: Which two statements are true regarding the count function?...
- Question 133: Examine this statement: SELECT student_id, gpa FROM student_...
- Question 134: You need to modify the STUDENTS table to add a primary key o...
- Question 135: The COMMISSION column shows the monthly commission earned by...
- Question 136: You work as a database administrator at ABC.com. You study t...
- Question 137: View the Exhibit and examine the structure of the PRODUCTS t...
- Question 138: Which describes the default behavior when you create a table...
- Question 139: Which two statements are true about WHERE and HAVING clauses...
- Question 140: View the Exhibit and examine the structure of the PRODUCTS t...
- Question 141: The STUDENT_GRADES table has these columns: STUDENT_ID. NUMB...
- Question 142: Examine the following SQL commands: (Exhibit) Which statemen...
- Question 143: User Mary has a view called EMP_DEPT_LOC_VU that was created...
- Question 144: Which statement adds a constraint that ensures the CUSTOMER_...
- Question 145: You need to display the date ll-oct-2007 in words as 'Eleven...
- Question 146: Which three SQL statements would display the value 1890.55 a...
- Question 147: You work as a database administrator at ABC.com. You study t...
- Question 148: Evaluate the following SQL statement: (Exhibit) Which statem...
- Question 149: Which two statements are true about sequences created in a s...
- Question 150: Which two statements complete a transaction? (Choose two)...
