Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

View solution

Q. ___________ is stored only in the Master database.

View solution

Q. If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.

View solution

Q. All aggregate functions except __________ ignore null values in their input collection.

View solution

Q. A Boolean data type that can take values true, false, and ____________

View solution

Q. Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester?

View solution

Q. The phrase “greater than at least one” is represented in SQL by ___________

View solution

Q. We can test for the nonexistence of tuples in a subquery by using the __________ construct.

View solution

Q. Which of the following command is used to get child items in powershell?

View solution

Q. Point out the wrong statement.

View solution

Q. __________ convert object properties into CSV objects.

View solution

Q. Point out the wrong statement.

View solution

Q. Syntax for viewing the methods and properties we can pipe our output to Get-Member by ______________

View solution

Q. Unrestricted execution policy can be set up in SQL Server can be done using __________

View solution

Q. Code for creating an HTML report that lists the name of each service along with its status is __________

View solution

Q. Which of the following code list all the log files in Window?

View solution

Q. Which of the following code snippet will return output as false?

View solution

Q. What is SQL Server 2008 R2 Hard Disk Space Requirement for database engine?

View solution

Q. Point out the correct statement.

View solution

Q. Which are the SQL Server 2008 R2 components require space more than 1.5 Gb?

View solution