Question 1

What type of functions are used to summarize data in a grouped column or for all records in a table?

Accepted Answer

A) Summary procedures 
B) Aggregate functions 
C) Grouping statements 
D) Totaling processes 
A) Summary procedures 
B) Aggregate functions 
C) Grouping statements 
D) Totaling processes B

Question 2

Use the syntax WHERE [Column Name] ______________ (SELECT * FROM [Table Name 2])when you want to compare a value of a column against the results of a subquery.

Accepted Answer

EXISTS

Question 3

What is the name for the type of query where a SQL query is embedded within another SQL query?

Accepted Answer

A) nested query 
B) embedded query 
C) subquery 
D) inner query 
A) nested query 
B) embedded query 
C) subquery 
D) inner query C

Question 4

What keyword can you include in a SELECT statement to create a column alias for the column returned in the result set?

Accepted Answer

A) FROM 
B) FOR 
C) ALIAS 
D) AS 
A) FROM 
B) FOR 
C) ALIAS 
D) AS

Question 5

Which of the following represents correct syntax for a SELECT statement?

Accepted Answer

A) SELECT [Column Name] FROM [Table Name] 
B) SELECT [Object Name] FOR [Column Name]; 
C) SELECT [Database Name] From [Column Name]; 
D) SELECT [Table Name] FROM [Row Name] 
A) SELECT [Column Name] FROM [Table Name] 
B) SELECT [Object Name] FOR [Column Name]; 
C) SELECT [Database Name] From [Column Name]; 
D) SELECT [Table Name] FROM [Row Name]

Question 6

Which statement is used to modify column values of an existing row in a table?

Accepted Answer

A) ALTER 
B) CHANGE 
C) MODIFY 
D) UPDATE 
A) ALTER 
B) CHANGE 
C) MODIFY 
D) UPDATE

Question 7

Which clause do you use with a join operation to specify which columns from each table should be used as the matching key?

Accepted Answer

A) FROM 
B) ON 
C) BY 
D) WITH 
A) FROM 
B) ON 
C) BY 
D) WITH

Question 8

Which command will result in records that have a Col1 value greater than 100?

Accepted Answer

A) SELECT Col1 FROM Table1 IF Col1 GT 100 
B) SELECT Col1 FROM Table1 WHERE Col1 > 100 
C) SELECT Col1 > 100 FROM Table1 
D) IF Col1 > 100 SELECT * FROM Table1 
A) SELECT Col1 FROM Table1 IF Col1 GT 100 
B) SELECT Col1 FROM Table1 WHERE Col1 > 100 
C) SELECT Col1 > 100 FROM Table1 
D) IF Col1 > 100 SELECT * FROM Table1

Question 9

How does the SQL language handle case and what are the recommendations on using case when constructing SQL statements?

Accepted Answer

The SQL language is not case sensitive;

Question 10

If you want to remove duplicates from a result set, which command should you use?

Accepted Answer

A) SELECT AS 
B) SELECT UNIQUE 
C) SELECT ONLY 
D) SELECT DISTINCT 
A) SELECT AS 
B) SELECT UNIQUE 
C) SELECT ONLY 
D) SELECT DISTINCT

Question 11

SQL is an imperative programming language.

Accepted Answer

A) True 
 B)False

Question 12

How can you ease the managing of permissions across different objects?

Accepted Answer

To improve the ease of managing permissi

Question 13

What are the keywords CHECK, UNIQUE, and NOT NULL referred to as?

Accepted Answer

A) limits 
B) keys 
C) constraints 
D) references 
A) limits 
B) keys 
C) constraints 
D) references

Question 14

Which of the following is true about the SQL language?

Accepted Answer

A) it is case sensitive 
B) keywords must be written in uppercase 
C) the semicolon is a statement terminator 
D) statement terminators are required at the end of a statement 
A) it is case sensitive 
B) keywords must be written in uppercase 
C) the semicolon is a statement terminator 
D) statement terminators are required at the end of a statement

Question 15

Which command changes the database context?

Accepted Answer

A) OPEN [Database Name] 
B) USE [Database Name]; 
C) SELECT [Database Name]; 
D) SWITCH [Database Name] 
A) OPEN [Database Name] 
B) USE [Database Name]; 
C) SELECT [Database Name]; 
D) SWITCH [Database Name]

