Test Bank for Murach’s SQL Server 2022 for Developers, 1st Edition by Bryan Syverson

Chapter 1: An introduction to relational databases and SQL
Murach's SQL Server 2022 for Developers

MULTIPLE CHOICE

1. Which of the following is not a SQL DML (Data Manipulation Language) statement?
a. INSERT c. SELECT
b. UPDATE d. CREATE TABLE
ANS: D PTS: 1

2. If you define a column with a default value, that value is used whenever a row...
a. is added to the table
b. in the table is updated
c. that doesn’t include a value for that column is added to the table
d. with a zero value for that column is added to the table
ANS: C PTS: 1

3. If you define a column as an identity column...
a. a number is generated for that column whenever a row is added to the table
b. you must provide a unique numeric value for that column whenever a row is added to the
table
c. you can’t use the column as a primary key column
d. you must also define the column with a default value
ANS: A PTS: 1

4. The processing that’s done by the DBMS (Database Management System) is typically referred to as:
a. front-end processing c. delayed processing
b. back-end processing d. any-time processing
ANS: B PTS: 1

5. Which of the following types of statements isn’t an action query?
a. SELECT c. UPDATE
b. INSERT d. DELETE
ANS: A PTS: 1

6. To retrieve or update the data in a database, the client sends a ________________ to the database.
a. handshake c. query
b. transaction request d. ping
ANS: C PTS: 1

7. A relational database consists of one or more what?
a. rows c. tables
b. columns d. cells
ANS: C PTS: 1

, 8. What uniquely identifies each row in a table?
a. foreign key c. cell
b. primary key d. field
ANS: B PTS: 1

9. The intersection of a row and a column is commonly called what?
a. cell c. primary key
b. field d. foreign key
ANS: A PTS: 1

10. Which of the following recommendations won’t improve the readability of your SQL statements?
a. break long clauses into multiple lines
b. use capital letters for all clauses except DDL statements
c. start each clause on a new line
d. indent continued lines
ANS: B PTS: 1

11. To relate one table to another, a/an ________________ in one table is used to point to the primary key
in another table.
a. index c. primary key
b. composite primary key d. foreign key
ANS: D PTS: 1

12. What is the most common type of relationship between two tables?
a. one-to-many c. many-to-many
b. one-to-one d. one-to-few
ANS: A PTS: 1

13. The American National Standards Institute (ANSI) publishes specifications for a standard SQL
language. What is the advantage to using a specific dialect of SQL?
a. different dialects off different color coding themes for accessibility
b. most dialects offer extensions for additional functionality
c. certain dialects work better with certain languages (English, Spanish, etc)
d. some dialects are optimized for faster DDL statements
ANS: B PTS: 1

14. When a column in a table is defined, what determines the kind of data it can store?
a. a relationship c. an index
b. a primary key d. a data type
ANS: D PTS: 1

15. What SQL dialect does Microsoft SQL Server use?
a. Transact-SQL c. ANSI
b. SQL-dialect d. SQL-92

, ANS: A PTS: 1

16. SQL statements that define the tables in a database are referred to as ________________ statements.
a. Data Manipulation Language (DML) c. SELECT
b. Data Definition Language (DDL) d. ASCII
ANS: B PTS: 1

17. INSERT, UPDATE, and DELETE statements can be referred to as ________________ queries.
a. SELECT c. action
b. result d. database
ANS: C PTS: 1

18. The three main hardware components of a client/server system are the clients, the server, and the
a. network c. application
b. hard drive d. data access API
ANS: A PTS: 1

19. Which of these is unlikely to be part of a client/server system that exclusively uses SQL Server?
a. an application server
b. a web server
c. a server running macOS
d. a DBMS (database management system)
ANS: C PTS: 1

, Chapter 2: How to use Management Studio
Murach's SQL Server 2022 for Developers

MULTIPLE CHOICE

1. When you use Windows authentication to connect to a database, SQL Server...
a. uses the login name and password that you use for your PC to authorize your connection
b. requires that you use a special login name and password for your authorization
c. lets you access the database without authorization as long as you’re logged on to Windows
d. uses both Windows and SQL Server login names and passwords for authorization
ANS: A PTS: 1

2. You can create a database diagram in Management Studio for...
a. up to 3 tables in a database
b. just the tables in a one-to-many relationship
c. just the related tables in a database
d. any combination of the tables in a database
ANS: D PTS: 1

3. If you want to use Management Studio to modify the data for a table, you can right-click on the table
in Object Explorer and select what?
a. Select Top 1000 Rows c. Design
b. Edit Top 200 Rows d. Script Table As
ANS: B PTS: 1

4. A database ________________ is a schematic drawing that shows you the relationships between the
tables you’re working with.
a. role c. diagram
b. object d. system
ANS: C PTS: 1

5. Which of these is a graphical tool that you can use to start and stop a database server?
a. SQL Server Management Studio
b. SQL Server Configuration Manager
c. Object Explorer
d. Table Designer
ANS: B PTS: 1

6. In Management Studio, what tool would you use if you wanted to modify a column in a table?
a. Query Editor c. Table Designer
b. Object Explorer d. Database Attacher
ANS: C PTS: 1

7. In Management Studio, the Query Editor uses the IntelliSense feature to automatically display
________________ lists that you can use to enter parts of a SQL statement.