Curioustab
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Aptitude
General Knowledge
Verbal Reasoning
Computer Science
Interview
Home
»
Database
»
Introduction to SQL
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
True
Correct Answer:
False
← Previous Question
Next Question→
More Questions from
Introduction to SQL
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
There is an equivalent join expression that can be substituted for all subquery expressions.
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
The result of every SQL query is a table.
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.
Discussion & Comments
No comments yet. Be the first to comment!
Name:
Comment:
Post Comment
Join Discussion
Discussion & Comments