Deveopting SQL Server Database Exam 1

Insert, Update, and Delete statements can be referred to as ________________ queries.

Action

A relational database consists of one or more what?

tables

The ____ operator specifies a range of values in a condition.​

BETWEEN

To store and manage the databases of the client/server system, each server requires what?

database management system (DBMS)

An unknown or absent value is represented in a database as a(n) _____

null

What is the most common type of relationship between two tables?

one-to-many

What uniquely identifies each row in a table?

primary key

To retrieve or update the data in a database, the client sends a ________________ to the database.

query

The ____ operator finds rows that do not contain a null value in the specified column.​

​NOT NULL

You use the ____ clause to list data in a specific order.​

​ORDER BY

What is the minimum recommended amount of RAM for Microsoft SQL Server 2019 Developer Edition?

1GB

In management Studio, what tool would you use if you wanted to modify a column or view more detained information about the columns in a table?

Table designer

When a column in a table is defined, what determines the kind of data it can store?

a data type

If you define a column as an identity column,

a number is generated for that column whenever a row is added to the table

You can create a database diagram for

any combination of the tables in a database

In Management Studio, the Query Editor uses the the IntelliSense feature to automatically display____________lists that you can use to enter parts of the SQL statement.

Completion ( reduces how much user has to write by providing the right tables)

Which of the following is not a SQL DML statement?

Create Table

SQL statements that define the tables in a database are referred to as ________________ statements.

Data Definition Language (DDL)

If you try to move a database file that's attached to a server, you'll get an error message that indicates the file is in use. To get around this, you need to ________________ the database from the server.

Detach

A database________ is a schematic drawing that shows you the relationships between the tables you are working with.

Diagram

When you install the Developer edition of Microsoft SQL Server 2019, the Microsoft License Key is already entered

False

Which of the following would be valid?

GETDATE()

In Management Studio, if a statement returns data, that data is displayed in the________ tab

Results Tab

ou can install Microsoft SQL Server 2019 on the home edition of Windows 10.

True

You form compound conditions by connecting two or more simple conditions using the ____ operator.​

All of the above

The interface between an application program and the DBMS is usually provided by the

data access API

Which of the following is typically modeled after a real-world entity, such as an invoice or a vendor?

table

If you define a column with a default value, that value is used whenever a row

that doesn't include a value for that column is added to the table

When you use Windows authentication to connect to a database, SQL Server

uses the login name and password that you use for your PC to authorize your connection

The processing that's done by the DBMS is typically referred to as

back-end processing

The typical file extension for a Microsoft SQL Server backup file is __________?

.bak

If you have files for an existing sql server database, the easiest way to create the database is to_________ those file to the database server.

Attach

Generally speaking, a record that is the parent record in a foreign key relationship may not be deleted.

False

When installing Microsoft SQL Server to host your own databases on a single computer, the Database Engine is typically all that you need to install.

False

When you set the compatibility level of SQL Server 2019, you make sure it is compatible with a specific version of

SQL Server

A graphical tool that you can use to start and stop the database server is called what?

SQL Server Configuration Manager

The Query Editor of the Management Studio lets you enter and execute all types of

SQL Statements

Which of the following types of statements isn't an action query? Update

Select

Literal values must be enclosed in

Single quotation marks

Which of the following recommendations won't improve the readability of your SQL statements?

Use comments to describe what each statement does.

What are the two authentication methods for Microsoft SQL Server?

Windows Authentication Microsoft Authentication

If you want to use the Management Studio to modify the data for a table, you can right-click on the table and select what?

edit top 200 rows command

To relate one table to another, a/an ________________ in one table is used to point to the primary key in another table.

foreign key

Which of the following is not a common error when entering and executing SQL statements?

forgetting to attach the required database

Which of the following can you use to combine data from two or more tables into a single result set?

join

A SQL Server database consists of two files: a database file and

log file

The three main hardware components of a client/server system are the clients, the server, and the

network