MTA DAF 1

Question 1

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

Answer 1

flat type database

Question 2

What is the primary means of programming and managing SQl-Sever?

Answer 2

T-SQl

Question 3

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?

Answer 3

DML (Data Manipulation Language)

Question 4

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

Answer 4

relational database

Question 5

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

Answer 5

DDL (Data Definition Language)

Question 6

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

Answer 6

.ldf

Question 7

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

Answer 7

SSMS (SQL Server Management Studio)

Question 8

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

Answer 8

DROP

Question 9

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

Answer 9

DELETE

Question 10

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

Answer 10

sqlcmd scripts

Question 11

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

Answer 11

constraint

Question 12

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

Answer 12

DDL

Question 13

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

Answer 13

index

Question 14

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

Answer 14

DBMS (Database Management System)

Question 15

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

Answer 15

database server