Question 1

The DUAL table is a little like an internal Oracle database cursor.

Accepted Answer

A) True 
 B)False  True

Question 2

____ queries simply retrieve rows.

Accepted Answer

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

Question 3

When using GROUP BY,the expression for the ____ statement should include at least one grouping function such as COUNT().

Accepted Answer

A)  HAVING 
B)  SELECT 
C)  WHERE 
D)  FROM 
A)  HAVING 
B)  SELECT 
C)  WHERE 
D)  FROM B

Question 4

The following query is an example of a(n)____.
SELECT TABLESPACE_NAME,BLOCK_SIZE
FROM DBA_TABLESPACES
WHERE TABLESPACE_NAME IN
(SELECT TABLESPACE_NAME FROM DBA_DATA_FILES);

Accepted Answer

A)  join query 
B)  aggregated query 
C)  sorted query 
D)  subquery 
A)  join query 
B)  aggregated query 
C)  sorted query 
D)  subquery

Question 5

A(n)____________________ view is a subquery embedded in the FROM clause of a calling SELECT statement,which is also a subquery.

Accepted Answer

The answer of A(n)____________________ view is a subquery embedded in...

Question 6

A likely use of sequences is for surrogate foreign key generation.

Accepted Answer

A) True 
 B)False

Question 7

The DISTINCT clause cannot operate on multiple columns.

Accepted Answer

A) True 
 B)False

Question 8

The ____________________ operator is used with the CONNECT BY operator to match the specified column in the parent row,with the parent column in the current row.

Accepted Answer

The answer of The ____________________ operator is used with the...

Question 9

The ____ statement allows you to specify tables and columns in the tables,from which data is selected.

Accepted Answer

A)  SELECT 
B)  WHERE 
C)  FROM 
D)  GROUP BY 
A)  SELECT 
B)  WHERE 
C)  FROM 
D)  GROUP BY

Question 10

The difference between EXISTS and IN is that EXISTS only allows an expression on the right.

Accepted Answer

A) True 
 B)False

Question 11

Queries can be summarized or aggregated into fewer rows using the GROUP BY and ____ clauses.

Accepted Answer

A)  FROM 
B)  WHERE 
C)  HAVING 
D)  ORDER BY 
A)  FROM 
B)  WHERE 
C)  HAVING 
D)  ORDER BY

Question 12

The ____ SQL group function adds values across rows in a group

Accepted Answer

A)  ADD 
B)  ADDITION 
C)  SUM 
D)  SUMMATION 
A)  ADD 
B)  ADDITION 
C)  SUM 
D)  SUMMATION

Question 13

The ____ clause is a special SQL clause used to retrieve the first value of each group in a set of duplications.

Accepted Answer

A)  DISTINCT 
B)  FIRST 
C)  INDEX 
D)  NULL 
A)  DISTINCT 
B)  FIRST 
C)  INDEX 
D)  NULL

Question 14

The ____ set operator returns distinct rows from both queries.

Accepted Answer

A)  UNION ALL 
B)  INTERSECT 
C)  MINUS 
D)  DISTINCT 
A)  UNION ALL 
B)  INTERSECT 
C)  MINUS 
D)  DISTINCT

Question 15

Filtering uses the ____ clause to filter out unwanted rows,or retain wanted rows.

Accepted Answer

A)  FROM 
B)  GROUP BY 
C)  HAVING 
D)  WHERE 
A)  FROM 
B)  GROUP BY 
C)  HAVING 
D)  WHERE

Question 16

The ____ pseudocolumn is used only in hierarchical queries,in tandem with the CONNECT BY operator,returning the level of a row in a hierarchy of rows,in a hierarchical query.

Accepted Answer

A)  LEVEL 
B)  PRIOR 
C)  START WITH 
D)  FIRST 
A)  LEVEL 
B)  PRIOR 
C)  START WITH 
D)  FIRST

Question 17

A database ____________________ uses a special type of SQL command called a SELECT statement.

Accepted Answer

The answer of A database ____________________ uses a special type...

Question 18

A(n)____ flashback query allows you to pull data from a database at a specific point in time.

Accepted Answer

