Oracle
1Z0-082 · Question #24
A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command: $ sqlplus hr/hr@orcl @abc.sql What will happen upon execution?
The correct answer is B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql. See the full explanation below for the reasoning.
Manage the Database Instance
Question
A script abc.sql must be executed to perform a job. A database user HR, who is defined in this database, executes this command:
$ sqlplus hr/hr@orcl @abc.sql What will happen upon execution?
Options
- AThe command succeeds and HR will be connected to the orcl and abc.sql databases
- BThe command succeeds and HR will be connected to the orcl database instance, and the abc.sql
- CThe command fails because the script must refer to the full path name
- DThe command fails and reports an error because @ is used twice
How the community answered
(37 responses)- A5% (2)
- B84% (31)
- C3% (1)
- D8% (3)
Topics
#SQL*Plus#command line connection#script execution#connect string
Community Discussion
No community discussion yet for this question.