Download Oracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcex

Oracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcexOracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcexOracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcexOracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcexOracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcexOracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcex
Exam Oracle Database 11g : SQL Fundamentals I
Number 1Z0-051
File Name Oracle.PracticeDumps.1z0-051.2018-03-22.1e.152q.vcex
Size 8.99 Mb
Posted August 08, 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

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: The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table
  • C: The WHERE clause cannot be used in a sub query embedded in an INSERT statement
  • D: Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match
Question 2

View the Exhibit and examine the description for the CUSTOMERS table. 

 
 
 
You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where 
CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the task?


  • A: UPDATE customersSET cust_credit_limit = NULLWHERE CUST_INCOME_LEVEL = NULL;
  • B: UPDATE customersSET cust_credit_limit = NULLWHERE cust_income_level IS NULL;
  • C: UPDATE customersSET cust_credit_limit = TO_NUMBER(NULL)WHERE cust_income_level = TO_NUMBER(NULL);
  • D: UPDATE customersSET cust_credit_limit = TO_NUMBER(' ',9999)WHERE cust_income_level IS NULL;
Question 3

Which two statements about sub queries are true? (Choose two.)


  • A: A sub query should retrieve only one row.
  • B: A sub query can retrieve zero or more rows.
  • C: A sub query can be used only in SQL query statements.
  • D: Sub queries CANNOT be nested by more than two levels.
  • E: A sub query CANNOT be used in an SQL query statement that uses group functions.
  • F: When a sub query is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the sub query should contain only one column.
Question 4

View the Exhibit and examine the structure of the PROMOTIONS table. 

 
  

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category. 
Which query would give you the required output?


  • A: SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT MAX(promo_begin_date) FROM promotions )ANDpromo_category = 'INTERNET';
  • B: SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE promo_category='INTERNET');
  • C: SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');
  • D: SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ANY (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');
Question 5

Which are /SQL*Plus commands? (Choose all that apply.)


  • A: INSERT
  • B: UPDATE
  • C: SELECT
  • D: DESCRIBE
  • E: DELETE
  • F: RENAME
Question 6

Which two statements are true regarding the COUNT function? (Choose two.)


  • A: COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
  • B: COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column
  • C: COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column
  • D: A SELECT statement using COUNT function with a DISTINCT keyword cannot have a WHERE clause
  • E: The COUNT function can be used only for CHAR, VARCHAR2 and NUMBER data types
Question 7

Examine the description of the EMP_DETAILS table given below:
Exhibit:

 
 
 
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? (Choose two.)


  • A: An EMP_IMAGE column can be included in the GROUP BY clause
  • B: You cannot add a new column to the table with LONG as the data type
  • C: An EMP_IMAGE column cannot be included in the ORDER BY clause
  • D: You can alter the table to include the NOT NULL constraint on the EMP_IMAGE column
Question 8

Which CREATE TABLE statement is valid?


  • A: CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMARY KEY,ord_date DATE NOT NULL);
  • B: CREATE TABLE ord_details(ord_no NUMBER(2) UNIQUE, NOT NULL,item_no NUMBER(3),ord_date DATE DEFAULT SYSDATE NOT NULL);
  • C: CREATE TABLE ord_details(ord_no NUMBER(2) ,item_no NUMBER(3),ord_date DATE DEFAULT NOT NULL,CONSTRAINT ord_uq UNIQUE (ord_no),CONSTRAINT ord_pk PRIMARY KEY (ord_no));
  • D: CREATE TABLE ord_details(ord_no NUMBER(2),item_no NUMBER(3),ord_date DATE DEFAULT SYSDATE NOT NULL,CONSTRAINT ord_pk PRIMARY KEY (ord_no, item_no));
Question 9

See the exhibit and examine the structure of the CUSTOMERS and GRADES tables:

 
 
 
You need to display names and grades of customers who have the highest credit limit. 
Which two SQL statements would accomplish the task? (Choose two.)


  • A: SELECT custname, gradeFROM customers, gradesWHERE (SELECT MAX(cust_credit_limit)FROM customers) BETWEEN startval and endval;
  • B: SELECT custname, gradeFROM customers, gradesWHERE (SELECT MAX(cust_credit_limit)FROM customers) BETWEEN startval and endvalAND cust_credit_limit BETWEEN startval AND endval;
  • C: SELECT custname, gradeFROM customers, gradesWHERE cust_credit_limit = (SELECT MAX(cust_credit_limit)FROM customers)AND cust_credit_limit BETWEEN startval AND endval;
  • D: SELECT custname, gradeFROM customers , gradesWHERE cust_credit_limit IN (SELECT MAX(cust_credit_limit)FROM customers)AND MAX(cust_credit_limit) BETWEEN startval AND endval;
Question 10

See 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: SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT" FROM customers;
  • B: SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT" FROM customers;
  • C: SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT" FROM customers;
  • D: SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT" FROM customers;



Comments