CET_TARDE - MTA Database - DIAGNOSTIC4

Descripción

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Test por Hawerth Castro, actualizado hace más de 1 año
Hawerth Castro
Creado por Hawerth Castro hace más de 7 años
27
0

Resumen del Recurso

Pregunta 1

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

Pregunta 2

Pregunta
What kind of data structure improves the speed of data retrieval?
Respuesta
  • sort
  • filter
  • index
  • transaction log

Pregunta 3

Pregunta
What is a collection of programs that enables you to enter, organize, and select data from a database?
Respuesta
  • flat program
  • spreadsheet group
  • DAT application
  • DBMS

Pregunta 4

Pregunta
What is a simple database that uses two-dimensional tables consisting of rows and columns?
Respuesta
  • flat type database
  • hierarchical database
  • relational database
  • tabled database

Pregunta 5

Pregunta
Which type of database has multiple tables with parent/child relationships and a child that can have more than one parent?
Respuesta
  • flat-file database
  • hierarchical database
  • relational database
  • tabled database

Pregunta 6

Pregunta
What allows a SQL database to be accessed by multiple users at the same time?
Respuesta
  • database server
  • workstation
  • collector
  • computer located in the center of the building

Pregunta 7

Pregunta
What are the limitations or rules placed on a file or column to ensure that data is considered valid for a database?
Respuesta
  • checker
  • validator
  • scanner
  • constraint

Pregunta 8

Pregunta
What is the primary console used to configure databases for Microsoft SQL Server?
Respuesta
  • DBS
  • SSMS
  • SQL Configuration Tool
  • SQL ODBC Emulator

Pregunta 9

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

Pregunta 10

Pregunta
Which of the following is a subset of T-SQL that deals with creating database objects such as tables and stored procedures?
Respuesta
  • DML
  • DDE
  • DDL
  • DAT

Pregunta 11

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

Pregunta 12

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

Pregunta 13

Pregunta
Which statement can you use to remove rows from a table?
Respuesta
  • SELECT
  • UPDATE
  • DELETE
  • STOP

Pregunta 14

Pregunta
What is the primary means of programing and managing SQL Server?
Respuesta
  • DOS commands
  • sqlcmd scripts
  • XQuery
  • T-SQL

Pregunta 15

Pregunta
What allows you to execute SQL commands in a command-line application?
Respuesta
  • DOS commands
  • sqlcmd scripts
  • XQuery
  • Transact-SQL
Mostrar resumen completo Ocultar resumen completo

Similar

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 Windows OS Fundamentals 5
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