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 (page: 4)

Page 4 of 77
PDF with 380 Questions

Which three statements are true about the Oracle join and ANSI join syntax?

  1. The Oracle join syntax supports natural joins.
  2. The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax.
  3. The Oracle join syntax supports creation of a Cartesian product of two tables.
  4. The SQL:1999 compliant ANSI join syntax supports natural joins.
  5. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
  6. The Oracle join syntax only supports right outer joins.
  7. The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.

Answer(s): A,D,G


Reference:

http://www.dba-oracle.com/oracle_tips_iso99_joins.htm



Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS?

  1. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.
  2. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.
  3. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.
  4. SYSDATE can be used in expressions only if the default date format is DD-MON-RR.
  5. SYSDATE can be queried only from the DUAL table.
  6. CURRENT_DATE returns the current date and time as per the session time zone.

Answer(s): E,F



The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.
You want to display the date of the first Monday after the completion of six months since hiring.
The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.
Which query can be used?

  1. SELECT emp_id, NEXT_DAY (MONTHS_BETWEEN (hire_date, SYSDATE), 6) FROM employees;
  2. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), ‘MONDAY’) FROM employees;
  3. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY(‘MONDAY’) FROM employees;
  4. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Answer(s): B


Reference:

http://www.dba-oracle.com/t_add_months.htm



You issued this command:


Which three statements are true?

  1. Views referencing HR.EMPLOYEES are dropped.
  2. All constraints defined on HR.EMPLOYEES are dropped.
  3. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
  4. The HR.EMPLOYEES table may be moved to the recycle bin.
  5. All indexes defined on HR.EMPLOYEES are dropped.
  6. Synonyms for HR.EMPLOYEES are dropped.

Answer(s): A,B,E


Reference:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables010.htm#ADMIN01505



Which two are true about dropping columns from a table?

  1. A column drop is implicitly committed.
  2. A column that is referenced by another column in any other table cannot be dropped.
  3. A column can be removed only if it contains no data.
  4. Multiple columns can be dropped simultaneously using the ALTER TABLE command.
  5. A column must be set as unused before it is dropped from a table.
  6. A primary key column cannot be dropped.

Answer(s): D,F


Reference:

https://oracle-base.com/articles/8i/dropping-columns



Viewing page 4 of 77



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

1Z0-071 Exam Discussions & Posts