MySQL Chapter 01

What does SQL stand for?

Structured Query Language

What kind of filename extension do Microsoft SQL Server transaction log files have?

.ldf

Primary data files used on a Microsoft SQL server have an ____ extension.

.mdf

What statement is used to add or remove columns from a table?

ALTER

What action is not supported by ALTER?

Changing the identity constraint of an existing column

What are limitations or rules placed on a field or column to ensure that data that is considered invalid is not entered.

Constraints

What are the limitations or rules placed on a file or column to ensure that data is considered valid for a database?

Constraints

What is a collection of programs that enables you to enter, organize, and select data from a database?

DBMS

What is the subset of T-SQL that deals with creating database objects such as tables and stored procedures?

DDL

What kind of statements are USE, CREATE, ALTER, and DROP?

DDL

Which statement can you use to remove rows from a table?

DELETE

What is the difference between the TRUNCATE and DELETE commands?

DELETE removes data, TRUNCATE removes data and clears the space used

What is the language element that allows you to use core statements such as INSERT, UPDATE, and DELETE to manipulate data in any SQL Server table?

DML

What statement would you use to delete a table from a SQL database?

DROP

A ____ is an organized collection of data, typically stored in electronic format.

Database

What allows a SQL database to be accessed by multiple users at the same time?

Database Server

T/F - A single INSERT statement can be used to add rows to multiple tables.

False

T/F - Multiple primary keys can be added to a table.

False

What is a simple database that uses two-dimensional tables consisting of rows and columns?

Flat-type Database

What kind of data structure improves the speed of data retrieval?

Index

Which of the following is not a DDL statement? CREATE, MERGE, ALTER, DROP

MERGE

Which of the following is not a constraint? Null, Unique, Check, Primary

Null

Which of the following is not a DML statement? REMOVE, INSERT, DELETE, UPDATE

REMOVE

Which of the following is not a column constraint? Default, Check, Range, Unique

Range

Which type of database has multiple tables with parent/child relationships and a child that can have more than one parent?

Relational Database

What SQL statement is used to extract data from a database?

SELECT

What is the primary console used to configure databases for Microsoft SQL Server?

SSMS

What is the primary means of programming and managing SQL Server?

Transact-SQL

T/F - A self-reference arises when a foreign key constraint references a column in the same table.

True

T/F - Indexes should only be created on columns that are frequently searched.

True

Which SQL statement is used to update data in a database?

UPDATE

Which statement would you use to change the database context?

USE

What allows you to execute SQL commands in a command-line application?

sqlcmd scripts