Hawerth Castro
Quiz by , created more than 1 year ago

Database Fundamentals Quizzes preparing to certification

16
0
0
Hawerth Castro
Created by Hawerth Castro almost 7 years ago
Close

CET_TARDE - MTA Database - DIAGNOSTIC4

Question 1 of 15

1

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

Select one of the following:

  • .mdf

  • .ldf

  • .ndf

  • .log

Explanation

Question 2 of 15

1

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

Select one of the following:

  • sort

  • filter

  • index

  • transaction log

Explanation

Question 3 of 15

1

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

Select one of the following:

  • flat program

  • spreadsheet group

  • DAT application

  • DBMS

Explanation

Question 4 of 15

1

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

Select one of the following:

  • flat type database

  • hierarchical database

  • relational database

  • tabled database

Explanation

Question 5 of 15

1

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

Select one of the following:

  • flat-file database

  • hierarchical database

  • relational database

  • tabled database

Explanation

Question 6 of 15

1

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

Select one of the following:

  • database server

  • workstation

  • collector

  • computer located in the center of the building

Explanation

Question 7 of 15

1

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

Select one of the following:

  • checker

  • validator

  • scanner

  • constraint

Explanation

Question 8 of 15

1

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

Select one of the following:

  • DBS

  • SSMS

  • SQL Configuration Tool

  • SQL ODBC Emulator

Explanation

Question 9 of 15

1

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?

Select one of the following:

  • DML

  • DDE

  • DDL

  • DAT

Explanation

Question 10 of 15

1

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

Select one of the following:

  • DML

  • DDE

  • DDL

  • DAT

Explanation

Question 11 of 15

1

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

Select one of the following:

  • DML

  • DDE

  • DDL

  • DAT

Explanation

Question 12 of 15

1

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

Select one of the following:

  • DELETE

  • DEL

  • DROP

  • REMOVE

Explanation

Question 13 of 15

1

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

Select one of the following:

  • SELECT

  • UPDATE

  • DELETE

  • STOP

Explanation

Question 14 of 15

1

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

Select one of the following:

  • DOS commands

  • sqlcmd scripts

  • XQuery

  • T-SQL

Explanation

Question 15 of 15

1

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

Select one of the following:

  • DOS commands

  • sqlcmd scripts

  • XQuery

  • Transact-SQL

Explanation

Previous
Check answer
Next