There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.
Select an option to see the answer and solution.
Database · all questionsSQL Server 2000
SQL Server 2000
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
SQL Server automatically creates an index on all primary and foreign keys.
Select an option to see the answer and solution.
An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.
Select an option to see the answer and solution.
With SQL Server, parameters and variables in T-SQL start with the "%" sign.
Select an option to see the answer and solution.
Nonclustered indexes are faster than clustered indexes for retrieval.
Select an option to see the answer and solution.
SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.
Select an option to see the answer and solution.
SQL Server supports two kinds of indexes: clustered and nonclustered.
Select an option to see the answer and solution.
SQL Server indexes are special data structures used to improve performance.
Select an option to see the answer and solution.
SQL Server supports a language called Transact-SQL (also called T-SQL).
Select an option to see the answer and solution.
The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.
Select an option to see the answer and solution.
READ COMMITTED is the default isolation level.
Select an option to see the answer and solution.
A differential backup makes a copy of the entire database.
Select an option to see the answer and solution.
SQL Server supports three recovery modes: simple, full and Bulk.
Select an option to see the answer and solution.
SERIALIZABLE is the strictest isolation level.
Select an option to see the answer and solution.
With SQL Server pessimistic locking, no lock is obtained until the user updates the data.
Select an option to see the answer and solution.
Better security occurs if Windows-only authentication is selected.
Select an option to see the answer and solution.
SQL Server AFTER Triggers may be assigned views.
Select an option to see the answer and solution.
'dbo' stands for database object.
Select an option to see the answer and solution.
With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
Select an option to see the answer and solution.
By default, SQL Server will create one data file and one log file for each newly created database.
Select an option to see the answer and solution.