SQL Server Test 1

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

情報技術・じょうほうぎじゅつ・ITの質問

View Set

EXIT HESI Comprehensive B Evolve Practice Questions

View Set

Pediatric Hematological immunological and neoplastic disorders

View Set