Question 1

What are the two basic building blocks of a database? Describe them.

Accepted Answer

The basic building blocks of a database are tables and indexes. A table is a collection of data stored in a database. In a relational database, tables are typically designed to model real-world objects and the relationships that exist between them. A table is organized as a two-dimensional structure consisting of rows and columns. A database index is a logical database structure used to improve the speed and efficiency of data access. database index is constructed based on a unique key, and it contains pointers to the underlying rows within the table that match the key.

Question 2

List and describe three of the five system databases found in an SQL Server 2012 system.

Accepted Answer

master - Stores information on the structure of other databases and their components; maintains configuration settings, including security tempdb - Stores temporary data that is generated when the database engine executes processes model - Stores a database template that is used as a blueprint when creating a new user database resource - Stores the system objects in a read-only database; these logically appear in each database in the sys schema msdb - Stores information related to jobs, schedules, and database backups,

Question 3

Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL server instance?

Accepted Answer

A) named pipes 
B) SSRP 
C) TDS packets 
D) loopback address 
A) named pipes 
B) SSRP 
C) TDS packets 
D) loopback address D

Question 4

Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?

Accepted Answer

A) modeling format 
B) virtual instance 
C) physical architecture 
D) logical structure 
A) modeling format 
B) virtual instance 
C) physical architecture 
D) logical structure

Question 5

Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?

Accepted Answer

A) physical resources 
B) transparency to the user 
C) backup and recovery operations 
D) security 
A) physical resources 
B) transparency to the user 
C) backup and recovery operations 
D) security

Question 6

What is the primary purpose of a database?

Accepted Answer

The primary purpose of a datab

Question 7

A linked server uses shared software components from the dynamic-link library on the server.

Accepted Answer

A) True 
 B)False

Question 8

The master system database stores a database template that is used as a blueprint when creating a new user database.

Accepted Answer

A) True 
 B)False

Question 9

Which tool allows you to create SQL queries to be executed against a database?

Accepted Answer

A) Object Explorer 
B) Query Editor 
C) Analysis Services 
D) View Compiler 
A) Object Explorer 
B) Query Editor 
C) Analysis Services 
D) View Compiler

Question 10

A ______________ is a physical unit of storage into which data files are subdivided.

Accepted Answer

The answer of A ______________ is a physical unit of...

Question 11

Which of the following enable frequently perform tasks to be stored as objects in the database?

Accepted Answer

A) procedures 
B) views 
C) indexes 
D) constraints 
A) procedures 
B) views 
C) indexes 
D) constraints

Question 12

In a _________________ database, tables are designed to model real-world objects and the relationships that exist between them.

Accepted Answer

The answer of In a _________________ database, tables are designed...

Question 13

Which system database stores information related to jobs, schedules, and database backups?

Accepted Answer

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

Question 14

Which of the following is a file extension used in the physical structure of a SQL database?

Accepted Answer

A) .ldf 
B) .mdb 
C) .txt 
D) .dbf 
A) .ldf 
B) .mdb 
C) .txt 
D) .dbf

Question 15

What is a data type and how are they used in tables?

Accepted Answer

The data type is a column attribute that

Question 16

What is used to configure a connection to an external data source from within SQL Server?

Accepted Answer

A) linked server object 
B) TDS packets 
C) listener 
D) named pipe 
A) linked server object 
B) TDS packets 
C) listener 
D) named pipe

Question 17

Match between columns
                        Premises: provides a tree view of the different database schema objects organized as a series of folders
a physical storage unit that is a collection of eight pages
organized as a two-dimensional structure consisting of rows and columns
constructed based on a unique key, and it contains pointers to the underlying rows within the table
a log of events on the database management system
the column or combination of columns that uniquely identify each record within a table
a condition that imposes a limitation on a value or action
provides the capability to execute queries against a remote data source for running distributed queries.
an older interprocess communication mechanism that enables a client application to connect to a server process on the same or different hosts
a precompiled block of code that enables frequently performed tasks for querying and/or manipulating data

Accepted Answer

The Answer of procedure and named pipe and extent and is...

Question 18

The ______________ system database stores the system objects in a read-only database.

Accepted Answer

The answer of The ______________ system database stores the system...

Question 19

Which of the following may require the database engine to perform a full scan on every record of the database?

Accepted Answer

A) invalid constraints 
B) too many triggers 
C) no index is defined 
D) no secondary key 
A) invalid constraints 
B) too many triggers 
C) no index is defined 
D) no secondary key

Question 20

Linked servers can be created, modified, or dropped by using a SQL query.

Accepted Answer

A) True 
 B)False

What are the two basic building blocks of a database? Describe them.

List and describe three of the five system databases found in an SQL Server 2012 system.

Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL server instance?

Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?

Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?

What is the primary purpose of a database?

A linked server uses shared software components from the dynamic-link library on the server.

The master system database stores a database template that is used as a blueprint when creating a new user database.

Which tool allows you to create SQL queries to be executed against a database?

A ______________ is a physical unit of storage into which data files are subdivided.

Which of the following enable frequently perform tasks to be stored as objects in the database?

In a _________________ database, tables are designed to model real-world objects and the relationships that exist between them.

Which system database stores information related to jobs, schedules, and database backups?

Which of the following is a file extension used in the physical structure of a SQL database?

What is a data type and how are they used in tables?

What is used to configure a connection to an external data source from within SQL Server?

The ______________ system database stores the system objects in a read-only database.

Which of the following may require the database engine to perform a full scan on every record of the database?

Linked servers can be created, modified, or dropped by using a SQL query.

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

What are the two basic building blocks of a database? Describe them.

List and describe three of the five system databases found in an SQL Server 2012 system.

Which of the following is used by SQLCMD to test network connections used to remotely connect to a SQL server instance?

Which of the following is a way of organizing data, with defined rules for storing, manipulating, and retrieving data?

Which of the following is NOT a reason for a database administrator to understand the main file types used in a SQL Server system?

What is the primary purpose of a database?

A linked server uses shared software components from the dynamic-link library on the server.

The master system database stores a database template that is used as a blueprint when creating a new user database.

Which tool allows you to create SQL queries to be executed against a database?

A ______________ is a physical unit of storage into which data files are subdivided.

Which of the following enable frequently perform tasks to be stored as objects in the database?

In a _________________ database, tables are designed to model real-world objects and the relationships that exist between them.

Which system database stores information related to jobs, schedules, and database backups?

Which of the following is a file extension used in the physical structure of a SQL database?

What is a data type and how are they used in tables?

What is used to configure a connection to an external data source from within SQL Server?

The ______________ system database stores the system objects in a read-only database.

Which of the following may require the database engine to perform a full scan on every record of the database?

Linked servers can be created, modified, or dropped by using a SQL query.

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