Zybooks Questions

Question 1

When to use DISTINCT keyword?

Answer 1

To remove duplicate values from query results

Question 2

When to use UNIQUE keyword?

Answer 2

Constraint on column to make sure they only contain unique values

Question 3

What is Data Definition Language (DDL)?

Answer 3

Defines database structure ie CREATE TABLE

Question 4

What is Data Query Language (DQL)?

Answer 4

Retrieves data ie SELECT

Question 5

What is Data Manipulation Language (DML)?

Answer 5

Inserts, updates, deletes in database

Question 6

_____ may appear in each cell.

Answer 6

Exactly one value

Question 7

What is the correct statement format to drop a table?

Answer 7

DROP Table tableName;

Question 8

What is the statement to do the following – Delete the column ShortDesc. from Deparment table?

Answer 8

ALTER TABLE Department DROP ShortDesc;

Question 9

What are WITH CHECK OPTIONS?

Answer 9

Database rejects inserts and updates that do not satisfy the view query

Question 10

What is CHECK when used with a constraint?

Answer 10

A way to check if values meet a condition

Question 11

How do you add or change constraint on an existing column?

Answer 11

Use CHANGE —- CHANGE table column datatype constraint. This is for unnamed constraints

Question 12

How do you add a named constraint to an existing column?

Answer 12

Use ADD CONSTRAINT in an ALTER TABLE statement

Question 13

Can you add a value with NULL?

Answer 13

NO

Question 14

________ languages contain control flow statements but no classes

Answer 14

Procedural

Question 15

_____ is the leading declarative language.

Answer 15

SQL

Question 16

SQL uses many keywords, like SELECT, FROM, and WHERE. C relies heavily on punctuation, like {} and #. This is an example of the ______ gap.

Answer 16

Syntax

Question 17

The EXEC SQL keyword is used in procedural SQL. T/F

Answer 17

False

Question 18

Usually generates a network round trip for each SQL query.

Answer 18

Embedded SQL

Question 19

Affords the greatest database security.

Answer 19

Procedural SQL

Question 20

Which form of SQL needs a precompiler

Answer 20

Embedded SQL

Question 21

Most Procedural SQL languages implement the entire SQL/PSM standard T/F

Answer 21

False

Question 22

First character in a user-defined variable.

Answer 22

@

Question 23

Consists of a simple or compound statement.

Answer 23

Body

Question 24

May appear in the body of a stored procedure.

Answer 24

CALL

Question 25

Precedes a parameter name in a .

Answer 25

INOUT

Question 26

Optional in CREATE PROCEDURE statements.

Question 27

Stored functions may be executed from the MySQL command line. T/F

Answer 27

True

Question 28

The has the same syntax in stored procedures and stored functions T/F

Answer 28

False

Question 29

All embedded SQL statements require an active connection. T/F

Answer 29

True

Question 30

Shared variables can appear in which clause of an embedded SELECT statement?

Answer 30

Both INTO and WHERE clauses

Question 31

In the declaration section, shared variables are assigned a data type in:

Answer 31

The host language

Question 32

The ________ statement associates a cursor name with a query.

Answer 32

DECLARE

Question 33

The _____ statement assigns query results to shared variables.

Answer 33

FETCH

Question 34

The ________ statement positions a cursor before the first row of a result table.

Answer 34

OPEN

Question 35

A(n) _______ statement must appear before an EXECUTE statement without the IMMEDIATE keyword.

Answer 35

PREPARE

Question 36

Shared variables appear in an EXECUTE statement with the ______ clause

Answer 36

USING

Question 37

Statements that are written explicitly in program code are ______ SQL.

Answer 37

static

Question 38

The precompiler cannot compile ______ SQL statements.

Answer 38

dynamic

Question 39

The executeQuery() method:

Answer 39

Both compiles and executes an SQL statement.

Question 40

In the Informix set type, the base type must be a group of character strings T/F

Answer 40

False