Section 1

Preview this deck

Names can contain a number sign (#)

Front

Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (198)

Section 1

(50 cards)

Names can contain a number sign (#)

Front

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?​

Back

disgruntled employees, natural distasters, ​computer criminals

Front

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.​

Back

​multiple-column subquery, single-row subquery, ​multiple-row subquery

Front

Which of the following can be used in a WHERE clause?​

Back

Having

Front

If the output is to be restricted based upon a group function, a(n) _____________ clause must be included in the SQL statement.

Back