Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

MS SQL Server > SQL Server Intro & Version History > Flashcards

SQL Server Intro & Version History Flashcards

1
Q

What is SQL Server?

A

A Relational Database Management System (RDBMS) developed by Microsoft.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is T-SQL?

A

A Microsoft Propriety language also known as Transact-SQL.

Provides additional capabilities beyond standard SQL, like declaring variables, handling errors, and storing procedures.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What type of architecture does MS SQL Server use?

A

Client-Server Architecture

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Key Components / Services of SQL Server:

> > What is SQL Server?

A

The service that starts, stops, pauses, continues an instance of Microsoft SQL Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Key Components / Services of SQL Server:

> > What is the Database Engine?

A

The component handling storage, rapid transaction processing, and securing data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Key Components / Services of SQL Server:

> > What is SQL Server Agent?

A

Performs the role of Task Scheduler. Can perform operations on ad hoc or scheduled basis.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Key Components / Services of SQL Server:

> > What is SQL Server Browser?

A

Service that listens for incoming requests and connects them to the desired SQL Server Instance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Key Components / Services of SQL Server:

> > What is SQL Server Full-Text Search?

A

Service that allows user to execute full-text queries against character data in SQL Tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Key Components / Services of SQL Server:

> > What is SQL Server VSS Writer?

A

Service that allows for backup and restoration of data files when SQL Server is not running.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Key Components / Services of SQL Server:

> > What is SQL Server Analysis Services (SSAS)?

A

Service that provides data analysis, data mining, and machine learning capabilities. Integrated with R and Python Languages for analytics.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Key Components / Services of SQL Server:

> > What is SQL Server Reporting Services (SSRS)?

A

Service that provides reporting features and decision-making capabilities. Integrated with Hadoop.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Key Components / Services of SQL Server:

> > What is SQL Server Integration Services?

A

Provides ETL functionality for converting data from one source to another, i.e., converts raw data into useful data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What type of SQL Server Instances are there?

A

Primary Instances (the main instance)

Named Instances (all other instances, must follow connection via IP Address and name (i.e, 127.0.0.1\xyz)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly

MS SQL Server (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions