Lesson 2: SQL Server Flashcards

1
Q

SQL Server Management Studio (SSMS)

A

The integrated environment used to manage the SQL infrastructure. It is used in this course.

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

Relational Database Management System (RDBMS

A

A database management system designed specifically for relational databases. I am using Microsoft SQL server Management Studio

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

New Query button

A

Opens a New Query window for a SQL query

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

Execute Button

A

The button to run the SQL query.

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

Object Explorer

A

In the SSMS, the window where the list of databases and other objects are located.

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

Query Editor Window

A

In the SSMS, the window where SQL query commands are written and executed.

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

SQL Script File

A

A file that contains SQL code that can be copied into the SSMS Query Editor window to be executed.

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

Comments

A

Written words in the code that the computer ignores. Comments are information for the programmer.

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

The * (Asterisk) in a SQL Command

A

The * (asterisk) is considered a wildcard and means “all.” For example, SELECT * FROM Customers means to select all the rows from the Customers table.

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

Available Databases Text Box

A

A text box that shows the name of the current database that is being used. You can change this option with the down arrow

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