Zusammenfassung der Ressource
Frage 1
Frage
What kind of filename extension do Microsoft SQL Server transaction log files have?
Frage 2
Frage
What kind of data structure improves the speed of data retrieval?
Antworten
-
sort
-
filter
-
index
-
transaction log
Frage 3
Frage
What is a collection of programs that enables you to enter, organize, and select data from a database?
Antworten
-
flat program
-
spreadsheet group
-
DAT application
-
DBMS
Frage 4
Frage
What is a simple database that uses two-dimensional tables consisting of rows and columns?
Antworten
-
flat type database
-
hierarchical database
-
relational database
-
tabled database
Frage 5
Frage
Which type of database has multiple tables with parent/child relationships and a child
that can have more than one parent?
Antworten
-
flat-file database
-
hierarchical database
-
relational database
-
tabled database
Frage 6
Frage
What allows a SQL database to be accessed by multiple users at the same time?
Frage 7
Frage
What are the limitations or rules placed on a file or column to ensure that data is
considered valid for a database?
Antworten
-
checker
-
validator
-
scanner
-
constraint
Frage 8
Frage
What is the primary console used to configure databases for Microsoft SQL Server?
Antworten
-
DBS
-
SSMS
-
SQL Configuration Tool
-
SQL ODBC Emulator
Frage 9
Frage
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?
Frage 10
Frage
Which of the following is a subset of T-SQL that deals with creating database objects
such as tables and stored procedures?
Frage 11
Frage
What kind of statements are USE, CREATE, ALTER, and DROP?
Frage 12
Frage
What statement would you use to delete a table from a SQL database?
Frage 13
Frage
Which statement can you use to remove rows from a table?
Antworten
-
SELECT
-
UPDATE
-
DELETE
-
STOP
Frage 14
Frage
What is the primary means of programing and managing SQL Server?
Antworten
-
DOS commands
-
sqlcmd scripts
-
XQuery
-
T-SQL
Frage 15
Frage
What allows you to execute SQL commands in a command-line application?
Antworten
-
DOS commands
-
sqlcmd scripts
-
XQuery
-
Transact-SQL