Download Oracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcex

Oracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcexOracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcexOracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcexOracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcexOracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcexOracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.vcex

All in One

Exam Oracle Database 12c: SQL Fundamentals
Number 1Z0-061
File Name Oracle.Pass4sure.1z0-061.v4-8.2015-04-04.1e.84q.zip
Size 15.49 Mb
Posted January 30, 2018

Download




How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%






Demo Questions

Question 1

Evaluate the following SQL statement:
 
 
Which statement is true regarding the outcome of the above query?


  • A: It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
  • B: It produces an error because positional notation cannot be used in the order by clause with set operators.
  • C: It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.
  • D: It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.
Question 2

Which three tasks can be performed using SQL functions built into Oracle Database?


  • A: Displaying a date in a nondefault format
  • B: Finding the number of characters in an expression
  • C: Substituting a character string in a text expression with a specified string
  • D: Combining more than two columns or expressions into a single column in the output
Question 3

View the Exhibit and examine the description of SALES and PROMOTIONS tables. 
 
 
You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table has either blowout sale of everyday low prices as values. 
Which three delete statements are valid? 
 
 


  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D
Question 4

Which three SQL statements would display the value 1890.55 as $1, 890.55? 
 
 


  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D
  • E: Option E
Question 5

Evaluate the following SQL commands:
 
 
The command to create a table fails. Identify the two reasons for the SQL statement failure?


  • A: You cannot use SYSDATE in the condition of a check constraint.
  • B: You cannot use the BETWEEN clause in the condition of a check constraint.
  • C: You cannot use the NEXTVAL sequence value as a default value for a column. 
  • D: You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the foreign key.
Question 6

View the Exhibit and examine the structure of the SALES table. 
 
 
The following query is written to retrieve all those product IDs from the SALES table that have more than 55000 sold and have been ordered more than 10 times. 
 
 
Which statement is true regarding this SQL statement?


  • A: It executes successfully and generates the required result.
  • B: It produces an error because count(*) should be specified in the SELECT clause also.
  • C: It produces an error because count{*) should be only in the HAVING clause and not in the WHERE clause.
  • D: It executes successfully but produces no result because COUNT (prod_id) should be used instead of COUNT (*).
Question 7

View the Exhibit and examine the structure of the customers table. 
 
 
Using the customers table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed. 
Which SQL statement would produce the required result? 
 
 


  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D
Question 8

View the Exhibit and examine the structure of the promotions table. 
 
 
Evaluate the following SQL statement:
 
 
Which statement is true regarding the outcome of the above query?


  • A: It shows COST_REMARK for all the promos in the table.
  • B: It produces an error because the SUBQUERY gives an error.
  • C: It shows COST_REMARK for all the promos in the promo category 'TV'
  • D: It produces an error because SUBQUERIES cannot be used with the case expression.
Question 9

Examine the structure and data of the CUST_TRANS table:
 
 
Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table. Which three SQL statements would execute successfully?


  • A: SELECT transdate + '10' FROM cust_trans;
  • B: SELECT * FROM cust_trans WHERE transdate = '01-01-07';
  • C: SELECT transamt FROM cust_trans WHERE custno > "11";
  • D: SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
  • E: SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
Question 10

View the Exhibit and examine the structure of the customers table. 
 
 
NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the customers table. 
Evaluate the following insert statement:
 
 
The insert statement fails when executed. 
What could be the reason?


  • A: The values clause cannot be used in an INSERT with a subquery.
  • B: Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
  • C: The where clause cannot be used in a subquery embedded in an INSERT statement.
  • D: The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.



Comments