Introduction

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

what does SSMS stand for

Answer 2

SQL server management studio

Question 3

In order from first to last, what is the order of the main SQL query clauses as keyed-in?

Answer 3

SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY

Question 4

In order from first to last, what are the phases of logical query processing?

Answer 4

FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER BY

Question 5

The JOIN clause is part of which main phase?

Answer 5

FROM

Question 6

What does RDBMS stand for?

Answer 6

relational database management system, This is the basis for SQL and all modern databases. The data in an RDBMS is stored in tables

Question 7

What is a column?

Answer 7

a vertical entity in a table that contains data

Question 8

What is a table?

Answer 8

a table is a collection of related data entries stored within a database

Question 9

What is a record/row?

Answer 9

a record/row is an individual entry that exists in a table

Question 10

What is a result set?

Answer 10

the results returned from a SELECT query

Question 11

what are syntax?

Answer 11

the structure of statements in a computer language, Eg SELECT or FROM.

Question 12

what does .dbo stand for?

Answer 12

Database order

Question 13

Which SQL statement is used to extract data from a database

Answer 13

SELECT

Question 14

Which SQL statement is used to update data in a database?

Answer 14

UPDATE

Question 15

Which SQL statement is used to delete data from a database?

Answer 15

DELETE

Question 16

Which SQL statement is used to insert new data in a database?

Answer 16

INSERT INTO

Question 17

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Answer 17

True

Question 18

Which SQL statement is used to return only different values?

Answer 18

SELECT DISTINCT

Question 19

Which SQL keyword is used to sort the result-set?

Answer 19

ORDER BY

Question 20

What is the most common type of join?

Answer 20

INNER JOIN

Question 21

Which operator is used to select values within a range?

Answer 21

BETWEEN

Question 22

The NOT NULL constraint enforces a column to not accept empty values.

Answer 22

True

Question 23

Which operator is used to search for a specified pattern in a column?

Answer 23

LIKE

Question 24

A table can have more than one primary key, True or false?

Answer 24

FALSE

Question 25

What is the integrity constraint as a rule?

Answer 25

every table must have a primary key and that the column(s) chosen to be the primary key should be unique and not NULL

Question 26

Which of the statements are true about primary key ? 1. Most uniquely identify the row 2. Cannot have NULL values 3. Should not change over time 4. All the above

Answer 26

4. All of the above

Question 27

An alternative name that you assign to the table in the query’s FROM clause 1. Query 2. Table Alias 3. Single-row Functions

Answer 27

2. Table Alias

Question 28

Built-in functions that return a single result for each row of data retrieved 1. Single-row functions 2. Search condition 3. Table alias

Answer 28

1. Single-row functions

Question 29

Removes all of a table’s data without saving any rollback information 1. Roll back 2. Truncate 3. Single-row functions

Answer 29

2. Truncate

Question 30

A query that joins a table to itself 1. outer join 2. Self-join 3. inner join

Answer 30

2. self-join

Question 31

Contains current date and time 1. single-row functions 2. savepoint 3. SYSDATE pseudocolumn

Answer 31

3. SYSDATE pseudocolumn

Question 32

A series of action queries that represent a logical unit of work 1. Query 2. Single Row function 3. Transaction

Answer 32

3. Transaction

Question 33

Combines multiple search conditions using the AND, OR, and NOT logical operators 1. Nested query 2. Complex search condition 3. Group function

Answer 33

2. Complex search condition

Question 34

A main query and one or more subqueries 1. Pseudocolumn 2. Nested query 3. Nested subquery

Answer 34

2. Nested query

Question 35

A bookmark that designates the beginning of an individual section of a transaction 1. Search condition 2. truncate 3. savepoint

Answer 35

3. savepoint

Question 36

A structure that contains information identifying the LOB data type and points to the alternate memory location 1. Pagesize 2. Linesize 3. LOB locator

Answer 36

3. LOB locator

Question 37

A DML command that allows database users to view database data 1. Pseudocolumn 2. Transaction 3. Query

Answer 37

3. Query

Question 38

A DML command that inserts, updates, or deletes database data 1. Alias 2. Inner Join 3. Action query

Answer 38

3. Action query

Question 39

An alternative name for a query column 1. Alias 2. Action query 3. LOB locator

Answer 39

1. Alias

Question 40

Acts like a column in a database table, but is actually a command that returns a specific value 1. table alias 2. search condition 3. Pseudocolumn

Answer 40

3. Pseudocolumn

Question 41

An expression that seeks to match specific table records 1. LOB locator 2. search condition 3. nested query

Answer 41

2. search condition