Download Oracle Database 12c SQL Fundamentals.1z0-061.Pass4Sure.2015-04-04.84q.vcex

Vendor: Oracle
Exam Code: 1z0-061
Exam Name: Oracle Database 12c SQL Fundamentals
Date: Apr 04, 2015
File Size: 10 MB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: TAURUSSIM_20OFF

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
Evaluate the following SQL statement:
  
Which statement is true regarding the outcome of the above query?
  1. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
  2. It produces an error because positional notation cannot be used in the order by clause with set operators.
  3. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.
  4. 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.
Correct answer: D
Explanation:
fine asnwer.
fine asnwer.
Question 2
Which three tasks can be performed using SQL functions built into Oracle Database?
  1. Displaying a date in a nondefault format
  2. Finding the number of characters in an expression
  3. Substituting a character string in a text expression with a specified string
  4. Combining more than two columns or expressions into a single column in the output
Correct answer: ABC
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? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: BCD
Question 4
Which three SQL statements would display the value 1890.55 as $1, 890.55? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
  5. Option E
Correct answer: ADE
Explanation:
genuine answer.
genuine answer.
Question 5
Evaluate the following SQL commands:
  
The command to create a table fails. Identify the two reasons for the SQL statement failure?
  1. You cannot use SYSDATE in the condition of a check constraint.
  2. You cannot use the BETWEEN clause in the condition of a check constraint.
  3. You cannot use the NEXTVAL sequence value as a default value for a column. 
  4. You cannot use ORD_NO and ITEM_NO columns as a composite primary key because ORD_NO is also the foreign key.
Correct answer: AC
Explanation:
CHECK Constraint The CHECK constraint defines a condition that each row must satisfy. The condition can use the same constructs as the query conditions, with the following exceptions:References to the CURRVAL, NEXTVAL, LEVEL, and ROWNUM pseudocolumns Calls to SYSDATE, UID, USER, and USERENV functions Queries that refer to other values in other rows A single column can have multiple CHECK constraints that refer to the column in its definition. There is no limit to the number of CHECK constraints that you can define on a column. CHECK constraints can be defined at the column level or table level. CREATE TABLE employees (... Salary NUMBER(8, 2) CONSTRAINT emp_salary_min CHECK (salary > 0),
CHECK Constraint 
The CHECK constraint defines a condition that each row must satisfy. The condition can use the same constructs as the query conditions, with the following exceptions:
References to the CURRVAL, NEXTVAL, LEVEL, and ROWNUM pseudocolumns Calls to SYSDATE, UID, USER, and USERENV functions 
Queries that refer to other values in other rows 
A single column can have multiple CHECK constraints that refer to the column in its definition. There is no limit to the number of CHECK constraints that you can define on a column. CHECK constraints can be defined at the column level or table level. 
CREATE TABLE employees 
(... 
Salary NUMBER(8, 2) CONSTRAINT emp_salary_min CHECK (salary > 0),
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?
  1. It executes successfully and generates the required result.
  2. It produces an error because count(*) should be specified in the SELECT clause also.
  3. It produces an error because count{*) should be only in the HAVING clause and not in the WHERE clause.
  4. It executes successfully but produces no result because COUNT (prod_id) should be used instead of COUNT (*).
Correct answer: C
Explanation:
Restricting Group Results with the HAVING Clause You use the HAVING clause to specify the groups that are to be displayed, thus further restricting the groups on the basis of aggregate information. In the syntax, group_condition restricts the groups of rows returned to those groups for which the specified condition is true. The Oracle server performs the following steps when you use the HAVING clause:Rows are grouped. The group function is applied to the group. The groups that match the criteria in the HAVING clause are displayed. The HAVING clause can precede the GROUP BY clause, but it is recommended that you place the GROUP BY clause first because it is more logical. Groups are formed and group functions are calculated before the HAVING clause is applied to the groups in the SELECT list. Note: The WHERE clause restricts rows, whereas the HAVING clause restricts groups.
Restricting Group Results with the HAVING Clause 
You use the HAVING clause to specify the groups that are to be displayed, thus further restricting the groups on the basis of aggregate information. 
In the syntax, group_condition restricts the groups of rows returned to those groups for which the specified condition is true. 
The Oracle server performs the following steps when you use the HAVING clause:
  1. Rows are grouped. 
  2. The group function is applied to the group. 
  3. The groups that match the criteria in the HAVING clause are displayed. 
The HAVING clause can precede the GROUP BY clause, but it is recommended that you place the GROUP BY clause first because it is more logical. Groups are formed and group functions are calculated before the HAVING clause is applied to the groups in the SELECT list. Note: The WHERE clause restricts rows, whereas the HAVING clause restricts groups.
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? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: D
Explanation:
NVL Function Converts a null value to an actual value:Data types that can be used are date, character, and number. Data types must match:NVL(commission_pct, 0) NVL(hire_date, '01-JAN-97') NVL(job_id, 'No Job Yet')
NVL Function 
Converts a null value to an actual value:
Data types that can be used are date, character, and number. 
Data types must match:
NVL(commission_pct, 0) 
NVL(hire_date, '01-JAN-97') 
NVL(job_id, 'No Job Yet')
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?
  1. It shows COST_REMARK for all the promos in the table.
  2. It produces an error because the SUBQUERY gives an error.
  3. It shows COST_REMARK for all the promos in the promo category 'TV'
  4. It produces an error because SUBQUERIES cannot be used with the case expression.
Correct answer: A
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?
  1. SELECT transdate + '10' FROM cust_trans;
  2. SELECT * FROM cust_trans WHERE transdate = '01-01-07';
  3. SELECT transamt FROM cust_trans WHERE custno > "11";
  4. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
  5. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
Correct answer: ACD
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?
  1. The values clause cannot be used in an INSERT with a subquery.
  2. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
  3. The where clause cannot be used in a subquery embedded in an INSERT statement.
  4. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
Correct answer: A
Explanation:
Copying Rows from Another Table Write your INSERT statement with a subquery:Do not use the VALUES clause. Match the number of columns in the INSERT clause to those in the subquery. Inserts all the rows returned by the subquery in the table, sales_reps.
Copying Rows from Another Table 
Write your INSERT statement with a subquery:
Do not use the VALUES clause. 
Match the number of columns in the INSERT clause to those in the subquery. Inserts all the rows returned by the subquery in the table, sales_reps.
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!