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: 9)

Page 9 of 77
PDF with 380 Questions

Which two statements are true about Oracle synonyms?

  1. A synonym can have a synonym.
  2. All private synonym names must be unique in the database.
  3. Any user can create a PUBLIC synonym.
  4. A synonym can be created on an object in a package.
  5. A synonym has an object number.

Answer(s): B,D


Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm



In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.

Which two statements are true about expressions using PROMO_BEGIN_DATE contained a query?

  1. PROMO_BEGIN_DATE – 5 will return a date.
  2. PROMO_BEGIN_DATE – SYSDATE will return a number.
  3. TO_NUMBER(PROMO_BEGIN_DATE) – 5 will return a number.
  4. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
  5. PROMO_BEGIN_DATE – SYSDATE will return an error.

Answer(s): B,D



Which statement is true about TRUNCATE and DELETE?

  1. You can never TRUNCATE a table if foreign key constraints will be violated.
  2. For large tables TRUNCATE is faster than DELETE.
  3. For tables with multiple indexes and triggers DELETE is faster than TRUNCATE.
  4. You can never DELETE rows from a table if foreign key constraints will be violated.

Answer(s): B


Reference:

https://www.sqlservercentral.com/articles/difference-between-truncate-and-delete



Which two are true about granting privileges on objects?

  1. An object privilege can be granted to other users only by the owner of that object.
  2. An object privilege can be granted to a role only by the owner of that object.
  3. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.
  4. The owner of an object acquires all object privileges on that object by default.
  5. The WITH GRANT OPTION clause can be used only by DBA users.

Answer(s): C,D


Reference:

https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1008214



You execute this query:



What is the result?

  1. It returns the date for the first Monday of the next month.
  2. It returns the date for the last Monday of the current month.
  3. It executes successfully but does not return any result.
  4. It generates an error.

Answer(s): A



Viewing page 9 of 77



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

1Z0-071 Exam Discussions & Posts