Question 1

The NULLS ____________________ clause can be used in conjunction with an ascending sort to return NULL values first.

Accepted Answer

The answer of The NULLS ____________________ clause can be used...

Question 2

Within the realm of a database a ____ valued column,in a row,in a table,is a column,which has never been set to anything (not yet accessed),or has been deliberately set to this value.

Accepted Answer

A)  NIL 
B)  NUL 
C)  NULL 
D)  VOID 
A)  NIL 
B)  NUL 
C)  NULL 
D)  VOID

Question 3

The following query returns a single number as a total (or sum)of all blocks,used by all datafiles in the database: ____.

Accepted Answer

A)  SELECT TOTAL(BLOCKS)FROM DBA_DATA_FILES; 
B)  SELECT SUM(BLOCKS)FROM DBA_DATA_FILES; 
C)  SELECT AVG(BLOCKS)FROM DBA_DATA_FILES; 
D)  SELECT COUNT(BLOCKS)FROM DBA_DATA_FILES; 
A)  SELECT TOTAL(BLOCKS)FROM DBA_DATA_FILES; 
B)  SELECT SUM(BLOCKS)FROM DBA_DATA_FILES; 
C)  SELECT AVG(BLOCKS)FROM DBA_DATA_FILES; 
D)  SELECT COUNT(BLOCKS)FROM DBA_DATA_FILES;

Question 4

What is a correlated subquery?

Accepted Answer

The word correlation is used to describe

Question 5

Provide an example of a query in which a new table or view can be created from the results of a query.

Accepted Answer

CREATE VIEW TABLESPACES AS
SEL

Question 6

The DUAL table can be queried and updated.

Accepted Answer

A) True 
 B)False

Question 7

A(n)____ is not a function,but can be added to a table query or into other SQL commands to retrieve values not normally accessed from simple table queries.

Accepted Answer

A)  NULL 
B)  marker 
C)  index 
D)  pseudocolumn 
A)  NULL 
B)  marker 
C)  index 
D)  pseudocolumn

Question 8

The GROUP BY clause column list ____ include all columns in the SELECT statement not affected by any aggregate functions.

Accepted Answer

A)  must 
B)  must not 
C)  should 
D)  should not 
A)  must 
B)  must not 
C)  should 
D)  should not

Question 9

What is a cross-join?

Accepted Answer

A cross-join or Cartesian product merges

Question 10

Some tables contain hierarchies of data and are natural candidates for using ____________________-joins.

Accepted Answer

The answer of Some tables contain hierarchies of data and...

Question 11

Comparison of a NULL value to any other value will always evaluate to ____.

Accepted Answer

A)  true 
B)  false 
C)  NULL 
D)  UNDEFINED 
A)  true 
B)  false 
C)  NULL 
D)  UNDEFINED

Question 12

The ____({value},{replace})function replaces NULL values in expressions,avoiding SQL errors.

Accepted Answer

A)  NVALUE 
B)  NVAL 
C)  NVL 
D)  NIL 
A)  NVALUE 
B)  NVAL 
C)  NVL 
D)  NIL

Question 13

A(n)____ join returns all rows from both tables with null values replacing missing values.

Accepted Answer

A)  inner 
B)  left outer 
C)  right outer 
D)  full outer 
A)  inner 
B)  left outer 
C)  right outer 
D)  full outer

Question 14

What is an outer join?

Accepted Answer

An outer join selects rows from two tabl

Question 15

AND has higher precedence than NOT,followed by OR.

Accepted Answer

A) True 
 B)False

Question 16

____ is used as a pattern-matching character representing zero or more characters in a subset of a string.

Accepted Answer

A)  % 
B)  _ 
C)  * 
D)  # 
A)  % 
B)  _ 
C)  * 
D)  #

Question 17

____ work best on multiple CPU platforms in tandem with partitioning,and particularly with multiple disks or RAID arrays.

Accepted Answer

