Question 1

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.​
A) ​view
B) ​index
C) ​synonym
D) ​sequence

Accepted Answer

A sequence generates sequential integers that can be used as a primary key for a table or to help with internal controls in an organization. Views, indexes, and synonyms serve different purposes in database management.

Question 2

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

Accepted Answer

PRIMARY KEY,UNIQUE

Question 3

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

Accepted Answer

USER_OBJECTS

Question 4

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________

Accepted Answer

An index serves as a lookup for finding specific rows in a database table quickly. It also helps to enforce uniqueness, ensuring that no two rows have the same values in the indexed column(s). This makes it easier and faster to determine whether a value already exists in a specific column.

Question 5

Both a minimum and maximum value can be defined for a(n)sequence._________________________

Accepted Answer

A sequence can have both a minimum and a maximum value.

Question 6

A(n)index can be created based on more than one column._________________________

Accepted Answer

This is true. In a database, an index can be created based on more than one column, which is called a composite index. This can improve query performance when filtering or sorting on multiple columns.

Question 7

The USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

Accepted Answer

The USER_INDEXES data dictionary view provides information about existing indexes owned by the current user. It can be used to verify the existence and characteristics of indexes.

Question 8

Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?
A) ​object
B) index
C) synonym
D) sequence

Accepted Answer

In Oracle12c, an object is defined as anything that has a name and a defined structure. An index is a database object used to improve the performance of queries. A synonym is an alias for a database object. A sequence is a database object used to generate unique numeric values.

Question 9

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________

Accepted Answer

USER_SEQUENCES

Question 10

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

Accepted Answer

START WITH

Question 11

The CURRVAL pseudocolumn is used to generate the next value in a sequence._________________________

Accepted Answer

NEXTVAL

Question 12

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

Accepted Answer

The DROP SEQUENCE command is used to delete a sequence from the database.

Question 13

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

Accepted Answer

NOCYCLE

Question 14

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

Accepted Answer

Indexes can improve the performance of queries for frequently referenced or searched columns by allowing the database to quickly find the relevant data without having to scan the entire table.

Question 15

Sequence settings can be altered using the ALTER SEQUENCE command._________________________

Accepted Answer

The ALTER SEQUENCE command allows users to change the parameters of a sequence, such as the start value and increment value. Therefore, sequence settings can indeed be altered using this command.

Question 16

The GENERATE option can be used to have a sequence pre-generate a set of numbers before they are requested by a user._________________________

Accepted Answer

CACHE

Question 17

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

Accepted Answer

index

Question 18

The lowest possible value for an increasing sequence is 1._________________________

Accepted Answer

If the sequence is increasing, it must start at a value greater than 0. The lowest possible value for an increasing sequence is 1.

Question 19

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________

Accepted Answer

To create a PUBLIC synonym, the PUBLIC keyword must be explicitly used in the CREATE SYNONYM command. Without it, the synonym will only be visible to the user who created it.

Question 20

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

Accepted Answer

schema

Quiz 6: Additional Database Objects

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.

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

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

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________

Both a minimum and maximum value can be defined for a(n)sequence._________________________

A(n)index can be created based on more than one column._________________________

The USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

The CURRVAL pseudocolumn is used to generate the next value in a sequence._________________________

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

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

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

Sequence settings can be altered using the ALTER SEQUENCE command._________________________

The GENERATE option can be used to have a sequence pre-generate a set of numbers before they are requested by a user._________________________

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

The lowest possible value for an increasing sequence is 1._________________________

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________

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

Quiz 6: Additional Database Objects

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.​

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

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

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________​

Both a minimum and maximum value can be defined for a(n)sequence._________________________

​A(n)index can be created based on more than one column._________________________

​The USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

Which of the following is defined in Oracle12c as simply anything that has a name and a defined structure?

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________​

The INCREMENT BY setting for a sequence cannot be changed with the ALTER SEQUENCE command._________________________

​The CURRVAL pseudocolumn is used to generate the next value in a sequence._________________________

A sequence can be deleted from the database using the DROP SEQUENCE command._________________________

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

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

​Sequence settings can be altered using the ALTER SEQUENCE command._________________________

The GENERATE option can be used to have a sequence pre-generate a set of numbers before they are requested by a user._________________________

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

The lowest possible value for an increasing sequence is 1._________________________

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________​

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

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.

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

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

A(n)index can be used to quickly determine whether a value already exists in a specific column._________________________

A(n)index can be created based on more than one column._________________________

The USER_INDEXES data dictionary view can be used to verify existing indexes.________________________

The USER_SEQ data dictionary view can be used to verify sequence settings._________________________

The CURRVAL pseudocolumn is used to generate the next value in a sequence._________________________

Sequence settings can be altered using the ALTER SEQUENCE command._________________________

To create a PUBLIC synonym,the PUBLIC keyword must be used in the CREATE SYNONYM command._________________________

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