SQL Server 2000 - General Questions Online Exam Quiz
SQL Server 2000 - General Questions GK Quiz. Question and Answers related to SQL Server 2000 - General Questions. MCQ (Multiple Choice Questions with answers about SQL Server 2000 - General Questions
With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Options
A : Differential recovery
B : Full recovery
C : Simple recovery
D : Bulk-logged recovery
Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Options
A : #
B : %
C : &
D : @
What mode of authentication does SQL Server NOT provide?
Options
A : Windows-only security
B : Both SQL Server and Windows-only security
C : Mixed security
D : SQL Server only security
The strictest transaction isolation level provided by SQL Server is called:
Options
A : REPEATABLE READ.
B : SERIALIZABLE.
C : READ COMMITTED.
D : READ UNCOMMITTED.
SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Options
A : INSTEAD OF trigger.
B : BEFORE trigger.
C : AFTER trigger.
D : BEGIN trigger.
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Options
A : READ_ONLY
B : SCROLL_LOCK
C : OPTIMISTIC
D : READCOMMITTED
Which of the three possible types of triggers does SQL Server support?
Options
A : INSTEAD OF only
B : AFTER only
C : BEFORE only
D : INSTEAD OF and AFTER only
Which of the following is a way to create and modify tables using SQL Server?
Options
A : Write SQL code using either CREATE or ALTER SQL statements only.
B : Use the graphical facilities of SQL Server Enterprise Manager only.
C : Both of the two methods above will work.
D : Neither of the two methods above will work.
With which type of SQL Server recovery model, is no logging done?
Options
A : Differential recovery
B : Full recovery
C : Bulk-logged recovery
D : Simple recovery
SQL Server 2000 stored procedures can:
Options
A : never be kept within the database.
B : be kept within the database and invoked by application programs.
C : be stored on the users' computer.
D : support BEFORE, INSTEAD OF and AFTER types.
Advanced SQL - General Questions more Online Exam Quiz
Introduction to Database - General Questions
Introduction to SQL - General Questions
JDBC, Java Server Pages, and MySQL - General Questions
Logical Database Design - General Questions
Managing Databases with Oracle - General Questions
Managing Multiuser Databases - General Questions
Modeling Data in the Organization - General Questions
Object-Oriented Database - General Questions