NAIMMCQ: Structured Query Language

Structured Query Language

Showing posts with label Structured Query Language. Show all posts

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?

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?

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?

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

Answer: D) SELECT DISTINCT

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?

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]

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

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

Answer: B) it is a text AutoComplete feature

A database operation that can be used to merge and retrieve data stored in more than one table view is called a SELECT.

A) True
B) False

Answer: B) False

Transact-SQL is the variant of SQL developed by Microsoft and Sybase.

A) True
B) False

Answer: A) True

SQL is an imperative programming language.

A) True
B) False

Answer: B) False

What happens if you need to compare two values of different data types?

A) the system is halted
B) the value with the highest precision is returned
C) an 'incompatible type' error occurs
D) a data type conversion is performed

Answer: D) a data type conversion is performed

What should you define if you want to grant several users the same permissions to database objects?

A) schema
B) user
C) role
D) access list

Answer: C) role

Which of the following is true about database permissions?

A) access to databases is controlled by Windows logon authentication
B) database users are defined for each database
C) server-level permissions provide the least access to SQL databases
D) permissions can only be set at the server or database level

Answer: B) database users are defined for each database

Which of the following is true about the Autogrowth setting?

A) by default, it doubles the size of the log file when it becomes full
B) the data file is affected by it but log files are not
C) you should keep this value as small as possible
D) you should configure it so that file growth occurs infrequently

Answer: D) you should configure it so that file growth occurs infrequently

Which of the following is best described as a logical unit of work reading or writing from a database?

A) I/O performance
B) database transaction
C) log file record
D) individual filegroup

Answer: B) database transaction

Which of the following is true about the model database template?

A) it cannot be customized
B) changes to it will affect existing databases
C) new databases will inherit settings from it
D) modifying model database settings requires different steps than user databases

Answer: C) new databases will inherit settings from it

Since it is easy to make configuration changes after a database is created, it's best to get the database created and make changes as necessary afterward.

A) True
B) False

Answer: B) False

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

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

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

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

Which command changes the database context?

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

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

A database operation that can be used to merge and retrieve data stored in more than one table view is called a SELECT.

Transact-SQL is the variant of SQL developed by Microsoft and Sybase.

SQL is an imperative programming language.

What happens if you need to compare two values of different data types?

What should you define if you want to grant several users the same permissions to database objects?

Which of the following is true about database permissions?

Which of the following is true about the Autogrowth setting?

Which of the following is best described as a logical unit of work reading or writing from a database?

Which of the following is true about the model database template?

Which of the following is a required setting that must be supplied when creating a database?

What should you always do before creating a new database?

The NEW table SQL language statement is used to make a new table.

Since it is easy to make configuration changes after a database is created, it's best to get the database created and make changes as necessary afterward.