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

Get-Ser | ConvertTo-HTML -Property Name, Status > C:\services.htm

Get-Service | Property Name, Status > C:\services.htm

Get-Service | ConvertTo-HTML -Property Name, Status > C:\services.htm

Unrestricted execution policy can be set up in SQL Server can be done using :

Set-ExecutionPolicy Unrestricted

__________ is stored only in the Master database.

Database-scoped Dynamic Management View

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

Find all the tuples having temperature greater than ‘Paris’.

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)

SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’

SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)

SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)

SELECT * FROM weather WHERE temperature > ‘Paris’ temperature

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70 .

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70

SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

What is the meaning of LIKE ‘%0%0%’ ?

Feature has more than two 0’s

Feature has two 0’s in it, at any position

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName” ?

SELECT * FROM Persons SORT BY ‘FirstName’ DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT ‘FirstName’ DESC

SELECT * FROM Persons ORDER BY FirstName DESC

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?

SELECT * FROM Persons WHERE FirstName=’%a%’

SELECT * FROM Persons WHERE FirstName=’a’

SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

SELECT * FROM Persons WHERE FirstName=’%a%’

What is the purpose of the SQL AS clause ?

The AS clause is used with the JOIN clause only

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column

The AS clause is used with the JOIN clause only

The AS clause defines a search condition

Which of the following statement is true ?

Both DELETE and TRUNCATE free the space containing the table

DELETE does not free the space containing the table and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE does not free the space containing the table

DELETE free the space containing the table and TRUNCATE does not free the space containing the table

424 + Mcqs in Basic Sql in Structured Query Language (SQL) Page 8 McqOptions

351.	Which server can join the indexes when only multiple indexes combined can cover the query ?
A.	SQL
B.	DBMS
C.	RDBMS
D.	All of the mentioned
Answer» B. DBMS

Discussion

352.	Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use :
A.	Limit 10
B.	Upto 10
C.	Only 10
D.	Max 10
Answer» B. Upto 10

Discussion

353.	Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary ?
A.	Mean(salary)
B.	Avg(salary)
C.	Sum(salary)
D.	Count(salary)
Answer» C. Sum(salary)

Discussion

354.	Which of the following function is used when you want all tied rows to have the same ranking ?
A.	RANK
B.	NTILE
C.	ROW_NUMBER
D.	None of the mentioned
Answer» B. NTILE

Discussion

355.	Which of the following functions are similar ?
A.	RANK and NTILE
B.	RANK and DENSE_RANK
C.	DENSE_RANK and NTILE
D.	None of the mentioned
Answer» C. DENSE_RANK and NTILE

Discussion

356.	LAST_VALUE comes in the category of :
A.	Ranking window function
B.	Associate window function
C.	Analytic window functions
D.	All of the mentioned
Answer» D. All of the mentioned

Discussion

357.	Which of the following function is a analytic window function ?
A.	LAG
B.	LEAD
C.	FIRST_VALUE
D.	None of the mentioned
Answer» C. FIRST_VALUE

Discussion

358.	Code for creating an HTML report that lists the name of each service along with its status is :
A.	Get-Ser \| ConvertTo-HTML -Property Name, Status > C:\services.htm
B.	Get-Service \| Property Name, Status > C:\services.htm
C.	Get-Service \| ConvertTo-HTML -Property Name, Status > C:\services.htm
D.	All of the mentioned
Answer» D. All of the mentioned

Discussion

359.	Unrestricted execution policy can be set up in SQL Server can be done using :
A.	Set-ExecutionPolicy Unrestricted
B.	Set-Policy Unrestricted
C.	Set-Policy Unrestricted
D.	None of the mentioned
Answer» B. Set-Policy Unrestricted

Discussion

360.	_________ convert object properties into CSV objects.
A.	ConvertFrom-CSV
B.	Convert-CSV
C.	ConvertFromCSV
D.	All of the mentioned
Answer» B. Convert-CSV

Discussion

361.	The phrase “greater than at least one” is represented in SQL by ____
A.	< all
B.	< some
C.	> all
D.	> some
Answer» E.

Discussion

362.	We can test for the nonexistence of tuples in a subquery by using the __________ construct.
A.	Not exist
B.	Not exists
C.	Exists
D.	Exist
Answer» C. Exists

Discussion

363.	A Boolean data type that can take values true, false, and ___
A.	1
B.	0
C.	Null
D.	Unknown
Answer» E.

Discussion

364.	__________ is stored only in the Master database.
A.	Database-scoped Dynamic Management View
B.	Complex View
C.	Catalog View
D.	None of the mentioned
Answer» E.

Discussion

365.	Which is not a type of join in T-SQL?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» C. Outer join

Discussion

366.	The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	Cartesian join
Answer» E.

Discussion

367.	How many tables may be included with a join ?
A.	One
B.	Two
C.	Three
D.	All of the Mentioned
Answer» E.

Discussion

368.	Which of the following is one of the basic approaches for joining tables ?
A.	Subqueries
B.	Union Join
C.	Natural join
D.	All of the Mentioned
Answer» E.

Discussion

369.	What type of join is needed when you wish to return rows that do have matching values ?
A.	Equi-join
B.	Natural join
C.	Outer join
D.	All of the Mentioned
Answer» E.

Discussion

370.	The command to remove rows from a table ‘CUSTOMER’ is
A.	DROP FROM CUSTOMER
B.	UPDATE FROM CUSTOMER
C.	REMOVE FROM CUSTOMER
D.	DELETE FROM CUSTOMER WHERE
Answer» E.

Discussion

371.	Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.
A.	SELECT * FROM weather WHERE humidity IN (63 to 79)
B.	SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)
C.	SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79
D.	SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79
Answer» D. SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

Discussion

372.	Find all the tuples having temperature greater than ‘Paris’.
A.	SELECT * FROM weather WHERE temperature > (SELECT temperature FROM weather WHERE city = ‘Paris’
B.	SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)
C.	SELECT * FROM weather WHERE temperature > (SELECT city FROM weather WHERE city = ‘Paris’)
D.	SELECT * FROM weather WHERE temperature > ‘Paris’ temperature
Answer» B. SELECT * FROM weather WHERE temperature > (SELECT * FROM weather WHERE city = ‘Paris’)

Discussion

373.	Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70 .
A.	SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
B.	SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
C.	SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
D.	SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
Answer» D. SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70

Discussion

374.	What is the meaning of LIKE ‘%0%0%’ ?
A.	Feature begins with two 0’s
B.	Feature ends with two 0’s
C.	Feature has more than two 0’s
D.	Feature has two 0’s in it, at any position
Answer» E.

Discussion

375.	How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
A.	UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
B.	MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
C.	MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
D.	UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Answer» E.

Discussion

376.	Which of the following command makes the updates performed by the transaction permanent in the database ?
A.	ROLLBACK
B.	COMMIT
C.	TRUNCATE
D.	DELETE
Answer» C. TRUNCATE

Discussion

377.	Which SQL keyword is used to sort the result-set ?
A.	ORDER BY
B.	SORT
C.	ORDER
D.	SORT BY
Answer» B. SORT

Discussion

378.	With SQL, how can you return the number of not null records in the “Persons” table ?
A.	SELECT COUNT() FROM Persons
B.	SELECT COLUMNS() FROM Persons
C.	SELECT COLUMNS(*) FROM Persons
D.	SELECT COUNT(*) FROM Persons
Answer» B. SELECT COLUMNS() FROM Persons

Discussion

379.	With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName” ?
A.	SELECT * FROM Persons SORT BY ‘FirstName’ DESC
B.	SELECT * FROM Persons ORDER FirstName DESC
C.	SELECT * FROM Persons SORT ‘FirstName’ DESC
D.	SELECT * FROM Persons ORDER BY FirstName DESC
Answer» E.

Discussion

380.	With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?
A.	SELECT * FROM Persons WHERE FirstName=’a’
B.	SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
C.	SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
D.	SELECT * FROM Persons WHERE FirstName=’%a%’
Answer» D. SELECT * FROM Persons WHERE FirstName=’%a%’

Discussion

381.	What does DML stand for ?
A.	Different Mode Level
B.	Data Model Language
C.	Data Mode Lane
D.	Data Manipulation language
Answer» E.

Discussion

382.	What is the purpose of the SQL AS clause ?
A.	The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column
B.	The AS clause is used with the JOIN clause only
C.	The AS clause defines a search condition
D.	All of the mentioned
Answer» B. The AS clause is used with the JOIN clause only

Discussion

383.	Which of the following statement is true ?
A.	DELETE does not free the space containing the table and TRUNCATE free the space containing the table
B.	Both DELETE and TRUNCATE free the space containing the table
C.	Both DELETE and TRUNCATE does not free the space containing the table
D.	DELETE free the space containing the table and TRUNCATE does not free the space containing the table
Answer» B. Both DELETE and TRUNCATE free the space containing the table

Discussion

384.	If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
A.	ASC
B.	DESC
C.	There is no default value
D.	None of the mentioned
Answer» B. DESC

Discussion

385.	_______________ is not a category of SQL command .
A.	TCL
B.	SCL
C.	DCL
D.	DDL
Answer» C. DCL

Discussion

