Tag: Oracle 1z0-061 Real Exam

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.321Examine the structure and data in the PRICE_LIST table: Name . Null . Type-PROD_ID . NOT NULL . NUMBER(3) PROD_PRICE . VARCHAR2(10) PROD_ID PROD_PRICE- 100 $234.55101 $6, 509.75102 $1, 234You plan to give a discount of 25% on the product price and need to display the discount amount in the same format as the PROD_PRICE.Which SQL statement would give the required result?SELECT TO_CHAR(prod_price* .25, #39;$99, 999.99#39;)FROM Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.301A data manipulation language statement .completes a transaction on a tablemodifies the structure and data in a tablemodifies the data but not the structure of a tablemodifies the structure but not the data of a tableCorrect Answer: CExplanation:modifies the data but not the structure of a tableIncorrect answer:DML does not complete a transactionDDL modifies the structure and data in the tableD. DML does not modified Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.311Which two statements are true regarding constraints? (Choose two.)A table can have only one primary key and one foreign key.A table can have only one primary key but multiple foreign keys.Only the primary key can be defined at the column and table levels.The foreign key and parent table primary key must have the same name.Both primary key and foreign key constraints can be defined at both column and table levels.Correct Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.271View the Exhibit and examine the structure and data in the INVOICE table.Which two statements are true regarding data type conversion in expressions used in queries? (Choose two.)inv_amt =#39;0255982#39;: requires explicit conversioninv_date gt; #39;01-02-2008#39;: uses implicit conversionCONCAT (inv_amt, inv_date): requires explicit conversioninv_date = #39;15-february-2008#39;: uses implicit conversioninv_no BETWEEN Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.281View the exhibit and examine the description for the SALES and CHANNELS tables.You issued the following SQL statement to insert a row in the SALES table:INSERT INTO sales VALUES(23, 2300, SYSDATE, (SELECT channel_idFROM channelsWHERE channel_desc=#39;Direct Sales#39;), 12, 1, 500);Which statement is true regarding the execution of the above statement?The statement will execute and the new row will be inserted in Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.291View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.Evaluate the following SQL command:SQLgt; SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit FROM orders o JOIN customers cUSING (customer_id)WHERE o.order_total gt; c.credit_limit FOR UPDATEORDER BY o.order_id;Which two statements are true regarding the outcome of the above query? (Choose two.)It locks all the rows that satisfy Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.241View the Exhibit and examine the structure of the CUSTOMERS table.Evaluate the query statement:What would be the outcome of the above statement?It executes successfully.It produces an error because the condition on CUST_LAST_NAME is invalid.It executes successfully only if the CUST_CREDIT_LIMIT column does not contain any null values.It produces an error because the AND operator cannot be used to combine multiple Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.251Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAMELex De Haan Renske Ladwig Jose Manuel Urman Jason MallinYou want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:CUST NAME*** De Haan**** Manuel UrmanWhich two queries give the required output? (Choose two.)SELECT LPAD(SUBSTR(cust_name, INSTR(cust_name, #39; #39;)), LENGTH(cust_name), Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.261The CUSTOMERS table has these columns:A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?WHERE lower(country_address) = quot;francequot;WHERE lower(country_address) = #39;france#39;WHERE lower(country_address) IS #39;france#39;WHERE lower(country_address) = #39;%france%#39;WHERE lower(country_address) LIKE %france%Correct Answer: BExplanation:WHERE Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.201The EMPLOYEES table has these columns: LAST NAME. VARCHAR2(35)SALARY. NUMBER(8, 2) HIRE_DATE. DATEManagement 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?Column definitions cannot be altered to add DEFAULT values.A change to the DEFAULT value affects only subsequent Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.211Evaluate the following SQL statements:Which is the correct output of the above query? A. 00-300, 54-02, 00 11:12:10.123457B. 00-300, 00-650, 00 11:12:10.123457C. 25-00, 54-02, 00 11:12:10.123457D. 25-00, 00-650, 00 11:12:10.123457Correct Answer: C Question No.212Which two statements are true regarding the ORDER BY clause? (Choose two.)It is executed first in the query execution.It must be the last clause Read more [...]

Get Full Version of the Examhttp://www.EnsurePass.com/1z0-061.html Question No.221Which statement is true regarding sub queries?The LIKE operator cannot be used with single- row subqueries.The NOT IN operator is equivalent to IS NULL with single- row subqueries.C. =ANY and =ALL operators have the same functionality in multiple- row subqueries.D. The NOT operator can be used with IN, ANY, and ALL operators in multiple- row subqueries.Correct Answer: DExplanation:Using the ANY Operator in Multiple-Row Read more [...]