MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
SQL Server 2000
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Q.1
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
Q.2
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
Q.3
Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED
Q.4
With SQL Server, parameters and variables in T-SQL start with the "%" sign.
True
False
Q.5
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
Q.6
Which of the three possible types of triggers does SQL Server support?
INSTEAD OF only
AFTER only
BEFORE only
INSTEAD OF and AFTER only
Q.7
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
Q.8
Nonclustered indexes are faster than clustered indexes for retrieval.
True
False
Q.9
With which type of SQL Server recovery model, is no logging done?
Differential recovery
Full recovery
Bulk-logged recovery
Simple recovery
Q.10
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
Q.11
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
PESSIMISTIC
Q.12
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
Q.13
With this type of index, the data are stored in the bottom level of the index and in the same order as that index.
Nonclustered
Clustered
Primary
Secondary
Q.14
In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?
Complete backup
Transaction Log
Differential backup
None of the above is correct
Q.15
With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.
Nonclustered
Clustered
Primary
Secondary
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page