Question 1

The ____________________ clause identifies the lowest value a sequence can generate.

Accepted Answer

The answer of The ____________________ clause identifies the lowest value...

Question 2

Structure of the BOOKS table
  
-Based on the structure of the BOOKS table, which of the following is a valid SQL statement?

Accepted Answer

A)  CREATE INDEX books_profit_idx
ON books "retail-cost"; 
B)  CREATE INDEX books_title_idx
ON books (INITCAP(title)); 
C)  CREATE INDEX books_profit_idx
FOR books "retail-cost"; 
D)  CREATE INDEX books_title_idx
FOR books (INITCAP(title); 
A)  CREATE INDEX books_profit_idx
ON books "retail-cost"; 
B)  CREATE INDEX books_title_idx
ON books (INITCAP(title)); 
C)  CREATE INDEX books_profit_idx
FOR books "retail-cost"; 
D)  CREATE INDEX books_title_idx
FOR books (INITCAP(title);

Question 3

The default value for the INCREMENT BY clause is $\underline { \text { two. } }$ _________________________

Accepted Answer

A) True 
 B)False

Question 4

To verify individual settings for the clauses of a sequence, you can query the ____ table in the data dictionary.

Accepted Answer

A)  USER_SEQUENCES 
B)  V$SEQUENCES 
C)  DISPLAY_SEQUENCES 
D)  VIEW_SEQUENCES 
A)  USER_SEQUENCES 
B)  V$SEQUENCES 
C)  DISPLAY_SEQUENCES 
D)  VIEW_SEQUENCES

Question 5

A synonym is an alternate name assigned to a database object.

Accepted Answer

A) True 
 B)False

Question 6

A(n) $\underline {\text { index } }$  can be created based on more than one column. _________________________

Accepted Answer

A) True 
 B)False

Question 7

Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?

Accepted Answer

A)  view 
B)  index 
C)  synonym 
D)  sequence 
A)  view 
B)  index 
C)  synonym 
D)  sequence

Question 8

A(n) $\underline {\text { index } }$ can be used to quickly determine whether a value already exists in a specific column. _________________________

Accepted Answer

A) True 
 B)False

Question 9

What are the benefits and disadvantages of an index?

Accepted Answer

An index can help speed up row retrieval

Question 10

A(n) ____________________ synonym can be referenced by other database users.

Accepted Answer

The answer of A(n) ____________________ synonym can be referenced by...

Question 11

How does an Index Organized table differ from a standard table and a typical index?

Accepted Answer

This structure stores the contents of th

Question 12

If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default.

Accepted Answer

A)  PUBLIC 
B)  functional 
C)  private 
D)  objective 
A)  PUBLIC 
B)  functional 
C)  private 
D)  objective

Question 13

A NEXTVAL call generates the sequence value of 5. After the value is generated, what value will be stored in CURRVAL?

Accepted Answer

A)  5 
B)  4 
C)  6 
D)  unknown 
A)  5 
B)  4 
C)  6 
D)  unknown

Question 14

Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?

Accepted Answer

A)  INCREMENT BY 
B)  START WITH 
C)  NOCACHE 
D)  NOMAXVALUE 
A)  INCREMENT BY 
B)  START WITH 
C)  NOCACHE 
D)  NOMAXVALUE

Question 15

A(n) $\underline {\text { sequence } }$can be used to generate a series of numeric values. _________________________

Accepted Answer

A) True 
 B)False

Question 16

A(n) ____________________ can be used to generate values for a column designated as the primary key for a table.

Accepted Answer

The answer of A(n) ____________________ can be used to generate...

Question 17

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n) $\underline {\text { sequence } }$. _________________________

Accepted Answer

A) True 
 B)False

Question 18

A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

Accepted Answer

A)  view 
B)  index 
C)  synonym 
D)  sequence 
A)  view 
B)  index 
C)  synonym 
D)  sequence

Question 19

Which of the following statements about indexes is incorrect?

Accepted Answer

