CET_TARDE - MTA Database - DIAGNOSTIC4

Descrição

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Quiz por Hawerth Castro, atualizado more than 1 year ago
Hawerth Castro
Criado por Hawerth Castro quase 7 anos atrás
18
0

Resumo de Recurso

Questão 1

Questão
What kind of filename extension do Microsoft SQL Server transaction log files have?
Responda
  • .mdf
  • .ldf
  • .ndf
  • .log

Questão 2

Questão
What kind of data structure improves the speed of data retrieval?
Responda
  • sort
  • filter
  • index
  • transaction log

Questão 3

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

Questão 4

Questão
What is a simple database that uses two-dimensional tables consisting of rows and columns?
Responda
  • flat type database
  • hierarchical database
  • relational database
  • tabled database

Questão 5

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

Questão 6

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

Questão 7

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

Questão 8

Questão
What is the primary console used to configure databases for Microsoft SQL Server?
Responda
  • DBS
  • SSMS
  • SQL Configuration Tool
  • SQL ODBC Emulator

Questão 9

Questão
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?
Responda
  • DML
  • DDE
  • DDL
  • DAT

Questão 10

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

Questão 11

Questão
What kind of statements are USE, CREATE, ALTER, and DROP?
Responda
  • DML
  • DDE
  • DDL
  • DAT

Questão 12

Questão
What statement would you use to delete a table from a SQL database?
Responda
  • DELETE
  • DEL
  • DROP
  • REMOVE

Questão 13

Questão
Which statement can you use to remove rows from a table?
Responda
  • SELECT
  • UPDATE
  • DELETE
  • STOP

Questão 14

Questão
What is the primary means of programing and managing SQL Server?
Responda
  • DOS commands
  • sqlcmd scripts
  • XQuery
  • T-SQL

Questão 15

Questão
What allows you to execute SQL commands in a command-line application?
Responda
  • DOS commands
  • sqlcmd scripts
  • XQuery
  • Transact-SQL

Semelhante

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