CET_TARDE - MTA Database - DIAGNOSTIC4

Description

Database Fundamentals Quizzes preparing to certification
Hawerth Castro
Quiz by Hawerth Castro, updated more than 1 year ago
Hawerth Castro
Created by Hawerth Castro over 7 years ago
27
0

Resource summary

Question 1

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

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

Question
What allows you to execute SQL commands in a command-line application?
Answer
  • DOS commands
  • sqlcmd scripts
  • XQuery
  • Transact-SQL
Show full summary Hide full summary

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