Final Exam AIT
If a PRIMARY KEY constraint, named ORDERITEMS_PK, exists for the ORDER# and ITEM# columns of the ORDERITEMS table, which of the following commands will drop the constraint?
ALTER TABLE orderitems DROP PRIMARY KEY;
If a PRIMARY KEY constraint, named ORDERITEMS_PK, for the ORDER# and ITEM# columns of the ORDERITEMS table have been disabled, which of the following commands will enable the constraint?
ALTER TABLE orderitems ENABLE CONSTRAINT orderitems_pk;
A column name can consist of up to 225 characters.
False
A column qualifier indicates the *column* containing the data being referenced.
False
A subquery nested in a WHERE clause can only be on the *left* side of the comparison operator.
False
A table alias can be assigned in the FROM clause, even when tables are being joined using the NATURAL JOIN keywords.
False
A(n) *uncorrelated* subquery is when the outer query is executed first, then the inner query is executed.
False
A(n) CRBMDS is a software program that can be used to create a relational database and allows you to enter, manipulate, and retrieve data.
False
A(n) synonym is a collection of objects.
False
All privileges granted to a role must be revoked before the role can be removed from the database.
False
If a date column is being used for comparison against the search condition, the search condition is enclosed in *double* quotation marks.
False
If a group function is used in the SELECT clause, then any individual columns listed in the SELECT clause must also be listed in the *ORDER BY* clause.
False
If a table alias is assigned in the *SELECT* clause, it must be used any time the table is referenced in that SQL statement.
False
If one of the data values being entered into a table by the INSERT command violates an existing constraint, the remaining portion of the row will be added, but the data violating the constraint will need to be added at a later time using the UPDATE command.
False
If the ON DELETE CASCADE keywords are included when a(n) *PRIMARY KEY* constraint is created, then if a row is deleted from the parent table, any corresponding records in the child table are also deleted.
False
If you are joining five tables in a SELECT statement, *five* joining conditions will be required.
False
If you are joining two tables in a SELECT statement, *three* joining conditions will be required.
False
The *GROUP BY* clause is used to restrict the groups returned by a query.
False
The *JOIN...USING* keywords are used to join two tables that do not have a commonly named and defined column.
False
The *NEXT_DATE* function is used to determine the next occurrence of a specific day of the week after a given date.
False
The *ON* clause can be used only if the tables being joined have a common column with the same name.
False
The *ORDER BY* clause is used to group data.
False
The *REFERENCE* constraint is used to ensure that a data value meets a specified condition before a record is added to a table.
False
The *ROUND* function can be used to truncate numeric data.
False
The WHERE clause specifies which groups will be displayed in the results.
False
The data *warehouse* contains information about objects included in the database.
False
The data contained in a dropped table can be retrieved if the *DROP* option was not used in the DROP TABLE command.
False
The default size of the CHAR column is *2*.
False
The default value for the INCREMENT BY clause is two .
False
The greater than operator, >, is a valid operator for *multiple-row* subqueries.
False
The maximum number of columns that can be used to sort the results of a query is 52.
False
The only group function that includes NULL values is the *NVL* function.
False
The optional UNIQUE keyword instructs Oracle 12c to include only unique numeric values in its calculation.
False
The use of a column alias in the SELECT clause can be designated by the keyword *ALIAS*.
False
The width of a NUMBER column cannot be *changed* once it contains data.
False
To calculate the difference between two date columns, you must use the TO_DATE function.
False
To indicate that the numeric value of the day of the year for a date is being specified, include DAY in format argument of the TO_DATE function.
False
Use MON in the format argument to spell out the specified month.
False
Use an asterisk in the REVOKE command to revoke all system and object privileges that have been assigned to a user.
False
Valid *multiple-row* operators include =, >, =, <=.
False
When DDL operations are performed, Oracle 12c will automatically place a(n) *shared* lock on the table.
False
When dropping a constraint, the user is always required to specify the name of the constraint being dropped.
False
When functions are nested, the outer function is solved or executed first.
False
When including a subquery in an INSERT command, the syntax of enclosing the subquery in parentheses is *mandatory*.
False
When two conditions are joined by the *OR* keyword, both conditions must be TRUE for a record to be included in the results.
False
When two conditions are joined by the AND logical operator, only one of the conditions must be TRUE to be included in the query results.
False
When using a search pattern, a(n) *?* symbol is used to indicate exactly one character in that position.
False
You cannot specify the width for a(n) *NUMBER* column.
False
Which of the following SQL statements will grant all object privileges for the ORDERS table to user RTHOMAS?
GRANT ALL ON orders TO rthomas;
Which of the following SQL statements will grant the SELECT privilege for the ORDERS table to all database users?
GRANT SELECT ON orders TO PUBLIC;
A negative number can be assigned to the ____ clause to generate sequential numbers in decreasing order.
INCREMENT BY
The ____ clause is used to specify the interval between two sequential values.
INCREMENT BY
Which of the following is a pseudocolumn?
NEXTVAL
An index is not implicitly created when which type of constraint is created?
NOT NULL
Which of the following commands can be used to revoke system or object privileges previously granted to a user?
REVOKE
Which of the following commands will revoke the SELECT privilege for the ORDERS table previously granted to user RTHOMAS?
REVOKE SELECT ON orders FROM rthomas;
Based upon the contents of the CUSTOMERS table, which of the following will display the shipping location as: City, State Zip Note: The ST column name is truncated, this represents the STATE column.
SELECT INITCAP(CONCAT(city, CONCAT(', ', CONCAT(state, CONCAT(' ', zip))))) FROM customers;
Based upon the contents of the ORDERS table, which of the following will display the shipping location as: Shipcity, Shipstate Shipzip Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
SELECT INITCAP(CONCAT(shipcity, CONCAT(', ', CONCAT(shipstate, CONCAT(' ', shipzip))))) FROM orders;
*DDL* commands are used to create or modify database objects.
True
*Parentheses* can be used to override the order of operations in an arithmetic expression.
True
A CHECK constraint requires that a data value meet a certain condition before the record is added to the database table.
True
A Cartesian join can be created by not including a joining condition in the *WHERE* clause of a SELECT statement.
True
A UNIQUE constraint is the same as a PRIMARY KEY constraint, except that it will accept NULL values.
True
A bridging table can be used to eliminate a many-to-many relationship in a relational database.
True
A clause is a section within a SQL statement that begins with a keyword.
True
A column represents a field in the physical database table.
True
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.
True
A sequence value may be set as a DEFAULT value for a column.
True
A table alias is assigned in the *FROM* clause.
True
A(n) index can be created based on more than one column.
True
A(n) sequence can be used to generate a series of numeric values.
True
AVG, COUNT, and STDDEV are all considered group functions.
True
An explicitly created index can be dropped with the DROP INDEX command.
True
Any type of constraint for a single column can be created at the *column* level.
True
Authentication is the process of ensuring that the individuals trying to access the system are who they claim to be.
True
Both the *table-level* and column-level approaches to creating a constraint can be included in the same command.
True
By default, the *JOIN* keyword creates an inner join.
True
Column qualifiers must be included in the WHERE clause if the columns used to join the tables have the same column names.
True
Constraints are used to ensure the accuracy and integrity of the data contained in the database.
True
If a data value violates a(n) *constraint*, the entire row is prevented from being added to the table.
True
If a subquery is nested in a HAVING clause, the subquery must be on the right side of the comparison operator.
True
If both nonaggregated and aggregated columns are used in the SELECT clause, the GROUP BY clause must contain the nonaggregated columns.
True
If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must be separated by a comma (,).
True
Including the keywords NULLS FIRST in the ORDER BY clause will result in NULL values appearing first in the results, regardless of the specified sort sequence.
True
More than one column can be changed at a time with the *ALTER TABLE...MODIFY* command.
True
Multiple-row subqueries are nested queries that can return more than one row of results to the parent query.
True
Object privileges allow users to perform DML operations on the data contained within database objects.
True
SELECT9 *is* a valid table name.
True
SUM, AVG, and COUNT are all considered *group* functions.
True
Sequence settings can be altered using the ALTER SEQUENCE command.
True
Set operators are used to combine the results of multiple queries.
True
Structured Query Language (SQL) is generally used to interact with a database.
True
The *=ANY* operator yields the same results as using the IN multiple-row operator.
True
The *AVG* function only includes non-NULL values in its calculations.
True
The *CONCAT* function can be used to concatenate the data contained in two columns.
True
The *DEFAULT ROLE* option of the ALTER USER command can be used to assign a default role to an existing user.
True
The *HAVING* clause specifies which groups will be displayed in the results, while the WHERE clause restricts the records that are retrieved from the table for processing.
True
The *MIN* function can be used with the DISTINCT or ALL keywords.
True
The IN logical operator is similar to using *OR*.
True
The INSERT, UPDATE, and DELETE object privileges can be applied to tables and views.
True
The LOWER function can be used to display upper-case characters in lower-case.
True
The LPAD or RPAD function can be used to add a character to extend the current contents of a column to a specified width.
True
The NVL function can be used to include records containing null values in calculations.
True
The PASSWORD EXPIRE option can be used to force a user to change his or her password at the time of the next login.
True
The REPLACE function is used to substitute one character string for another character string in a set of data.
True
The SET clause of the UPDATE command is used to identify the column(s) being updated.
True
The START WITH clause of a sequence cannot be reset with the ALTER SEQUENCE command.
True
When a subquery is used in the INSERT command, the subquery does not have to be enclosed in parentheses.
True
When a user asks the database a question, the user is issuing a query.
True
When the subquery is executed first and the value is passed back as input to the outer query, the subquery is known as an uncorrelated subquery.
True
When used with a multiple-row subquery, the IN operator indicates that the records processed by the outer query must match one of the values returned by the subquery.
True
With the exception of the NOT NULL constraint, constraints can be added to a table using the ADD clause of the ALTER TABLE command.
True
Which of the following serves the same basic purpose as an index in a book, by allowing users to quickly locate specific records?
index
Which of the following is a valid SQL statement when referencing a sequence?
none of the above
A complete query nested inside another query is called a(n) ____
subquery
Which of the following can be created so other users will not need to prefix a table owned by user Jeff with his schema name?
synonym
Which of the following symbols cannot be used in a table name?
%
Which of the following search patterns could be used to find the word HELLO in Oracle12c?
%H%
Group functions can be nested to a depth of ____.
2
If the DISTINCT keyword is not included in the STDDEV function, the ____ keyword will be assumed.
ALL
Which of the following commands can be used to make structural changes to an existing table?
ALTER TABLE
Which of the following commands will increase the size of the CITY column in the CUSTOMERS table from 12 to 20 and increase size of the LASTNAME column from 10 to 14?
ALTER TABLE customers MODIFY (city VARCHAR2(20), lastname VARCHAR2(14));
Based on the structure of the ORDERITEMS table, which of the following commands will make certain that the ISBN entered actually exists in the ISBN column of the BOOKS table?
ALTER TABLE orderitems ADD FOREIGN KEY (isbn) REFERENCES books(isbn);
If the MAXRETAIL column of the PROMOTION table has been set as unused, which of the following commands is valid?
ALTER TABLE promotion DROP UNUSED COLUMNS;
Which of the following keywords is used to mark a column for deletion at a later time?
ALTER TABLE...SET UNUSED
The ____ command will assign a default role to a user.
ALTER USER username DEFAULT ROLE rolename;
Which of the following committees are responsible for establishing SQL guidelines?
ANSI and ISO
To instruct Oracle12cto sort data in ascending order, enter ____ after the column name in the ORDER BY clause.
ASC
Which of the following datatypes refers to fixed-length character data, where n represents the maximum length of the column?
CHAR(n)
The ____ constraint requires that a specific condition be met before a record can be added to a table.
CHECK
Based on the structure of the ORDERITEMS table, which of the following commands was most likely used to create the table?
CREATE TABLE orderitems (order# NUMBER (4), item# NUMBER(2), isbn VARCHAR2(10), qty NUMBER(3), PRIMARY KEY(order#, item#));
Only one ____ constraint can exist for each table.
PRIMARY KEY
Which command is used to rename a table you own?
RENAME...TO
Based upon the contents of the BOOKS table in the accompanying figure, which of the following SQL statements will retrieve all books published by the publisher assigned Pubid 1?
SELECT * FROM books WHERE pubid = 1;
Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list all books stored in the BOOKS table with a retail price of more than $38 sorted by retail price?
SELECT * FROM books WHERE retail >38 ORDER BY retail;
Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?
SELECT * FROM orders WHERE shipdate IS NOT NULL ORDER BY customer#, order#;
Which SQL statement will return the same results as the following SQL statement? SELECT * FROM orders, customers;
SELECT * FROM orders CROSS JOIN customers;
Based upon the contents of the PUBLISHER table, which of the following is a valid SQL statement?
SELECT * FROM publisher;
Based upon the contents of the BOOKS tables, which of the following SQL statements will return the number of different publishers represented in the table?
SELECT COUNT(DISTINCT pubid) FROM books;
Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders shipped between April 4, 2003 and April 5, 2003?
both b and c
In Oracle12c, tables can be linked through which clause(s)?
both b and c
Which of the following terms is considered the basic unit of data in a database?
character
A field in the logical design of a database is represented by what in the physical database?
column
A ____ is a group of interrelated files.
database
Which of the following commands can be used to modify an index?
none of the above
Which of the following commands will change the name of the LAST NAME column to LAST_NAME in the CUSTOMERS table?
none of the above
The STDDEV function can be used with ____ columns.
numeric
The SUM function can only be used with ____ data.
numeric
The VARIANCE function can be used with ____ columns.
numeric
When sorting the results in descending order, which of the following values will be presented last in the output?
numeric
When functions are nested, the ____ function is solved last.
outer
An outer query is also referred to as a(n) ____ query.
parent query
A(n) ____ synonym is used by an individual to reference objects owned by that person.
private
The partial listing of privileges shown above displays what type of privileges?
system
Data in second normal form (2NF) may contain which of the following?
transitive dependencies
Which of the following symbols can be used to combine data from different columns into one column of output?
||
A *Datatype* is a rule used to ensure the accuracy of data stored in a database.
False
A FOREIGN KEY constraint will not allow a row containing a NULL value in the foreign key column to be added to the table.
False
A NOT NULL constraint can only be added to an existing table by using the *ADD* clause with the ALTER TABLE command.
False
A NOT NULL constraint is a special FOREIGN KEY constraint.
False
A collection of fields is a file.
False
A column has low cardinality if it contains many distinct values.
False
A column heading that is longer than the width of a column will not be truncated for a column that is defined to store *character* data.
False
A constraint can be renamed using the ALTER TABLE command.
False
A constraint can only be created as part of the CREATE TABLE command.
False
A constraint name can consist of up to 10 characters.
False
A cross join between two tables, containing four rows each, will display *eight* rows in its output.
False
A database is a physical storage device for data.
False
A group function cannot be included in the SELECT clause of a single-row subquery.
False
A large table containing a particular column that is frequently referenced by a WHERE clause would probably benefit from a(n) sequence .
False
A multiple-column subquery cannot be nested in a WHERE clause.
False
A one-to-many relationship cannot be included in a relational database.
False
A role can be removed from the database with the *DELETE ROLE* command.
False
A role can only be granted to other roles.
False
A sequence serves as a nickname for a database object.
False
A string literal must be enclosed in *double* quotation marks.
False
A subquery can only be nested in the WHERE or HAVING clause of the outer query.
False
A subquery is required when the condition for the *inner* query is based upon an unknown.
False
A table alias is assigned to a table in the WHERE clause.
False
A table name can consist of numbers, letters, and blank spaces.
False
A table name must begin with a(n) *number*.
False
A user can be granted both system and object privileges in the same GRANT command.
False
A(n) *clause* identifies what must exist or a requirement that must be met for a record to be included in the results of a query.
False
A(n) *group* is a collection of privileges that can be granted to users.
False
A(n) *index* can be used to generate a series of unique numbers.
False
A(n) *non-equality* join is also known as an equijoin, inner join, or simple join.
False
A(n) *non-equality* join is when a table is joined to itself.
False
All synonyms are PUBLIC.
False
An automatic column will generate a value at runtime and may reference values from other columns.
False
An index is implicitly created when a NOT NULL constraint is added to a table.
False
An index is implicitly created whenever a(n) *CHECK* constraint is created for a table column.
False
An inequality join refers to a join that is used to link a table to a copy of itself.
False
An outer join only lists rows that contain a match in both tables.
False
An outer join operator can be included in a FROM clause to list all rows from one table that do not have a corresponding row in the other table.
False
By default, the COUNT function uses the *DISTINCT* keyword when counting the values contained in a column.
False
Case conversion functions can only be used in the SELECT clause of a SELECT statement.
False
Choosing specific columns to be displayed by a SELECT statement is known as selection.
False
Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.
False
Data stored in multiple tables can be combined through the use of an ORDER BY clause.
False
Each column can only be included in one constraint.
False
Each section of a SQL command that begins with a keyword is known as a statement.
False
If you assign a column alias to a column, it must be enclosed in double quotation marks (" ").
False
In a WHERE clause, logical operators are evaluated before comparison operators.
False
In the USER_CONSTRAINTS view, the constraint type for a NOT NULL constraint will be listed as *N*.
False
Insignificant zeros *are* displayed for numeric columns by default to show two decimal places.
False
NOT, ALL, and OR are all considered logical operators.
False
NOT, AND, and OR are *comparison* operators.
False
Once a privilege has been granted to a role, it cannot be revoked without re-creating the role.
False
Only a DATE function can be nested inside another DATE function.
False
Only one type of relationship can be represented in an Entity-Relationship Model.
False
Results returned from a SELECT statement that include a GROUP BY clause will present the results in *descending* order of the column(s) listed in the GROUP BY clause.
False
Single-row functions cannot be included in the UPDATE command.
False
Single-row functions return one row of results for each group or category of rows processed.
False
Single-row operators can be used with multiple-row subqueries that return only one column of results.
False
The *<* symbol is used to search for records containing a value that is less than or equal to the stated search condition.
False
The *COUNT* function is used to total the values stored in numeric columns.
False
The *DROP* command can be used to remove rows from an existing table.
False
The *GENERATE ROLE* command is used to add a new role to the database.
False
The *GENERATE* option can be used to have a sequence pre-generate a set of numbers before they are requested by a user.
False
The *SUBSTR* function is used to substitute one character string for another in a set of data.
False
The *WITH ADMIN OPTION* is required to enable the user to grant the specified object privileges to other users.
False
The *YR* element can be included in a format argument of the TO_CHAR function to spell out the year of the specified date.
False
The ALPHANUMERIC datatype can be used to store characters and numbers to a maximum width of 2000.
False
The ALTER TABLE command with the *MODIFY* clause can be used to disable a constraint.
False
The ALTER USER command can be used to change the name assigned to a user account.
False
The COUNT function can only be used for numeric columns.
False
The DISTINCT keyword cannot be used with the MAX function.
False
The GRANT clause of the GRANT command identifies the user who is granting a specific privilege.
False
The GROUP BY clause can only be used when a SELECT statement includes a group function.
False
The INSTR function is used to return a portion of a character string.
False
The JOIN keyword must be used in the *WHERE* clause of a SELECT statement.
False
The LENGTH function is used to determine the number of rows in a table.
False
The MAX function can only be used with numeric or date columns.
False
The MAX functions returns the *smallest* value stored in the specified column.
False
The MODIFY clause is used with the ALTER TABLE command to add a PRIMARY KEY constraint to an existing table.
False
The NATURAL JOIN keywords can be used to create non-equality joins.
False
The NEXTVALUE pseudocolumn is used to actually generate the next value in a sequence.
False
The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.
False
The SORT BY clause is used to present query results in a specific order.
False
The SYSDATE can be used as a condition in a CHECK constraint.
False
The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.
False
The UNION set operator will not suppress rows that are returned by both queries.
False
The UPDATE ANY TABLE privilege is a system privilege.
False
The USER_ALL data dictionary view displays information about all the relevant objects owned by the user.
False
The USER_SEQ data dictionary view can be used to verify sequence settings.
False
The password for a user can be set with the PASSWORD clause of the CREATE USER command.
False
The percent sign (%) is used in a search pattern to indicate "exactly one character in this position".
False
The structure of a table can be viewed by issuing the STRUCTURE command.
False
The table called DUMMY consists of a blank holding area that can be referenced by a user.
False
The table level approach can be used to create any constraint, except a CHECK constraint.
False
To retain the structure of a table, while deleting all its data and releasing their storage space, execute the TRUNC command.
False
Transitive dependency can only exist if the data is uniquely identified by a composite primary key.
False
When the column names are listed in the INSERT INTO clause of the INSERT command, the order of the names must exactly match the order of the data values in the *UPDATE* clause.
False
A constraint is always enforced at the table level.
True
A correlated subquery is a subquery that is executed once for each row in the outer query.
True
A correlated subquery references one or more columns in the outer query, and the EXISTS operator is used to test whether the relationship or link is present.
True
A function-based index can be used for queries that include searches based upon arithmetic expressions or functions.
True
A group function can be used in a(n) *inline view*.
True
A grouping sets expression can perform multiple Group BY clauses in a single query .
True
A many-to-many relationship cannot exist in a relational database.
True
A multiple-row subquery can be nested in a HAVING clause.
True
A single-row function can be used with the DUAL table.
True
A subquery is required when the condition for the outer query is based upon an unknown.
True
A subquery nested in a SELECT clause cannot contain an ORDER BY clause.
True
A user can check all his or her currently enabled privileges by examining the SESSION_PRIVS view.
True
A(n) *Cartesian Join* replicates each row from the first table with every row from the second table.
True
A(n) *NOT NULL* constraint is a special CHECK constraint with the condition of IS NOT NULL.
True
A(n) *correlated* subquery references one or more columns from the outer query.
True
A(n) *index* can be used to quickly determine whether a value already exists in a specific column.
True
A(n) *inner join* will only include rows that have matching rows in the other table.
True
A(n) *non-equality* join is used when there are no equivalent rows of data in the tables that are being joined.
True
A(n) *outer* query is also referred to as a parent query.
True
A(n) *percent* sign is used in a search pattern to indicate zero, one, or more characters in a position.
True
Equality, non-equality, and self-joins are all categorized as inner joins.
True
Every table name within a specific schema must be unique.
True
Group functions are also known as aggregate functions.
True
Group functions return one result per group of rows processed.
True
If the minimum value for a sequence is not specified, then NOMINVALUE will be assumed as the default.
True
If you are joining four tables in a SELECT statement, *three* joining conditions will be required.
True
In Oracle12c, a MERGE statement compares data between two tables and can perform a series of DML actions to assist in synchronizing the data of the two tables.
True
Include *DAY* in a format argument of the TO_CHAR function to spell out the day of the week in the specified date.
True
Oracle12c *is case sensitive* when comparing data to a search condition.
True
The *NVL2* function allows different options to be selected, based upon whether a NULL value exists.
True
The *REVOKE* command can be used to revoke a role from a user or another role.
True
The *REVOKE* command can be used to revoke system and object privileges, but not both in the same command.
True
The *RTRIM* function can be used to remove a specific set of characters from the right side of a set of data values.
True
The *TO CHAR* function can be used to display insignificant zeros.
True
The *syntax* for a SQL statement gives the basic structure required to execute the statement. _________________________
True
The <>, !=, or ^= operators can be used to search for values that are *not equivalent* to the specified search condition.
True
The <ALL operator indicates that for a value to be included in the results, it must be less than the lowest value returned by the subquery.
True
The ALTER TABLE command can be used to *delete* an existing constraint.
True
The ALTER TABLE command can be used to disable a constraint.
True
The CONSTRAINT keyword is required if the user is going to assign a name to a constraint.
True
The COUNT function can be used to count NULL, as well as, non-NULL values.
True
The DECODE function allows the user to specify different actions to be taken, depending on the value being used for the comparison.
True
The GROUP BY clause is used to group data.
True
The HAVING clause is used to restrict the groups returned by a query.
True
The MAX function can be used with character data.
True
The MIN function is used to determine the smallest value in a specified column.
True
The NATURAL JOIN keywords can be used to link two tables that have a commonly named and defined column.
True
The NEXTVAL pseudocolumn can be referenced in an INSERT command to add the value to a database table.
True
The SUM function is used to calculate the total amount stored in a numeric field for a group of records.
True
The TO_CHAR function can be used to add a dollar sign ($) to a numeric value.
True
The USER_INDEXES data dictionary view can be used to verify existing indexes.
True
The VARIANCE function is used to determine the variance in a group of numeric data.
True
The WHERE clause filters the data before grouping, while the HAVING clause filters the groups *after* grouping is performed.
True
The default beginning value for a sequence is *one*.
True
The default format of a DATE column in Oracle 12c is DD-MON-YY.
True
The default name for a constraint is *SYS C*n** where n consists of a number that will make the name unique within the database.
True
The equal sign, =, is a valid single-row operator.
True
The first column listed in an ORDER BY clause is considered the primary sort.
True
The highest possible value for a descending sequence is -1.
True
The lowest possible value for an increasing sequence is 1 .
True
The most common type of join is an equijoin, which joins two or more tables together based upon the tables having equivalent data values in a common column.
True
The number of joining conditions required to join tables is always one less than the number of tables being joined.
True
To change the starting value for a sequence, the sequence must be dropped and then re-created.
True
To indicate that data should be sorted in descending order, use the *DESC* keyword.
True
When a column is deleted, the deletion is permanent.
True
When a positive value is assigned to the INCREMENT BY clause of the CREATE SEQUENCE command, numeric values are generated in ascending order.
True
When a self-join is created, each copy of the table must be assigned a table alias.
True
You must include the MI element in the format argument of a TO_CHAR function to include the minutes when displaying time.
True
If a new table is being created based upon a subquery, the subquery must be enclosed in which of the following symbols?
( )
To display the name of each customer and the ISBN of each book purchased by the customers would require how many joins in the FROM clause of the SQL statement?
2
To display the name of each customer and the title of each book purchased by the customers would require how many join conditions?
3
In a Cartesian join, linking a table that contains 10 rows to a table that contains 9 rows will result in ____ rows being displayed in the output.
90
Which operator will instruct Oracle12c to list all records with a value that is more than the highest value returned by the subquery?
>ALL
Which of the following is not a valid statement concerning identity columns.
A DEFAULT clause may be assigned
Which of the following is a correct statement?
A PUBLIC synonym can be referenced by any user.
When modifying data in existing columns, which of the following is correct?
A column must be as wide as the data it already contains.
Which of the following functions can be used to determine the date one month after a specified date?
ADD_MONTHS
If the DISTINCT keyword is not included in the SUM function, the ____ keyword will be assumed.
ALL
If the DISTINCT keyword is not included in the VARIANCE function, the ____ keyword will be assumed.
ALL
Which command will modify a sequence?
ALTER SEQUENCE sequencename
The ____ function calculates the average of the numeric values in a specified column.
AVG
Which of the following cannot be used with date columns?
AVG
Which of the following is a correct statement?
An asterisk can be used as the argument for the COUNT function to include NULL values in the results.
What will happen if you try to use the INSERT command to insert a NULL value into a column that has been assigned a PRIMARY KEY constraint?
An error message is returned and the row is not added to the table.
In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a CHECK constraint.
C
Which option is used to have Oracle12c pre-generate a set of values and store those values in the server's memory?
CACHE
Which of the following functions is similar to using the (| |) symbol to combine the contents of two character strings?
CONCAT
If the ____ keyword is included when a constraint is created, a constraint name must be provided by the user.
CONSTRAINT
Which command will create an index?
CREATE INDEX indexname ON tablename (columnname)
Which of the following SQL statements will create a new role named PRCLERK?
CREATE ROLE prclerk;
Which of the following commands can be used to create a sequence for the CUSTOMERS table?
CREATE SEQUENCE customers_customer#;
Which command will create a sequence named NEWSEQUENCE to generate a series of integers?
CREATE SEQUENCE newsequence;
Which of the following privileges is necessary to perform the connection procedure shown above?
CREATE SESSION
Which command will create a synonym for a table?
CREATE SYNONYM synonymname FOR tablename;
Which command instructs Oracle 12c to create a new table?
CREATE TABLE
Which of the following keywords is used to create a Cartesian join?
CROSS JOIN
Which of the following types of joins refers to results consisting of each row from the first table being replicated from every row in the second table?
Cartesian join
Which of the following search conditions can be used to identify records that have data stored in a column named ColB?
ColB IS NOT NULL
Which of the following is a valid statement?
Column aliases cannot be used in a GROUP BY clause.
Which of the following format elements will display the value of Friday in a specified date as a 6?
D
In which format does Oracle 12c display a date value?
DD-MON-YY
Which of the following functions can be used to specify a list of alternative actions that should be taken depending upon a stated value?
DECODE
Which clause will allow you to delete a constraint?
DROP
Which command will remove an existing role from a database?
DROP ROLE rolename;
Which of the following commands can be used to remove a sequence from a database?
DROP SEQUENCE
Which keywords are used to complete the deletion of a column previously marked with SET UNUSED?
DROP UNUSED COLUMNS
Which of the following is a table provided in Oracle which can be helpful for testing functions?
DUAL
Which of the following types of constraints is used to enforce referential integrity?
FOREIGN KEY
The JOIN keyword is included in which of the following clauses?
FROM
Which of the following is a mandatory clause in a SELECT statement?
FROM
Which of the following is an example of assigning "o" as a table alias for the ORDERS table in the FROM clause?
FROM orders o, customers c
If a SELECT statement contains HAVING, GROUP BY, and WHERE clauses, the ____ clause will be processed last.
HAVING
If the output is to be restricted based upon a group function, a(n) ____ clause must be included in the SQL statement.
HAVING
The ____ clause is used to restrict the groups returned by a query.
HAVING
Which clause is used when the group results of a subquery need to be restricted, based on some condition?
HAVING
Which of the following set operators can be used to make certain that only the rows returned by both queries are displayed in the results?
INTERSECT
Which of the following statements about creating constraints is incorrect?
If you do not provide a name for a constraint, the Oracle 12c server will issue an error message.
Which of the following statements about a PRIMARY KEY is incorrect?
It can be NULL, as long as the FOREIGN KEY contains a value.
Which of the following keywords can be used to join two tables that do not contain a commonly named and defined column?
JOIN...ON
Which of the following represents the number of days that have passed since January 1, 4712 B.C.?
Julian date
Which of the following functions determines the number of characters in a character string?
LENGTH
Which of the following functions can be used to convert a character string to lower-case letters?
LOWER
Which of the following lines of the SQL statement contains an error? 1 SELECT title, MAX(retail) 2 FROM books 3 WHERE retail > 30 4 AND pubid = 1 5 GROUP BY retail
Line 5
Which of the following lines of the SQL statement contains an error? 1SELECT title, MAX(retail) 2FROM books 3WHERE retail > 30 4AND pubid = 1 5GROUP BY retail
Line 5
What clause offers many options to identify measures and patterns to analyze in a query?
MATCH_RECOGNIZE
The ____ function can be used to determine the largest value stored in a specified column.
MAX
The ____ function returns the smallest value in a specified column.
MIN
Which of the following is used to establish a minimum or maximum value, respectively, for a sequence?
MINVALUE | MAXVALUE
A table alias cannot be assigned in the FROM clause if which of the following keywords is used to join tables?
NATURAL JOIN
Which of the following can only be used to link tables that have a common column?
NATURAL JOIN
Which of the following is a valid column name?
NEW_COLUMN
Which of the following statements about NEXTVAL and CURRVAL is incorrect?
NEXTVAL and CURRVAL are pseudocolumns that store unique names for database objects.
Which of the following functions can be used to determine the next occurrence of a specific day of the week after a given date?
NEXT_DAY
Which of the following keywords must have been included during the creation of a FOREIGN KEY constraint to allow a row from the parent table to be deleted, even if it is referenced by a row in the child table?
ON DELETE CASCADE
To remove a PUBLIC synonym, you must include the ____ keyword in the DROP command.
PUBLIC
In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.
R
Which of the following is not a constraint type in Oracle 12c?
REFERENCE
Which of the following privileges will allow a user to reference a table when creating a FOREIGN KEY constraint?
REFERENCES
Which of the following commands will change the name of the PROMOTION table to GIFT?
RENAME promotion TO gift;
Which of the following can be used to replace a specific set of characters with another set of characters?
REPLACE
Which of the following will revoke a user's object privileges?
REVOKE objectprivilege ON objectname FROM username;
Which of the following commands allows a user to "undo" uncommitted changes to data?
ROLLBACK
Which of the following functions will round the numeric data to no decimal places?
ROUND(34.21, 0)
Which of the following commands is used to issue a query?
SELECT
Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will display all books stored in the BOOKS table that generate more than 60 percent profit?
SELECT * FROM books WHERE (retail-cost)/cost > .60;
Based upon the contents of the ORDERS table in the accompanying figure, which of the following queries will display all orders that were not shipped for at least three days after the order was received?
SELECT * FROM orders WHERE shipdate-orderdate >= 3;
Which of the following will display the name of each customer in lower-case characters based upon the contents of the CUSTOMERS table? Note: The ST column name is truncated, this represents the STATE column.
SELECT LOWER(firstname) || ' ' || LOWER(lastname) FROM customers;
Which of the following is a valid SQL statement based upon the contents of the CUSTOMERS table? Note: The ST column name is truncated, this represents the STATE column.
SELECT customer#, NVL2(referred, 'Referred', 'Not Referred') FROM customers;
Which of the following SQL statements would most likely be used to generate the partial output shown above?
SELECT name FROM SYSTEM_PRIVILEGE_MAP;
Based upon the contents of the PUBLISHER table, which of the following is not a valid SQL statement?
SELECT name, contact FROM publisher/
Based upon the contents of the ORDERS table, which of the following SQL statements will display the ship date for order 1006 as April 2, 2002? Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
SELECT order#, TO_CHAR(shipdate, 'Month DD, YYYY') FROM orders;
Which of the following is a valid SQL statement to retrieve data from the ORDERS table?
SELECT order#, orderdate, shipdate FROM orders;
Based upon the contents of the ORDERS table in the accompanying figure, which of the following SQL statements will display how long it took to ship order # 1007 (based upon when the order was originally placed)?
SELECT order#, shipdate-orderdate FROM orders WHERE order# = 1007;
Based upon the contents of the PUBLISHER table, which of the following SQL statements will execute without returning an error message?
SELECT pubid name FROM publisher;
Based on the contents of the BOOKS table, which of the following is a valid SQL statement?
SELECT pubid, AVG(retail-cost) "Average Profit" FROM books GROUP BY pubid;
Which of the following SQL statements will display the title of all books that have had multiple copies requested in a single order?
SELECT title FROM books NATURAL JOIN orderitems WHERE qty > 1;
Which of the following will display all books that were published at least three years before they were ordered?
SELECT title FROM orders o, orderitems oi, books b WHERE b.isbn = oi.isbn AND oi.order# = o.order# AND (orderdate-pubdate)/365 >= 3;
Which of the following SQL statements will display books that have not been ordered recently?
SELECT title FROM books MINUS SELECT title FROM books NATURAL JOIN orderitems;
Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will retrieve all book titles that are in the Business or Computer category and have a retail price of more than $35.00?
SELECT title FROM books WHERE (category = 'BUSINESS' OR category ='COMPUTER' ) AND retail >35;
Based upon the contents of the BOOKS table in the accompanying figure, which of the following queries will list the title and retail price of each book stored in the BOOKS table, sorted in order of the book titles?
SELECT title, retail FROM books ORDER BY title;
Based upon the contents of the BOOKS table, which of the following SQL statements will display the retail price for two copies of each book currently in inventory?
SELECT title, retail+retail FROM books;
Based upon the contents of the BOOKS table, which of the following SQL statements will display two columns in its output?
SELECT title, retail-cost "Profit" FROM books;
Which of the following views will display the privileges currently enabled for a user?
SESSION_PRIVS
The phonetic representation of a character string can be determined using the ____ function.
SOUNDEX
Which of the following format model elements can be used to spell out a number?
SP
Which of the following format argument elements will display the number of seconds past midnight?
SSSS
Which of the following sequence settings cannot be changed with the ALTER SEQUENCE command?
START WITH
Which of the following is used to return a portion of a character string?
SUBSTR
The UNIQUE constraint differs from the PRIMARY KEY constraint in what way?
The UNIQUE constraint allows NULL values.
When creating a table, which of the following statements is correct?
The column list must be enclosed in parentheses ( ).
Which of the following statements is correct?
The columns will be listed in the results in the same order they are listed in the SELECT clause of the SELECT statement.
When using the ALTER TABLE...DROP COLUMN command, which of the following is not correct?
The command can be used to delete multiple columns from a table.
Which of the following statements about privileges is incorrect?
There are five types of privileges, including DATATYPE, ROLETYPE, and USERNAME privileges.
Which of the following set operators will display only the unique results of the combined SQL statements?
UNION
Which of the following commands is used to modify existing data in a table?
UPDATE
Which of the following is not a valid SQL command?
UPDATE acctmanager WHERE amid = 'J500';
A _______ column generates values automatically at runtime and may reference values from other columns.
Virtual
If the ____ clause of the UPDATE command is omitted, then all the rows in the specified table will be changed.
WHERE
Which of the following clauses is used to restrict the rows returned by a query?
WHERE
When working with cached sequence values, which of the following is correct?
When a value has been generated and cached, that value has been assigned and cannot be regenerated until the sequence begins a new cycle.
Based upon the contents of the CUSTOMERS table, which of the following would be the most appropriate use of a subquery?
When searching for all customers who live in the same state as customer# 1007. >
Which of the following is an accurate statement?
When the LOWER function is used in a SELECT clause, the function only stays in effect for the duration of that SQL statement.
A lock arising from a SELECT...FOR UPDATE command will be released when ____.
a COMMIT command is executed
Partial dependency exists if what conditions exist?
a column is dependent only on a portion of a composite primary key
When a constraint is created at the table level, the constraint definition is provided ____ the column definition list.
after
If a new column is added to the PROMOTION table, where will the new column be listed?
after the MAXRETAIL column
A column alias must be contained within double quotation marks (" ") if it contains which of the following?
all of the above
Any type of subquery can be used in the ____ clause of a SELECT statement.
all of the above
The MAX function can be used with which type of columns?
all of the above
Which of the following can be used in a WHERE clause?
all of the above
Which of the following can be used with date columns?
all of the above
Which of the following is a valid comparison operator?
all of the above
Which of the following is a valid logical operator?
all of the above
Which of the following is a valid statement?
all of the above
When the WHERE clause contains multiple types of operators, which of the following is resolved first?
arithmetic operations
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?
authentication
Which of the following is not a method used by the Oracle 12c database to prevent illegal access into the software?
automatic encryption of all user input
A group function can be nested inside a(n)____.
both a and b
A subquery must include a(n) ____ clause.
both a and b
An index can be created ____.
both a and b
How can constraints be added to a table?
both a and b
Which of the following functions can be used to fill a character string to a specific width?
both a and b
Which of the following queries will display the first and last name of the individual who referred another customer, along with the customer# of the referred customer?
both a and b
Which of the following commands will set the MINRETAIL column of the PROMOTION table as unused?
both a and c
The NOT NULL constraint can only be created at the ____ level.
column
Which of the following terms refers to a column with equivalent data that exists in two or more tables?
common column
Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?
correlated subquery
Analyzing historical sales data stored in a database is commonly referred to as ____.
data mining
If uncontrolled, what can lead to data anomalies?
data redundancy
A ____ is a storage structure designed to hold a collection of data.
database
A(n) ____ simply identifies the type of data that Oracle 12c will be expected to store in a column.
datatype
Which of the following types of joins is created by matching equivalent values in each table?
equality join
Which of the following terms best describes where a group of characters that represents a customer's address would be stored in the logical design?
field
Which of the following does not contain repeating groups, but has a primary key and possibly partial dependencies?
first normal form (1NF)
Where does the Oracle 12c server store information about objects in the database, including information about constraints?
in the data dictionary
Which of the following contains the ROWID of referenced rows?
index
A temporary table that is created when a multiple-column subquery is used in the FROM clause of an outer query is called a(n) ____.
inline view
When functions are nested, the ____ function is solved first.
inner
Which of the following types of relationships cannot exist in a relational database?
many-to-many
(SELECT category, AVG(retail) cataverage FROM books GROUP BY category);
multiple-column
A(n) ____ subquery is one that can return several rows of results.
multiple-row
The following SQL statement contains which type of subquery? SELECT title, retail, category FROM books WHERE retail IN (SELECT MAX(retail) FROM books GROUP BY category);
multiple-row
Based on the contents of the BOOKS table, which line of the following SQL statement contains an error?
none of the above
Based on the contents of the BOOKS table, which of the following SQL statements will display the title of all books published by the publisher of SHORTEST POEMS?
none of the above
Based upon the contents of the ORDERS table in the accompanying figure, which of the following SELECT statements will retrieve all orders contained in the ORDERS table that have not yet been shipped to the customer?
none of the above
Based upon the contents of the PUBLISHER table, which of the following SELECT statements will display the publisher's name first in the results?
none of the above
Data in third normal form (3NF) contains which of the following?
none of the above
Which of the following SQL statements will display the gift that should be sent to any customer who orders the book titled THE WOK WAY TO COOK?
none of the above
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?
none of the above
Which of the following SQL statements will return an error message, based upon the contents of the CUSTOMERS table? Note: The ST column name is truncated, this represents the STATE column.
none of the above
Which of the following are case sensitive in Oracle 12c?
none of the above
Which of the following operators can be used to retrieve rows containing NULL values in a specific column?
none of the above
The AVG function can be used with ____ values.
numeric
Which of the following types of columns will automatically right-align the data when it is displayed?
numeric
The TO_CHAR function can be used to format what types of data?
numeric and date
Which of the following is defined in Oracle12 as simply anything that has a name and a defined structure?
object
Suppose that a patient in a hospital can only be assigned to one room. However, the room may be assigned to more than one patient at a time. This is an example of what type of relationship?
one-to-many
The results of a subquery are passed back as input to the ____ query.
outer
Which of the following symbols is a wildcard character that can represent any number of characters in a WHERE clause?
percent sign (%)
Which of the following is used to uniquely identify each record?
primary key
If the PUBLIC keyword is not included when a synonym is created, the command will create a(n) ____ synonym, by default.
private
Based upon the contents of the BOOKS table, which of the following columns will be displayed with a right-aligned column heading?
pubid
Which of the following terms represents a collection of fields?
record
When used with a FOREIGN KEY, the keyword REFERENCES refers to what?
referential integrity
Which of the following terms refers to a collection of privileges?
role
A record in the logical design of a database corresponds to a ____ in the physical database.
row
If there is an exact match between the data used for a primary sort, a(n) ____ can be used to determine the sequence used to display the data.
secondary sort
The process of retrieving only certain rows based upon a specified condition is known as ____.
selection
Which of the following types of joins refers to joining a table to itself?
self-join
A(n) ____ is used to combine the results of two queries.
set operator
The <> operator is referred to as a(n) ____ operator.
single-row
The = operator is referred to as a(n) ____ operator.
single-row
The > operator is referred to as a(n) ____ operator.
single-row
The following SQL statement contains what type of subqueries? SELECT isbn, title FROM books WHERE pubid = (SELECT pubid FROM books WHERE title = 'SHORTEST POEMS') AND retail-cost > (SELECT AVG(retail-cost) FROM books);
single-row
The following SQL statement contains which type of subquery? SELECT title, retail, (SELECT AVG(retail) FROM books) FROM books;
single-row
Which of the following returns one row of results for each record processed?
single-row function
The multi-step process used when creating a new system is referred to as ____.
the Systems Development Life Cycle
If the data has no partial dependencies, repeating groups, or transitive dependencies, and has a composite primary key, the data is in which form?
third normal
If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint, and the actual constraint name is not known, which of the following commands can be used to delete the constraint?
ALTER TABLE orderitems DROP PRIMARY KEY;
Based on the structure of the BOOKS table, which of the following is a valid SQL statement?
CREATE INDEX books_title_idx ON books (INITCAP(title));
Which of the following commands is used to create a function-based index?
CREATE INDEX...ON
The ____ function is based upon the concept of a normal distribution.
STDDEV
The ____ function is used to calculate the total amount stored in a numeric field.
SUM
All the Oracle12c system privileges can be viewed through the data dictionary view ____.
SYSTEM_PRIVILEGE_MAP
What is the syntax for the default constraint name provided by the Oracle 12c server?
SYS_Cn
If a SELECT statement includes SUBSTR(TO_CHAR(SYSDATE, 'fmMONTH DD, YYYY'), -4, 4) in the SELECT clause, which of these functions will be executed first?
TO_CHAR
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?
TO_DATE
Which of the following SQL statements will assign the DBA role as the default role for user RTHOMAS?
ALTER USER rthomas DEFAULT ROLE dba;
Which of the following SQL commands will require the user RTHOMAS to change the account password the next time the database is accessed?
ALTER USER rthomas PASSWORD EXPIRE ;
The last value generated by a sequence is stored in the ____ pseudocolumn.
CURRVAL
Which of the following is a valid SQL statement?
SELECT c.customer#, order#, orderdate, shipdate FROM customers c, orders c WHERE c.customer# = o.customer#;
Which of the following statements will display the value of FL assigned to the state column as FLORIDA? Note: The ST column name is truncated, this represents the STATE column.
SELECT customer#, city, REPLACE(state, 'FL', 'FLORIDA') FROM customers WHERE state = 'FL';
Which of the following SQL statements will return the names of all customers who placed an order on April 12, 2003?
SELECT lastname, firstname FROM customers NATURAL JOIN orders WHERE orderdate = '12-APR-03';
Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table, and, if the customer has placed an order that is contained in the ORDERS table, the order# of any order each customer has placed?
SELECT lastname, firstname, order# FROM customers, orders WHERE orders.customer# (+) = customers.customer#;
Which of the following SQL statements will display the publisher name, book title, and retail price of all books that cost more than $35.95?
SELECT name, title, retail FROM books NATURAL JOIN publisher WHERE cost > 35.95;
Based upon the contents of the ORDERS table, which of the following SQL statements will display only those orders shipped to the zip code zone that begins with 323? Note: Column names are truncated as follows: SH = SHIPSTATE and SHIPZ = SHIPZIP.
SELECT order# FROM orders WHERE SUBSTR(shipzip, 1, 3) = 323;
Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table, as well as the name of the contact person and the phone number to call to reorder the book?
SELECT title, cost, contact, phone FROM publisher JOIN books USING (pubid);
If it is possible for a subquery to return a NULL value to the outer query for comparison, the ____ function should be used to substitute an actual value for the NULL.
NVL
The ____ function can be used to include NULL values in a calculation.
NVL
Which of the following is not a GROUP BY extension?
OLAP
Which of the following commands will delete only publisher 4 from the PUBLISHER table?
DELETE FROM publisher WHERE pubid = 4;
To instruct Oracle12c to sort data in descending order, enter ____ after the column name in the WHERE clause.
DESC
Which command can be used to determine whether or not a column is allowed to contain a NULL value?
DESCRIBE
Which clause will allow you to disable a constraint?
DISABLE
Based on the contents of the CUSTOMERS table, which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?
SELECT customer# FROM customers WHERE NVL(referred, 0) = (SELECT NVL(referred,0) FROM customers WHERE customer# = 1003);
Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?
SELECT customer# FROM customers WHERE state = (SELECT state FROM customers WHERE customer#=1013);
Based on the contents of the ORDERS table, which of the following SELECT statements will determine the number of orders placed by each customer?
SELECT customer#, COUNT(customer#) FROM orders GROUP BY customer#;
Which view will display the names of all the constraints that you own?
USER_CONSTRAINTS
Which data dictionary object contains a column named HIDDEN_COLUMN?
USER_TAB_COLS.
Which of the following methods is not used in an INSERT statement to enable the use of a DEFAULT sequence value defined for a column?
Use NEXTVAL to call the value
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?
VALUES
Which of the following datatypes refers to variable-length character data, where n represents the maximum length of the column?
VARCHAR2(n)
The ____ function is used to determine how widely data are spread out within a group.
VARIANCE
A database must be shut down before the ALTER TABLE command can be executed.
False
A field in the logical design of a database corresponds to a row in the physical table of a relational database.
False
A field is a basic unit of data also referred to as a record.
False
A one-to-many relationship means that an occurrence of a specific entity can only exist once in each table.
False
By default, a column alias is displayed in lower case characters in the results.
False
Data is in second normal form (2NF) if it contains no repeating groups and has a primary key to uniquely identify each record.
False
Each clause of a SELECT statement *must* be entered on a new line in SQL*Plus.
False
If a primary key has been identified for the data, then the data is considered to be in first normal form (1NF).
False
Only one column can be added to an existing table at one time.
False
Tables can be linked or joined together through their primary keys.
False
The *SELECT* command can be used to display the structure of a database table.
False
The *scale* of a NUMBER column indicates the total number of digits that can be stored in the column.
False
The CREATE TABLE cannot contain a subquery.
False
The DELETE TABLE command can be used to delete all the data stored in a table and release the storage space, yet retain the structure of the table.
False
The DELETE TABLE command can be used to remove a table from a database.
False
A record in the logical design of a database corresponds to a row in the physical table of a relational database.
True
A user can indicate that all columns of a table should be displayed in the results of a SELECT statement by including an asterisk (*) in the SELECT clause.
True
Once a column as been set as *UNUSED*, it cannot be recovered.
True
The *MODIFY* clause can be included in the ALTER TABLE command to add a default value to an existing column.
True
The INTERVAL datatype can be used to identify a specific interval, or amount, of time.
True
The following types of relationships can be included in an Entity-Relationship Model: one-to-one, one-to-many, many-to-many.
True
The occurrence of data anomalies would indicate an unnormalized database design.
True
The syntax of the *CREATE TABLE* command requires that the column list be enclosed in parentheses.
True
Two tables can be linked or joined together through a common field.
True
You cannot delete the last column in a table.
True
If the results of a SELECT statement include more than one column of data, the column names must be separated in the SELECT clause by which of the following symbols?
,
The maximum width of the NUMBER datatype is ____ digits.
38
Which of the following commands will add a new column named FIRST ORDER DATE to the CUSTOMERS table to store the date that the customer first placed an order with the company?
ALTER TABLE customers ADD (firstorderdate DATE);
Which command instructs Oracle 12c to create a new table from existing data?
CREATE TABLE...AS
Which of the following keywords uses a subquery to create a new table using existing database tables?
CREATE TABLE...AS
Which of the following commands can be used to view the structure of a table?
DESCRIBE
Based upon the contents of the PUBLISHER table, which of the following SQL statements will display only two columns in the results?
SELECT contact person, name FROM publisher;
Which of the following is a valid SQL statement?
SELECT title, retail-cost FROM books;
Which of the following queries will allow hidden columns to be displayed?
SELECT which specifically references the hidden column.
Which of the following is displayed by the DESCRIBE command?
all of the above
Which of the following may contain transitive dependencies, but not partial dependencies?
first normal form (1NF)
The fact that a person can wear different size clothes and that different people can wear the same size clothes is best characterized as a what type of relationship?
one-to-all
