A trigger is a special type of stored procedure that is executed by the SQL Server when an Insert, Modify or Delete operation is performed Against a given table.
True
False
Stored procedures are the way to create routines and procedures that are run on the server.
We can not execute a stored procedure on either local or remote SQL Server.
Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.
'Select Into'Statement retrieves rows and columns from one source table to a target table.
__is an interface you can use to write both SQL and PL/SQL scripts
PL/SQL
SQL
SQL*PLUS
JAVA
___is the language used to put data into the database, retrieve data from the database, control transactions, and administer your database
__is the procedural programming language of Oracle, and with it you can write custom programs and procedural code for execution inside the database
____setting that indicates the number of records that must be returned in the query results for SQL*Plus to show the message
LINESIZE
FEEDBACK
PAGESIZE
PAUSE
PAUSE command is useful, when you execute a query that is longer than a page in size, the output will stop until you hit the Enter key.