Filters
Question type
Study Flashcards

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


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

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


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

E) All of the above
F) A) and B)

Correct Answer

verifed

verified

Structure of the BOOKS table Structure of the BOOKS table ​ -Based on the structure of the BOOKS table,which of the following is a valid SQL statement?​ 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) ; ​ -Based on the structure of the BOOKS table,which of the following is a valid SQL statement?​


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) ;

E) None of the above
F) B) and D)

Correct Answer

verifed

verified

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) ​NOMAXVALUE
B) ​CYCLE
C) ​INCREMENT BY 5
D) ​MAXVALUE 200

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Structure of the BOOKS table 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?​ A) ​Use the DEFAULT keyword B) ​Do not include the column C) ​Use NEXTVAL to call the value D) ​All of the above ​ -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?​


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

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Structure of the CUSTOMERS table Structure of the CUSTOMERS table ​ -​Which of the following commands can be used to create a sequence for the CUSTOMERS table? 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 ​ -​Which of the following commands can be used to create a sequence for the CUSTOMERS table?


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

E) All of the above
F) C) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


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

E) C) and D)
F) A) and D)

Correct Answer

verifed

verified

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


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

E) None of the above
F) All of the above

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Showing 121 - 138 of 138

Related Exams

Exam 1

Overview of Database Concepts

108 Questions

Exam 2

Basic SQL Select Statements

121 Questions

Exam 3

Table Creation and Management

136 Questions

Exam 4

Constraints

132 Questions

Exam 5

Data Manipulation and Transaction Control

136 Questions

Exam 7

User Creation and Management

130 Questions

Exam 8

Restricting Rows and Sorting Data

132 Questions

Exam 9

Joining Data From Multiple Tables

119 Questions

Exam 10

Selected Single-Row Functions

133 Questions

Exam 11

Group Functions

137 Questions

Exam 12

Subqueries and Merge Statements

131 Questions

Exam 13

Views

133 Questions

Show Answer