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

Question text

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

Select one:

Question text

 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:

Question text

Use to get aggregation results for different groups of records.


group by

Question text

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

Select one:

Question text

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


Expression


Question text

Cross Join – Used the foreign key as the matching criteria


Select one:

Question text

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

Select one:

Question text

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


OR operator

Question text

Matching Type
Aggregate Functions

number of all or selected values

maximum of all or selected values


minimum of all or selected values

sum of all or selected values

average of all or selected values

Question text

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


outer join


Question text

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

Select one:

Question text

Asterisk (*) means all or a list of 


lumnsco

Question text

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


full join

Question text

Matching Type.
What does SQL do

Used to define and modify data structures


Used to control data access


Used to retrive data and manipulate data


Question text

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

Select one:

Question text

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


Select one:

Question text

Records that have matching records from two (2) tables


inner join

Question text

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

Select one:

Question text

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


Select one:

Question text

Use to retrieve data from multiple tables.


Table join

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

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

Question text

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

Select one:

Question text

DDL used to control data access.

Select one:

Question text

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


Select one:

Question text

DCL - Use the command: Permissions

Select one:

Question text

SQL is not a Programming Language.

Select one:

Question text

We use  to give column another name.


ALIAS

Question text

Used to sort the result.


Order by keyword

Question text

SQL is used to retrieve data from relational databases.

Select one:

Question text

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

Select one:

Question text

Use  if there is ambiguity when distinguishing a column.


qualifiers

Question text

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

Select one:

Question text

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

Select one:

Question text

Matching Type
Aggregate Functions

average of all or selected values

maximum of all or selected values


minimum of all or selected values

number of all or selected values

sum of all or selected values

Question text

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


Question text

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

Question text

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

Select one:

Question text

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

Select one:

Question text

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


Question text

Records that have matching records from two (2) tables

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.

Question text

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


Select one:

Question text

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

Select one:

Question text

Use to get aggregation results for different groups of records.

Question text

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

Select one:

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.

Question text

DCL - Use the command: Permissions

Select one:

Question text

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

Question text

Used to sort the result.

Question text

SQL is used to retrieve data from relational databases.

Select one:

Question text

DDL used to control data access.

Select one:

Question text

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

Select one:

Question text

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


Select one:

Question text

Asterisk (*) means all or a list of .

Question text

SQL is not a Programming Language.

Select one:

Question text

Cross Join – Used the foreign key as the matching criteria


Select one:

Question text

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


Select one:

Question text

We use  to give column another name.

Question text

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

Question text

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

Select one:

Question text

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

Select one:

Question text

Use to retrieve data from multiple tables.

Question text

 means missing value.

Question text

Matching Type.
What does SQL do

Used to control data access


Used to retrive data and manipulate data


Used to define and modify data structures


Question text

Use  if there is ambiguity when distinguishing a column.