What kind of filename extension do Microsoft SQL Server transaction log files have?
.mdf
.ldf
.ndf
.log
What kind of data structure improves the speed of data retrieval?
sort
filter
index
transaction log
What is a collection of programs that enables you to enter, organize, and select data from a database?
flat program
spreadsheet group
DAT application
DBMS
What is a simple database that uses two-dimensional tables consisting of rows and columns?
flat type database
hierarchical database
relational database
tabled database
Which type of database has multiple tables with parent/child relationships and a child that can have more than one parent?
flat-file database
What allows a SQL database to be accessed by multiple users at the same time?
database server
workstation
collector
computer located in the center of the building
What are the limitations or rules placed on a file or column to ensure that data is considered valid for a database?
checker
validator
scanner
constraint
What is the primary console used to configure databases for Microsoft SQL Server?
DBS
SSMS
SQL Configuration Tool
SQL ODBC Emulator
Which of the following is a language element that allows you to use core statements such as INSERT, UPDATE, and DELETE to manipulate data in any SQL Server table?
DML
DDE
DDL
DAT
Which of the following is a subset of T-SQL that deals with creating database objects such as tables and stored procedures?
What kind of statements are USE, CREATE, ALTER, and DROP?
What statement would you use to delete a table from a SQL database?
DELETE
DEL
DROP
REMOVE
Which statement can you use to remove rows from a table?
SELECT
UPDATE
STOP
What is the primary means of programing and managing SQL Server?
DOS commands
sqlcmd scripts
XQuery
T-SQL
What allows you to execute SQL commands in a command-line application?
Transact-SQL
