Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 171:

  Which two statements are true about Oracle synonyms? (Choose two.)

  A. Users must have the required privileges on the underlying objects to use public synonyms.
  B. Synonyms can be created for roles.
  C. Synonyms cannot be created for sequences.
  D. Synonyms cannot be created for synonyms.
  E. Synonyms can be created for packages.
  F. Users must have the DBA role to create public synonyms.
  A. Users must have the required privileges on the underlying objects to use public synonyms.
  E. Synonyms can be created for packages.

• Question 172:

  Which three statements are true about an ORDER BY clause?

  A. An ORDER BY clause always sorts NULL values last.
  B. An ORDER BY clause can perform a binary sort
  C. An ORDER BY clause can perform a linguistic sort
  D. By default an ORDERBY clause sorts rows in ascending order
  E. An ORDR BY clause will always precede a HAVI NG clause if both are used in the same top-level
  B. An ORDER BY clause can perform a binary sort
  C. An ORDER BY clause can perform a linguistic sort
  D. By default an ORDERBY clause sorts rows in ascending order

• Question 173:

  Examine the description of the EMPLOYEES table:

  

  Which two statements will run successfully?

  A. SELECT `The first_name is `` || first_name || `` FROM employees;
  B. SELECT `The first_name is ``` || first_name || ```` FROM employees;
  C. SELECT `The first_name is ``` || first_name || ``` FROM employees;
  D. SELECT `The first_name is ` || first_name || `` FROM employees;
  E. SELECT `The first_name is \`` || first_name || `\`` FROM employees;
  B. SELECT `The first_name is ``` || first_name || ```` FROM employees;
  D. SELECT `The first_name is ` || first_name || `` FROM employees;

• Question 174:

  Examine the description of the EMPLOYEES table:

  

  Which two queries will result in an error?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  F. Option F
  C. Option C
  E. Option E

• Question 175:

  Examine this query:

  SELECT INTERVAL '100' MONTH DURATION FROM DUAL;

  What will be the output?

  A. DURATION +08-04
  B. DUFATION +100
  C. DURATION +08
  D. an error
  A. DURATION +08-04

• Question 176:

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

  A. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
  B. DELETE would remove a sequence from the database.
  C. The numbers generated by an explicitly defined sequence can only be used to insert data in one table.
  D. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.
  E. When a database instance shuts down abnormally, sequence numbers that have been cached but not used are available again when the instance is restarted.
  A. When the MAXVALUE limit for a sequence is reached, it can be increased by using the ALTER SEQUENCE statement.
  D. CURRVAL is used to refer to the most recent sequence number that has been generated for a particular sequence.

  ---

  Explanation/Reference:

  References: http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_2012.htm#SQLRF00817 https://docs.oracle.com/cd/A84870_01/doc/server.816/a76989/ch26.htm

• Question 177:

  Examine the description of the SALES table:

  

  The SALES table has 55,000 rows. Examine this statement:

  

  Which two statements are true? (Choose two.)

  A. SALES1 is created with 55,000 rows.
  B. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
  C. SALES1 is created with no rows.
  D. SALES1 is created with 1 row
  E. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
  A. SALES1 is created with 55,000 rows.
  B. SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

• Question 178:

  Which three statements are true about defining relations between tables in a relational database? (Choose three.)

  A. Primary key columns allow null values.
  B. Every primary or unique key value must refer to a matching foreign key value.
  C. Every foreign key value must refer to a matching primary or unique key value.
  D. Foreign key columns allow null values.
  E. Unique key columns allow null values.
  C. Every foreign key value must refer to a matching primary or unique key value.
  D. Foreign key columns allow null values.
  E. Unique key columns allow null values.

• Question 179:

  In your session NLS_ DATE_ FORMAT is set to DD-MON_RR.

  Which two queries display the year as four digits?

  A. SELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;
  B. SELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;
  C. SELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;
  D. SELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;
  E. SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;
  F. SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;
  E. SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;
  F. SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

• Question 180:

  Which two statements are true about outer Joins?

  A. The outer join operator (+) can be used on both sides of the join condition in an outer join.
  B. An outer join is used to retrieve only the rows that do not meet the join condition.
  C. The IN operator cannot be used in a condition that Involves an outer join.
  D. A condition representing an outer join cannot be linked to another condition using the or logical operator.
  E. The outer join operator (+) is used next to the column of the table without the matching rows.
  C. The IN operator cannot be used in a condition that Involves an outer join.
  D. A condition representing an outer join cannot be linked to another condition using the or logical operator.