Question is ⇒ What is not an advantage of stored procedures?, Options are ⇒ (A) Greater security, (B) SQL can be optimized, (C) Code sharing, (D) Increased network traffic, (E) , Leave your comments or Download question paper.

Question is ⇒ What is not an advantage of stored procedures?, Options are ⇒ (A) Greater security, (B) SQL can be optimized, (C) Code sharing, (D) Increased network traffic, (E) , Leave your comments or Download question paper. Previous question Next question


Q1.	What is not an advantage of stored procedures?
A.	Greater security [Wrong Answer]
B.	SQL can be optimized [Wrong Answer]
C.	Code sharing [Wrong Answer]
D.	Increased network traffic [Correct Answer]
View Answer 1 -1 Explanation:- Answer : D 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 :

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

⇒ A subquery in an SQL SELECT statement:
can only be used with two tables.
can always be duplicated by a join.
has a distinct form that cannot be duplicated by a join.
cannot have its results sorted using ORDER BY.

⇒ Which of the following statements is true concerning subqueries?
Involves the use of an inner and outer query.
Cannot return the same result as a query that is not a subquery.
Does not start with the word SELECT.
All of the above.

⇒ Which of the following statements is true concerning routines and triggers?
Both consist of procedural code.
Both have to be called to operate.
Both run automatically.
Both are stored in the database.

⇒ 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 NOT a type of SQL constraint?
PRIMARY KEY
FOREIGN KEY
ALTERNATE KEY
UNIQUE

⇒ How many JDBC driver types does Sun define?
One
Two
Three
Four

⇒ The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Equi-join
Natural join
Outer join
Cartesian join

⇒ Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Type 1 only
Type 2 only
Both Type 3 and Type 4
All of Type 1, Type 2, Type 3 and Type 4

⇒ What mode of authentication does SQL Server NOT provide?
Windows-only security
Both SQL Server and Windows-only security
Mixed security
SQL Server only security

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

⇒ To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
ONLY
UNIQUE
DISTINCT
SINGLE

⇒ Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
REPEATABLE READ
SERIALIZABLE
READ COMMITTED
READ UNCOMMITTED

⇒ When using the SQL INSERT statement:
rows can be modified according to criteria only.
rows cannot be copied in mass from one table to another only.
rows can be inserted into a table only one at a time only.
rows can either be inserted into a table one at a time or in groups.

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

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

⇒ Which of the following is true concerning triggers?
You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).

⇒ SQL Server 2000 stored procedures can:
never be kept within the database.
be kept within the database and invoked by application programs.
be stored on the users' computer.
support BEFORE, INSTEAD OF and AFTER types.

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

⇒ The command to remove rows from a table 'CUSTOMER' is:
REMOVE FROM CUSTOMER ...
DROP FROM CUSTOMER ...
DELETE FROM CUSTOMER WHERE ...
UPDATE FROM CUSTOMER ...

⇒ ________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS

⇒ A ________ is a program that performs some common action on database data and that is stored in the database.
trigger
stored procedure
pseudofile
None of the above is correct.

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

⇒ SQL Server automatically creates an index on:
primary keys only.
foreign key only.
both primary and foreign keys.
SQL Server never automatically creates an index.

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

⇒ Who invented Java?
Netscape
Microsoft
Sun
None of the above is correct.

⇒ 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

⇒ SQL data definition commands make up a(n) ________ .
DDL
DML
HTML
XML

⇒ 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

⇒ 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