Question 1

A view derives its data from database tables called ____ tables.

Accepted Answer

A) view 
B) source 
C) display 
D) object

Question 2

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...

Question 3

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 4

What is the most likely cause when a multiple-table query returns more records than you expect?

Accepted Answer

A) Missing join condition 
B) Too much data 
C) Used an outer join when you should have used an inner join 
D) DBMS made a mistake

Question 5

What is the name of the underlying query used to create a view?

Accepted Answer

A) View query 
B) Source query 
C) Select query 
D) Source table

Question 6

The UNION ALL operator excludes duplicate values.

Accepted Answer

A) True 
 B)False

Question 7

When you drop a view,you delete the data values that appear in the view.

Accepted Answer

A) True 
 B)False

Question 8

Use a(n)____________________ to specify a non-default input or output format for NUMBERs and DATEs.

Accepted Answer

The answer of Use a(n)____________________ to specify a non-default input...

Question 9

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 10

Which operator is used with a subquery that returns multiple values?

Accepted Answer

A) = 
B)  
C) IN 
D) ON

Question 11

The following search condition would match the column value "Sunday": WHERE value LIKE 'Sun%'

Accepted Answer

A) True 
 B)False

Question 12

In an outer join,all rows will be returned from the outer table.

Accepted Answer

A) True 
 B)False

Question 13

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 14

When using the SQL*Plus interpreter,the ____ property specifies how many lines appear on a SQL*Plus page.

Accepted Answer

A) linesize 
B) pagelines 
C) pagesize 
D) numline

Question 15

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

Accepted Answer

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

Question 16

Explain the syntax and usage of the SQL GRANT command.

Accepted Answer

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

Question 17

The query INSERT INTO student ____ ('abc','123');inserts a new row into the student table.

Accepted Answer

A) DATA 
B) COLS 
C) ROWS 
D) VALUES

Question 18

When you add a new row to a database table,it is immediately visible to other users.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following does not match the string '_T%' when used with the LIKE operator?

Accepted Answer

A) MT 
B) MTW 
C) T 
D) MTWRF

Question 20

When you use the ____ logical operator to create a complex search condition,only one of the conditions must be true for the complex search condition to be true.

Accepted Answer

A) OR 
B) AND 
C) XOR 
D) NOT

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

A view derives its data from database tables called ____ tables.

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

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

What is the most likely cause when a multiple-table query returns more records than you expect?

What is the name of the underlying query used to create a view?

The UNION ALL operator excludes duplicate values.

When you drop a view,you delete the data values that appear in the view.

Use a(n)____________________ to specify a non-default input or output format for NUMBERs and DATEs.

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

Which operator is used with a subquery that returns multiple values?

The following search condition would match the column value "Sunday": WHERE value LIKE 'Sun%'

In an outer join,all rows will be returned from the outer table.

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

When using the SQLPlus interpreter,the ____ property specifies how many lines appear on a SQLPlus page.

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

Explain the syntax and usage of the SQL GRANT command.

The query INSERT INTO student ____ ('abc','123') ;inserts a new row into the student table.

When you add a new row to a database table,it is immediately visible to other users.

Which of the following does not match the string '_T%' when used with the LIKE operator?

When you use the ____ logical operator to create a complex search condition,only one of the conditions must be true for the complex search condition to be true.