Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 271:

  Which two statements are true regarding the USING clause in table joins?(Choose two.)

  A. It can be used to join a maximum of three tables.
  B. It can be used to restrict the number of columns used in a NATURAL join.
  C. It can be used to access data from tables through equijoins as well as nonequijoins.
  D. It can be used to join tables that have columns with the same name and compatible data types.
  B. It can be used to restrict the number of columns used in a NATURAL join.
  D. It can be used to join tables that have columns with the same name and compatible data types.

• Question 272:

  What does the FORCE option for creating a view do?

  A. creates a view with constraints
  B. creates a view even if the underlying parent table has constraints
  C. creates a view in another schema even if you don't have privileges
  D. creates a view regardless of whether or not the base tables exist
  D. creates a view regardless of whether or not the base tables exist

• Question 273:

  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.
  A. It executes and produces the required result.

• Question 274:

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

  A. A sub query can retrieve zero or more rows.
  B. Only two sub queries can be placed at one level.
  C. A sub query can be used only in SQL query statements.
  D. A sub query can appeal* on either side of a comparison operator.
  E. There is no limit on the number of sub query levels in the WHERE clause of a SELECT statement.
  A. A sub query can retrieve zero or more rows.
  D. A sub query can appeal* on either side of a comparison operator.

• Question 275:

  Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

  A. Combining more than two columns or expressions into a single column in the output
  B. Displaying a date in a nondefault format
  C. Substituting a character string in a text expression with a specified string
  D. Finding the number of characters in an expression
  B. Displaying a date in a nondefault format
  C. Substituting a character string in a text expression with a specified string
  D. Finding the number of characters in an expression

• Question 276:

  Which statement is true regarding the default behavior of the ORDER BY clause?

  A. In a character sort, the values are case-sensitive
  B. NULL values are not considered at all by the sort operation
  C. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause
  D. Numeric values are displayed from the maximum to the minimum value if they have decimal positions
  A. In a character sort, the values are case-sensitive

• Question 277:

  Evaluate the following query:

  

  What would be the outcome of the above query?

  A. It produces an error because flower braces have been used.
  B. It produces an error because the data types are not matching.
  C. It executes successfully and introduces an 's at the end of each promo_name in the output.
  D. It executes successfully and displays the literal" {'s start date was} " for each row in the output.
  C. It executes successfully and introduces an 's at the end of each promo_name in the output.

• Question 278:

  See the Exhibit and Examine the structure of SALES and PROMOTIONS tables: Exhibit:

  

  You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values. Which DELETE statements are valid? (Choose all that apply.)

  A. DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'blowout sale') AND promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'everyday low price');
  B. DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'blowout sale') OR promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'everyday low price');
  C. DELETE FROM sales WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_name = 'blowout sale' OR promo_name = 'everyday low price');
  D. D DELETE FROM sales WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_name IN ('blowout sale','everyday low price'));
  B. DELETE FROM sales WHERE promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'blowout sale') OR promo_id = (SELECT promo_id FROM promotions WHERE promo_name = 'everyday low price');
  C. DELETE FROM sales WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_name = 'blowout sale' OR promo_name = 'everyday low price');
  D. D DELETE FROM sales WHERE promo_id IN (SELECT promo_id FROM promotions WHERE promo_name IN ('blowout sale','everyday low price'));

• Question 279:

  You need to extract details of those products in the SALES table where the PROD_ID column contains the string '_D123'. Which WHERE clause could be used in the SELECT statement to get the required output?

  A. WHERE prod_id LIKE '%_D123%' ESCAPE '_'
  B. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'
  C. WHERE prod_id LIKE '%_D123%' ESCAPE '%_'
  D. WHERE prod_id LIKE '%\_D123%' ESCAPE '\_'
  B. WHERE prod_id LIKE '%\_D123%' ESCAPE '\'

• Question 280:

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

  A. Savepoints are effective only for COMMIT.
  B. Savepoints may be used to ROLLBACK.
  C. Savepoints can be used for only DML statements.
  D. Savepoints are effective for both COMMIT and ROLLBACK.
  E. Savepoints can be used for both DML and DDL statements.
  B. Savepoints may be used to ROLLBACK.
  C. Savepoints can be used for only DML statements.