To define what columns should be displayed in an SQL SELECT statement:

A use FROM to name the source table(s) and list the columns to be shown after SELECT.
B use USING to name the source table(s) and list the columns to be shown after SELECT.
C use SELECT to name the source table(s) and list the columns to be shown after USING.
D use USING to name the source table(s) and list the columns to be shown after WHERE.

Correct Answer: use FROM to name the source table(s) and list the columns to be shown after SELECT.

Bissoy MCQ
#Database #Introduction To SQL

Related Questions

On sports day. if 30 children were made to stand in a column, 16 columns could be formed. If 24 children were made to stand in a column,how many columns could be formed?
A 45
B 20
C 22
D 29
On sports day, if 30 children were made to stand in a column, 16 columns could be formed. If 24 children were made a stand in a column, how many columns could be formed ?
A 40
B 20
C 22
D 30
Diameter of bubble caps used in high pressure columns is __________ as compared to that used in identical vacuum columns.
A Less
B More
C Same
D Either A or B; no generalisation can be made
Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.
A True
B False
What SQL command can be used to delete columns from a table?
A MODIFY TABLE TableName DROP ColumnName
B MODIFY TABLE TableName DROP COLUMN ColumnName
C ALTER TABLE TableName DROP ColumnName
D ALTER TABLE TableName DROP COLUMN ColumnName
What SQL command can be used to add columns to a table?
A ALTER TABLE TableName ADD ColumnName
B ALTER TABLE TableName ADD COLUMN ColumnName
C MODIFY TABLE TableName ADD ColumnName
D MODIFY TABLE TableName ADD COLUMN ColumnName
What resistence in ohms should be displayed ehen testing a speaker in a computer?
A 0 Ohms
B 16 Ohms
C -200 Ohms
D Unlimited Ohms
E None of the above
What resistance in ohms should be displayed when testing a speaker in a computer?
A Q Ohms
B 16 Ohms
C -200 Ohms
D Unlimited Ohms
E None of the above
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.
A True
B False
You have linked SQL*Plus to an external text editor. To invoke the text editor for use within SQL*Plus, which command do you use?
A Open
B Show
C Alter
D Edit

Next steps