Which of the following rules apply to table names in Oracle 12c?​
Back
Primary Key
Front
Which of the following is used to uniquely identify each record?​
Back
nn
Front
Which of the following is the standard abbreviation for the constraint NOT NULL?​
Back
RENAME...TO
Front
Which command is used to rename a table you own?
Back
bridging table
Front
What is added to a relational database to eliminate many-to-many relationships?​
Back
​Database Management System (DBMS)
Front
Which of the following is used to create and maintain the physical database?​
Back
From
Front
Which of the following is a mandatory clause in a SELECT statement?​
Back
MYTABLE
Front
​Which of the following is a valid table name?
Back
DESCRIBE
Front
Which of the following commands can be used to view the structure of a table?​
Back
It can be NULL, as long as the FOREIGN KEY contains a value
Front
Which of the following statements about a PRIMARY KEY is incorrect?​
Back
True
Front
Two tables can be linked or joined together through a common field.
Back
analyzing data already stored in a database
Front
Data mining refers to
Back
The column can store a total of 5 digits, with 3 on the left side of the decimal point, and 2 on the right.
Front
If a column is defined as NUMBER(5,2), which of the following is true?​
Back
Field
Front
What represents a characteristic or attribute that is being collected about an entity?​
Back
database
Front
A ____ is a storage structure designed to hold a collection of data.​
Back
MODIFY
Front
Which of the following keywords can be used to change the size, datatype, and/or default value of an existing column?
Back
Distinct
Front
Which of the following keywords can be included in a SELECT statement to suppress duplicate data?
Back
/
Front
What is used to indicate the end of an SQL statement?​
Back
​CREATE TABLE...AS
Front
Which of the following keywords uses a subquery to create a new table using existing database tables?
Back
CREATE TABLE newname (colA NUMBER, colB DATE);
Front
Which of the following is a valid SQL statement?​
Back
four
Front
If you are creating a new table containing four columns from an existing table and want to change the name of one of the columns when it is created in the new table, add a column list containing ____ names in the CREATE TABLE clause.​
Back
ANSI and ISO
Front
Which of the following committees are responsible for establishing SQL guidelines?​
Back
DROP TABLE
Front
Which of the following keywords is used to remove a database table in Oracle 12c?​
Back
transitive dependencies
Front
Data in second normal form (2NF) may contain which of the following?
Back
||
Front
Which of the following symbols can be used to combine data from different columns into one column of output?
Back
DROP UNUSED COLUMNS
Front
Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?
Back
The command can be used to delete multiple columns from a table.
Front
When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?​
Back
foreign key
Front
What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?
Back
*
Front
Which of the following symbols represents all the columns contained in a table?​
Back
​systems design
Front
In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?​
Back
​the Systems Development Life Cycle
Front
The multi-step process used when creating a new system is referred to as ____.​
Back
File
Front
Which of the following terms refers to a group of related records?
Back
NEW_COLUMN
Front
Which of the following is a valid column name?
Back
concatenation
Front
Combining the contents of two or more columns is known as ____.​
Back
15
Front
What is the correct solution for the arithmetic expression (2+8)/2*9/3 using the order of operations employed by Oracle 12c when solving equations?​
Back
none of the above
Front
What is the maximum width that can be assigned to a DATE column?
Back
repeating groups
Front
Data in first normal form (1NF) does not contain which of the following?​
Back
a person's hair color
Front
Which of the following is an example of an attribute?​
Back
ALTER TABLE tablea DROP UNUSED COLUMNS;
Front
Which of the following commands will drop any columns marked as unused from the TABLEA table?​
Back
double quotation marks (" ")
Front
If a column alias contains a blank space, it must be enclosed in ____.
Back
FROM
Front
To indicate which database table contains the data to be selected by a query, the table name should be listed in the ____ clause
Back
before the AS clause
Front
If you are creating a new table from data contained in an existing table, new column names can be specified by including a list of column names ____.​
Back
The column list must be enclosed in parentheses ( ).
Front
When creating a table, which of the following statements is correct?​
Back
SELECT
Front
Which of the following commands is used to issue a query
Back
The constraint can reference any column in another table, even a column that has not been designated as the primary key for the referenced table.
Front
Which of the following statements about the FOREIGN KEY constraint is incorrect
Back
ALTER TABLE
Front
Which of the following commands can be used to make structural changes to an existing table?
Back
​CREATE TABLE...AS
Front
Which command instructs Oracle 12c to create a new table from existing data?​
Back
ALTER TABLE...AS
Front
Which of the following keywords cannot be used to modify an existing table?​
Back
​systems analysis
Front
In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?
Back
CREATE TABLE
Front
Which command instructs Oracle 12c to create a new table?
Back
Section 2
(50 cards)
Values
Front
Which of the following keywords is omitted from the INSERT command if the data to be added to a table is already contained in another table?
Back
CREATE INDEX indexname ON tablename (columnname)
Front
​Which command will create an index?
Back
GRANT CREATE SESSION TO username;
Front
Which of the following commands will allow a use to connect to the Oracle database?
Back
Drop
Front
Which clause will allow you to delete a constraint?​
Which of the following can be considered potential threats to an organization's data?
Back
Create/alter table, commit
Front
The effect of which of the following commands can never be reversed by the ROLLBACK command?​
Back
NEXTVAL
Front
Which of the following keywords is used to actually generate a sequence value?
Back
Private
Front
A(n) ____ synonym is used by an individual to reference objects owned by that person.​
Back
UPDATE
Front
Which of the following commands is used to modify existing data in a table
Back
R
Front
In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.​
Back
MINVALUE | MAXVALUE
Front
Which of the following is used to establish a minimum or maximum value, respectively, for a sequence?​
Back
substitution variable
Front
A(n) ____ in a SQL command instructs Oracle 12c to use a substituted value in place of the variable at the time the command is actually executed.​
Back
Insert
Front
Which of the following commands is used to add rows to a table?​
Back
SELECT...FOR UPDATE
Front
The ____ command can be used to view the contents of a record when it is anticipated that the record will need to be modified. It places a shared lock on the record(s) to be changed and prevents any other user from acquiring a lock on the same record(s).​
Back
ALTER USER username DEFAULT ROLE rolename;
Front
The ____ command will assign a default role to a user.​
Back
Both A and B, Explicity
Front
An index can be created ____.​
Back
fk
Front
Which of the following is the standard abbreviation for the constraint FOREIGN KEY?
Back
GRANT SELECT ON orders TO PUBLIC;
Front
Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?
Back
none of the above
Front
Which of the following SQL statements will remove the SELECT ANY TABLE privilege from the database so it can never be granted to another user?​
Back
SET ROLE dba;
Front
Which of the following SQL statements will allow a user to enable the DBA role?​
Back
Describe
Front
Which command can be used to determine whether or not a column is allowed to contain a NULL value?​
Back
alter user
Front
Which of the following commands can be used to assign a default role to a user?​
Back
commas
Front
If more than one column is listed in the INSERT INTO clause, the column names must be separated by ____.​
Back
data manipulation language (DML)
Front
Commands used to modify data are called ____ commands.​
Back
both a and b,
​In the VALUES clause, include the keyword NULL in the position where the value should be listed
Front
When inserting a row into a table, how can you indicate that a row contains a NULL value?​
Back
REVOKE rolename FROM username;
Front
The ____ command is used to revoke a role.​
Back
DROP SYNONYM mysynon;
Front
Which of the following SQL statements will delete the private synonym named MYSYNON?​
Back
table
Front
If a constraint applies to more than one column, the constraint must be created at the ____ level.​
Back
Primary Key
Front
Only one ____ constraint can exist for each table.​
Back
CREATE ROLE rolename;
Front
Which command will establish a new role?
Back
Unique constraint allows null values
Front
The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?​
Back
Increment By
Front
The ____ clause is used to specify the interval between two sequential values
Back
False
Front
When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in descending order.​
Back
After
Front
When a constraint is created at the table level, the constraint definition is provided ____ the column definition list.​
Back
Private
Front
If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default.
Back
Disable
Front
Which clause will allow you to disable a constraint?​
Back
Drop Sequence
Front
Which of the following commands can be used to remove a sequence from a database?​
Back
Oracle 12c does not allow column names to be omitted from the INSERT INTO clause
Front
Which of the following statements about the INSERT keyword is incorrect?​
Back
ALTER USER rthomas DEFAULT ROLE dba;​
Front
Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?​
Back
Unique
Front
The purpose of the ____ constraint is to ensure that two records do not have the same value stored in the same column. However, it can contain NULL values.​
Back
WHERE
Front
If the ____ clause of the UPDATE command is omitted, then all the rows in the specified table will be changed.​
Back
When the user executes COMMIT
Front
When does a COMMIT command explicitly occur?​
Back
Column names are enclosed in parentheses ( ), The data values to be inserted are enclosed in parentheses ( ) after the VALUES keyword, Non-numeric data is enclosed in single quotation marks.
Front
Regarding the INSERT statement, which of the following is correct?​
Back
role
Front
Which of the following terms refers to a collection of privileges?
Back
GRANT...ON...TO
Front
The ____ keywords are used to grant object privileges to users and roles.
Back
INCREMENT BY
Front
A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.
Back
LOCK TABLE
Front
The ____ command will prevent two users from trying to make changes to the same table at the same time.
Back
DROP SEQUENCE sequencename
Front
Which command will delete a sequence?​
Back
column
Front
The NOT NULL constraint can only be created at the ____ level.​
Back
Where
Front
The row(s) to be updated by the UPDATE command is specified by the ____ clause.​
Back
Section 3
(50 cards)
Where
Front
If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed first.
Back
LPAD, both A and B
Front
Which of the following functions can be used to fill a character string to a specific width?
Back
equality join
Front
A join based upon a column from each table containing equivalent data is known as a(n) ____.
Back
Logical Operators
Front
When the WHERE clause contains multiple types of operators, which of the following is resolved last?
Back
True
Front
A Cartesian join can be created by not including a joining condition in the WHERE clause of a SELECT statement. _________________________​
Back
True
Front
A positive number is used in the ROUND function to indicate that numeric data should be rounded to the indicated position to the right of the decimal point.​
Back
%03
Front
Which of the following search patterns would find dates occurring only in the year 2003?​
Back
LOWER
Front
Which of the following functions can be used to convert a character string to lower-case letters?​
Back
ALTER USER username IDENTIFIED BY newpassword;
Front
Which of the following commands will change a user's password?
Back
CREATE USER username IDENTIFIED BY password;
Front
Which of the following commands is used to establish a user account?​
Back
%H%
Front
Which of the following search patterns could be used to find the word HELLO in Oracle12c?​
Back
Julian date
Front
Which of the following represents the number of days that have passed since January 1, 4712 B.C.?
Back
With grant Option
Front
Which of the following keywords must be included with the GRANT command to allow the user to grant object privileges to other users?
Back
UPPER
Front
Which of the following functions can be used to convert a character string to upper-case letters?​
Back
ALTER ROLE rolename IDENTIFIED BY password;
Front
Which of the following will add a password to a role?
Back
Union All
Front
Which of the following set operators will display the results of the combined SQL statements without suppressing duplicate rows?
Back
All
Front
If the DISTINCT keyword is not included in the SUM function, the ___________ keyword will be assumed.
Back
ColB IS NOT NULL
Front
Which of the following search conditions can be used to identify records that have data stored in a column named ColB?
Back
False
Front
A cross join between two tables, containing four rows each, will display eight rows in its output. _________________________​
Back
NULL
Front
When sorting the results in descending order, which of the following values will be presented first in the output?​
Back
Where
Front
A(n) ___________ clause cannot include a group function.
Back
Set Operator
Front
A(n) ____ is used to combine the results of two queries.
Back
False
Front
The SUBSTR function is used to substitute one character string for another in a set of data. _________________________​
Back
Outer
Front
When functions are nested, the ____ function is solved last.
Back
A user name cannot contain numbers.
Front
Which of the following statements about creating a username is incorrect?
Back
Selection
Front
The process of retrieving only certain rows based upon a specified condition is known as ____.​
Back
WHERE, GROUP BY, HAVING
Front
Which of the following indicates the processing order for the indicated clauses?
a. WHERE, HAVING, GROUP BY
b. GROUP BY, HAVING, WHERE
c. WHERE, GROUP BY, HAVING
d. HAVING, WHERE, GROUP BY
Back
SUBSTR
Front
Which of the following is used to return a portion of a character string?​
Back
Having
Front
If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ___________ clause will be processed last.
Back
Revoke
Front
Which of the following commands can be used to revoke system or object privileges previously granted to a user?
Back
Decode
Front
Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?
Back
NVL
Front
Which of the following functions can be used to substitute another value for a NULL value during calculations?
Back
TO_DATE
Front
Which of the following functions can be used to change the format of a date that has been entered by a user to the default storage format use by Oracle12c?
Back
numeric
Front
When sorting the results in ascending order, which of the following values will be presented first in the output?​
Back
ColB IS NULL
Front
Which of the following search conditions can be used to identify records that do not have data stored in a column named ColB?
Back
SYSDATE
Front
Which of the following keywords will return the value of the date according to the computer?
Back
Null
Front
If the two values compared by the NULLIF function are equal, what value does the function return?
Back
outer join operator (+)
Front
Which of the following is used to create an outer join in a WHERE clause?​
Back
NVL2
Front
Which of the following functions allows for different options, depending upon whether a NULL value exists?
Back
nulls last, nulls first
Front
The order in which NULL values appear in the results can be overridden by which of the following keywords?​
Back
Authentication
Front
Which of the following refers to the process of ensuring that individuals trying to access the system are who they say they are, thus preventing them from illegally accessing data?
Back
Join On, Join Using, Natural Join
Front
Which of the following keywords is used to create an equality join?
Back
All
Front
If the DISTINCT keyword is not included in the STDDEV function, the _____________ keyword will be assumed.
Back
Min, max, count
Front
Which of the following can be used with date columns?
Back
​arithmetic operations
Front
When the WHERE clause contains multiple types of operators, which of the following is resolved first?​
Back
REVOKE SELECT ON orders FROM rthomas;
Front
Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?
Back
LTRIM
Front
Which of the following functions can be used to remove a specific set of characters from the left side of a set of data values?​
Back
group, multiple-row, aggregate
Front
Functions that return one result per group of rows are called __________ functions.
Back
Cross Join
Front
​Which of the following keywords is used to create a Cartesian join?
Back
Group by, single row
Front
A group function can be nested inside a(n)________________.
Back
Section 4
(48 cards)
simple
Front
Which of the following types of views cannot include a GROUP BY clause?​
Back
Numeric
Front
The SUM function can only be used with ____________ data.
Back
NoForce
Front
What is the default mode for the CREATE VIEW command?​
Back
simple view
Front
Which of the following describes a type of view that is based upon a subquery that only references one table and does not include any group functions, expressions, or GROUP BY clauses?​
Back
Complex
Front
Which type of view is created from the following command?
CREATE VIEW prices
AS SELECT isbn, title, cost, retail, retail-cost profit
FROM books;
Back
Complex View
Front
Which of the following describes a type of view that is based on a subquery that retrieves or derives data from one or more tables, and may also contain functions or grouped data?​
Back
STD DEV
Front
The __________ function is based upon the concept of a normal distribution.
Back
INSERT INTO prices (title, cost, retail)
VALUES ('A NEW BOOK', 49.99, 69.99);
Front
Which SQL statement can be executed based upon the view created from the following command, assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn, title, cost, retail, retail-cost profit
FROM books;
Back
False
Front
Single-row operators can be used with multiple-row subqueries that return only one column of results.
Back
Views are database objects that actually store data.
Front
Which of the following statements about views is incorrect?​
Back
DISTINCT
Front
DML operations are not allowed on a view that is created with the ____ keyword.​
Back
simple
Front
Which of the following types of views cannot contain grouped data?​
Back
Multiple Column
Front
The following SQL statement contains which type of subquery?
SELECT title, retail, category, cataverage FROM books NATURAL JOIN
(SELECT category, AVG(retail) cataverage FROM books GROUP BY
Back
ALL and ANY
Front
Which operators can be combined with other comparison operators to treat the results of a subquery as a set of values, rather than as individual values?​
Back
None of the above: on the left side of the comparison operator,
​on the right side of the comparison operator,
​in the SELECT clause
Front
The EXISTS operator must be listed ____​
Back
re-create the view without the option
Front
If a view was created with the WITH CHECK OPTION constraint, to remove the constraint you will need to ____.
Back
more than the highest
Front
The >ALL operator indicates that a value must be ____ value returned by the subquery. query?
Back
Values cannot be inserted into columns that are based on arithmetic expressions.
Front
Which of the following statements about performing DML operations on complex views is correct?​
Back
view
Front
A(n) ____ stores a query and is used to access data in the underlying tables.​
Back
Individual column
Front
If a group function is used in the SELECT clause, any ______________ listed in the SELECT clause must also be listed in the GROUP BY clause.
Back
Inline
Front
The subquery used to create a(n) ____ view can contain an ORDER BY clause.​
Back
AVG
Front
The ____________ function calculates the average of the numeric values in a specified column.
Back
another view does not exist with the same name
Front
The OR REPLACE clause is not required if ____.
Back
False
Front
When a multiple-column subquery is used in the WHERE clause of the outer query, the column names listed on the left side of the comparison operator must be enclosed in double-quotation marks.​
Back
multiple-row subquery
Front
Which of the following subqueries returns more than one row of results to the outer query?​
Back
Key preserved
Front
A(n) ____ table is the table that contains the primary key the view uses to uniquely identify each record being displayed by the view.​
Back
Complex
Front
A view based on the contents of one table that uses an expression for one of the columns is considered a(n) ____ view.​
Back
True
Front
An ORDER BY clause can be used to perform "TOP-N" analysis.​
Back
Inline View
Front
The following SQL statement contains what type of subquery?
SELECT b.title, b.retail, a.category, a.cataverage
FROM books b, (SELECT category, AVG(retail) cataverage
FROM books GROUP BY category) a
WHERE b.category = a.category;
Back
GROUP BY
Front
The _____________ clause is used to indicate that groups should be created.
Back
numeric
Front
The MAX function can be used with which type of columns?
Back
correlated subquery
Front
Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?
Back
False
Front
The COUNT(*) function is only used to count the number of records containing NULL values.
Back
both a and b, From and Select
Front
A subquery must include a(n) ____ clause.​
Back
​non key-preserved
Front
A(n) ____ table is a table that does not contain the primary key that a view uses to uniquely identify each record being displayed by the view
Back
True
Front
A(n) single-row subquery can be nested in a(n) SELECT clause.
Back
re-create the view without the option
Front
If a view was created with the WITH READ ONLY constraint, to remove the constraint you will need to ____.​
Back
IN
Front
The ____ operator indicates that the records processed by the outer query must match one of the values returned by the subquery.​
Back
Subquery
Front
The outer query receives its input from the ____.​
Back
SUM
Front
The _____________ function is used to calculate the total amount stored in a numeric field.
Back
Numeric
Front
The STDDEV function can be used with ____________ columns.
Back
IN
Front
When a multiple-column subquery is included in the WHERE or HAVING clause of the outer query, which operator is used by the outer query to evaluate the results of the subquery?​
Back
DML
Front
With a MERGE statement, a series of ____ actions can occur with a single SQL statement.
Back
​materialized
Front
The type of view that actually replicates data is called a(n) ____ view
Back
Numeric
Front
The VARIANCE function can be used with _____________ columns.
Back
Multiple Row
Front
A(n) ____ subquery is one that can return several rows of results.​