Question 16

Which command selects all columns in a table?

Accepted Answer

A) SELECT # 
B) SELECT ; 
C) SELECT * 
D) SELECT @ 
A) SELECT # 
B) SELECT ; 
C) SELECT * 
D) SELECT @

Question 17

A string concatenation operation evaluates to null if all of the input columns have a value.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following best describes the IntelliSense feature in Query Editor?

Accepted Answer

A) it is a database building wizard 
B) it is a text AutoComplete feature 
C) it is a visual query builder 
D) it is used to create tables 
A) it is a database building wizard 
B) it is a text AutoComplete feature 
C) it is a visual query builder 
D) it is used to create tables

Question 19

What are the key requirements to keep in mind when creating an INSERT statement?

Accepted Answer

The column values in the VALUES or SELEC

Question 20

Which command returns all the columns for records in which the value of Col1 is greater than 10 but has a value less than Col2?

Accepted Answer

A) SELECT * FROM Table1 WHERE Col1 10 B) SELECT ALL FROM Table1 WHEN Col1 10 C) SELECT * FROM Table1 IF Col1 > 10 BUT Col1 10 NOT Col1 < Col2 A) SELECT * FROM Table1 WHERE Col1 10 B) SELECT ALL FROM Table1 WHEN Col1 10 C) SELECT * FROM Table1 IF Col1 > 10 BUT Col1 10 NOT Col1 < Col2

What type of functions are used to summarize data in a grouped column or for all records in a table?

Use the syntax WHERE [Column Name] ______________ (SELECT * FROM [Table Name 2])when you want to compare a value of a column against the results of a subquery.

What is the name for the type of query where a SQL query is embedded within another SQL query?

What keyword can you include in a SELECT statement to create a column alias for the column returned in the result set?

Which of the following represents correct syntax for a SELECT statement?

Which statement is used to modify column values of an existing row in a table?

Which clause do you use with a join operation to specify which columns from each table should be used as the matching key?

Which command will result in records that have a Col1 value greater than 100?

How does the SQL language handle case and what are the recommendations on using case when constructing SQL statements?

If you want to remove duplicates from a result set, which command should you use?

SQL is an imperative programming language.

How can you ease the managing of permissions across different objects?

What are the keywords CHECK, UNIQUE, and NOT NULL referred to as?

Which of the following is true about the SQL language?

Which command changes the database context?

Which command selects all columns in a table?

A string concatenation operation evaluates to null if all of the input columns have a value.

Which of the following best describes the IntelliSense feature in Query Editor?

What are the key requirements to keep in mind when creating an INSERT statement?

Which command returns all the columns for records in which the value of Col1 is greater than 10 but has a value less than Col2?

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters

Exam 5: Transact:SQL Primer

What type of functions are used to summarize data in a grouped column or for all records in a table?

Use the syntax WHERE [Column Name] ______________ (SELECT * FROM [Table Name 2])when you want to compare a value of a column against the results of a subquery.

What is the name for the type of query where a SQL query is embedded within another SQL query?

What keyword can you include in a SELECT statement to create a column alias for the column returned in the result set?

Which of the following represents correct syntax for a SELECT statement?

Which statement is used to modify column values of an existing row in a table?

Which clause do you use with a join operation to specify which columns from each table should be used as the matching key?

Which command will result in records that have a Col1 value greater than 100?

How does the SQL language handle case and what are the recommendations on using case when constructing SQL statements?

If you want to remove duplicates from a result set, which command should you use?

SQL is an imperative programming language.

How can you ease the managing of permissions across different objects?

What are the keywords CHECK, UNIQUE, and NOT NULL referred to as?

Which of the following is true about the SQL language?

Which command changes the database context?

Which command selects all columns in a table?

A string concatenation operation evaluates to null if all of the input columns have a value.

Which of the following best describes the IntelliSense feature in Query Editor?

What are the key requirements to keep in mind when creating an INSERT statement?

Which command returns all the columns for records in which the value of Col1 is greater than 10 but has a value less than Col2?

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

SQL Server Security

Performance Monitoring and Optimization

Backup and Recovery

Data Integration

Monitoring SQL Server 2012

Filters