Database Processing, 15e (Kroenke)
Online Chapter 10A: Managing Databases with SQL Server 2017
1) The SQL Server GUI program is the Enterprise Manager.
2) The Microsoft SQL Server Management Studio Manager can be used to create a new
database.
3) The SQL Server default when creating a new database is to create two data files and one log
file for each database.
4) In addition to the standard SQL Server 2017 tools, SQL statements such as CREATE TABLE
can now also be executed by using Microsoft’s PowerShell.
5) When viewing the SQL Server list of tables in a database, dbo means “domain base object”
and indicates a system table.
6) SQL Server 2017 provides two ways to create tables—graphically and through SQL code.
7) With SQL Server, the preferred way to create database structures is with SQL statements.
8) SQL Statements can be submitted to SQL Server from the Microsoft SQL Server Management
Studio.
9) To use an SQL Server reserved word as a user identifier, it must be enclosed in square
brackets [ ].
10) The Microsoft SQL Server Management Studio cannot verify SQL statements until they are
executed.
11) Stored procedures and triggers in SQL Server may become confused while executing stored
procedures and triggers when SQL Server special words such as TRANSACTION appear as table
or other names, even if they are enclosed in square brackets [ ].
12) The name TRANSACTION is so special to SQL Server that no stored procedures will work
on a table with that name.
13) In the Microsoft SQL Server Management Studio, the starting value for a field that has been
set as an IDENTITY in SQL Server is set in the seed (StartingValue) property.
14) In the Microsoft SQL Server Management Studio, the amount to add to the surrogate key
value when adding a new row is specified by the increment property.
15) When viewing a table in the GUI tools table design window in SQL Server, the primary key
is indicated by a black arrow.
16) When viewing a table in the GUI tools table design window in SQL Server, the notation that
should supply the values for a surrogate key is that the Identity property of that column is set to
“Yes.”
17) SQL Server automatically creates an index on primary key fields only.
18) The developer can direct SQL Server to create indexes on non-key fields.
19) SQL Server supports three types of indexes: clustered, unclustered, and random.
20) In an SQL Server clustered index, the data are stored in the bottom level of the index and in
the same order as the index.
21) With SQL Server, a clustered index has the data with, and in the same order as, the bottom
level of the index.
22) With SQL Server, only one clustered index is allowed per table.
23) With SQL Server, a nonclustered index does not contain data but has pointers to the data.
24) With SQL Server, the clustered index is faster for data retrieval.
25) Data can be entered directly into a table in Enterprise Manager or via SQL INSERT
statements submitted through the Microsoft SQL Server Management Studio.
26) Database views can only be created in SQL Server using SQL commands.
27) One means of processing an SQL Server database is to create application code in a
programming language and invoke SQL Server DBMS commands from that program.
28) One means of processing an SQL Server database is to save groups of SQL Server DBMS
commands in a text file and then process this file in the Microsoft SQL Server Management
Studio.
29) PL/SQL is a programming language for SQL Server that adds programming constructs to the
SQL language.
30) SQL Server user variables and parameters start with the @ symbol.
31) When you use the Microsoft SQL Server Management Studio to run and rerun a set of SQL
Server DBMS commands stored in a text file, the stored procedure must start with CREATE
PROCEDURE.
32) SQL Server supports AFTER and INSTEAD OF triggers, but not BEFORE triggers.
33) SQL Server AFTER triggers may be assigned to either tables or views.
34) SQL Server AFTER triggers may be used with insert and update actions, but not delete
actions.
35) In SQL Server, triggers can roll back the transaction that caused them to be fired.
36) In SQL Server, insert and update triggers store new values in a pseudotable named inserted.
37) In SQL Server, insert and update triggers store old values in a pseudotable named deleted.
38) SQL Server built-in system function names start with the @@ symbol.
39) When using SQL Server, developers place explicit locks.
40) SQL Server automatically makes determinations of whether or not to promote or demote a
lock.
41) In SQL Server, it is not possible to make dirty reads.
42) The default cursor concurrency for a dynamic cursor in SQL Server is optimistic.
43) The default transaction isolation level for SQL Server is Read Committed.
44) In SQL Server, SCROLL_LOCK is a version of pessimistic locking.
45) Locking hints included in an SQL statement will override locking behavior based on explicit
transaction isolation level statements.
46) In SQL Server, locking behavior can be modified by providing locking hints in the WITH
parameter of the FROM clause in SELECT statements.
47) SQL Server logins can be based on Windows Operating System security or SQL server-
specific security.
48) The recommended SQL Server security is Windows-only security.
49) SQL Server security roles provide a simple way to control user privileges in a database.
50) When recovering a database in SQL Server, it is possible to process the log to a particular
point in time or to a transaction mark.
51) In SQL Server, a differential backup makes a copy of the entire database.
52) In SQL Server, a transaction log backup makes a copy of the changes that have been made
since the last time a backup of the entire database was made.
53) SQL Server supports three recovery models: simple, complex and bulk logged.
54) SQL Server bulk-logged recovery differs from other log-based recovery methods because it
does not include log entries for changes that cause large log entries.
55) In SQL Server, the full recovery model creates a log entry for every change to the database.
56) The SQL Server GUI interface database management program is the ________.
A) Enterprise Manager
B) Query Analyzer
C) Microsoft SQL Server Management Studio
D) Both A and B are correct
57) Which of the following is true about SQL Server Import and Export Wizard?
A) SQL Server Native Client should be selected as the destination.
B) The user can’t specify that the column names are in the first row.
C) There are no problems with modifying the default column attributes.
D) The user can specify the primary key to be set on the imported table.
58) The SQL Server default when creating a new database is to create ________ for each
database.
A) one data file and one log file
B) one data file and two log files
C) two data files and one log file
D) There is no default—the database creator must specify how many data files and log files will
be created.
59) SQL statements can be passed to SQL Server using the ________.
A) Enterprise Manager
B) Query Analyzer
C) Microsoft SQL Server Management Studio
D) Both A and B are correct
60) SQL Server tables can be created and modified using ________.
A) Enterprise Manager
B) Query Analyzer
C) Microsoft SQL Server Management Studio
D) Both A and B are correct