DBMS

Question 1

data type are useful if columns or variables accept only two values plus not null. It is the smallest and fastest numeric data type.

Answer 1

Bit

Question 2

smallest integer data type and only uses 1 byte of storage.

Answer 2

TINYINT

Question 3

stores small whole numbers. The maximum negative number, –32,768, is a reserved value and cannot be used. Allow designers to place limits on both space size and data usage.

Answer 3

SMALLINT

Question 4

It represents whole numbers. 9-10 digits of precision.

Answer 4

INT

Question 5

A normal-size floating point number. The total number of digits is specified in size. The number of digits after the decimal point is specified in the d parameter. up to 15 digits decimal digits.

Answer 5

DOUBLE -

Question 6

• Largest integer data type. It is intended for use when integer values might exceed the
  range that is supported by the int data type.

Answer 6

BIGINT

Question 7

type of exact numeric type. It is used to store numbers with a predetermined number of digits and decimal places.

Answer 7

DECIMAL

Question 8

is a precise numeric storage format in SQL databases, used to store numbers with a fixed number of decimal places. It allows specifying the total number of digits (precision) and the number of digits to the right of the decimal point (scale).

Answer 8

NUMERIC

Question 9

an approximate number with floating point data.__________ value is approximate which means not all values can be represented exactly. FLOAT(24) is identical to REAL.

Answer 9

FLOAT

Question 10

suitable for storing data that needs to represent larger or smaller numerical values, such as scientific or engineering calculations. It occupies 4 bytes with a precision of approximately 7 digits

Answer 10

REAL

Question 11

stores integers like int , but gives a wider range of values at the cost of taking more memory. Long stores at least 32 bits, giving it a range of -2,147,483,648 to 2,147,483,647.

Answer 11

LONG

Question 12

Stores only the date component without the time.
Example: 2024-02-21

Answer 12

DATE

Question 13

Stores only the time component without the date.
Example: 12:30:45

Answer 13

TIME

Question 14

Stores both date and time components.
Example: 2024-02-21 12:30:45

Answer 14

DATETIME

Question 15

Fixed length with a maximum length of 8,000 characters

Answer 15

CHAR

Question 16

• Variable-length storage with a maximum length of
  8,000 characters

Answer 16

VARCHAR-

Question 17

Variable-length storage with provided max
characters, not supported in MySQL

Answer 17

VARCHAR(max)-

Question 18

• Variable-length storage with a maximum size of 2GB data

Answer 18

TEXT

Question 19

Fixed length with a maximum length of 4,000 characters

Answer 19

NCHAR

Question 20

Variable-length storage with a maximum length of
4,000 characters

Answer 20

NVARCHAR

Question 21

Variable-length storage with a maximum size of 1GB data

Answer 21

NTEXT

Question 22

is a base-2 numeral system used in computing and
digital electronics.

Answer 22

BINARY

Question 23

Miscellaneous Data Types

Answer 23

CLOB (Character Large OBject)-

BLOB (Binary Large OBject)]

XML (eXtensible Markup Language)-

JSON (JavaScript Object Notation)

Question 24

NULL in SQL represents a column field in the table with no value. NULL is different from a zero value and from “none”

Answer 24

Is NOT NULL

Question 25

constraint ensures that all values in a column are
different.

Answer 25

UNIQUE

Question 26

is a column (or combination of columns) that
uniquely identifies each record in a database table.

Answer 26

Primary Key

Question 27

is a critical link between tables in a database, ensuring data integrity by enforcing relationships between them.

Answer 27

FOREIGN KEY

Question 28

Types of Index

Answer 28

Unique Index
Single-Column Index
Composite Index

Question 29

To drop an INDEX constraint

Answer 29

DROP Index

Question 30

are used to perform mathematical operations on the numerical values. SQL provides following operators to perform mathematical operations.

Answer 30

SQL Arithmetic Operators

Question 31

in math is defined as the operation used to represent
repeated multiplication.

Answer 31

Exponentiation

Question 32

Give Logical operator

Answer 32

ALL
EXISTS
AND
IN
ANY
IS NULL
LIKE
SOME
NOT
UNIQUE
BETWEEN
OR

Question 33

Data types that do not fall into standard
categories like integers, strings, or dates. Instead,
these types are diverse and might be designed to
handle specific kinds of data or scenarios.

Answer 33

Miscellaneous Data Types

Question 34

TRUE if all of a set of comparisons are TRUE.

Answer 34

ALL

Question 35

TRUE if all the conditions separated by AND are TRUE.

Answer 35

AND

Question 36

TRUE if any one of a set of comparisons are TRUE

Answer 36

ANY

Question 37

TRUE if the operand lies within the range of comparisons.

Answer 37

BETWEEN

Question 38

TRUE if the subquery returns one or more records

Answer 38

EXISTS

Question 39

TRUE if the operand is equal to one of a list of expressions.

Answer 39

IN

Question 40

TRUE if the operand matches a pattern specially with wildcard.

Answer 40

LIKE

Question 41

Reverses the value of any other Boolean operator

Answer 41

NOT

Question 42

TRUE if any of the conditions separated by OR is TRUE

Answer 42

OR

Question 43

TRUE if the expression value is NULL.

Answer 43

is NULL

Question 44

TRUE if some of a set of comparisons are TRUE.

Answer 44

SOME

Question 45

operator searches every row of a specified table for uniqueness (no duplicates).

Answer 45

UNIQUE

Question 46

SQL Operator Precendence

Answer 46

Parentheses
Identity, Negation
Multiplication, Division
Addition, Subtraction
Comparison
Logical Operators
Assignment Operator