SQL*Plus & Oracle Basics — Test 1

Correct Answer: B. CONNECT hr/hr@orcl
Explanation: CONNECT username/password@service switches the session to another account.

Correct Answer: B. SHOW USER
Explanation: SHOW USER prints 'USER is "HR"'. SELECT USER FROM dual gives the same in SQL.

Correct Answer: B. SPOOL
Explanation: SPOOL output.txt starts capturing; SPOOL OFF stops and closes the file.

Correct Answer: B. @
Explanation: @script.sql executes the script. @@ runs a script located relative to the calling script.

Correct Answer: A. Oracle Database Express Edition (XE)
Explanation: XE is free to develop and deploy but has limits on CPU, memory and user data.

Correct Answer: B. In uppercase (EMP)
Explanation: Unquoted identifiers are case-insensitive and stored in uppercase. Quoted identifiers like "Emp" are case-sensitive.