386.	_______________ is not a category of SQL command.
A.	TCL
B.	SCL
C.	DCL
D.	DDL
Answer» C. DCL

Discussion

387.	Built in Functions in SQL Server is categorized in to how many category ?
A.	4
B.	5
C.	6
D.	7
Answer» B. 5

Discussion

388.	______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking
A.	RANK
B.	NTILE
C.	DENSE_RANK
D.	ROW_NUMBER
Answer» D. ROW_NUMBER

Discussion

389.	Text and Image Functions are ______
A.	nondeterministic
B.	deterministic
C.	table valued
D.	All of the mentioned
Answer» B. deterministic

Discussion

390.	__________ are used for supporting encryption, decryption, digital signing and their validation .
A.	Cryptographic functions
B.	Cursor functions
C.	Configuration functions
D.	None of the mentioned
Answer» B. Cursor functions

Discussion

391.	_____________ function returns current date and time.
A.	SET DATEFIRST
B.	SYSDATETIME
C.	Cert_ID
D.	GETDATE
Answer» E.

Discussion

392.	Which of the data type has storage size of 8 bytes ?
A.	timestamp
B.	uniqueidentifier
C.	real
D.	smallmoney
Answer» B. uniqueidentifier

Discussion

393.	_____________ is monetary data type in SQL Server.
A.	Smallmoney
B.	sql_variant
C.	Cursor
D.	None of the Mentioned
Answer» B. sql_variant

Discussion

394.	________ is a spatial data type .
A.	geometry
B.	sql_variant
C.	cursor
D.	all of the mentioned
Answer» C. cursor

Discussion

395.	________ is a spatial data type.
A.	geometry
B.	sql_variant
C.	cursor
D.	all of the mentioned
Answer» C. cursor

Discussion

396.	Exact Numeric data type is ______
A.	bigint
B.	int
C.	smallmoney
D.	all of the mentioned
Answer» E.

Discussion

397.	The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.
A.	model
B.	msdb
C.	master
D.	temp
Answer» C. master

Discussion

398.	_____________ is schematic drawing used for representing relationships in database.
A.	Trigger
B.	Database Diagrams
C.	Table designer
D.	Query Editor
Answer» C. Table designer

Discussion

399.	Which of the following is used to build sql statements without writing code ?
A.	Registered Servers
B.	Query Designer
C.	Template Explorer
D.	Context Explorer
Answer» C. Template Explorer

Discussion

400.	__________menu allows user to set up some keyboard shortcuts.
A.	Edit
B.	File
C.	Tools
D.	None of the Mentioned
Answer» D. None of the Mentioned

Discussion

Explore topic-wise MCQs in Structured Query Language (SQL).

Which server can join the indexes when only multiple indexes combined can cover the query ?

Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use :

Select __________ from instructor where dept name= ’Comp. Sci.’; Which of the following should be used to find the mean of the salary ?

Which of the following function is used when you want all tied rows to have the same ranking ?

Which of the following functions are similar ?

LAST_VALUE comes in the category of :

Which of the following function is a analytic window function ?

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

Unrestricted execution policy can be set up in SQL Server can be done using :

_________ convert object properties into CSV objects.

The phrase “greater than at least one” is represented in SQL by ____

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

A Boolean data type that can take values true, false, and ___

__________ is stored only in the Master database.

Which is not a type of join in T-SQL?

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?

How many tables may be included with a join ?

Which of the following is one of the basic approaches for joining tables ?

What type of join is needed when you wish to return rows that do have matching values ?

The command to remove rows from a table ‘CUSTOMER’ is

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

Find all the tuples having temperature greater than ‘Paris’.

Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70 .

What is the meaning of LIKE ‘%0%0%’ ?

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

Which of the following command makes the updates performed by the transaction permanent in the database ?

Which SQL keyword is used to sort the result-set ?

With SQL, how can you return the number of not null records in the “Persons” table ?

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName” ?

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a” ?

What does DML stand for ?

What is the purpose of the SQL AS clause ?

Which of the following statement is true ?

If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default

_______________ is not a category of SQL command .

_______________ is not a category of SQL command.

Built in Functions in SQL Server is categorized in to how many category ?

______________ returns the rank of rows within the partition of a result set, without any gaps in the ranking

Text and Image Functions are ______

__________ are used for supporting encryption, decryption, digital signing and their validation .

_____________ function returns current date and time.

Which of the data type has storage size of 8 bytes ?

_____________ is monetary data type in SQL Server.

________ is a spatial data type .

________ is a spatial data type.

Exact Numeric data type is ______

The _________ database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

_____________ is schematic drawing used for representing relationships in database.

Which of the following is used to build sql statements without writing code ?

__________menu allows user to set up some keyboard shortcuts.