A)  Subqueries 
B)  Flashback queries 
C)  Joins 
D)  Parallel queries 
A)  Subqueries 
B)  Flashback queries 
C)  Joins 
D)  Parallel queries

Question 18

____ queries merge rows from one or more tables,usually linking rows based on related values.

Accepted Answer

A)  Join 
B)  Filtered 
C)  Sorted 
D)  Aggregated 
A)  Join 
B)  Filtered 
C)  Sorted 
D)  Aggregated

Question 19

A(n)____________________ character can match any character.

Accepted Answer

The answer of A(n)____________________ character can match any character....

Question 20

Subqueries can return more than a single column,and their calling queries can validate against those multiple columns.

Accepted Answer

A) True 
 B)False

The NULLS ____________________ clause can be used in conjunction with an ascending sort to return NULL values first.

Within the realm of a database a ____ valued column,in a row,in a table,is a column,which has never been set to anything (not yet accessed),or has been deliberately set to this value.

The following query returns a single number as a total (or sum)of all blocks,used by all datafiles in the database: ____.

What is a correlated subquery?

Provide an example of a query in which a new table or view can be created from the results of a query.

The DUAL table can be queried and updated.

A(n)____ is not a function,but can be added to a table query or into other SQL commands to retrieve values not normally accessed from simple table queries.

The GROUP BY clause column list ____ include all columns in the SELECT statement not affected by any aggregate functions.

What is a cross-join?

Some tables contain hierarchies of data and are natural candidates for using ____________________-joins.

Comparison of a NULL value to any other value will always evaluate to ____.

The ____({value},{replace})function replaces NULL values in expressions,avoiding SQL errors.

A(n)____ join returns all rows from both tables with null values replacing missing values.

What is an outer join?

AND has higher precedence than NOT,followed by OR.

____ is used as a pattern-matching character representing zero or more characters in a subset of a string.

____ work best on multiple CPU platforms in tandem with partitioning,and particularly with multiple disks or RAID arrays.

____ queries merge rows from one or more tables,usually linking rows based on related values.

A(n)____________________ character can match any character.

Subqueries can return more than a single column,and their calling queries can validate against those multiple columns.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters

Exam 6: The Basics of Querying a Database

The NULLS ____________________ clause can be used in conjunction with an ascending sort to return NULL values first.

Within the realm of a database a ____ valued column,in a row,in a table,is a column,which has never been set to anything (not yet accessed),or has been deliberately set to this value.

The following query returns a single number as a total (or sum)of all blocks,used by all datafiles in the database: ____.

What is a correlated subquery?

Provide an example of a query in which a new table or view can be created from the results of a query.

The DUAL table can be queried and updated.

A(n)____ is not a function,but can be added to a table query or into other SQL commands to retrieve values not normally accessed from simple table queries.

The GROUP BY clause column list ____ include all columns in the SELECT statement not affected by any aggregate functions.

What is a cross-join?

Some tables contain hierarchies of data and are natural candidates for using ____________________-joins.

Comparison of a NULL value to any other value will always evaluate to ____.

The ____({value},{replace})function replaces NULL values in expressions,avoiding SQL errors.

A(n)____ join returns all rows from both tables with null values replacing missing values.

What is an outer join?

AND has higher precedence than NOT,followed by OR.

____ is used as a pattern-matching character representing zero or more characters in a subset of a string.

____ work best on multiple CPU platforms in tandem with partitioning,and particularly with multiple disks or RAID arrays.

____ queries merge rows from one or more tables,usually linking rows based on related values.

A(n)____________________ character can match any character.

Subqueries can return more than a single column,and their calling queries can validate against those multiple columns.

Oracle Architecture Overview

Tools and Architecture

Creating an Oracle Instance

Oracle Physical Architecture and Data Dictionary Views

Basic Storage Concepts and Settings

Basic Table Management

Advanced Table Management

Constraints, indexes, and Other Specialized Objects

Basic Data Management

Advanced Data Management

Security Management

Performance Monitoring

Proactive Maintenance

Backup and Recovery

Filters