Oracle 1Z0-051 Online Practice Questions and Exam Preparation

Oracle 1Z0-051 Online Questions & Answers

• Question 251:

  Which two statements are true about sequences created in a single instance database? (Choose two.)

  A. CURRVAL is used to refer to the last sequence number that has been generated
  B. DELETE would remove a sequence from the database
  C. The numbers generated by a sequence can be used only for one table
  D. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement
  E. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted
  A. CURRVAL is used to refer to the last sequence number that has been generated
  D. When the MAXVALUE limit for a sequence is reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement

• Question 252:

  Which two statements are true about WHERE and HAVING clauses? (Choose two)

  A. A WHERE clause can be used to restrict both rows and groups.
  B. A WHERE clause can be used to restrict rows only.
  C. A HAVING clause can be used to restrict both rows and groups.
  D. A HAVING clause can be used to restrict groups only.
  E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
  F. A HAVING clause CANNOT be used in sub queries.
  B. A WHERE clause can be used to restrict rows only.
  D. A HAVING clause can be used to restrict groups only.

• Question 253:

  Which substitution variable would you use if you want to reuse the variable without prompting the user each time?

  A. and
  B. ACCEPT
  C. PROMPT
  D. andand
  D. andand

• Question 254:

  View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format: CATEGORIES 5MP Digital Photo Camera's category is Photo Y Box's category is Electronics Envoy Ambassador's category is Hardware Which two queries would give the required output? (Choose two.)

  

  A. SELECT prod_name || q'''s category is ' || prod_category CATEGORIES FROM products;
  B. SELECT prod_name || q'['s ]'category is ' || prod_category CATEGORIES FROM products;
  C. SELECT prod_name || q'\'s\' || ' category is ' || prod_category CATEGORIES FROM products;
  D. SELECT prod_name || q'
  C. SELECT prod_name || q'\'s\' || ' category is ' || prod_category CATEGORIES FROM products;
  D. SELECT prod_name || q'

• Question 255:

  Which statement describes the ROWID data type?

  A. Binary data up to 4 gigabytes.
  B. Character data up to 4 gigabytes.
  C. Raw binary data of variable length up to 2 gigabytes.
  D. Binary data stored in an external file, up to 4 gigabytes.
  E. A hexadecimal string representing the unique address of a row in its table.
  E. A hexadecimal string representing the unique address of a row in its table.

• Question 256:

  View the Exhibit and examine the structure of the CUSTOMERS table. Exhibit:

  

  you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name 'king' and whose credit limit is less than the maximum credit limit in countries that have customers with the last name 'king'.

  

  Which statement is true regarding the outcome of the above query?

  A. It produces an error and the < operator should be replaced by < ANY to get the required output
  B. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main query to get the required output
  C. It executes and shows the required result
  D. It produces an error and the < operator should be replaced by < ALL to get the required output
  C. It executes and shows the required result

• Question 257:

  Evaluate the following two queries:

  Exhibit:

  

  Exhibit:

  

  Which statement is true regarding the above two queries?

  A. Performance would improve in query 2 only if there are null values in the CUST_CREDIT_LIMIT column
  B. Performance would degrade in query 2
  C. There would be no change in performance
  D. Performance would improve in query 2
  C. There would be no change in performance

• Question 258:

  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
  A. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
  C. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column

• Question 259:

  View the Exhibit and examine the data in the PRODUCTS table. You need to display product names from the PRODUCTS table that belong to the 'Software/Other1 category with minimum prices as either $2000 or $4000 and no unit of measure. You issue thej following query:

  

  Which statement is true regarding the above query?

  

  A. It executes successfully but returns no result.
  B. It executes successfully and returns the required result.
  C. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
  D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
  A. It executes successfully but returns no result.

• Question 260:

  Evaluate the following query:

  SELECT INTERVAL '300' MONTH,

  INTERVAL '54-2' YEAR TO MONTH,

  INTERVAL '11:12:10.1234567' HOUR TO SECOND

  FROM dual;

  What is the correct output of the above query?

  A. +25-00 , +54-02, +00 11:12:10.123457
  B. +00-300, +54-02, +00 11:12:10.123457
  C. +25-00 , +00-650, +00 11:12:10.123457
  D. +00-300 , +00-650, +00 11:12:10.123457
  A. +25-00 , +54-02, +00 11:12:10.123457