Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 161:

  Examine the structure of the MARKS table:

  Exhibit:

  

  Which two statements would execute successfully? (Choose two.)

  A. SELECT student_name,subject1 FROM marks WHERE subject1 > AVG(subject1);
  B. SELECT student_name,SUM(subject1) FROM marks WHERE student_name LIKE 'R%';
  C. SELECT SUM(subject1+subject2+subject3) FROM marks WHERE student_name IS NULL;
  D. SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) FROM marks WHERE subject1 > subject2;
  C. SELECT SUM(subject1+subject2+subject3) FROM marks WHERE student_name IS NULL;
  D. SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1) FROM marks WHERE subject1 > subject2;

• Question 162:

  Which four are attributes of single row functions? (Choose four.)

  A. cannot be nested
  B. manipulate data items
  C. act on each row returned
  D. return one result per row
  E. accept only one argument and return only one value
  F. accept arguments which can be a column or an expression
  B. manipulate data items
  C. act on each row returned
  D. return one result per row
  F. accept arguments which can be a column or an expression

• Question 163:

  Which two statements are true regarding indexes? (Choose two.)

  A. They can be created on tables and clusters.
  B. They can be created on tables and simple views.
  C. You can create only one index by using the same columns.
  D. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.
  A. They can be created on tables and clusters.
  D. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.

• Question 164:

  View the Exhibit; e xamine the structure of the PROMOTIONS table.

  

  Each promotion has a duration of at least seven days.

  Your manager has asked you to generate a report, which provides the weekly cost for each promotion done to l date.

  Which query would achieve the required result?

  A. SELECT promo_name, promo_cost/promo_end_date-promo_begin_date/7 FROM promotions;
  B. SELECT promo_name,(promo_cost/promo_end_date-promo_begin_date)/7 FROM promotions;
  C. SELECT promo_name, promo_cost/(promo_end_date-promo_begin_date/7) FROM promotions;
  D. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;
  D. SELECT promo_name, promo_cost/((promo_end_date-promo_begin_date)/7) FROM promotions;

• Question 165:

  Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

  

  Which DELETE statement is valid?

  A. DELETE FROM employees WHERE employee_id = (SELECT employee_id FROM employees);
  B. DELETE * FROM employees WHERE employee_id=(SELECT employee_id FROM new_employees);
  C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey');
  D. DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey');
  C. DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = `Carrey');

• Question 166:

  You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:

  

  Examine the structure of PRODUCTS table.

  Using the PRODUCTS table, you issue the following query to generate the names, current list price and discounted list price for all those products whose list price fails below $10 after a discount of 25% is applied on it.

  Exhibit:

  

  The query generates an error.

  What is the reason of generating error?

  A. The column alias should be put in uppercase and enclosed within double quotation marks in the WHERE clause
  B. The parenthesis should be added to enclose the entire expression
  C. The column alias should be replaced with the expression in the WHERE clause
  D. The double quotation marks should be removed from the column alias
  C. The column alias should be replaced with the expression in the WHERE clause

• Question 167:

  Examine the statement:

  GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;

  Which two are true? (Choose two.)

  A. MANAGER must be a role.
  B. It allows the MANAGER to pass the specified privileges on to other users.
  C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
  D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
  E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
  F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
  B. It allows the MANAGER to pass the specified privileges on to other users.
  E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

• Question 168:

  Using the CUSTOMERS table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which query would give the required result?

  A. SELECT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;
  B. SELECT DISTINCT cust_income_level, DISTINCT cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;
  C. SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;
  D. SELECT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;
  C. SELECT DISTINCT cust_income_level ' ' cust_credit_limit * 0.50 AS "50% Credit Limit" FROM customers;

• Question 169:

  In which two cases would you use an outer join? (Choose two.)

  A. The tables being joined have NOT NULL columns.
  B. The tables being joined have only matched data.
  C. The columns being joined have NULL values.
  D. The tables being joined have only unmatched data.
  E. The tables being joined have both matched and unmatched data.
  F. Only when the tables have a primary key/foreign key relationship.
  C. The columns being joined have NULL values.
  E. The tables being joined have both matched and unmatched data.

• Question 170:

  Examine the structure of the TRANSACTIONS table:

  Name Null Type

  TRANS_ID NOT NULL NUMBER(3)

  CUST_NAME VARCHAR2(30)

  TRANS_DATE DATE

  TRANS_AMT NUMBER(10,2)

  You want to display the transaction date and specify whether it is a weekday or weekend.

  Evaluate the following two queries:

  

  Which statement is true regarding the above queries?

  A. Both give wrong results.
  B. Both give the correct result.
  C. Only the first query gives the correct result.
  D. Only the second query gives the correct result.
  C. Only the first query gives the correct result.