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.
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.
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.
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
Question text
AND operator displays a record if all the conditions separated by AND are FALSE.
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.
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.
Question text
DDL - Schema: databases, tables, views and many more
Question text
Records that have matching records from two (2) tables
inner join
Question text
DML - Manipulate data using commands: insert, update and delete
Question text
Structured Query Language is a command use by relational database management system to perform database operations.
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.
Question text
DDL used to control data access.
Question text
In SQL the command language used is like an Spanish language.
Question text
DCL - Use the command: Permissions
Question text
SQL is not a Programming Language.
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.
Question text
An Expression can't be a number, columns, literals, functions connected by operators
Question text
Use if there is ambiguity when distinguishing a column.
qualifiers
Question text
DML - Manipulate data using commands: insert, update and delete
Question text
An Expression can't be a number, columns, literals, functions connected by operators
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.
Question text
Columns or expressions can be in the SELECT clause only if they are in the GROUP BY clause.
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
Question text
AND operator displays a record if all the conditions separated by AND are TRUE.
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.
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
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.
Question text
DDL used to control data access.
Question text
Compound Conditions use logical operators to filter or connect multiple criteria.
Question text
In SQL the command language used is like an Spanish language.
Question text
Asterisk (*) means all or a list of .
Question text
SQL is not a Programming Language.
Question text
Cross Join – Used the foreign key as the matching criteria
Question text
Structured Query Language is a command use by relational database management system to perform database operations.
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.
Question text
To sort the records in descending order, use the DESC keyword.
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.