Download Oracle Database 12c-SQL Fundamentals.braindumps.1z0-061.2018-10-27.1e.206q.vcex

Download Dump

File Info

Exam Oracle Database 12c: SQL Fundamentals
Number 1z0-061
File Name Oracle Database 12c-SQL Fundamentals.braindumps.1z0-061.2018-10-27.1e.206q.vcex
Size 10.94 Mb
Posted October 27, 2018
Downloads 286



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
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? 

  

  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D



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?

  • A: It executes and produces the required result.
  • B: It produces an error because an expression cannot be used in the order by clause.
  • C: It produces an error because the DESC option cannot be used with an expression in the order by clause.
  • D: It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause.



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? 

  

  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D



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?

  • A: It produces an error.
  • B: It shows the names of all products in the table.
  • C: It shows the names of products whose list price is the second highest in the table.
  • D: It shows the names of all products whose list price is less than the maximum list price.



Question 5
You issued the following command:
SQL> DROP TABLE employees; 
Which three statements are true?

  • A: All uncommitted transactions are committed.
  • B: All indexes and constraints defined on the table being dropped are also dropped.
  • C: Sequences used in the employees table become invalid.
  • D: The space used by the employees table is reclaimed immediately.
  • E: The employees table can be recovered using the rollback command.
  • F: The employees table is moved to the recycle bin.



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?

  • A: Disable the primary key in the STORES table.
  • B: Use CASCADE keyword with DELETE statement.
  • C: DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
  • D: Disable the FOREIGN KEY in SALES table and then delete the rows.
  • E: Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.



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? 

  

  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D



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? 

  

  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D



Question 9
Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1) 
FROM DUAL; 
What would be the outcome?

  • A: 16
  • B: 100
  • C: 160
  • D: 200
  • E: 150



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? 

  

  • A: Option A
  • B: Option B
  • C: Option C
  • D: Option D









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset