The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

Introduction to SQL
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

SELECT DISTINCT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

SELECT s.sname FROM sailors s, reserves r WHERE s.sid = r.sid;

None of These

SELECT DISTINCT s.sname FROM sailors, reserves WHERE s.sid = r.sid;

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last.

NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last.

AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last.

The order of occurrence determines the order of evaluation.

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

False

True

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
Which of the following SQL commands can be used to add data to a database table?

APPEND

INSERT

UPDATE

ADD

APPEND

INSERT

UPDATE

ADD

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

True

False

ANSWER DOWNLOAD EXAMIANS APP

Introduction to SQL

Introduction to SQL The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

Introduction to SQL Which of the following query finds the names of the sailors who have reserved at least one boat?

Introduction to SQL If a query involves NOT, AND, OR with no parenthesis

Introduction to SQL Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL Which of the following SQL commands can be used to add data to a database table?

Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

Introduction to SQL
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."

Introduction to SQL
Which of the following query finds the names of the sailors who have reserved at least one boat?

Introduction to SQL
If a query involves NOT, AND, OR with no parenthesis

Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Introduction to SQL
Which of the following SQL commands can be used to add data to a database table?

Introduction to SQL
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.