A)  AS 
B)  LIKE 
C)  AS OF 
D)  IN 
A)  AS 
B)  LIKE 
C)  AS OF 
D)  IN

Question 19

Leaving a column value set to NULL uses more space.

Accepted Answer

A) True 
 B)False

Question 20

If you obtain a description of the DUAL table using the DESC command in SQL*Plus Worksheet,you will see that the only column present is called ____.

Accepted Answer

A)  DUAL 
B)  NULL 
C)  VOID 
D)  DUMMY 
A)  DUAL 
B)  NULL 
C)  VOID 
D)  DUMMY

The DUAL table is a little like an internal Oracle database cursor.

____ queries simply retrieve rows.

When using GROUP BY,the expression for the ____ statement should include at least one grouping function such as COUNT().

The following query is an example of a(n)____. SELECT TABLESPACE_NAME,BLOCK_SIZE FROM DBA_TABLESPACES WHERE TABLESPACE_NAME IN (SELECT TABLESPACE_NAME FROM DBA_DATA_FILES);

A(n)____________________ view is a subquery embedded in the FROM clause of a calling SELECT statement,which is also a subquery.

A likely use of sequences is for surrogate foreign key generation.

The DISTINCT clause cannot operate on multiple columns.

The ____________________ operator is used with the CONNECT BY operator to match the specified column in the parent row,with the parent column in the current row.

The ____ statement allows you to specify tables and columns in the tables,from which data is selected.

The difference between EXISTS and IN is that EXISTS only allows an expression on the right.

Queries can be summarized or aggregated into fewer rows using the GROUP BY and ____ clauses.

The ____ SQL group function adds values across rows in a group

The ____ clause is a special SQL clause used to retrieve the first value of each group in a set of duplications.

The ____ set operator returns distinct rows from both queries.

Filtering uses the ____ clause to filter out unwanted rows,or retain wanted rows.

The ____ pseudocolumn is used only in hierarchical queries,in tandem with the CONNECT BY operator,returning the level of a row in a hierarchy of rows,in a hierarchical query.

A database ____________________ uses a special type of SQL command called a SELECT statement.

A(n)____ flashback query allows you to pull data from a database at a specific point in time.

Leaving a column value set to NULL uses more space.

If you obtain a description of the DUAL table using the DESC command in SQL*Plus Worksheet,you will see that the only column present is called ____.

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 DUAL table is a little like an internal Oracle database cursor.

____ queries simply retrieve rows.

When using GROUP BY,the expression for the ____ statement should include at least one grouping function such as COUNT().

The following query is an example of a(n)____. SELECT TABLESPACE_NAME,BLOCK_SIZE FROM DBA_TABLESPACES WHERE TABLESPACE_NAME IN (SELECT TABLESPACE_NAME FROM DBA_DATA_FILES);

A(n)____________________ view is a subquery embedded in the FROM clause of a calling SELECT statement,which is also a subquery.

A likely use of sequences is for surrogate foreign key generation.

The DISTINCT clause cannot operate on multiple columns.

The ____________________ operator is used with the CONNECT BY operator to match the specified column in the parent row,with the parent column in the current row.

The ____ statement allows you to specify tables and columns in the tables,from which data is selected.

The difference between EXISTS and IN is that EXISTS only allows an expression on the right.

Queries can be summarized or aggregated into fewer rows using the GROUP BY and ____ clauses.

The ____ SQL group function adds values across rows in a group

The ____ clause is a special SQL clause used to retrieve the first value of each group in a set of duplications.

The ____ set operator returns distinct rows from both queries.

Filtering uses the ____ clause to filter out unwanted rows,or retain wanted rows.

The ____ pseudocolumn is used only in hierarchical queries,in tandem with the CONNECT BY operator,returning the level of a row in a hierarchy of rows,in a hierarchical query.

A database ____________________ uses a special type of SQL command called a SELECT statement.

A(n)____ flashback query allows you to pull data from a database at a specific point in time.

Leaving a column value set to NULL uses more space.

If you obtain a description of the DUAL table using the DESC command in SQL*Plus Worksheet,you will see that the only column present is called ____.

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