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?
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?
When the command $ sqlplus hr/hr@orcl @abc.sql is executed, the following happens: sqlplus is the Oracle command-line utility to connect to an Oracle database. The command hr/hr@orcl specifies the username (hr) and password (hr) to connect to the database instance identified by the alias orcl. The @abc.sql part of the command specifies a SQL script file (abc.sql) to be executed after connecting to the database. Therefore, upon execution, HR will be connected to the orcl database instance, and the abc.sql script will be executed.
B looks OK the answer?
yes B is correct
yes, i agree
B is correct
The correct answer is B. The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed. The sqlplus command is used to connect to an Oracle database and execute SQL statements. The @ symbol is used to specify a script file to be executed. In the command $ sqlplus hr/hr@orcl @abc.sql, the user HR is connecting to the orcl database instance and specifying the abc.sql script to be executed. The command will succeed and HR will be connected to the orcl database instance and the abc.sql script will be executed.
B is correct. I tried it in my personal environment and it worked. What happens is that the hr user connects to the orcl instance and then executes the sql script successfully.
The correct answer is B, this time I agree with the one indicated.
la respuesta correcta es la B, esta vez coincido con la indicada.
Provided answer is correct.
B is correct
B is correct
hey C is correct because orcl is alias not database instance. and full path need.
Sorry but you're wrong. if you're in linux path that have the script, full path not needed.
It's false, as the example is exposed you can also omit the extension of the file (.sql)
C is correct. orcl is a host not database instance
You are wrong!!!!
Yeah, on this case you're wrong