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

The answer of If a column contains a large number...

Question 2

The default beginning value for a sequence is one._________________________​

Accepted Answer

A) True 
 B)False

Question 3

​Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?

Accepted Answer

A)  ​INTERVAL STORE 
B)  ​CACHE VALUE 
C)  ​CACHE 
D)  ​INCREMENT BY 
A)  ​INTERVAL STORE 
B)  ​CACHE VALUE 
C)  ​CACHE 
D)  ​INCREMENT BY

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.​

Accepted Answer

Index Orga

Question 6

Which of the following can be used to provide an alternative,simplified name,to identify database objects?​

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Question 9

An index is not implicitly created when which type of constraint is created?

Accepted Answer

A)  NOT NULL 
B)  UNIQUE 
C)  PRIMARY KEY 
D)  none of the above 
A)  NOT NULL 
B)  UNIQUE 
C)  PRIMARY KEY 
D)  none of the above

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

The ____ clause is used to specify the interval between two sequential values.

Accepted Answer

A)  INTERVAL SIZE 
B)  INCREMENT BY 
C)  STEP BY 
D)  START WITH 
A)  INTERVAL SIZE 
B)  INCREMENT BY 
C)  STEP BY 
D)  START WITH

Question 12

​The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

Accepted Answer

The answer of ​The keyword ____________________ must be used in...

Question 13

​A basic CREATE INDEX command will create a B-Tree index.

Accepted Answer

A) True 
 B)False

Question 14

The ____________________ clause of the CREATE SEQUENCE command is used to identify the starting value for a sequence.

Accepted Answer

The answer of The ____________________ clause of the CREATE SEQUENCE...

Question 15

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?​

Accepted Answer

A)  ​CREATE SEQUENCE newsequence; 
B)  ​CREATE SEQUENCE STARTING WITH 5; 
C)  ​CREATE SEQUENTIAL newsequence STARTING WITH 5; 
D)  ​none of the above 
A)  ​CREATE SEQUENCE newsequence; 
B)  ​CREATE SEQUENCE STARTING WITH 5; 
C)  ​CREATE SEQUENTIAL newsequence STARTING WITH 5; 
D)  ​none of the above

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

How can an organization use a sequence for internal control purposes?​

Accepted Answer

One aim of internal control is to ensure

Question 18

Only one identity column may be defined on a table.

Accepted Answer

A) True 
 B)False

Question 19

A(n)____________________ synonym is an alternate name that can be referenced by all users.​

Accepted Answer

The answer of A(n)____________________ synonym is an alternate name that...

Question 20

​A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.

Accepted Answer

A) True 
 B)False

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.

The default beginning value for a sequence is one._________________________

Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?

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

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.

Which of the following can be used to provide an alternative,simplified name,to identify database objects?

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

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

An index is not implicitly created when which type of constraint is created?

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

The ____ clause is used to specify the interval between two sequential values.

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

A basic CREATE INDEX command will create a B-Tree index.

The ____________________ clause of the CREATE SEQUENCE command is used to identify the starting value for a sequence.

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?

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

How can an organization use a sequence for internal control purposes?

Only one identity column may be defined on a table.

A(n)____________________ synonym is an alternate name that can be referenced by all users.

A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.

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.

The default beginning value for a sequence is one._________________________​

​Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?

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

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.​

Which of the following can be used to provide an alternative,simplified name,to identify database objects?​

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

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

An index is not implicitly created when which type of constraint is created?

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

The ____ clause is used to specify the interval between two sequential values.

​The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

​A basic CREATE INDEX command will create a B-Tree index.

The ____________________ clause of the CREATE SEQUENCE command is used to identify the starting value for a sequence.

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?​

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

How can an organization use a sequence for internal control purposes?​

Only one identity column may be defined on a table.

A(n)____________________ synonym is an alternate name that can be referenced by all users.​

​A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.

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 one._________________________

Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?

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

An _________________________ is a variant of the B-tree index structure and is used as an alternative to the conventional heap-organized table.

Which of the following can be used to provide an alternative,simplified name,to identify database objects?

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

The keyword ____________________ must be used in a CREATE INDEX command to create a Bitmap index.

A basic CREATE INDEX command will create a B-Tree index.

Which command will create a sequence named NEWSEQUENCE to generate a series of integers?

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

How can an organization use a sequence for internal control purposes?

A(n)____________________ synonym is an alternate name that can be referenced by all users.

A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.