Question is ⇒ SQL Server program code that is executed instead of an SQL command that needs to be 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 instead of an SQL command that needs to be 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 instead of an SQL command that needs to be processed is called a(n):
A.	INSTEAD OF trigger. [Correct Answer]
B.	BEFORE trigger. [Wrong Answer]
C.	AFTER trigger. [Wrong Answer]
D.	BEGIN trigger. [Wrong Answer]
View Answer 1 -1 Explanation:- Answer : A 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 :

⇒ To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
a particular column in a particular underlying table.
a particular column in a particular row.
a particular row in a particular underlying table.
None of the above is correct.

⇒ What type of join is needed when you wish to include rows that do not have matching values?
Equi-join
Natural join
Outer join
All of the above.

⇒ 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

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

⇒ SQL query and modification commands make up a(n) ________ .
DDL
DML
HTML
XML

⇒ With which type of SQL Server recovery model are all database changes logged?
Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery

⇒ 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.

⇒ SQL can be used to:
create database structures only.
query database data only.
modify database data only.
All of the above can be done by SQL.

⇒ A reason for using an SQL view to hide columns is:
to simplify a result only.
to prevent the display of sensitive data only.
to accomplish both of the above.
None of the above are reasons for using an SQL view.

⇒ 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.

⇒ What is an SQL virtual table that is constructed from other tables?
Just another table
A view
A relation
Query results

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

⇒ SQL Server program code that is executed after an SQL command has been processed is called a(n):
INSTEAD OF trigger.
BEFORE trigger.
AFTER trigger.
BEGIN trigger.

⇒ What servlet processor was developed by Apache Foundation and Sun?
Apache Tomcat
Apache Web server
Sun servlet processor
None of the above is correct.

⇒ Which of the following is valid SQL for an Index?
CREATE INDEX ID;
CHANGE INDEX ID;
ADD INDEX ID;
REMOVE INDEX ID;

⇒ Which of the following is true concerning systems information in an RDBMS?
RDBMS store database definition information in system-created tables.
This information can be accessed using SQL.
This information often cannot be updated by a user.
All of the above.

⇒ Which of the following is an SQL trigger supported by Oracle?
BEFORE
INSTEAD OF
AFTER
All of the above.

⇒ An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:
COBOL.
VB.NET.
TRANSACT SQL.
Visual Basic.

⇒ What is not true of a Java bean?
There are no public instance variables.
All persistent values are accessed using get and set methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.

⇒ What is the full form of SQL?
Simple Query Language
Structured Query Language
Structured Query List
None of these

⇒ The SQL -92 wildcards are ____ and ____ .
asterisk (*); percent sign (%)
percent sign (%); underscore (_)
underscore(_); question mark (?)
question mark (?); asterisk (*)

⇒ Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
Lock level
Transaction isolation level
Cursor concurrency setting
Locking hints

⇒ Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language(DDL)
Data Manipulation Language(DML)
Both of above
None

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

⇒ When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.

⇒ A CASE SQL statement is which of the following?
A way to establish an IF-THEN-ELSE in SQL.
A way to establish a loop in SQL.
A way to establish a data definition in SQL.
All of the above.

⇒ 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 is a way to create and modify tables using SQL Server?
Write SQL code using either CREATE or ALTER SQL statements only.
Use the graphical facilities of SQL Server Enterprise Manager only.
Both of the two methods above will work.
Neither of the two methods above will work.

⇒ What is an advantage of placing computations in SQL views?
To save users from having to write an expression.
To ensure that the results are consistent.
To accomplish both of the above.
None of the above is correct - computations cannot be placed in a view.

⇒ The SQL keyword(s) ________ is used with wildcards.
LIKE only
IN only
NOT IN only
IN and NOT IN