stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
SQL Quiz Review Flashcards | StudBud
Explore
/
SQL Quiz Review
SQL Quiz Review
50 terms
·
StudBud Administration
·
18 plays
SQL Server Admin quiz review for quiz covering chapters 1, 2, and 3.
Flashcards
50 cards
F
Practice quiz
P
Host live
L
Questions
50
Answers
1
The smallest unit of data SQL can work with is a __________.
extent
table
row
page
2
The minimum amount of hard drive space required by SQL is __________ GB.
64
24
12
6
3
The default port the SQL server default instance listens on is _____________.
123
3389
4409
1433
4
SQL Mixed authentication supports?
Windows accounts
local and remote accounts
SQL or Oracle account access
SQL user database accounts
5
Configuring listeners for a SQL server is done with which utility?
SQL Server Configuration Manager
SQL Server Profilier
SQL Server Management Studio
SQL Server Installation Center
6
A transaction represents _____________?
an entry in the SQL profilier
a modification to database data
a connection to a SQL Instance
a stored procedure
7
When writing SQL statements in the management studio we use which window/pane?
Object Explorer
Query Editor
Solution Explorer
Properties Window
8
The first file that gets modified when making a change to database data is the _________ file.
audit
log
mdf
table
9
A database is made up of the logical basic building block called a ____________.
data type
procedure
row
table
10
Databases created by client applications hosted on a SQL Server would be called?
named instance
default instance
model database
user database
11
A logical instance of an object contained within a table can be referred to as a?
column
id
row
record
12
Each named instance _____________.
is a copy of the model database
contains one user database
includes the SQL Analysis service
is a running copy of the database engine
13
What is the main management tool for SQL Server?
SQL Server Data Tools
SQL Server Installation Center
SQL Server Management Studio
SQL Server Configuration Manager
14
Using Windows Authentication allows who access to your SQL server?
Windows accounts ONLY
Both Windows and SQL server accounts
Windows Administrator ONLY
SQL Server accounts ONLY
15
Which of the following Editions of SQL cannot be used in a production environment?
any 32 bit version
Developer
Web
Express
16
When connections come through a firewall to your SQL server ensure you set TCP dynamic ports to
blank
0
disabled
1
17
What is a linked server used for?
enable database failover
testing and troubleshooting network connectivity
query a remote DB
setup a database replay controller
18
Analyzing database data to make decisions about product marketing or inventory control would be
data warehousing
BI
unethical
performed using the Solutions Manager
19
Business Intelligence is supplied by which of the following SQL components?
SSIS
PowerPivot for Sharepoint
SSRS
SSAS
20
The key attribute required when defining a column in a table is the ___________.
primary key
index
id
data type
21
Which system database stores information related to scheduled jobs and backups?
Msdb
Model
TempDB
Master
22
______ represents a summary of data within a series of columns and is used for efficient search
table
stored procedure
row
index
23
Standard Edition is limited to ___________ GB of RAM.
64
32
16
8
24
If a user doesn't identify the instance to connect to the SQL server will _______________.
disconnect after a 30 seconds if no instance is chosen
connect the user to the default instance
connect the user to the master
wait for a valid instance to be chosen
25
sp_configure is a ______________ stored in the master database.
command line utility
a linked database
SQL profile
stored procedure
26
The database files and Log files should be stored on the same disk (which is the default)
not "should" the "MUST" be on the same disk
only if the disk has at least 40 GB free space
False
True
27
What tool is used to view open SQL server connections?
sqlcmd
SQL profilier
netstat
configuration manager
28
The column that uniquely identifies each record in a database is the ______________.
index
primary key
row
trigger
29
Where is documentation for SQL server found by default?
on the distribution DVD
As a bound book in the product packaging
inline once the product is installed
TechNet or MSDN online
30
Which system database stores data while changing other database data?
master
resource
tempdb
msdb
31
Which of the following would exceed Standard Edition SQL CPU limits?
2x 16 core Xeons
12x single core CPUs
6x dual core CPUs
4x quad core Xeons
32
The first unnamed instance installed on a SQL server is called the ______________.
default
model
tempdb
master
33
What are Log files used for?
auditing database access
automate database maintenance tasks
track changes to the database
hold summary.txt files of database mods
34
Which system database is the main configuration database for all other databases?
Master
Model
MSDB
Resource
35
Which system database contains all defaults for any new user database?
Model
Tempdb
Msdb
MASTER
36
Support for non-traditional data like images and word documents is provided by _____________.
FILESTREAM
FAT32
NTFS
Transact-SQL
37
Core licensing is based on a minimum of ______ cores.
8
1
2
4
38
Log files use which file extension?
.msl
.ldf
.log
.ldb
39
Prior to installing SQL Server you should ___________.
Disable IPv6
Disable your Windows firewall
All 3 of these should be done.
run System configuration checker
40
After the default instance all others must be ______________ instances.
named
unnamed
user
model
41
What feature does Enterprise SQL have that Standard edition doesn't?
core of CAL licensing options
Management and Development tools
no CPU or memory limitations
Advanced Business Intelligence
42
A SQL table is a logical structure made up of __________?
columns
triggers
rows
pages
43
Global configuration settings can be modified by setting the properties of ___________________.
the Host server through Server Manager
the SQL server instance properties
master database
msdb database
44
Which file is used to ensure data integrity when a SQL server crashes and is later brought back
index
log
page
extent
45
What file extension do SQL database files use?
.mdb
.mdf
.sql
.db
46
Which utility will let you run the SQL Server Features Discovery Report?
Configuration Manager
Installation Center
SQL Profilier
Management Studio
47
What is the database Engine responsible for?
data mining and analytics
managing the SQL Server services
extract, transform and load (ETL) functions
handling client application requests
48
The SQL Server Management Studio window that shows the instance and hosted databases is?
Query Editor
Object Explorer
Properties Window
Solutions Explorer
49
Configuration information for SQL Server databases is held in _____________.
the log (.msl) files
the "master" named instance
the default instance
system databases
50
Which system database is read-only and contains system objects?
resource
msdb
model
master
