SQL Server Test 1
diagram
A database __________________ is a schematic drawing that shows you the relationships between the tables you're working with.
attach
Before you can use the Management Studio to work with the objects in a database, you must ___________ the database to an instance of SQL Server 2012.
certain types of complex queries
One limitation of the Query Designer is that you can't use it for
books online
SQL Server comes with a complete set of reference manuals and help information called ____________________________________.
DDL
SQL statements that define the tables in a database are referred to as _______________ statements.
Which of the following types of statements isn't an action query?
Select
third
Typically, most database designers consider a database structure normalized if it's in the ________________________ normal form.
type
When a column in a table is defined, it is given a data _________ that determines what kind of data it can store.
If you define a column with a default value, that value is used whenever a row
that doesen't include a value for the column is added to the table
Which of the following recommendations won't improve the readability of your SQL statements?
use comments to describe what each statement does
tables
A relational database consists of one or more ___________.
database
A view is a SELECT statement that is stored with the ______________.
primary key
A/An __________________ uniquely identifies each row in a table.
dialect or variant
Although the American National Standards Institute publishes the specifications for a standard SQL language, each DBMS vendor has its own _______________ of SQL.
Which of the following types of SQL statements isn't a DML statement?
CreateTable
linking
If two tables have a many-to-many relationship, you need to define a/an _____________ table that relates their records.
Action
Insert, Update, and Delete statements can be referred to as ______________ queries.
DDL statements
The Query Editor of the Management Studio lets you enter and execute all types of
Transact-SQL
The SQL dialect that Microsoft SQL Server uses is called _______________.
management studio
The ________________________________________ is a graphical user interface for working with the objects in a SQL Server database.
data access API
The interface between an application program and the DBMS is usually provided by the
cell
The intersection of a row and a column is commonly called a/an _______________.
one-to-many
The most common type of relationship between two tables is a/an ___________________ relationship.
one-to-many
The most common type of relationship between two tables is called a/an _______________ relationship.
back-end processing
The processing that's done by the DBMS is typically referred to as
clustered
The rows in a table are kept in the sequence that's based on its __________________________ index.
network
The three main hardware components of a client/server system are the clients, the server, and the
referential integrity
To maintain _________________________________, if you delete a row in a primary key table, you must also delete any related rows in foreign key tables.
table
To model a database on a real-world system, you typically represent each real-world entity as a/an ____________________________.
normal forms
To normalize a data structure, you apply the ______________________ in sequence.
foreign key
To relate one table to another, a/an __________________ in one table is used to point to the primary key in another table.
query
To retrieve or update the data in a database, the client sends a/an ________________ to the database.
command
To run a SELECT statement from an application program, you store the statement in the ____________ object for the database connection.
commands, connections and datasets
To work with the data in a SQL Server database from a .NET application, you can use ADO.NET objects like
the smallest practical components
When you identify the data elements in a new database, you typically subdivide data elements into
SQL server
When you set the compatibility level of SQL Server 2012, you make sure it is compatible with a specific version of
uses the login name and password that you use for your PC to authorize your connection
When you use Windows authentication to connect to a database, SQL Server
forgetting to attach the required database
Which of the following isn't a common error when entering and executing SQL statements?
Query designer
Within the Management Studio, you can build a SQL statement without having to write your own code by using the ____________________________________.
any combination of the tables in a database
You can create a database diagram for
If you define a column as an identity column,
a number is generated for that column whenever a row is added to the table