61) When creating SQL Server tables in a database, SQL statements can now also be submitted
by using ________.
A) Internet Explorer
B) Microsoft PowerShell
C) Microsoft Excel
D) PL/SQL
62) Anytime you want to use an SQL Server reserved word as a user identifier, enclose it in
________.
A) { }
B) [ ]
C) ( )
D) < >
63) The column(s) that is/are the primary key in an SQL table are indicated by ________ when
viewed graphically in Enterprise Manager.
A) the black arrow symbol
B) the outline arrow symbol
C) the key symbol
D) being underlined
64) What name is so special to SQL Server that no stored procedure will work on a table with
that name, not even if it is enclosed in brackets?
A) NAME
B) UPDATE
C) TRANSACTION
D) KEY
65) When reviewing a table in the SQL Server GUI tools, which property should be set to “Yes”
to indicate that the column is a surrogate key for which SQL Server should automatically supply
values?
A) Identity
B) Surrogate
C) AutoIncrement
D) AutoNumber
66) Using only SQL Server tools, you can enter data into a table by ________.
A) entering it into a table grid in the Microsoft SQL Server Management Studio
B) using INSERT statements through the Microsoft SQL Server Management Studio
C) using an SQL Server form
D) Both A and B are correct
67) When creating a T-SQL statement, you should ________.
A) predefine it graphically in Enterprise Manager
B) limit it to one table
C) limit it to two tables
D) end it with the semicolon normally used to terminate SQL statements
68) Which of the following is true about indexes in SQL Server?
A) SQL Server automatically creates indexes for columns appearing in WHERE clauses in
queries.
B) SQL Server pads all indexes.
C) SQL Server supports filling up to a limit of 70 percent.
D) SQL Server automatically creates indexes for foreign keys.
69) Which type(s) of index in SQL Server has/have a bottom level that does not contain data but
has pointers to the data?
A) Clustered
B) Nonclustered
C) Unique
D) Both A and B are correct
70) Which of the following is true of clustered indexes?
A) They are normally slower than nonclustered indexes for retrieving data.
B) Only one is allowed per table.
C) They are normally slower than nonclustered indexes for updating data.
D) They do not have data in the bottom level.
71) Which type of index in SQL Server is faster for data retrieval?
A) Clustered
B) Nonclustered
C) Baseline
D) There is no advantage to any particular index for data retrieval, only for data updating.
72) Which of the following is true about the SQL Server Import and Export Wizard?
A) The spreadsheet data must already be normalized to be imported.
B) There may be problems importing Excel 2016 data and we may need to install Excel 2007
compatibility software.
C) The Import and Export Wizard sometimes creates blank rows at the end of the imported table.
D) Both B and C are correct.
73) The language available in SQL Server that adds programming constructs to the SQL
language is known as ________.
A) PL/SQL
B) C++
C) INTERACT-SQL
D) TRANSACT-SQL
74) Which of the following is known to be true if the command EXEC abcCust @Cost = 5 is
used in SQL to invoke a stored procedure in Microsoft SQL Server?
A) The name of the stored procedure is abcCust.
B) The name of the stored procedure is abc.
C) The parameter Cost is given a value of 5.
D) Both A and C are correct.
75) A stored procedure can be stored in a text file and run with the Microsoft SQL Server
Management Studio. If we are running the code that creates this procedure for the third time, it
must start with ________.
A) RUN PROCEDURE
B) CREATE PROCEDURE
C) ALTER PROCEDURE
D) MODIFY PROCEDURE
76) SQL Server user variables and parameters start with the symbol ________.
A) @@
B) #
C) ##
D) @
77) Which of the following is not a type of trigger supported by SQL Server?
A) BEFORE
B) INSTEAD OF
C) CONCURRENT
D) Both A and C are correct
78) A view may not be assigned to a(n) ________.
A) BEFORE trigger
B) INSTEAD OF trigger
C) CONCURRENT trigger
D) AFTER trigger
79) SQL Server system function names start with the symbol ________.
A) @@
B) #
C) ##
D) @
80) For triggers on insert and update actions, the new column values are stored in ________.
A) a table named new:TableName
B) a table named old:TableName
C) a pseudotable name inserted
D) a pseudotable named deleted
81) Which of the following is not a lock granularity supported by SQL Server?
A) Row
B) Attribute
C) Table
D) Page
82) Which of the following is not a transaction isolation level supported by SQL Server?
A) Pessimistic
B) Read Committed
C) Serializable
D) Read Uncommitted
83) Which of the following is the default transaction isolation level for SQL Server?
A) Repeatable Read
B) Read Committed
C) Serializable
D) Read Uncommitted
84) Which of the following is the most restrictive transaction isolation level option supported by
SQL Server?
A) Repeatable Read
B) Read Committed
C) Serializable
D) Read Uncommitted
85) Which of the following is a type of cursor concurrency that causes SQL Server to place an
update lock on a row when the row is read?
A) SCROLL_LOCK
B) Optimistic
C) Serializable
D) Read only
86) The default cursor concurrency setting for a static cursor in SQL Server is ________.
A) SCROLL_LOCK
B) Optimistic
C) Serializable
D) Read only
87) The default cursor concurrency setting for a keyset cursor in SQL Server is ________.
A) Pessimistic
B) Optimistic
C) Serializable
D) Read only
88) Specifying locking hints in which parameter in an SQL clause can modify locking behavior
in SQL Server?
A) SELECT
B) WITH
C) LOCK
D) HINT
89) Which type of backup in SQL Server will create a backup of the entire database?
A) Full backup
B) Transaction backup
C) Database backup
D) Complete backup
90) Which of the following is a type of recovery model supported in SQL Server in which all
database changes are logged?
A) Bulk logged
B) Full
C) Simple
D) Complete
91) Describe the database files that are automatically created when a new database is created in
SQL Server.
92) Explain two ways of creating tables in SQL Server.
93) Discuss the Microsoft PowerShell utility.
94) What is the SQL CLR?
95) Explain SQL Server indexes.
96) Explain the SQL Server IDENTITY constraint.
97) Explain how to work around the SQL Server IDENTITY constraint when non-sequential
data must be entered.
98) Briefly describe how a developer defines the type of locking behavior to be used with SQL
Server.
99) Briefly explain the different SQL Server backup types.
100) Briefly explain the different SQL Server recovery models.
101) Briefly explain the process for importing spreadsheet data into a SQL Server table, and
indicate some of the pitfalls or potential problems.