.Net Technology

.Net Technology - Upwork

Question: What is returned by NULLIF if the two expressions that it compares are NOT equal?
A
It returns the first expression.

B
It returns the second expression.

C
It returns a null value.

D
It returns an error.

Note: Not available
1. Report
Question: User defined data type columns can be designated with ROWGUIDCOL.
A
True

B
False

Note: Not available
1. Report
Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?
A
sqlcmd -S instanceName -o C:\new.txt

B
sqlcmd -S instanceName -i C:\myScript.sql -o C:\new.txt

C
sqlcmd -S myServer\instanceName -o C:\new.txt

D
sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\new.txt

Note: Not available
1. Report
Question: Analyze the following code snippet:
DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime'
What is the output of the above code?
A
02:02:02.2345

B
02:02:02

C
02:02:02.2346

D
An error is displayed

Note: Not available
1. Report
Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?
A
sqlcmd -S instanceName -o C:\new.txt

B
sqlcmd -S instanceName -i C:\myScript.sql -o C:\new.txt

C
sqlcmd -S myServer\instanceName -o C:\new.txt

D
sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\new.txt

Note: Not available
1. Report
Question: Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?
A
sqlcmd

B
icrosoft .NET Framework SqlClient

C
OLE DB provider

D
None of these

Note: Not available
1. Report
Question: What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?
A
ON

B
OFF

C
TRUE

D
FALSE

Note: Not available
1. Report
Question: Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?
A
Multiple UNIQUE constraints can be defined on a table.

B
When using the UNIQUE constraint, only one null value is allowed per column.

C
UNIQUE constraint cannot be referenced by a FOREIGN KEY constraint

D
None

Note: Not available
1. Report
Question: Which of the following options is used to change the value of the password variable and exit using sqlcmd?
A
-p

B
-P

C
-z

D
-Z

Note: Not available
1. Report
Question: The regular identifiers of SQL Server 2008 may contain a range of _______ characters.
A
1 to 116

B
1 to 127

C
1 to 128

D
1 to 512

Note: Not available
1. Report

First Prev 13 14 15 16 17 Next Last

Question: What is returned by NULLIF if the two expressions that it compares are NOT equal?

Question: User defined data type columns can be designated with ROWGUIDCOL.

Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

Question: Analyze the following code snippet:
DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime'
What is the output of the above code?

Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

Question: Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

Question: What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?

Question: Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?

Question: Which of the following options is used to change the value of the password variable and exit using sqlcmd?

Question: The regular identifiers of SQL Server 2008 may contain a range of _______ characters.

Question: What is returned by NULLIF if the two expressions that it compares are NOT equal?

Question: User defined data type columns can be designated with ROWGUIDCOL.

Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

Question: Analyze the following code snippet:DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime' What is the output of the above code?

Question: Which of the following commands is used to save the output to a text file after you run a Transact-SQL script using sqlcmd?

Question: Which of the following is used by SQL Server 2008 Management Studio to execute scripts in regular mode in the Query Editor?

Question: What is the default value of the SORT_IN_TEMPDB clause of the relational_index_option specified at the time of creation of an index on a table in SQL Server 2008?

Question: Which of the following statements is NOT true about the UNIQUE constraint of SQL Server 2008?

Question: Which of the following options is used to change the value of the password variable and exit using sqlcmd?

Question: The regular identifiers of SQL Server 2008 may contain a range of _______ characters.

Question: Analyze the following code snippet:
DECLARE @myTime TIME(4) = '02:02:02.234567 +01:01' SELECT @myTime AS '@myTime'
What is the output of the above code?