SQL 1 & 2

Question 1

is a specific request for data manipulation issued by the end-user or the application to the DBMS.

Answer 1

query

Question 2

SQL Consists of commands that

Create _______and _____structures
Perform various types of data _________ and data _________
Query the _________ to extract useful _________

Answer 2

Create database and table structures
Perform various types of data manipulation and data administration
Query the database to extract useful information

Question 3

free edition of SQL server ideal for development and production for desktop, web, and small server applications.

Answer 3

Microsoft SQL Server

Question 4

an open-source relational database management system.

Answer 4

MySQL

Question 5

– Is a multi-model database management system produced and marketed by Oracle Corporation.

Answer 5

Oracle RDBMS

Question 6

a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools.

Answer 6

Microsoft Access

Question 7

bigint, bit, decimal, int, money, numeric

Answer 7

exact numeric

Question 8

float, real

Answer 8

approximate numeric

Question 9

date, datetime, time

Answer 9

date and time

Question 10

char, text, varchar

Answer 10

character strings

Question 11

nchar, ntext, nvarchar

Answer 11

unicode character strings

Question 12

binary, image, varbinary

Answer 12

binary strings

Question 13

cursor, sql_variant, table, uniqueidentifier, xml

Answer 13

other data types

Question 14

A large integer. Signed range from -9223372036854775808 to 9223372036854775807. Unsigned range is from 0 to 18446744073709551615. The size parameter specifies the maximum display width (which is 255).

Answer 14

BIGINT (size)

Question 15

A bit-value type. The number of bits per value is specified in size. The size parameter can hold a value from 1 to 64. The default value for size is 1.

Answer 15

BIT (size)

Question 16

An exact fixed-point number. The total number of digits is specified insize. The number of digits after the decimal point is specified in thedparameter. The maximum number forsizeis 65. The maximum number fordis 30. The default value forsizeis 10. The default value fordis 0.

Answer 16

DECIMAL (size, d)

Question 17

A medium integer. Signed range is from -2147483648 to 2147483647. Unsigned range is from 0 to 4294967295. Thesizeparameter specifies the maximum display width (which is 255)

Answer 17

INT (size)

Question 18

Stores currency amounts. Can store fixed-point numbers up to a maximum of 32 significant digits. Can be used like DECIMAL (x,y) format.

Answer 18

MONEY

Question 19

Used to store fixed-precision and scaled numbers. Similar to DECIMAL data type. This type is useful when precise numeric values are required, such as in financial calculations.

Answer 19

NUMERIC

Question 20

Zero is considered as false, nonzero values are considered as true.

Answer 20

BOOL or BOOLEAN

Question 21

A normal-size floating point number. The total number of digits is specified insize. The number of digits after the decimal point is specified in thedparameter.

Answer 21

DOUBLE (size, d)

Question 22

A floating point number. The total number of digits is specified insize. The number of digits after the decimal point is specified in thedparameter. This syntax is deprecated in MySQL 8.0.17, and it will be removed in future MySQL versions.

Answer 22

FLOAT (size, d)

Question 23

An approximate number with floating point numerical data. Equivalent to FLOAT.

Answer 23

REAL

Question 24

A date. Format: YYYY-MM-DD. The supported range is from ‘1000-01-01’ to ‘9999-12-31’

Answer 24

DATE

Question 25

A date and time combination. Format: YYYY-MM-DD hh:mm:ss. The supported range is from '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. Adding DEFAULT and ON UPDATE in the column definition to get automatic initialization and updating to the current date and time. FSP means fractional seconds precision.

Answer 25

DATETIME (fsp)

Question 26

A time. Format: hh:mm:ss. The supported range is from '-838:59:59' to '838:59:59'

Answer 26

TIME (fsp)

Question 27

A fixed length string (can contain letters, numbers, and special characters). The size parameter specifies the column length in characters – can be from 0 to 255. Default is 1.

Answer 27

CHAR (size)

Question 28

Holds a string with a maximum length of 65,535 bytes

Answer 28

TEXT

Question 29

A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum string length in characters - can be from 0 to 65535.

Answer 29

VARCHAR (size)

Question 30

A fixed-width Unicode string with maximum of 4,000 characters.

Answer 30

NCHAR

Question 31

A variable-width Unicode string with a maximum of 2GB of text data.

Answer 31

NTEXT

Question 32

A variable-width Unicode string with a maximum of 4,000 characters.

Answer 32

NVARCHAR

Question 33

Equal to CHAR() but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1.

Answer 33

BINARY (size)

Question 34

A variable-width binary string with a maximum of 2GB capacity.

Answer 34

IMAGE

Question 35

Equal to VARCHAR() but stores binary byte strings. The size parameter specifies the maximum column length in bytes.

Answer 35

VARBINARY (size)

Question 36

Stores a reference to a cursor used for database operations. You can use cursors to manipulate data in a database, one row at a time. A cursor uses a SQL SELECT statement to fetch a rowset from a database and then can read and manipulate one row at a time.

Answer 36

CURSOR

Question 37

Stores up to 8,000 bytes of data of various data types, except text, ntext, and timestamp. A column of type sql_variant may contain rows of different data types. For example, a column defined as sql_variant can store int, binary, and char values. sql_variant can have a maximum length of 8016 bytes.

Answer 37

SQL_VARIANT

Question 38

Stores a result-set for later processing.

Answer 38

TABLE

Question 39

Stores a globally unique identifier (GUID). It can store 16 bytes of data.

Answer 39

UNIQUEIDENTIFIER

Question 40

Stores XML formatted data with a maximum of 2GB capacity. A built-in data type in SQL server and is somewhat similar to other built-in data type such as int and varchar.

Answer 40

XML