Question 1

Explain the syntax and usage of the SQL GRANT command.

Accepted Answer

The answer of Explain the syntax and usage of the...

Question 2

When you join a table to itself,you are using a(n)____________________.

Accepted Answer

The answer of When you join a table to itself,you...

Question 3

Why is it more efficient to perform calculations within a query than to retrieve the individual values and perform the calculation on the client machine? Provide an example.

Accepted Answer

The answer of Why is it more efficient to perform...

Question 4

If you see the + character in a join condition,you are looking at a(n)____________________ join.

Accepted Answer

The answer of If you see the + character in...

Question 5

Explain how Oracle 10g prevents two users from retrieving the same sequence number.

Accepted Answer

The answer of Explain how Oracle 10g prevents two users...

Question 6

To get the current date and time,use the ____________________ pseudocolumn.

Accepted Answer

The answer of To get the current date and time,use...

Question 7

When using a subquery the DBMS executes the ____________________ first.

Accepted Answer

The answer of When using a subquery the DBMS executes...

Question 8

The set operator ____________________ returns only rows returned by both queries.

Accepted Answer

The answer of The set operator ____________________ returns only rows...

Question 9

To add two string values together to form one string,use the ____________________ function.

Accepted Answer

The answer of To add two string values together to...

Question 10

To sort query output,use the ____________________ clause.

Accepted Answer

The answer of To sort query output,use the ____________________ clause....

Question 11

COUNT is a(n)____________________ function.

Accepted Answer

The answer of COUNT is a(n)____________________ function....

Question 12

When you use the syntax: SELECT column1 AS anothername ...you are using a(n)____________________.

Accepted Answer

The answer of When you use the syntax: SELECT column1...

Question 13

Explain how Oracle uses transactions to shield users from changes that may be rolled back.

Accepted Answer

The answer of Explain how Oracle uses transactions to shield...

Question 14

When using the LIKE operator,the ____________________ wildcard represents multiple characters.

Accepted Answer

The answer of When using the LIKE operator,the ____________________ wildcard...

Question 15

To place a search condition on the results of queries that display group function calculations use the ____________________ clause.

Accepted Answer

The answer of To place a search condition on the...

Question 16

The ____________________ function operates on character data and returns a string starting at the start position and of the specified length.

Accepted Answer

The answer of The ____________________ function operates on character data...

Question 17

Explain what a search condition is and describe the SQL syntax.

Accepted Answer

The answer of Explain what a search condition is and...

Question 18

When a row's value is a foreign key that references another row,it is called a(n)____________________ row.

Accepted Answer

The answer of When a row's value is a foreign...

Question 19

An inner join is also known as a(n)____________________.

Accepted Answer

The answer of An inner join is also known as...

Question 20

To take the absolute value of a NUMBER column,use the single-row function ____________________.

Accepted Answer

The answer of To take the absolute value of a...

Quiz 3: Using SQL Queries to Insert, update, delete, and View Data