Information Management

Question 1

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

Answer 1

Query

Question 2

SQL data type: bigint, bit, decimal, int, money, numeric

Answer 2

Exact numeric

Question 3

SQL data type: float, real

Answer 3

Approximate numeric

Question 4

SQL data type: date, datetime, time

Answer 4

Date and time

Question 5

SQL data type: char, text, varchar

Answer 5

Character strings

Question 6

SQL data type: nchar, ntext, nvarchar

Answer 6

Unicode character strings

Question 7

SQL data type: binary, image, varbinary

Answer 7

Binary strings

Question 8

SQL data type: cursor, sql_variant, table, uniqueidentifier, xml

Answer 8

Other data types

Question 9

SQL operators: +, - , *, /, %

Answer 9

Arithmetic

Question 10

SQL operators: =,>, <, >=, <=, <>

Answer 10

Comparison

Question 11

SQL operators: +=, -=, *=, /=, %=

Answer 11

Compound

Question 12

SQL operators: AND, OR, NOT, LIKE, IN, BETWEEN, EXISTS, ANY, ALL

Answer 12

Logical

Question 13

Syntax that creates a new database.

Answer 13

CREATE DATABASE

Question 14

Syntax that deletes an existing database.

Answer 14

DROP DATABASE

Question 15

Syntax that creates a new table in a database.

Answer 15

CREATE TABLE

Question 16

Syntax that deletes an existing table in a database.

Answer 16

DROP TABLE

Question 17

Syntax that adds, deletes, or modifies columns in an existing table.

Answer 17

ALTER TABLE

Question 18

Constraint that ensures that a column cannot have a null value upon creating a table on CREATE TABLE and ALTER TABLE.

Answer 18

NOT NULL

Question 19

Constraint that ensures that all values in a column are different upon creating a table on CREATE TABLE.

Answer 19

UNIQUE

Question 20

Constraint that creates a constraint on a column of an existing table on ALTER TABLE.

Answer 20

UNIQUE

Question 21

Constraint that uniquely identifies each row in a table on CREATE TABLE and ALTER TABLE.

Answer 21

PRIMARY KEY

Question 22

Constraint that uniquely identifies a row in another table on CREATE TABLE.

Answer 22

FOREIGN KEY

Question 23

Constraint that creates a constraint on a column of an existing table.

Answer 23

FOREIGN KEY

Question 24

Constraint that ensures that all values in a column satisfy a specific condition upon creating a table on CREATE TABLE and ALTER TABLE.

Answer 24

CHECK

Question 25

Constraint that sets a default value for a column when there is no value specified on CREATE TABLE and ALTER TABLE.

Answer 25

DEFAULT

Question 26

INSERT, SELECT, UPDATE, and DELETE

Answer 26

SQL Data Manipulation Commands

Question 27

Adds new rows/records to a table.

Answer 27

INSERT INTO

Question 28

Retrieves values of all rows or a subset of rows in a table.

Answer 28

SELECT

Question 29

An operator used with SELECT to retrieve unique values from columns in a table.

Answer 29

DISTINCT

Question 30

An option used with SELECT to filter the rows of data based on provided criteria.

Answer 30

WHERE

Question 31

An operator used with SELECT to determine whether a field is empty or not.

Answer 31

IS NULL

Question 32

An operator used with WHERE to determine whether a value matches a given string pattern.

Answer 32

LIKE

Question 33

An operator used with WHERE to check whether a value matches any value within a given list.

Answer 33

IN

Question 34

An operator used with WHERE to check whether a value is within a range.

Answer 34

BETWEEN

Question 35

An option used with SELECT to sort retrieved values in ascending or descending order.

Answer 35

ORDER BY

Question 36

Modifies existing records in a table.

Answer 36

UPDATE

Question 37

Removes existing records in a table.

Answer 37

DELETE