Quiz
CET_TARDE - MTA Database - DIAGNOSTIC4
Questions in this quiz (15)
1What kind of filename extension do Microsoft SQL Server transaction log files have?
- A.mdf
- B.ldf
- C.ndf
- D.log
2What kind of data structure improves the speed of data retrieval?
- Asort
- Bfilter
- Cindex
- Dtransaction log
3What is a collection of programs that enables you to enter, organize, and select data from a database?
- Aflat program
- Bspreadsheet group
- CDAT application
- DDBMS
4What is a simple database that uses two-dimensional tables consisting of rows and columns?
- Aflat type database
- Bhierarchical database
- Crelational database
- Dtabled database
5Which type of database has multiple tables with parent/child relationships and a child
that can have more than one parent?- Aflat-file database
- Bhierarchical database
- Crelational database
- Dtabled database
6What allows a SQL database to be accessed by multiple users at the same time?
- Adatabase server
- Bworkstation
- Ccollector
- Dcomputer located in the center of the building
7What are the limitations or rules placed on a file or column to ensure that data is
considered valid for a database?- Achecker
- Bvalidator
- Cscanner
- Dconstraint
8What is the primary console used to configure databases for Microsoft SQL Server?
- ADBS
- BSSMS
- CSQL Configuration Tool
- DSQL ODBC Emulator
9Which 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?- ADML
- BDDE
- CDDL
- DDAT
10Which of the following is a subset of T-SQL that deals with creating database objects
such as tables and stored procedures?- ADML
- BDDE
- CDDL
- DDAT
11What kind of statements are USE, CREATE, ALTER, and DROP?
- ADML
- BDDE
- CDDL
- DDAT
12What statement would you use to delete a table from a SQL database?
- ADELETE
- BDEL
- CDROP
- DREMOVE
13Which statement can you use to remove rows from a table?
- ASELECT
- BUPDATE
- CDELETE
- DSTOP
14What is the primary means of programing and managing SQL Server?
- ADOS commands
- Bsqlcmd scripts
- CXQuery
- DT-SQL
15What allows you to execute SQL commands in a command-line application?
- ADOS commands
- Bsqlcmd scripts
- CXQuery
- DTransact-SQL
Information
- Description
- Database Fundamentals Quizzes preparing to certification
- Author
- Hawerth Castro
- Language
- Português
- Views
- 84
- History
- Created on 27 Jul 2017 · updated on 27 Jul 2017
- Tags
- Rating
- No ratings yet Rate this quiz