Introduction to SQL - Database MCQ Questions and answers- Technical Aptitude

Home / Database / Introduction To SQL

51.
The result of every SQL query is a table.

Answer & Solution Discuss in Board Save for Later

52.
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.

Answer & Solution Discuss in Board Save for Later

53.
SUM, AVG, MIN, and MAX can only be used with numeric columns.

Answer & Solution Discuss in Board Save for Later

54.
Most companies keep at least two versions of any database they are using.

Answer & Solution Discuss in Board Save for Later

55.
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Answer & Solution Discuss in Board Save for Later

56.
Indexes may be created or dropped at any time.

Answer & Solution Discuss in Board Save for Later

57.
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.

Answer & Solution Discuss in Board Save for Later

58.
ORDER BY can be combined with the SELECT statements.

Answer & Solution Discuss in Board Save for Later

59.
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.

Answer & Solution Discuss in Board Save for Later

60.
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

Answer & Solution Discuss in Board Save for Later