Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-071

Free Oracle 1Z0-071 Exam Questions

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

  1. In a character sort, the values are case-sensitive.
  2. NULLs are not included in the sort operation.
  3. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.
  4. Numeric values are displayed in descending order if they have decimal positions.
  5. Column aliases can be used in the ORDER BY clause.

Answer(s): A

Explanation:

The ORDER BY clause performs case sensitive sorting with character values.



Which statement is true about the INTERSECT operator used in compound queries?

  1. INTERSECT is of lower precedence than UNION or UNION ALL.
  2. Multiple INTERSECT operators are not possible in the same SQL statement.
  3. It ignores NULLs.
  4. It processes NULLs in the selected columns.

Answer(s): D



Which two commands execute successfully?

-MANAGER is an existing role with no privileges or roles.
-EMP is an existing role containing the CREATE TABLE privilege.
-EMPLOYEES is an existing table in the HR schema.

  1. GRANT CREATE SEQUENCE TO manager, emp;
  2. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
  3. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;
  4. GRANT CREATETABLE, emp TP manager;
  5. GRANT CREATE TABLE, SELECT ON hr.employees TO manager;

Answer(s): A,C



Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

  1. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
  2. A TIMESTAMP data type column contains information about year, month, and day.
  3. The CURRENT_TIMESTAMP function returns data without time zone information.
  4. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
  5. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

Answer(s): A,C,E


Reference:

https://docs.oracle.com/database/121/NLSPG/ch4datetime.htm



Examine the description of the SALES1 table:


SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

  1. SUBTRACT
  2. INTERSECT
  3. UNION ALL
  4. UNION
  5. MINUS

Answer(s): E



Viewing page 10 of 77



Post your Comments and Discuss Oracle 1Z0-071 exam prep with other Community members:

1Z0-071 Exam Discussions & Posts