History
Who first proposed the relational model?
Edgar F. Codd
How do you select unique records only?
Using the Distinct keyword
What statement is used to define the conditions tofilter the results by
WHERE
A relational database stores data as ____
a set of simple relations/as a table of row and columns
What function do we use to perform exponentiation
POWER
In what year was SQL first developed at IBM?
1974
What is the syntax for the basic SELECT clause to get all rows?
SELECT *
What statement is used to check for null
ISNULL
A row in a relation is referred to as a ___
tuples or records
Suppose we want to compare two strings in a case insensitive manner, what function/s can we use to ensure this works as expected?
UPPER() or LOWER()
Who was the client of Oracle Version 1?
CIA
What is the template for SELECT statements?
SELECT [DISTINCT] *|{_column_|expression [alias],…} FROM _table_;
The between statement is inclusive of the start and end? True or False
True
True or false, SQL code is completely portable between different database systems
False
We have a column called counter and we want it to display the numbers in a fixed number of digits. What function should we use to achieve this?
LPAD()
What was the first version of Oracle officially released?
Version 2
When an expression is returned as a column, what appears as the column name?
The expression itself
What is the symbol used to represent wildcards for single characters for the LIKE keyword.
_ (underscore)
SQL adheres to a set standard. True or False
True
Suppose we have a column for first_name and last_name, how can we display this as a column for full name using single row functions
CONCAT(first_name, " ", last_name)
Who were the first three software engineers that founded Software Development Laboratories?
Larry Ellison, Bob Miner, and Ed Oates
How do you select unique records by multiple columns (e.g. by job and department id)?
DISTINCT(col1, col2, ..., coln)
What is the difference between Where and Having
Where is for regular columns, having is for aggregated columns
SQL consists of what 3 languages?
DDL, DML, DCL
What is the where clause of the SQL statement to filter rows for employees that started within the past 30 days? Assume start_date is the column for the starting date of the employee.
WHERE start_date > CURRENT_DATE() - 30