Join the discussion
Question 18/32
Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc. What will happen and why?
Correct Answer: E
A .False. "Logging out to the abc database" is nonsensical; abc is a script, not a database.
B .False. SQL*Plus finds abc.sql in the current directory by default; a full path isn't required unless it's elsewhere.
C .False. The first @ specifies the TNS alias (orcl), the second runs the script (@abc); this is valid syntax.
D & E.True (identical options). The command connects to orcl via TNSNAMES.ORA, authenticates HR, and executes abc.sql.
Mechanics:sqlplus hr/hr@orcl resolves orcl to a listener address, connects, and@abc runs the script post-login.
B .False. SQL*Plus finds abc.sql in the current directory by default; a full path isn't required unless it's elsewhere.
C .False. The first @ specifies the TNS alias (orcl), the second runs the script (@abc); this is valid syntax.
D & E.True (identical options). The command connects to orcl via TNSNAMES.ORA, authenticates HR, and executes abc.sql.
Mechanics:sqlplus hr/hr@orcl resolves orcl to a listener address, connects, and@abc runs the script post-login.
Add Comments
- Other Question (32q)
- Q1. Which three Oracle database space management features will work with both Dictionary and L...
- Q2. Which two statements are true about the configuration and use of UNDO?...
- Q3. Which two account management capabilities can be configured using Oracle profiles?...
- Q4. What are Oracle Database Metrics?
- Q5. Which three statements are true about Oracle Managed Files (OMF)?...
- Q6. Which two statements are true about the UNLIMITED TABLESPACE system privilege and space qu...
- Q7. Which two Oracle database space management features require the use of locally managed tab...
- Q8. Which two are benefits of external tables?
- Q9. Which of the following is true about the status of a PDB that has been unplugged from a CD...
- Q10. Which three tasks are part of the predefined Automated Maintenance Tasks?...
- Q11. Which two statements are true about database instances and Real Application Clusters (RAC)...
- Q12. Which three statements are true about resumable space allocation in Oracle databases?...
- Q13. What are Optimizer Statistics?
- Q14. Which two statements are true about the PMON background process?...
- Q15. Which three statements are true about row chaining and row migration done by Oracle databa...
- Q16. Which statement is true about database links?
- Q17. You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of...
- Q18. Script abc.sql must be executed to perform a certain task. User HR with password HR exists...
- Q19. Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf...
- Q20. Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?...
- Q21. Examine these commands: [oracle@host01 ~]$ sqlplus u1/oracle SQL> SELECT * FROM emp; EN...
- Q22. What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;...
- Q23. You must create a tablespace of nonstandard block size in a new file system and plan to us...
- Q24. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q25. Which two AWR-based tools listed below are part of Oracle Database self-tuning components?...
- Q26. Which three statements are true about dynamic performance views?...
- Q27. One of your database instances was shut down normally and then started in NOMOUNT state. Y...
- Q28. Which three statements are true about UNDO and REDO?...
- Q29. Which three statements are true about a dedicated server configuration?...
- Q30. Which two statements describe why Database Auditing is a security requirement?...
- Q31. Which three are benefits of using temp UNDO when performing DML on global temporary tables...
- Q32. What memory structure caches the data dictionary providing access to all database user pro...