A)  An index is a database object that stores a frequently referenced value and the row id (ROWI
D)  of the record containing that value. 
B)  An index is only beneficial if a large percentage of a table is expected to be returned in query results. 
C)  An index is used to speed up the process of searching for specific data. 
D)  An index is updated automatically every time a DML operation is performed on the underlying table, which can slow down execution of the DML operation. 
A)  An index is a database object that stores a frequently referenced value and the row id (ROWI
D)  of the record containing that value. 
B)  An index is only beneficial if a large percentage of a table is expected to be returned in query results. 
C)  An index is used to speed up the process of searching for specific data. 
D)  An index is updated automatically every time a DML operation is performed on the underlying table, which can slow down execution of the DML operation.

Question 20

Which of the following is a correct statement?

Accepted Answer

A)  A PUBLIC synonym allows any user to access the specified table. 
B)  A PUBLIC synonym can be referenced by any user. 
C)  A PUBLIC synonym can only be deleted by the user that created the synonym. 
D)  all of the above 
A)  A PUBLIC synonym allows any user to access the specified table. 
B)  A PUBLIC synonym can be referenced by any user. 
C)  A PUBLIC synonym can only be deleted by the user that created the synonym. 
D)  all of the above

The ____________________ clause identifies the lowest value a sequence can generate.

Structure of the BOOKS table -Based on the structure of the BOOKS table, which of the following is a valid SQL statement?

The default value for the INCREMENT BY clause is $\underline { \text { two. } }$ _________________________

To verify individual settings for the clauses of a sequence, you can query the ____ table in the data dictionary.

A synonym is an alternate name assigned to a database object.

A(n) $\underline {\text { index } }$ can be created based on more than one column. _________________________

Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?

A(n) $\underline {\text { index } }$ can be used to quickly determine whether a value already exists in a specific column. _________________________

What are the benefits and disadvantages of an index?

A(n) ____________________ synonym can be referenced by other database users.

How does an Index Organized table differ from a standard table and a typical index?

If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default.

A NEXTVAL call generates the sequence value of 5. After the value is generated, what value will be stored in CURRVAL?

Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?

A(n) $\underline {\text { sequence } }$ can be used to generate a series of numeric values. _________________________

A(n) ____________________ can be used to generate values for a column designated as the primary key for a table.

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n) $\underline {\text { sequence } }$ . _________________________

A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

Which of the following statements about indexes is incorrect?

Which of the following is a correct statement?

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 6: Additional Database Objects

The ____________________ clause identifies the lowest value a sequence can generate.

Structure of the BOOKS table -Based on the structure of the BOOKS table, which of the following is a valid SQL statement?

The default value for the INCREMENT BY clause is two. ‾\underline { \text { two. } } two. ​ _________________________

To verify individual settings for the clauses of a sequence, you can query the ____ table in the data dictionary.

A synonym is an alternate name assigned to a database object.

A(n) index ‾\underline {\text { index } } index ​ can be created based on more than one column. _________________________

Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?

A(n) index ‾\underline {\text { index } } index ​ can be used to quickly determine whether a value already exists in a specific column. _________________________

What are the benefits and disadvantages of an index?

A(n) ____________________ synonym can be referenced by other database users.

How does an Index Organized table differ from a standard table and a typical index?

If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default.

A NEXTVAL call generates the sequence value of 5. After the value is generated, what value will be stored in CURRVAL?

Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?

A(n) sequence ‾\underline {\text { sequence } } sequence ​ can be used to generate a series of numeric values. _________________________

A(n) ____________________ can be used to generate values for a column designated as the primary key for a table.

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n) sequence ‾\underline {\text { sequence } } sequence ​ . _________________________

A(n) ____ generates sequential integers that can be used by organizations to assist with internal controls or simply to serve as a primary key for a table.

Which of the following statements about indexes is incorrect?

Which of the following is a correct statement?

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single Row Functions

Group Functions

Subqueries and Merge Statements

Views

Filters

The default value for the INCREMENT BY clause is $\underline { \text { two. } }$ _________________________

A(n) $\underline {\text { index } }$ can be created based on more than one column. _________________________

A(n) $\underline {\text { index } }$ can be used to quickly determine whether a value already exists in a specific column. _________________________

A(n) $\underline {\text { sequence } }$ can be used to generate a series of numeric values. _________________________

A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n) $\underline {\text { sequence } }$ . _________________________