Fundamentals of Database System

Fundamentals of Database System
(Final Q1, Q2, FinXam)

Question text

It is a command used or a request for information from a database.

Query

Answer: 

Question text

OR operator displays a record if any of the conditions separated by OR is TRUE.

Select one:

True

False

Question text

Answer means missing value.

Null

Question text

Columns or expressions can be in the SELECT clause only if they are in the GROUP BY clause.

Select one:

True

False

Question text

Use to get aggregation results for different groups of records.

group by

Answer: 

Question text

To sort the records in descending order, use the DESC keyword.

Select one:

True

False

Question text

It is a combination of symbols and operators that returns a single value.

Expression

Answer: 

Question text

Cross Join – Used the foreign key as the matching criteria

Select one:

True

False

Question text

AND operator displays a record if all the conditions separated by AND are FALSE.

Select one:

True

False

Question text

Displays a record if any of the conditions separated by OR is TRUE.

OR operator

Answer: 

Question text

Matching Type
Aggregate Functions

number of all or selected values	Answer 1Choose...countmaxavgsummin
maximum of all or selected values	Answer 2Choose...countmaxavgsummin
minimum of all or selected values	Answer 3Choose...countmaxavgsummin
sum of all or selected values	Answer 4Choose...countmaxavgsummin
average of all or selected values	Answer 5Choose...countmaxavgsummin

Question text

It is needed when minimum cardinality is optional on a table.

outer join

Answer: 

Question text

AND operator displays a record if all the conditions separated by AND are TRUE.

Select one:

True

False

Question text

Asterisk (*) means all or a list of Answer. 

lumnsco

Question text

Include all qualified records from both tables in the join condition.

full join

Answer: 

Question text

Matching Type.
What does SQL do

Used to define and modify data structures	Answer 1Choose...DCLDMLDDL
Used to control data access	Answer 2Choose...DCLDMLDDL
Used to retrive data and manipulate data	Answer 3Choose...DCLDMLDDL

Question text

Compound Conditions use logical operators to filter or connect multiple criteria.

Select one:

True

False

Question text

DDL - Schema: databases, tables, views and many more

Select one:

True

False

Question text

Records that have matching records from two (2) tables

inner join

Answer: 

Question text

DML -  Manipulate data using commands: insert, update and delete

Select one:

True

False

Question text

Structured Query Language is a command use by relational database management system to perform database operations.

Select one:

True

False

Question text

Use to retrieve data from multiple tables.

Table join

Answer: 

Question text

Include all qualified records from the right table in the join condition even if they do not have matching records in the left table.

right join

Answer: 

Question text

Include all qualified records from the left table in the join condition even if they do not have matching records in the right table.

left join

Answer: 

Question text

An Expression can be a single constant, column, variable, or scalar function.

Select one:

True

False

Question text

DDL used to control data access.

Select one:

True

False

Question text

In SQL the command language used is like an Spanish language.

Select one:

True

False

Question text

DCL - Use the command: Permissions

Select one:

True

False

Question text

SQL is not a Programming Language.

Select one:

True

False

Question text

We use Answer to give column another name.

ALIAS

Question text

Used to sort the result.

Order by keyword

Answer: 

Question text

SQL is used to retrieve data from relational databases.

Select one:

True

False

Question text

An Expression can't be a number, columns, literals, functions connected by operators

Select one:

True

False

Question text

Use Answer if there is ambiguity when distinguishing a column.

qualifiers

Question text

DML -  Manipulate data using commands: insert, update and delete

Select one:

True

False

Question text

An Expression can't be a number, columns, literals, functions connected by operators

Select one:

True

False

Question text

Matching Type
Aggregate Functions

average of all or selected values	Answer 1Choose...avgcountminsummax
maximum of all or selected values	Answer 2Choose...avgcountminsummax
minimum of all or selected values	Answer 3Choose...avgcountminsummax
number of all or selected values	Answer 4Choose...avgcountminsummax
sum of all or selected values	Answer 5Choose...avgcountminsummax

Question text

It is a combination of symbols and operators that returns a single value.

Answer: 

Question text

Include all qualified records from both tables in the join condition.

Answer: 

Question text

An Expression can be a single constant, column, variable, or scalar function.

Select one:

True

False

Question text

Columns or expressions can be in the SELECT clause only if they are in the GROUP BY clause.

Select one:

True

False

Question text

It is needed when minimum cardinality is optional on a table.

Answer: 

Question text

Records that have matching records from two (2) tables

Answer: 

Question text

Include all qualified records from the left table in the join condition even if they do not have matching records in the right table.

Answer: 

Question text

DDL - Schema: databases, tables, views and many more

Select one:

True

False

Question text

AND operator displays a record if all the conditions separated by AND are TRUE.

Select one:

True

False

Question text

Use to get aggregation results for different groups of records.

Answer: 

Question text

OR operator displays a record if any of the conditions separated by OR is TRUE.

Select one:

True

False

Question text

Include all qualified records from the right table in the join condition even if they do not have matching records in the left table.

Answer: 

Question text

DCL - Use the command: Permissions

Select one:

True

False

Question text

It is a command used or a request for information from a database.

Answer: 

Question text

Used to sort the result.

Answer: 

Question text

SQL is used to retrieve data from relational databases.

Select one:

True

False

Question text

DDL used to control data access.

Select one:

True

False

Question text

Compound Conditions use logical operators to filter or connect multiple criteria.

Select one:

True

False

Question text

In SQL the command language used is like an Spanish language.

Select one:

True

False

Question text

Asterisk (*) means all or a list of Answer.

Question text

SQL is not a Programming Language.

Select one:

True

False

Question text

Cross Join – Used the foreign key as the matching criteria

Select one:

True

False

Question text

Structured Query Language is a command use by relational database management system to perform database operations.

Select one:

True

False

Question text

We use Answer to give column another name.

Question text

Displays a record if any of the conditions separated by OR is TRUE.

Answer: 

Question text

AND operator displays a record if all the conditions separated by AND are FALSE.

Select one:

True

False

Question text

To sort the records in descending order, use the DESC keyword.

Select one:

True

False

Question text

Use to retrieve data from multiple tables.

Answer: 

Question text

Answer means missing value.

Question text

Matching Type.
What does SQL do

Used to control data access	Answer 1Choose...DMLDCLDDL
Used to retrive data and manipulate data	Answer 2Choose...DMLDCLDDL
Used to define and modify data structures	Answer 3Choose...DMLDCLDDL

Question text

Use Answer if there is ambiguity when distinguishing a column.