Question 1

Which system database stores information on the structure of other databases and their components?

Accepted Answer

A) model 
B) master 
C) msdb 
D) tempdb 
A) model 
B) master 
C) msdb 
D) tempdb

Question 2

Which of the following is NOT a network protocol supported by SQL Server 2012?

Accepted Answer

A) shared memory 
B) named pipes 
C) NWLink 
D) TCP/IP 
A) shared memory 
B) named pipes 
C) NWLink 
D) TCP/IP

Question 3

Describe the logical organization of a database.

Accepted Answer

Each database is organized using a logic

Question 4

Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?

Accepted Answer

A) table 
B) index 
C) constraint 
D) time stamp 
A) table 
B) index 
C) constraint 
D) time stamp

Question 5

Client applications can only connect to the SQL Server instance on the local computer.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is NOT a system database on a SQL Server system?

Accepted Answer

A) model 
B) master 
C) directory 
D) resource 
A) model 
B) master 
C) directory 
D) resource

Question 7

Which of the following is a data provider that enables a connection to be established to almost any database or file irrespective of the operating system?

Accepted Answer

A) DLL 
B) ODBC 
C) Oracle 
D) Jet 
A) DLL 
B) ODBC 
C) Oracle 
D) Jet

Question 8

LastName and FirstName are examples of ____________ in a database table.

Accepted Answer

The answer of LastName and FirstName are examples of ____________...

Question 9

The primary purpose of a database is to organize and store data in a secure manner.

Accepted Answer

A) True 
 B)False

Question 10

When defining a ____________ server, it is possible to override the integrated authentication with a stored username and password.

Accepted Answer

The answer of When defining a ____________ server, it is...

Question 11

Describe the physical structure of a database.

Accepted Answer

Each database that is mounted on a SQL S

Question 12

What are int, date, and bit examples of in a SQL database?

Accepted Answer

A) data type 
B) condition 
C) column name 
D) record 
A) data type 
B) condition 
C) column name 
D) record

Question 13

Which service enables a client to connect to the SQL Server instance over a network?

Accepted Answer

A) loopback 
B) listener 
C) SQLCMD 
D) shared memory 
A) loopback 
B) listener 
C) SQLCMD 
D) shared memory

Question 14

What happens if there is no index defined for a query? What is its impact?

Accepted Answer

If no index is defined, a query will req

Question 15

What should you do to prevent blockage of the port used to communicate with a SQL Server instance?

Accepted Answer

A) disable the firewall on the client 
B) configure a fixed port 
C) disable the firewall on the server 
D) use named pipes 
A) disable the firewall on the client 
B) configure a fixed port 
C) disable the firewall on the server 
D) use named pipes

Question 16

Describe how TCP/IP is used in SQL Server 2012 remote connectivity.

Accepted Answer

TCP/IP is the most common protocol used

Question 17

What are the roles of listeners and loopback addresses in SQL Server remote connections?

Accepted Answer

A listener is a service that enables a c

Question 18

Describe some of the components found in SQL Server Management Studio.

Accepted Answer

SQL Server Management Studio is a manage

Question 19

Which of the following is commonly referred to as a record?

Accepted Answer

A) constraint 
B) column 
C) row 
D) attribute 
A) constraint 
B) column 
C) row 
D) attribute

Question 20

What can be used to satisfy compliance aspects of business requirements by creating time stamps and audits?

Accepted Answer

A) logical instance 
B) index 
C) constraint 
D) trigger 
A) logical instance 
B) index 
C) constraint 
D) trigger

Which system database stores information on the structure of other databases and their components?

Which of the following is NOT a network protocol supported by SQL Server 2012?

Describe the logical organization of a database.

Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?

Client applications can only connect to the SQL Server instance on the local computer.

Which of the following is NOT a system database on a SQL Server system?

Which of the following is a data provider that enables a connection to be established to almost any database or file irrespective of the operating system?

LastName and FirstName are examples of ____________ in a database table.

The primary purpose of a database is to organize and store data in a secure manner.

When defining a ____________ server, it is possible to override the integrated authentication with a stored username and password.

Describe the physical structure of a database.

What are int, date, and bit examples of in a SQL database?

Which service enables a client to connect to the SQL Server instance over a network?

What happens if there is no index defined for a query? What is its impact?

What should you do to prevent blockage of the port used to communicate with a SQL Server instance?

Describe how TCP/IP is used in SQL Server 2012 remote connectivity.

What are the roles of listeners and loopback addresses in SQL Server remote connections?

Describe some of the components found in SQL Server Management Studio.

Which of the following is commonly referred to as a record?

What can be used to satisfy compliance aspects of business requirements by creating time stamps and audits?

Introduction to SQL Server 2012

Deploying SQL Server 2012

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters

Exam 3: Architecture and Configuration

Which system database stores information on the structure of other databases and their components?

Which of the following is NOT a network protocol supported by SQL Server 2012?

Describe the logical organization of a database.

Which of the following is a basic building block of a database that is used to improve the speed and efficiency of data access?

Client applications can only connect to the SQL Server instance on the local computer.

Which of the following is NOT a system database on a SQL Server system?

Which of the following is a data provider that enables a connection to be established to almost any database or file irrespective of the operating system?

LastName and FirstName are examples of ____________ in a database table.

The primary purpose of a database is to organize and store data in a secure manner.

When defining a ____________ server, it is possible to override the integrated authentication with a stored username and password.

Describe the physical structure of a database.

What are int, date, and bit examples of in a SQL database?

Which service enables a client to connect to the SQL Server instance over a network?

What happens if there is no index defined for a query? What is its impact?

What should you do to prevent blockage of the port used to communicate with a SQL Server instance?

Describe how TCP/IP is used in SQL Server 2012 remote connectivity.

What are the roles of listeners and loopback addresses in SQL Server remote connections?

Describe some of the components found in SQL Server Management Studio.

Which of the following is commonly referred to as a record?

What can be used to satisfy compliance aspects of business requirements by creating time stamps and audits?

Introduction to SQL Server 2012

Deploying SQL Server 2012

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters