Download Oracle Database 12c SQL Fundamentals.1z0-061.BrainDumps.2018-10-27.206q.vcex

Vendor: Oracle
Exam Code: 1z0-061
Exam Name: Oracle Database 12c SQL Fundamentals
Date: Oct 27, 2018
File Size: 11 MB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

ProfExam Discount

Demo Questions

Question 1
You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New credit Limit. The column headings should have only the first letter of each word in uppercase. 
Which statement would accomplish this requirement? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: C
Explanation:
A column alias:Renames a column heading Is useful with calculations Immediately follows the column name (There can also be the optional AS keyword between the column name and the alias.) Requires double quotation marks if it contains spaces or special characters, or if it is case sensitive.
A column alias:
  • Renames a column heading 
  • Is useful with calculations 
  • Immediately follows the column name (There can also be the optional AS keyword between the column name and the alias.) 
  • Requires double quotation marks if it contains spaces or special characters, or if it is case sensitive.
Question 2
View the Exhibit and examine the data in the costs table. 
  
 
You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost. 
You issue the following query:
  
 
Which statement is true regarding the above query?
  1. It executes and produces the required result.
  2. It produces an error because an expression cannot be used in the order by clause.
  3. It produces an error because the DESC option cannot be used with an expression in the order by clause.
  4. It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause.
Correct answer: A
Question 3
View the Exhibits and examine the structures of the products, sales, and customers tables. 
  
  
  
You need to generate a report that gives details of the customer's last name, name of the product, and the quantity sold for a customers in 'Tokyo'. 
Which two queries give the required result? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: AC
Question 4
View the Exhibit and examine the structure of the products table. 
  
Evaluate the following query:
  
What would be the outcome of executing the above SQL statement?
  1. It produces an error.
  2. It shows the names of all products in the table.
  3. It shows the names of products whose list price is the second highest in the table.
  4. It shows the names of all products whose list price is less than the maximum list price.
Correct answer: C
Question 5
You issued the following command:
SQL> DROP TABLE employees; 
Which three statements are true?
  1. All uncommitted transactions are committed.
  2. All indexes and constraints defined on the table being dropped are also dropped.
  3. Sequences used in the employees table become invalid.
  4. The space used by the employees table is reclaimed immediately.
  5. The employees table can be recovered using the rollback command.
  6. The employees table is moved to the recycle bin.
Correct answer: ABF
Explanation:
A: If a user issues a DDL (CREATE, ALTER, or DROP) or DCL (GRANT or REVOKE) command, the transaction in progress (if any) will be committed.B: Dropping a table invalidates dependent objects, such as indexes and constraints.F: The DROP TABLE statement moves a table or object table to the recycle bin.Incorrect:Not B: In general sequences used in the table would not by affected when the table is dropped.Not D: Unless you specify the PURGE clause, the DROP TABLE statement does not result in space being released back to the tablespace for use by other objects, and the space continues to count toward the user's space quota.Not E: Dropping a table invalidates dependent objects and removes object privileges on the table. If you want to re-create the table, then you must regrant object privileges on the table, re-create the indexes, integrity constraints, and triggers for the table, and respecify its storage parameters.Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm
A: If a user issues a DDL (CREATE, ALTER, or DROP) or DCL (GRANT or REVOKE) command, the transaction in progress (if any) will be committed.
B: Dropping a table invalidates dependent objects, such as indexes and constraints.
F: The DROP TABLE statement moves a table or object table to the recycle bin.
Incorrect:
Not B: In general sequences used in the table would not by affected when the table is dropped.
Not D: Unless you specify the PURGE clause, the DROP TABLE statement does not result in space being released back to the tablespace for use by other objects, and the space continues to count toward the user's space quota.
Not E: Dropping a table invalidates dependent objects and removes object privileges on the table. If you want to re-create the table, then you must regrant object privileges on the table, re-create the indexes, integrity constraints, and triggers for the table, and respecify its storage parameters.
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9003.htm
Question 6
Examine the create table statements for the stores and sales tables. 
SQL>  CREATE  TABLE   stores(store_id  NUMBER(4)   CONSTRAINT  store_id_pk   PRIMARY  KEY, store_name  VARCHAR2(12), store_address   VARCHAR2(20), start_date   DATE); 
SQL>  CREATE  TABLE  sales(sales_id NUMBER(4)   CONSTRAINT   sales_id_pk   PRIMARY   KEY, item_id  NUMBER(4), quantity NUMBER(10), sales_date   DATE, store_id  NUMBER(4), CONSTRAINT   store_id_fk  FOREIGN  KEY(store_id)   REFERENCES stores(store_id)); 
You executed the following statement:
SQL> DELETE   from stores 
WHERE  store_id=900; 
The statement fails due to the integrity constraint error:
ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which three options ensure that the statement will execute successfully?
  1. Disable the primary key in the STORES table.
  2. Use CASCADE keyword with DELETE statement.
  3. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
  4. Disable the FOREIGN KEY in SALES table and then delete the rows.
  5. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.
Correct answer: ACD
Question 7
You want to create a sales table with the following column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified
PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified
Which statement would create the table? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: B
Explanation:
To specify the default value of payment field you must use DEFAULT 'CASH'. Reference: https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#SQLRF01402
To specify the default value of payment field you must use DEFAULT 'CASH'. 
Reference: https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#SQLRF01402
Question 8
Examine the data in the CUST_NAME column of the customers table. 
  
You need to display customers' second names where the second name starts with "Mc" or "MC." 
Which query gives the required output? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: B
Question 9
Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1) 
FROM DUAL; 
What would be the outcome?
  1. 16
  2. 100
  3. 160
  4. 200
  5. 150
Correct answer: C
Explanation:
Function Purpose ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.) TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero
Function Purpose 
ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.) 
TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero
Question 10
You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows. 
Which query will provide the required result? 
  
  1. Option A
  2. Option B
  3. Option C
  4. Option D
Correct answer: D
Explanation:
The FETCH statement must include WITH TIES. Incorrect:Not B: You cannot use ROWS WITH in a FETCH statement.
The FETCH statement must include WITH TIES. 
Incorrect:
Not B: You cannot use ROWS WITH in a FETCH statement.
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

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

Get Now!