FREE Back-End Development MCQ Questions and Answers

Question 1

A component of SQL used to access, and add the total number of records in a table can be obtained using an integrated aggregate function (will NOT ignore null values in columns) and remove data from databases.

Accepted Answer

DML (Data Manipulation Language)

Answer

DDL (Data Definition Language)

Answer

DCL (data Control Language)

Question 2

The total number of records in a table can be obtained using an integrated aggregate function (will NOT ignore null values in columns).

Accepted Answer

Count(*)

Answer

Min()

Answer

Max()

Answer

Avg()

Question 3

A broad view of a database showing all its tables and connections.

Accepted Answer

Schema

Answer

Many-to-many

Answer

Insert

Answer

Derived Column

Question 4

Contains two ID values and, if available, other details.

Accepted Answer

Linking Table

Answer

Set

Answer

Delete

Answer

Lookup Table

Question 5

A set of data spanning all rows in a table with the same datatype (records)

Accepted Answer

Column

Answer

Statement

Answer

Row

Answer

Combination Key

Question 6

An integrated function that changes a given value in the result set to a null.

Accepted Answer

NullIf

Answer

Distinct

Answer

Count()

Answer

Coalesce

Question 7

A word or phrase used to specify which columns should be returned by a query

Accepted Answer

Select

Answer

Insert

Answer

Set

Answer

Delete