Database Concepts, 6e (Kroenke/Auer)
Appendix A Microsoft SQL Server 2012 Express Edition
1) SQL Server 2012 Express requires that the .NET Framework version 2.0 be installed.
Answer: FALSE
Diff: 1 Page Ref: A-4
2) The Microsoft SQL Server Management Studio is included with Microsoft SQL Server
2012 Express Advanced.
Answer: TRUE
Diff: 1 Page Ref: A-4
3) An important reason for using SQL Server 2012 Express is that it has full SQL
capabilities.
Answer: TRUE
Diff: 1 Page Ref: A-4
4) To start working with SQL Server 2012 Express, use the command Start | All
Programs | Microsoft SQL Server 2012 | SQL Server management Studio Express.
Answer: TRUE
Diff: 1 Page Ref: A-5
5) Users log into SQL Server 2012 Express using the Connect to Server dialog box.
Answer: TRUE
Diff: 1 Page Ref: A-5
,6) SQL Server 2012 uses DBMS authentication by default.
Answer: FALSE
Diff: 2 Page Ref: A-5
7) Database objects are displayed in the Object Explorer window in the SQL Server
Management Studio.
Answer: TRUE
Diff: 1 Page Ref: A-5
8) A new SQL Server database is created using the New Database dialog box.
Answer: TRUE
Diff: 2 Page Ref: A-6-A-8
9) SQL statements can be run individually or as part of a related group of SQL statements
known as a script.
Answer: TRUE
Diff: 1 Page Ref: A-8
10) To run an SQL script, click the Execute button on the Query Toolbar.
Answer: FALSE
Diff: 1 Page Ref: A-10
11) To create a new SQL query, click the New Query button.
Answer: TRUE
Diff: 1 Page Ref: A-11
12) SQL query results are displayed in a tabbed Resultset window.
,Answer: FALSE
Diff: 1 Page Ref: A-12
13) SQL Server 2012 Express requires the prior or concurrent installation of:
A) the .NET Framework version 2.0.
B) the .NET Framework version 3.0.
C) the .NET Framework version 4.0.
D) the .NET Framework version 3.5 SP1.
E) None of the above — the .NET Framework is not required.
Answer: C
Diff: 1 Page Ref: A-4
14) Microsoft SQL Server 2012 Express Advanced includes:
A) SQL Server 2012 Management Studio.
B) SQL Server 2012 Reporting Services.
C) Windows Installer 4.5.
D) Both A and B
E) All of the above
Answer: D
Diff: 2 Page Ref: A-4
15) Logging into the SQL Server 2012 Express DBMS is done using:
A) the Connect to Server command.
B) the Connect to Server dialog box.
C) the Connect to SQL Server Instance command.
, D) the Connect to SQL Server Instance dialog box.
E) None of the above is correct.
Answer: B
Diff: 2 Page Ref: A-5
16) DBMS objects are displayed:
A) in the Navigation Pane.
B) in the Object Browser.
C) in the tabbed database window.
D) in the tabbed document window.
E) in the command tab.
Answer: B
Diff: 2 Page Ref: A-6-A-7
Appendix A Microsoft SQL Server 2012 Express Edition
1) SQL Server 2012 Express requires that the .NET Framework version 2.0 be installed.
Answer: FALSE
Diff: 1 Page Ref: A-4
2) The Microsoft SQL Server Management Studio is included with Microsoft SQL Server
2012 Express Advanced.
Answer: TRUE
Diff: 1 Page Ref: A-4
3) An important reason for using SQL Server 2012 Express is that it has full SQL
capabilities.
Answer: TRUE
Diff: 1 Page Ref: A-4
4) To start working with SQL Server 2012 Express, use the command Start | All
Programs | Microsoft SQL Server 2012 | SQL Server management Studio Express.
Answer: TRUE
Diff: 1 Page Ref: A-5
5) Users log into SQL Server 2012 Express using the Connect to Server dialog box.
Answer: TRUE
Diff: 1 Page Ref: A-5
,6) SQL Server 2012 uses DBMS authentication by default.
Answer: FALSE
Diff: 2 Page Ref: A-5
7) Database objects are displayed in the Object Explorer window in the SQL Server
Management Studio.
Answer: TRUE
Diff: 1 Page Ref: A-5
8) A new SQL Server database is created using the New Database dialog box.
Answer: TRUE
Diff: 2 Page Ref: A-6-A-8
9) SQL statements can be run individually or as part of a related group of SQL statements
known as a script.
Answer: TRUE
Diff: 1 Page Ref: A-8
10) To run an SQL script, click the Execute button on the Query Toolbar.
Answer: FALSE
Diff: 1 Page Ref: A-10
11) To create a new SQL query, click the New Query button.
Answer: TRUE
Diff: 1 Page Ref: A-11
12) SQL query results are displayed in a tabbed Resultset window.
,Answer: FALSE
Diff: 1 Page Ref: A-12
13) SQL Server 2012 Express requires the prior or concurrent installation of:
A) the .NET Framework version 2.0.
B) the .NET Framework version 3.0.
C) the .NET Framework version 4.0.
D) the .NET Framework version 3.5 SP1.
E) None of the above — the .NET Framework is not required.
Answer: C
Diff: 1 Page Ref: A-4
14) Microsoft SQL Server 2012 Express Advanced includes:
A) SQL Server 2012 Management Studio.
B) SQL Server 2012 Reporting Services.
C) Windows Installer 4.5.
D) Both A and B
E) All of the above
Answer: D
Diff: 2 Page Ref: A-4
15) Logging into the SQL Server 2012 Express DBMS is done using:
A) the Connect to Server command.
B) the Connect to Server dialog box.
C) the Connect to SQL Server Instance command.
, D) the Connect to SQL Server Instance dialog box.
E) None of the above is correct.
Answer: B
Diff: 2 Page Ref: A-5
16) DBMS objects are displayed:
A) in the Navigation Pane.
B) in the Object Browser.
C) in the tabbed database window.
D) in the tabbed document window.
E) in the command tab.
Answer: B
Diff: 2 Page Ref: A-6-A-7
