Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
Introduction to SQL
The result of every SQL query is a table.
True
Correct Answer:
True
← Previous Question
Next Question→
More Questions from
Introduction to SQL
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
ORDER BY can be combined with the SELECT statements.
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
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.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments