Multiple choice technology databases

Which two are attributes of /SQL* Plus? (Choose two).

  1. /SQL * Plus commands cannot be abbreviated

  2. /SQL* Plus commands are accessed from a browser.

  3. /SQL*Plus commands are used to manipulate data in tables

  4. /SQL* Plus command manipulate table definitions in the database

  5. /SQL* Plus is the Oracle proprietary interface for executing SQL statements.
Reveal answer Fill a bubble to check yourself
C,E Correct answer
Explanation

SQL*Plus is Oracle's command-line interface for executing SQL and PL/SQL statements. Option E correctly identifies it as Oracle's proprietary tool. Option C is correct because SQL*Plus allows you to run SQL statements (DML) to manipulate data in tables. Option A is false because SQL*Plus commands CAN be abbreviated (e.g., DESC for DESCRIBE). Option B is false because SQL*Plus is a command-line tool, not browser-based. Option D is misleading because while you can run DDL through SQL*Plus, table definition manipulation is done via SQL DDL commands, not SQL*Plus-specific commands.

AI explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) /SQL * Plus commands cannot be abbreviated - This option is incorrect. SQL*Plus commands can be abbreviated using a combination of the first few letters of the command.

Option B) /SQL* Plus commands are accessed from a browser - This option is incorrect. SQL*Plus commands are accessed through a command-line interface, not a browser.

Option C) /SQL*Plus commands are used to manipulate data in tables - This option is correct. SQL*Plus commands are used to interact with the Oracle database, including manipulating data in tables through SQL statements.

Option D) /SQL* Plus commands manipulate table definitions in the database - This option is incorrect. SQL*Plus commands are mainly used to interact with data, not to manipulate table definitions.

Option E) /SQL* Plus is the Oracle proprietary interface for executing SQL statements - This option is correct. SQL*Plus is a command-line interface provided by Oracle for executing SQL statements and managing the Oracle database.

The correct answers are C and E. These options correctly describe attributes of SQL*Plus, as it is used to manipulate data in tables and is the Oracle proprietary interface for executing SQL statements.

Keep practicing — related questions