Which syntax should you use to sort the result set in reverse alphabetic order.

Which syntax should you use to sort the result set in reverse alphabetic order.

A) ORDER ON [Column Name] Z-A
B) SORT REVERSE BY [Column Name]
C) SORT ON [Column Name] REVERSE
D) ORDER BY [Column Name] DESC

Answer: D) ORDER BY [Column Name] DESC

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

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

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

Answer: B) SELECT Col1 FROM Table1 WHERE Col1 > 100

If Col1 contains the string "Hello" and Col2 is Null, what is the result of SELECT Col1 + Col2?

If Col1 contains the string "Hello" and Col2 is Null, what is the result of SELECT Col1 + Col2?

A) "Hello"
B) Error
C) Null
D) "HelloNull"

Answer: C) Null

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

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

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

Answer: D) SELECT DISTINCT

Which command changes the database context?

Which command changes the database context?

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

Answer: B) USE [Database Name];

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

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

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]


Answer: A) SELECT [Column Name] FROM [Table Name]