Question 1

An index is implicitly created when a NOT NULL constraint is added to a table.​

Accepted Answer

A) True 
 B)False

Question 2

Using an identity column is particularly suited to use for a primary key when only random values are needed to uniquely identify rows.

Accepted Answer

A) True 
 B)False

Question 3

Structure of the CUSTOMERS table
   ​
-​Which of the following commands can be used to create a sequence for the CUSTOMERS table?

Accepted Answer

A)  ​CREATE SEQUENCE customers_customer#; 
B)  ​CREATE SEQUENCE customers_customer#
START WITH 2000 
C)  ​CREATE SEQUENCE customers_customer#
INCREMENT BY -1
NOCACHE|CACHE; 
D)  ​all of the above 
A)  ​CREATE SEQUENCE customers_customer#; 
B)  ​CREATE SEQUENCE customers_customer#
START WITH 2000 
C)  ​CREATE SEQUENCE customers_customer#
INCREMENT BY -1
NOCACHE|CACHE; 
D)  ​all of the above

Question 4

​The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

Accepted Answer

The answer of ​The starting value for a sequence cannot...

Question 5

The CYCLE option prevents a sequence from regenerating previous values._________________________

Accepted Answer

A) True 
 B)False

Question 6

Indexes are usually created for frequently referenced or searched columns._________________________

Accepted Answer

A) True 
 B)False

Question 7

Which of the following keywords is used to actually generate a sequence value?

Accepted Answer

A)  NEXTVALUE 
B)  NEXTVAL. 
C)  GENERATEVAL 
D)  GENERATE 
A)  NEXTVALUE 
B)  NEXTVAL. 
C)  GENERATEVAL 
D)  GENERATE

Question 8

The last value generated by a sequence is stored in the ____ pseudocolumn.

Accepted Answer

A)  NEXTVAL 
B)  DUAL 
C)  CURRENTVAL 
D)  CURRVAL​ 
A)  NEXTVAL 
B)  DUAL 
C)  CURRENTVAL 
D)  CURRVAL​

Question 9

Structure of the BOOKS table
   ​
-Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?​

Accepted Answer

A)  ​Use the DEFAULT keyword 
B)  ​Do not include the column 
C)  ​Use NEXTVAL to call the value 
D)  ​All of the above 
A)  ​Use the DEFAULT keyword 
B)  ​Do not include the column 
C)  ​Use NEXTVAL to call the value 
D)  ​All of the above

Question 10

The ____________________ view can be used to verify the existence of an index owned by a user.

Accepted Answer

The answer of The ____________________ view can be used to...

Question 11

​The USER_ALL data dictionary view displays information about all the relevant objects owned by the user._________________________

Accepted Answer

A) True 
 B)False

Question 12

Which of the following commands can be used to modify an index?​

Accepted Answer

A)  ​ALTER INDEX...MODIFY 
B)  ​ALTER INDEX...CHANGE 
C)  ​ALTER TABLE...INDEX 
D)  ​none of the above 
A)  ​ALTER INDEX...MODIFY 
B)  ​ALTER INDEX...CHANGE 
C)  ​ALTER TABLE...INDEX 
D)  ​none of the above

Question 13

A(n)sequencecan be used to generate a series of numeric values._________________________

Accepted Answer

A) True 
 B)False

Question 14

If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?​

Accepted Answer

A)  ​NOMAXVALUE 
B)  ​CYCLE 
C)  ​INCREMENT BY 5 
D)  ​MAXVALUE 200 
A)  ​NOMAXVALUE 
B)  ​CYCLE 
C)  ​INCREMENT BY 5 
D)  ​MAXVALUE 200

Question 15

​A(n)synonym is a collection of objects._________________________

Accepted Answer

A) True 
 B)False

Question 16

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 17

Which of the following commands can be used to remove a sequence from a database?​

Accepted Answer

A)  ​DELETE SEQ 
B)  ​DROP SEQ 
C)  ​REMOVE SEQUENCE 
D)  ​DROP SEQUENCE 
A)  ​DELETE SEQ 
B)  ​DROP SEQ 
C)  ​REMOVE SEQUENCE 
D)  ​DROP SEQUENCE

Question 18

An index is implicitly created whenever a(n)CHECK constraint is created for a table column._________________________​

Accepted Answer

A) True 
 B)False

An index is implicitly created when a NOT NULL constraint is added to a table.

Using an identity column is particularly suited to use for a primary key when only random values are needed to uniquely identify rows.

Structure of the CUSTOMERS table -Which of the following commands can be used to create a sequence for the CUSTOMERS table?

The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

The CYCLE option prevents a sequence from regenerating previous values._________________________

Indexes are usually created for frequently referenced or searched columns._________________________

Which of the following keywords is used to actually generate a sequence value?

The last value generated by a sequence is stored in the ____ pseudocolumn.

Structure of the BOOKS table -Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?

The ____________________ view can be used to verify the existence of an index owned by a user.

The USER_ALL data dictionary view displays information about all the relevant objects owned by the user._________________________

Which of the following commands can be used to modify an index?

A(n)sequencecan be used to generate a series of numeric values._________________________

If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?

A(n)synonym is a collection of objects._________________________

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

Which of the following commands can be used to remove a sequence from a database?

An index is implicitly created whenever a(n)CHECK constraint is created for a table column._________________________

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

An index is implicitly created when a NOT NULL constraint is added to a table.​

Using an identity column is particularly suited to use for a primary key when only random values are needed to uniquely identify rows.

Structure of the CUSTOMERS table ​ -​Which of the following commands can be used to create a sequence for the CUSTOMERS table?

​The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

The CYCLE option prevents a sequence from regenerating previous values._________________________

Indexes are usually created for frequently referenced or searched columns._________________________

Which of the following keywords is used to actually generate a sequence value?

The last value generated by a sequence is stored in the ____ pseudocolumn.

Structure of the BOOKS table ​ -Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?​

The ____________________ view can be used to verify the existence of an index owned by a user.

​The USER_ALL data dictionary view displays information about all the relevant objects owned by the user._________________________

Which of the following commands can be used to modify an index?​

A(n)sequencecan be used to generate a series of numeric values._________________________

If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?​

​A(n)synonym is a collection of objects._________________________

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

Which of the following commands can be used to remove a sequence from a database?​

An index is implicitly created whenever a(n)CHECK constraint is created for a table column._________________________​

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

An index is implicitly created when a NOT NULL constraint is added to a table.

Structure of the CUSTOMERS table -Which of the following commands can be used to create a sequence for the CUSTOMERS table?

The starting value for a sequence cannot be changed using the ____________________ SEQUENCE command.

Structure of the BOOKS table -Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?

The USER_ALL data dictionary view displays information about all the relevant objects owned by the user._________________________

Which of the following commands can be used to modify an index?

If the last values generated by a sequence were 277 and 278,which of the following changes cannot be initiated by the ALTER SEQUENCE command?

A(n)synonym is a collection of objects._________________________

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

Which of the following commands can be used to remove a sequence from a database?

An index is implicitly created whenever a(n)CHECK constraint is created for a table column._________________________