Question 1

If a column contains a large number of NULL values, a(n) ____________________ can quickly help determine the rows that contain NULL values and those that do not.

Accepted Answer

index

Question 2

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

Accepted Answer

A) True 
 B)False  False

Question 3

The highest possible value for a sequence can be specified through the MAXVALUE clause.

Accepted Answer

A) True 
 B)False  True

Question 4

The default beginning value for a sequence is $\underline { \text { one. }  }$ _________________________

Accepted Answer

A) True 
 B)False

Question 5

A(n) $\underline { \text { index } }$ can be used to generate a series of unique numbers. _________________________

Accepted Answer

A) True 
 B)False

Question 6

A(n) ____ synonym is used by an individual to reference objects owned by that person.

Accepted Answer

A)  unique 
B)  duplicated 
C)  public 
D)  private 
A)  unique 
B)  duplicated 
C)  public 
D)  private

Question 7

If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.

Accepted Answer

A) True 
 B)False

Question 8

A database index allows users and application programs to quickly locate specific records.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.

Accepted Answer

The answer of The ____________________ SEQUENCE command can be used...

Question 10

$\underline {  \text { Indexes }  }$ are usually created for frequently referenced or searched columns. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Even if you created a PUBLIC synonym, you must have ____________________ privileges to delete a PUBLIC synonym.

Accepted Answer

The answer of Even if you created a PUBLIC synonym,...

Question 12

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following can be used to remove an index that currently exists on the column of a database table?

Accepted Answer

A)  ALTER TABLE...DROP 
B)  ALTER TABLE...MODIFY 
C)  DROP INDEX 
D)  DELETE INDEX 
A)  ALTER TABLE...DROP 
B)  ALTER TABLE...MODIFY 
C)  DROP INDEX 
D)  DELETE INDEX

Question 14

A(n) ____ synonym is used by others to access an individual's database objects.

Accepted Answer

A)  unique 
B)  duplicated 
C)  public 
D)  private 
A)  unique 
B)  duplicated 
C)  public 
D)  private

Question 15

A(n) ____________________ can be used for internal control purposes by generating a series of numbers.

Accepted Answer

The answer of A(n) ____________________ can be used for internal...

Question 16

The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

Accepted Answer

The answer of The ____________________ clause is used to indicate...

Question 17

If a sequence is set to pre-generate sequential values, ____ values will be generated at one time by default.

Accepted Answer

A)  5 
B)  10 
C)  15 
D)  20 
A)  5 
B)  10 
C)  15 
D)  20

Question 18

The ____________________ index structure can be particularly beneficial in queries involving compound conditions (AND and OR operator usage).

Accepted Answer

The answer of The ____________________ index structure can be particularly...

Question 19

A column has low cardinality if it contains many distinct values.

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ SYNONYM command is used to permanently remove a synonym from a database.

Accepted Answer

The answer of The ____________________ SYNONYM command is used to...

If a column contains a large number of NULL values, a(n) ____________________ can quickly help determine the rows that contain NULL values and those that do not.

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

The highest possible value for a sequence can be specified through the MAXVALUE clause.

The default beginning value for a sequence is $\underline { \text { one. } }$ _________________________

A(n) $\underline { \text { index } }$ can be used to generate a series of unique numbers. _________________________

A(n) ____ synonym is used by an individual to reference objects owned by that person.

If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.

A database index allows users and application programs to quickly locate specific records.

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.

$\underline { \text { Indexes } }$ are usually created for frequently referenced or searched columns. _________________________

Even if you created a PUBLIC synonym, you must have ____________________ privileges to delete a PUBLIC synonym.

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

Which of the following can be used to remove an index that currently exists on the column of a database table?

A(n) ____ synonym is used by others to access an individual's database objects.

A(n) ____________________ can be used for internal control purposes by generating a series of numbers.

The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

If a sequence is set to pre-generate sequential values, ____ values will be generated at one time by default.

The ____________________ index structure can be particularly beneficial in queries involving compound conditions (AND and OR operator usage).

A column has low cardinality if it contains many distinct values.

The ____________________ SYNONYM command is used to permanently remove a synonym from a database.

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

If a column contains a large number of NULL values, a(n) ____________________ can quickly help determine the rows that contain NULL values and those that do not.

When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

The highest possible value for a sequence can be specified through the MAXVALUE clause.

The default beginning value for a sequence is one. ‾\underline { \text { one. } } one. ​ _________________________

A(n) index ‾\underline { \text { index } } index ​ can be used to generate a series of unique numbers. _________________________

A(n) ____ synonym is used by an individual to reference objects owned by that person.

If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.

A database index allows users and application programs to quickly locate specific records.

The ____________________ SEQUENCE command can be used to permanently delete a sequence from a database.

Indexes ‾\underline { \text { Indexes } } Indexes ​ are usually created for frequently referenced or searched columns. _________________________

Even if you created a PUBLIC synonym, you must have ____________________ privileges to delete a PUBLIC synonym.

When a negative value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.

Which of the following can be used to remove an index that currently exists on the column of a database table?

A(n) ____ synonym is used by others to access an individual's database objects.

A(n) ____________________ can be used for internal control purposes by generating a series of numbers.

The ____________________ clause is used to indicate the interval that must exist between two values generated in a sequence.

If a sequence is set to pre-generate sequential values, ____ values will be generated at one time by default.

The ____________________ index structure can be particularly beneficial in queries involving compound conditions (AND and OR operator usage).

A column has low cardinality if it contains many distinct values.

The ____________________ SYNONYM command is used to permanently remove a synonym from a database.

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 beginning value for a sequence is $\underline { \text { one. } }$ _________________________

A(n) $\underline { \text { index } }$ can be used to generate a series of unique numbers. _________________________

$\underline { \text { Indexes } }$ are usually created for frequently referenced or searched columns. _________________________