Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 131:

  Which is an iSQL*Plus command?

  A. INSERT
  B. UPDATE
  C. SELECT
  D. DESCRIBE
  E. DELETE
  F. RENAME
  D. DESCRIBE

• Question 132:

  You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Winch two queries would achieve the required result? (Choose two.)

  A. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit DESC:
  B. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit:
  C. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST:
  D. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_last_name. cust_credit_limit NULLS LAST:
  B. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit:
  C. SELECT cust_last_name. cust_credit_limit FROM customers ORDER BY cust_credit_limit NULLS LAST:

• Question 133:

  View the Exhibit and examine the structure of the PRODUCT, COMPONENT, and PDT_COMP tables.

  

  In PRODUCT table, PDTNO is the primary key.

  In COMPONENT table, COMPNO is the primary key.

  In PDT_COMP table, (PDTNO,COMPNO) is the primary key, PDTNO is the foreign key referencing PDTNO in PRODUCT table and COMPNO is the foreign key referencing the COMPNO in COMPONENT table.

  You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.

  Evaluate the following query:

  SQL>SELECT pdtno,pdtname, compno,compname

  FROM product _____________ pdt_comp

  USING (pdtno) ____________ component USING(compno)

  WHERE compname IS NOT NULL;

  Which combination of joins used in the blanks in the above query gives the correct output?

  A. JOIN; JOIN
  B. FULL OUTER JOIN; FULL OUTER JOIN
  C. RIGHT OUTER JOIN; LEFT OUTER JOIN
  D. LEFT OUTER JOIN; RIGHT OUTER JOIN
  C. RIGHT OUTER JOIN; LEFT OUTER JOIN

• Question 134:

  Which statement correctly describes SQL and /SQL*Plus?

  A. Both SQL and /SQL*plus allow manipulation of values in the database.
  B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
  C. /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
  D. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.
  A. Both SQL and /SQL*plus allow manipulation of values in the database.

• Question 135:

  The CUSTOMERS table has the following structure: Exhibit:

  

  You need to write a query that does the following task:

  *

  Display the first name and tax amount of the customers. Tax is 5% of their credit limit

  *

  Only those customers whose income level has a value should be considered

  *

  Customers whose tax amount is null should not be considered Which statement accomplishes all the required tasks?

  A. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND tax_amount IS NOT NULL;
  B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;
  C. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level NULL AND tax_amount NULL;
  D. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE (cust_income_level,tax_amount) IS NOT NULL;
  B. SELECT cust_first_name, cust_credit_limit * .05 AS TAX_AMOUNT FROM customers WHERE cust_income_level IS NOT NULL AND cust_credit_limit IS NOT NULL;

• Question 136:

  The CUSTOMERS table has these columns:

  CUSTOMER_ID NUMBER(4) NOT NULL

  CUSTOMER_NAME VARCHAR2(100) NOT NULL

  CUSTOMER_ADDRESS VARCHAR2(150)

  CUSTOMER_PHONE VARCHAR2(20)

  You need to produce output that states "Dear Customer customer_name, ". The customer_name data values come from the CUSTOMER_NAME column in the CUSTOMERS table.

  Which statement produces this output?

  A. SELECT dear customer, customer_name, FROM customers;
  B. SELECT "Dear Customer", customer_name || ',' FROM customers;
  C. SELECT 'Dear Customer ' || customer_name ',' FROM customers;
  D. SELECT 'Dear Customer ' || customer_name || ',' FROM customers;
  E. SELECT "Dear Customer " || customer_name || "," FROM customers;
  F. SELECT 'Dear Customer ' || customer_name || ',' || FROM customers;
  D. SELECT 'Dear Customer ' || customer_name || ',' FROM customers;

• Question 137:

  The SQL statements executed in a user session as follows: Exhibit:

  

  Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

  A. Both the DELETE statements and the UPDATE statement are rolled back
  B. The rollback generates an error
  C. Only the DELETE statements are rolled back
  D. Only the seconds DELETE statement is rolled back
  E. No SQL statements are rolled back
  B. The rollback generates an error
  E. No SQL statements are rolled back

• Question 138:

  The CUSTOMERS table has these columns:

  

  The CUSTOMER_ID column is the primary key for the table.

  You need to determine how dispersed your customer base is. Which expression finds the number of different countries represented in the CUSTOMERS table?

  A. COUNT(UPPER(country_address))
  B. COUNT(DIFF(UPPER(country_address)))
  C. COUNT(UNIQUE(UPPER(country_address)))
  D. COUNT DISTINCT UPPER(country_address)
  E. COUNT(DISTINCT (UPPER(country_address)))
  E. COUNT(DISTINCT (UPPER(country_address)))

• Question 139:

  Examine the structure of the SHIPMENTS table:

  

  You want to generate a report that displays the PO_ID and the penalty amount to be paid if the SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day. Evaluate the following two queries:

  

  Which statement is true regarding the above commands?

  A. Both execute successfully and give correct results.
  B. Only the first query executes successfully but gives a wrong result.
  C. Only the first query executes successfully and gives the correct result.
  D. Only the second query executes successfully but gives a wrong result.
  E. Only the second query executes successfully and gives the correct result.
  C. Only the first query executes successfully and gives the correct result.

• Question 140:

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

  A. INSERT
  B. UPDATE
  C. SELECT
  D. DESCRIBE
  E. DELETE
  F. RENAME
  D. DESCRIBE