Database Concepts, Kroenke - Exam Preparation Test Bank (Downloadable Doc)

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