DBMS 110 Final With complete solutions
According to the reading you can connect to an Oracle Database using SQL*Plus
Correct!
True -ANSW- True
SQL provides an interface to a -ANSW- Relational Database
Data is stored in a two-dimensional matrix known as a -ANSW- File
SQL stands for Structured question language -ANSW- False
What is the second stage of the SQL processing? -ANSW- Optimization
DDL stands for Data Definition Language -ANSW- True
Table names and column names can start with number value. -ANSW- False
To issue a CREATE TABLE statement, you must have: -ANSW- You can logically
relate data from multiple tables using
A DML statement is executed when you: -ANSW- Add new rows to a table
Add rows to a table by using? -ANSW- INSERT
Values for a specific row or rows are modified if you specify the clause. -ANSW-
WHERE
The function records the current date and time. -ANSW- SYSDATE()
A consists of a collection of DML statements that form a logical unit of work. -ANSW-
transaction
Which of the following statements modify existing values in a table? -ANSW- UPDATE
The ROLLBACK rolls the database back to factory setting. -ANSW- F
You can remove existing rows from a table by using the statement. -ANSW- DELETE
What doe TCL stand for: -ANSW- Transaction Control Language
A DML statement is executed when you: -ANSW- Add new rows to a table
, You can combine the two wildcard characters with literal characters for pattern
matching. -ANSW- True
Null is the same as zero or a blank space. -ANSW- False
When using the LIKE operator in a WHERE statement what is the wildcard character for
zero or more characters? -ANSW- %
Which character is used to SELECT all columns in a table? -ANSW- *
SQL statement identifies the columns to be displayed. -ANSW- SELECT
A is a character, a number, or a date that is included in the SELECT statement. -
ANSW- literal
is a value that is unavailable, unassigned, unknown, or inapplicable. -ANSW- Null
Use the operator to display rows based on a range of values. -ANSW- BETWEEN
SQL keyword requires both component conditions to be true. -ANSW- AND
What clause is used to arrange the output of a SELECT statement? -ANSW- ORDER
BY
SQL clause identifies the table that contains those columns. -ANSW- FROM
When using the LIKE operator in a WHERE statement what is the wildcard character for
zero or more characters? -ANSW- %
You can combine the two wildcard characters with literal characters for pattern
matching. -ANSW- True
Use the operator to display rows based on a range of values. -ANSW- BETWEEN
Restrict the rows that are returned by using the clause. -ANSW- WHERE
SQL statements are case-sensitive. -ANSW- False
Which character is used to SELECT all columns in a table? -ANSW- *
The CFO of company ABC wants to give every employee a 3% raise, but would like a
report to confirm if this is possible. Write an SQL statement that would pull this report
from the Employee table. They are requesting just the Employee ID, Current Salary,
and Salary plus 3%. Salary is saved in the database for the employee's annual pay. -
ANSW- SELECT Employee_ID, Current_Salary, Salary*1.03 "Salary plus 3 percent"
According to the reading you can connect to an Oracle Database using SQL*Plus
Correct!
True -ANSW- True
SQL provides an interface to a -ANSW- Relational Database
Data is stored in a two-dimensional matrix known as a -ANSW- File
SQL stands for Structured question language -ANSW- False
What is the second stage of the SQL processing? -ANSW- Optimization
DDL stands for Data Definition Language -ANSW- True
Table names and column names can start with number value. -ANSW- False
To issue a CREATE TABLE statement, you must have: -ANSW- You can logically
relate data from multiple tables using
A DML statement is executed when you: -ANSW- Add new rows to a table
Add rows to a table by using? -ANSW- INSERT
Values for a specific row or rows are modified if you specify the clause. -ANSW-
WHERE
The function records the current date and time. -ANSW- SYSDATE()
A consists of a collection of DML statements that form a logical unit of work. -ANSW-
transaction
Which of the following statements modify existing values in a table? -ANSW- UPDATE
The ROLLBACK rolls the database back to factory setting. -ANSW- F
You can remove existing rows from a table by using the statement. -ANSW- DELETE
What doe TCL stand for: -ANSW- Transaction Control Language
A DML statement is executed when you: -ANSW- Add new rows to a table
, You can combine the two wildcard characters with literal characters for pattern
matching. -ANSW- True
Null is the same as zero or a blank space. -ANSW- False
When using the LIKE operator in a WHERE statement what is the wildcard character for
zero or more characters? -ANSW- %
Which character is used to SELECT all columns in a table? -ANSW- *
SQL statement identifies the columns to be displayed. -ANSW- SELECT
A is a character, a number, or a date that is included in the SELECT statement. -
ANSW- literal
is a value that is unavailable, unassigned, unknown, or inapplicable. -ANSW- Null
Use the operator to display rows based on a range of values. -ANSW- BETWEEN
SQL keyword requires both component conditions to be true. -ANSW- AND
What clause is used to arrange the output of a SELECT statement? -ANSW- ORDER
BY
SQL clause identifies the table that contains those columns. -ANSW- FROM
When using the LIKE operator in a WHERE statement what is the wildcard character for
zero or more characters? -ANSW- %
You can combine the two wildcard characters with literal characters for pattern
matching. -ANSW- True
Use the operator to display rows based on a range of values. -ANSW- BETWEEN
Restrict the rows that are returned by using the clause. -ANSW- WHERE
SQL statements are case-sensitive. -ANSW- False
Which character is used to SELECT all columns in a table? -ANSW- *
The CFO of company ABC wants to give every employee a 3% raise, but would like a
report to confirm if this is possible. Write an SQL statement that would pull this report
from the Employee table. They are requesting just the Employee ID, Current Salary,
and Salary plus 3%. Salary is saved in the database for the employee's annual pay. -
ANSW- SELECT Employee_ID, Current_Salary, Salary*1.03 "Salary plus 3 percent"
