Question is ⇒ SQL Server program code that is executed after an SQL command has been processed is called a(n):, Options are ⇒ (A) INSTEAD OF trigger., (B) BEFORE trigger., (C) AFTER trigger., (D) BEGIN trigger., (E) , Leave your comments or Download question paper.

Question is ⇒ SQL Server program code that is executed after an SQL command has been processed is called a(n):, Options are ⇒ (A) INSTEAD OF trigger., (B) BEFORE trigger., (C) AFTER trigger., (D) BEGIN trigger., (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	SQL Server program code that is executed after an SQL command has been processed is called a(n):
A.	INSTEAD OF trigger. [Wrong Answer]
B.	BEFORE trigger. [Wrong Answer]
C.	AFTER trigger. [Correct Answer]
D.	BEGIN trigger. [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : C Discuss it below : !! OOPS Login [Click here] is required to post your answer/result Help other students, write article, leave your comments

Previous question Next question

Also Read Similar Questions Below :

⇒ A UNION query is which of the following?
Combines the output from no more than two queries and must include the same number of columns.
Combines the output from no more than two queries and does not include the same number of columns.
Combines the output from multiple queries and must include the same number of columns.
Combines the output from multiple queries and does not include the same number of columns.

⇒ ________ was adopted as a national standard by ANSI in 1992.
Oracle
SQL
Microsoft Access
DBase

⇒ Which of the three possible types of triggers does SQL Server support?
INSTEAD OF only
AFTER only
BEFORE only
INSTEAD OF and AFTER only

⇒ A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands

⇒ The SQL WHERE clause:
limits the column data that are returned.
limits the row data are returned.
Both A and B are correct.
Neither A nor B are correct.

⇒ Which of the following is a correlated subquery?
Uses the result of an inner query to determine the processing of an outer query.
Uses the result of an outer query to determine the processing of an inner query.
Uses the result of an inner query to determine the processing of an inner query.
Uses the result of an outer query to determine the processing of an outer query.

⇒ Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
#
%
&
@

⇒ A subquery in an SQL SELECT statement is enclosed in:
braces -- {...}.
CAPITAL LETTERS.
parenthesis -- (...) .
brackets -- [...].

⇒ The result of a SQL SELECT statement is a(n) ________ .
report
form
file
table

⇒ Embedded SQL is which of the following?
Hard-coded SQL statements in a program language such as Java.
The process of making an application capable of generating specific SQL code on the fly.
Hard-coded SQL statements in a procedure.
Hard-coded SQL statements in a trigger.

⇒ SQL is:
a programming language.
an operating system.
a data sublanguage.
a DBMS.

⇒ Where is metadata stored in MySQL?
In the MySQL database
In the MySQL database
In the MySQL database
None of the above is correct.

⇒ The strictest transaction isolation level provided by SQL Server is called:
REPEATABLE READ.
SERIALIZABLE.
READ COMMITTED.
READ UNCOMMITTED.

⇒ With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

⇒ Which of the following do you need to consider when you make a table in SQL?
Data types
Primary keys
Default values
All of the above.

⇒ The SQL command to create a table is:
MAKE TABLE.
ALTER TABLE.
DEFINE TABLE.
CREATE TABLE.

⇒ The SQL keyword BETWEEN is used:
for ranges.
to limit the columns displayed.
as a wildcard.
None of the above is correct.

⇒ You can add a row using SQL in a database with which of the following?
ADD
CREATE
INSERT
MAKE

⇒ What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ JDBC stands for:
Java Database Connectivity
Java Database Components
Java Database Control
None of the above is correct.

⇒ How does Tomcat execute a JSP?
As a CGI script
As an independent process
By one of Tomcat's threads
None of the above is correct.

⇒ The benefits of a standard relational language include which of the following?
Reduced training costs
Increased dependence on a single vendor
Applications are not needed.
All of the above.

⇒ What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
A Java application
A Java applet
A Java servlet
None of the above is correct.

⇒ The DROP TABLE statement:
deletes the table structure only.
deletes the table structure along with the table data.
works whether or not referential integrity constraints would be violated.
is not an SQL statement.

⇒ The SQL ALTER statement can be used to:
change the table structure.
change the table data.
add rows to the table.
delete rows from the table.

⇒ What MySQL property is used to create a surrogate key in MySQL?
UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL.

⇒ With which type of SQL Server recovery model, is no logging done?
Differential recovery
Full recovery
Bulk-logged recovery
Simple recovery

⇒ The command to eliminate a table from a database is:
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
UPDATE TABLE CUSTOMER;

⇒ Which is NOT one of the most common types of SQL CHECK constraints?
System date
Range checks
Lists of values
Comparing one column value to another within the same table