Tag: sql

Questions Related to sql

What will be the output of the following statement? SELECT ROUND(123.89, -1)
sql

  1. 120.00

  2. 123.00

  3. 123.90

  4. 124.00

Show answer
Correct Option: A

What will be the output of the following statement? SELECT STR(6365, 3)
sql

  2. 6365

  3. 6,365

  4. 6400

  5. 6365.000

Show answer
Correct Option: A

What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0
sql

  1. Null

  2. 0

  3. Infinity

  4. An error is generated.

Show answer
Correct Option: A

View text definitions are stored in which system table?
sql

  1. sysobjects

  2. syscolumns

  3. syscomments

  4. sysviews

Show answer
Correct Option: C

What's the maximum value can an INT data type hold?
sql

  1. 2,147,483,647

  2. 2,147,483,648

  3. 4,294,967,295

  4. 4,294,967,296

Show answer
Correct Option: A

What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?
sql

  1. DATETIME

  2. INT

  3. SMALLDATETIME

  4. VARCHAR

Show answer
Correct Option: B

Which of the following is NOT a valid description of the public role?
sql

  1. The public role captures all default permissions for users in a database.

  2. The public role cannot be dropped.

  3. The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.

  4. The public role cannot have users, groups, or roles assigned to it.

Show answer
Correct Option: C

What is the maximum date value that can be stored in a SMALLDATETIME data type?

sql

  1. June 6, 2079

  2. July 6, 2079

  3. December 31, 2079

  4. December 31, 9999

Show answer
Correct Option: A

AI Explanation

To answer this question, we need to understand the range of values that can be stored in the SMALLDATETIME data type.

The SMALLDATETIME data type in SQL Server is used to store dates and times with a precision of one minute. It has a range from January 1, 1900, to June 6, 2079.

Let's go through each option to determine the correct answer:

Option A) June 6, 2079 - This option is correct because it falls within the range of values that can be stored in the SMALLDATETIME data type.

Option B) July 6, 2079 - This option is incorrect because it falls outside the range of values that can be stored in the SMALLDATETIME data type.

Option C) December 31, 2079 - This option is incorrect because it falls outside the range of values that can be stored in the SMALLDATETIME data type.

Option D) December 31, 9999 - This option is incorrect because it falls outside the range of values that can be stored in the SMALLDATETIME data type.

The correct answer is A) June 6, 2079. This option is correct because it falls within the range of values that can be stored in the SMALLDATETIME data type.

SELF JOIN not allowed in
sql

  1. Indexed view

  2. procedures

  3. triggers

  4. views

Show answer
Correct Option: A

What does ACID stands for?
sql

  1. Access, Consistency,Isolation,Data

  2. Access,Constrain,Index ,data

  3. Atomicity,Consistency,Isolation,Durability

  4. None of these

Show answer
Correct Option: C