SQL/MCQ | SQL Data Types Sample Test,Sample questions

Question:
 Bit is an integer that can be –

1.0

2.1

3.Null

4.All the above

Posted Date:-2022-01-01 07:19:34


Question:
 TINYTEXT can hold the maximum length of ___ characters?

1. 254

2.255

3.256

4.257

Posted Date:-2022-01-01 07:09:50


Question:
 What does BOOL mean in MySQL Numeric Data Types?

1.A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is considered true.

2.A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is considered false.

3.A Boolean value is specified by this variable. When a value is nonzero, it is considered true, and zero is also considered true.

4.A Boolean value is specified by this variable. When a value is nonzero, it is considered false, and zero is also considered false.

Posted Date:-2022-01-01 07:13:52


Question:
 Which of the following is SQL Server Numeric Data Type?

1.image

2.nchar

3.money

4.cursor

Posted Date:-2022-01-01 07:07:56


Question:
How MySQL determines which one to use, FLOAT or DOUBLE, using the p parameter?

1.If p comes between 0 to 25, data type becomes FLOAT(). If p comes between 26 to 54, data type becomes DOUBLE().

2.If p comes between 26 to 54, data type becomes FLOAT(). If p comes between 0 to 25, data type becomes DOUBLE().

3.If p comes between 25 to 53, data type becomes FLOAT(). If p comes between 0 to 24, data type becomes DOUBLE().

4.If p comes between 0 to 24, data type becomes FLOAT(). If p comes between 25 to 53, data type becomes DOUBLE().

Posted Date:-2022-01-01 07:12:35


Question:
In how many categories data types has been classified?

1.2

2.3

3.4

4.5

Posted Date:-2022-01-01 07:04:10


Question:
In the database table, data types describe the kind of ___ that it can contain.

1. Table

2.Data

3.Number

4.None of the above

Posted Date:-2022-01-01 07:03:42


Question:
Name of the data type categories are,

1.String Data types

2. Numeric Data types

3.Date and time Data types

4.All the above

Posted Date:-2022-01-01 07:04:55


Question:
What can be the maximum size of char(n) in SQL Server String Data Type?

1.7000

2.8000

3.9000

4.10000

Posted Date:-2022-01-01 07:14:22


Question:
What is the difference between nchar and nvarchar?

1.nchar is fixed and nvarchar is variable.

2.nchar is variable and nvarchar is fixed.

3.nchar has the maximum size of 4000 characters and nvarchar has the maximum size of 8000 characters.

4.nchar has the maximum size of 800 characters and nvarchar has the maximum size of 4000 characters.

Posted Date:-2022-01-01 07:15:29


Question:
What is the difference between VARCHAR and VARCHAR2?

1.VARCHAR can store upto 4000 bytes and VARCHAR2 can store upto 8000 bytes.

2.VARCHAR can store upto 2000 bytes and VARCHAR2 can store upto 4000 bytes.

3.Both VARCHAR and VARCHAR2 are similar but use of VARCHAR2 is mostly recommended.

4.There is no similarity between VARCHAR and VARCHAR2.

Posted Date:-2022-01-01 07:23:00


Question:
What is the full form of BLOB?

1.Binary Long Objects

2.Binary Least Objects

3. Binary Large Objects

4.Binary Large Orientation

Posted Date:-2022-01-01 07:11:05


Question:
What is the full form of GUID?

1.Guided Unique Identifier

2.Guided Unique Interpreter Globally

3.Unique Identifier Globally

4.Unique Interpreter

Posted Date:-2022-01-01 07:20:42


Question:
What is the similarity between CLOB and NCLOB Oracle Large Object Data Types?

1.Both CLOB and NCLOB are used for multibyte national character set data.

2.Both CLOB and NCLOB can range upto 2^32-1 bytes or 4 GB.

3.Both CLOB and NCLOB can range upto 2^32-1 bytes or 8GB.

4.Both CLOB and NCLOB are used for singlebyte and multibyte national character set data.

Posted Date:-2022-01-01 07:22:00


Question:
Which of the following are not MySQL Date and Time Data Type?

1.DATE

2.TIME(fsp)

3.YEAR

4.None of the above

Posted Date:-2022-01-01 07:06:37


Question:
Which of the following is not MySQL Numeric Data Type?

1.BIT(Size)

2.CHAR(Size)

3.INTEGER(Size)

4. INT(Size)

Posted Date:-2022-01-01 07:05:52


Question:
Which of the following is SQL Server Date and Time Data Type?

1.timestamp

2.sql_variant

3. real

4. text

Posted Date:-2022-01-01 07:08:50


Question:
Which of the following is SQL Server String Data Type?

1.ntext

2.binary(n)

3.varbinary

4.All the above

Posted Date:-2022-01-01 07:07:16


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL Basics
  20. MCQ | SQL Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!