CET_TARDE - MTA Database - DIAGNOSTIC4

Beschreibung

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Quiz von Hawerth Castro, aktualisiert more than 1 year ago
Hawerth Castro
Erstellt von Hawerth Castro vor fast 7 Jahre
16
0

Zusammenfassung der Ressource

Frage 1

Frage
What kind of filename extension do Microsoft SQL Server transaction log files have?
Antworten
  • .mdf
  • .ldf
  • .ndf
  • .log

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?
Antworten
  • database server
  • workstation
  • collector
  • computer located in the center of the building

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?
Antworten
  • DML
  • DDE
  • DDL
  • DAT

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?
Antworten
  • DML
  • DDE
  • DDL
  • DAT

Frage 11

Frage
What kind of statements are USE, CREATE, ALTER, and DROP?
Antworten
  • DML
  • DDE
  • DDL
  • DAT

Frage 12

Frage
What statement would you use to delete a table from a SQL database?
Antworten
  • DELETE
  • DEL
  • DROP
  • REMOVE

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
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

CET_TARDE - MTA Database - INDEX
Hawerth Castro
CET_TARDE - MTA Database - E_COMANDS
Hawerth Castro
CET_TARDE - MTA Database - E_backup_permissions
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Mobility and Devices Fundamentals 1
Hawerth Castro
CET_TARDE - MTA Software Development Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Database - DIAGNOSTIC5
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 4
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 6
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 3
Hawerth Castro
CET_TARDE - MTA Windows OS Fundamentals 5
Hawerth Castro