Curioustab

Home » Database » Introduction to SQL

Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

True
False

Correct Answer: True

← Previous Question Next Question→

More Questions from Introduction to SQL

To establish a range of values, < and > can be used.
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
The condition in a WHERE clause can refer to only one value.
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
A dynamic view is one whose contents materialize when referenced.
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion