Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 201:

  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 202:

  Examine these statements and the result:

  

  Now examine this command:

  

  What must replace MISSING CLAUSE for CUSTOMER_SEQ.NEXTVAL to return 11?

  A. NOCACHE
  B. INCREMENT BY 10
  C. START WITH 11
  D. MINVALUE 11
  E. CYCLE 11
  B. INCREMENT BY 10

• Question 203:

  Examine the ORDER _ITEms table:

  

  Which two queries return rows where QUANTITY is a multiple of ten? (Choose two.)

  A. SELECT * FROM order_items WHERE quantity / 10 - TRUNC(quantity)
  B. SELECT * FROM order_items WHERE MOD(quantity, 10) - 0;
  C. SELECT * FROM order_items WHERE FLOOR(quantity / 10) = TRUNC(quantity / 10);
  D. SELECT * FROM order_items WHERE quantity = TRUNC(quantity, -1);
  E. SELECT * FROM order_items WHERE quantity = ROUND(quantity, 1);
  B. SELECT * FROM order_items WHERE MOD(quantity, 10) - 0;
  D. SELECT * FROM order_items WHERE quantity = TRUNC(quantity, -1);

• Question 204:

  Examine this statement:

  

  Which two statements are true?

  A. All remaining employee names will appear in an ascending order
  B. The names of employees remaining the maximum salary will appear first in an ascending order
  C. All remaining employee names will appear in ascending order
  D. All remaining employee names will appear in descending order
  E. The names of employees maximum salary will appear fist to descending order
  F. The names of employees maximum salary will appear fist to ascending order
  C. All remaining employee names will appear in ascending order
  E. The names of employees maximum salary will appear fist to descending order

• Question 205:

  Examine this query:

  What is the result?

  A. an error
  B. no rows
  C. 1 row
  D. 3 rows
  E. 6 rows
  F. 8 rows
  B. no rows

• Question 206:

  Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

  A. An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
  B. A column that is set to UNUSED still counts towards the limit of 1000 columns per table.
  C. A DROP COLUMN command can be rolled back.
  D. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
  E. An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
  F. Partition key columns cannot be dropped.
  B. A column that is set to UNUSED still counts towards the limit of 1000 columns per table.
  D. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
  F. Partition key columns cannot be dropped.

• Question 207:

  Which two statements are true about Oracle databases and SQL? (Choose two.)

  A. Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.
  B. The database guarantees read consistency at select level on user-created tablers.
  C. When you execute an UPDATE statement, the database instance locks each updated row.
  D. A query can access only tables within the same schema.
  E. A user can be the owner of multiple schemas In the same database.
  B. The database guarantees read consistency at select level on user-created tablers.
  C. When you execute an UPDATE statement, the database instance locks each updated row.

• Question 208:

  Examine the description of the EMPLOYEES table

  

  You write this failing statement:

  

  Which clause causes the error?

  A. ORDER BY
  B. WHERE
  C. GROUP BY
  D. SELECT
  C. GROUP BY

• Question 209:

  View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.

  

  The PROD_ID column is the foreign key in the SALES table, Which references the PRODUCTS table.

  Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.

  Evaluate the following CREATE TABLE command:

  CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)

  AS SELECT prod_id, cust_id, time_id FROM sales;

  Which statement is true regarding the above command?

  A. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
  B. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
  C. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
  D. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.
  A. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.

• Question 210:

  Examine the description of the EMPLOYEES table:

  

  Which query is valid?

  A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
  B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
  C. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
  D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
  B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;