SQL Server Flashcards

1
Q

What are the two authentication modes in SQL Server?

A

Windows Mode and Mixed Mode

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

What Is SQL Profiler?

A

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring an instance of the Database Engine or Analysis Services.

Microsoft SQL Server Profiler is now depricated.

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

What are the differences between local and global temporary tables?

A

Local temporary tables are visible when there is a connection, and are deleted when the connection is closed.

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

What is COALESCE in SQL Server?

A

COALESCE is used to return the first non-null expression within the arguments. This function is used to return a non-null from more than one column in the arguments.

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

What does UNION do?

A

UNION merges the contents of two structurally-compatible tables into a single combined table.

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

What is the difference between UNION and UNION ALL?

A

UNION will omit duplicate records whereas UNION ALL will include duplicate records.

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

What are the 3 types of SQL statements?

A
  1. DDL (Data Definition Language): It is used to define the database structure such as tables. It includes three statements such as Create, Alter, and Drop.
  2. DML (Data Manipulation Language): These statements are used to manipulate the data in records. Commonly used DML statements are Insert, Update, and Delete.
  3. DCL (Data Control Language): These statements are used to set privileges such as Grant and Revoke database access permission to the specific user.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is Referential Integrity?

A

Set of rules that restrict the values of one or more columns of the tables based on the values of the primary key or unique key of the referenced table.

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

What is Collation?

A

Set of rules that define how data is stored, how case sensitivity and Kana character can be treated etc.

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