ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 214 discussion

Actual exam question from Oracle's 1z0-062
Question #: 214
Topic #: 1
[All 1z0-062 Questions]

Examine the parameter settings in your local ORCL database:

Examine the parameter settings for the remote SALES database:

As the SYS user, you issue the following command on ORCL:
CREATE PUBLIC DATABASE LINK sales.us.example.com USING sales1;
The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

  • A. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.
  • B. The SALES1 net service name should be known to both the local and remote databases.
  • C. Local database users who use this database link should have accounts and the required privileges in the remote database.
  • D. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.
  • E. Only the user creating the database link must have an account and the required privileges in the remote database.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️
by Clozoerie at Aug. 24, 2021, 6:37 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
NorwayOracle
3 years, 1 month ago
Selected Answer: AC
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects. If the value of GLOBAL_NAMES is false, then no check is performed. If you use or plan to use distributed processing, then Oracle recommends that you set this parameter to true to ensure the use of consistent naming conventions for databases and links in a networked environment.
upvoted 1 times
...
yosiw96816
3 years, 8 months ago
I think AC is correct Ref - https://docs.oracle.com/database/121/SQLRF/statements_5006.htm#SQLRF01205 If you omit both of those clauses (CONNECT TO user IDENTIFIED BY password / CONNECT TO CURRENT_USER), then the database link connects to the remote database as the locally connected user.
upvoted 3 times
...
Clozoerie
3 years, 8 months ago
AB more no?
upvoted 1 times
Clozoerie
3 years, 8 months ago
or more AD in fact
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago