Which two statements are true regarding SQL*Plus?

Question

Options

• AIt has commands for performing database administration operations.
• BIt can be used in interactive but not batch mode for SQL commands.
• CIt has to be installed separately after the Oracle Database 12c installation.
• DOperating system commands can be executed from the SQL*Plus command prompt.

• A
  78% (18)
• B
  4% (1)
• C
  17% (4)

Explanation

Not B: SQLPlus command-line, the use of an external editor in combination with the @, @@ or START commands is an effective method of creating and executing generic scripts. You can write scripts which contain SQL and PL/SQL commands, which you can retrieve and edit. This is especially useful for storing complex commands or frequently used reports. SQLPlus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQLPlus web-based user interface. SQLPlus has its own commands and environment, and it provides access to the Oracle Database. It enables you to enter and execute SQL, PL/SQL, SQLPlus and operating system commands to perform the following: - Format, perform calculations on, store, and print from query results - Examine table and object definitions - Develop and run batch scripts - Perform database administration You can use SQLPlus to generate reports interactively, to generate reports as batch processes, and to output the results to text file, to screen, or to HTML file for browsing on the Internet. You can generate reports dynamically using the HTML output facility of SQLPlus, or using the dynamic reporting capability of iSQLPlus to run a script from a web page.

No community discussion yet for this question.