DBMS 110 Final Exam: Questions And Verified Answers
According to the reading you can connect to an Oracle Database using
SQL*Plus
Correct!
True Right Ans - True
SQL provides an interface to a Right Ans - Relational Database
Data is stored in a two-dimensional matrix known as a Right Ans - File
SQL stands for Structured question language Right Ans - False
What is the second stage of the SQL processing? Right Ans - Optimization
DDL stands for Data Definition Language Right Ans - True
Table names and column names can start with number value. Right Ans -
False
To issue a CREATE TABLE statement, you must have: Right Ans - You can
logically relate data from multiple tables using
A DML statement is executed when you: Right Ans - Add new rows to a
table
Add rows to a table by using? Right Ans - INSERT
Values for a specific row or rows are modified if you specify the clause.
Right Ans - WHERE
The function records the current date and time. Right Ans - SYSDATE()
A consists of a collection of DML statements that form a logical unit of work.
Right Ans - transaction
Which of the following statements modify existing values in a table? Right
Ans - UPDATE
, The ROLLBACK rolls the database back to factory setting. Right Ans - F
You can remove existing rows from a table by using the statement. Right
Ans - DELETE
What doe TCL stand for: Right Ans - Transaction Control Language
A DML statement is executed when you: Right Ans - Add new rows to a
table
You can combine the two wildcard characters with literal characters for
pattern matching. Right Ans - True
Null is the same as zero or a blank space. Right Ans - False
When using the LIKE operator in a WHERE statement what is the wildcard
character for zero or more characters? Right Ans - %
Which character is used to SELECT all columns in a table? Right Ans - *
SQL statement identifies the columns to be displayed. Right Ans - SELECT
A is a character, a number, or a date that is included in the SELECT statement.
Right Ans - literal
is a value that is unavailable, unassigned, unknown, or inapplicable. Right
Ans - Null
Use the operator to display rows based on a range of values. Right Ans -
BETWEEN
SQL keyword requires both component conditions to be true. Right Ans -
AND
What clause is used to arrange the output of a SELECT statement? Right
Ans - ORDER BY
SQL clause identifies the table that contains those columns. Right Ans -
FROM
According to the reading you can connect to an Oracle Database using
SQL*Plus
Correct!
True Right Ans - True
SQL provides an interface to a Right Ans - Relational Database
Data is stored in a two-dimensional matrix known as a Right Ans - File
SQL stands for Structured question language Right Ans - False
What is the second stage of the SQL processing? Right Ans - Optimization
DDL stands for Data Definition Language Right Ans - True
Table names and column names can start with number value. Right Ans -
False
To issue a CREATE TABLE statement, you must have: Right Ans - You can
logically relate data from multiple tables using
A DML statement is executed when you: Right Ans - Add new rows to a
table
Add rows to a table by using? Right Ans - INSERT
Values for a specific row or rows are modified if you specify the clause.
Right Ans - WHERE
The function records the current date and time. Right Ans - SYSDATE()
A consists of a collection of DML statements that form a logical unit of work.
Right Ans - transaction
Which of the following statements modify existing values in a table? Right
Ans - UPDATE
, The ROLLBACK rolls the database back to factory setting. Right Ans - F
You can remove existing rows from a table by using the statement. Right
Ans - DELETE
What doe TCL stand for: Right Ans - Transaction Control Language
A DML statement is executed when you: Right Ans - Add new rows to a
table
You can combine the two wildcard characters with literal characters for
pattern matching. Right Ans - True
Null is the same as zero or a blank space. Right Ans - False
When using the LIKE operator in a WHERE statement what is the wildcard
character for zero or more characters? Right Ans - %
Which character is used to SELECT all columns in a table? Right Ans - *
SQL statement identifies the columns to be displayed. Right Ans - SELECT
A is a character, a number, or a date that is included in the SELECT statement.
Right Ans - literal
is a value that is unavailable, unassigned, unknown, or inapplicable. Right
Ans - Null
Use the operator to display rows based on a range of values. Right Ans -
BETWEEN
SQL keyword requires both component conditions to be true. Right Ans -
AND
What clause is used to arrange the output of a SELECT statement? Right
Ans - ORDER BY
SQL clause identifies the table that contains those columns. Right Ans -
FROM
