Which of the following is not true about modifying table columns?

You can drop a column at any time.

You can add a column at any time as long as it is a NULL column.

You can increase the number of characters in character columns or the number of digits in numeric columns

You cannot increase or decrease the number of decimal places.

Which of the following is not true of SQL views?

Oracle views are created using the standard SQL-92 CREATE VIEW command.

Oracle views cannot use the ORDER BY clause in view definitions.

Oracle views are created using the standard SQL-92 CREATE VIEW command.

The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.

Which of the following is not true about indexes?

Indexes are created to enforce uniqueness on columns.

Indexes are created to enable fast retrieval by column values.

Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

Indexes are created with the ALTER TABLE command.

Which statement about sequences is not true?

A sequence is an object that generates a sequential series of unique numbers.

Sequences are most often used to provide values for surrogate keys.

Explore topic-wise MCQs in Managing Databases with Oracle.

This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Managing Databases with Oracle knowledge and support exam preparation. Choose a topic below to get started.

1.	Which of the following is not true about modifying table columns?
A.	You can drop a column at any time.
B.	You can add a column at any time as long as it is a NULL column.
C.	You can increase the number of characters in character columns or the number of digits in numeric columns
D.	You cannot increase or decrease the number of decimal places.
Answer» E.

Discussion

2.	Which of the following is not true of SQL views?
A.	Oracle views cannot use the ORDER BY clause in view definitions.
B.	Oracle views are created using the standard SQL-92 CREATE VIEW command.
C.	Oracle views can by queried.
D.	The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
Answer» B. Oracle views are created using the standard SQL-92 CREATE VIEW command.

Discussion

3.	Which of the following is not true about indexes?
A.	Indexes are created to enforce uniqueness on columns.
B.	Indexes are created to enable fast retrieval by column values.
C.	Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
D.	Indexes are created with the ALTER TABLE command.
Answer» E.

Discussion

4.	Which statement about sequences is not true?
A.	A sequence is an object that generates a sequential series of unique numbers.
B.	Sequences are most often used to provide values for surrogate keys.
C.	NextVal
D.	CurrVal
E.	D.
Answer» E. D.

Discussion