AIT524 - 5 to 7

The ____________________ TABLE command is used to add a PRIMARY KEY constraint to an existing table.

ALTER

The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.

ALTER TABLE

The ____________________ command can be used to enable or disable a constraint.

ALTER TABLE

The ____________________ command can be used to modify the structure of a table.

ALTER TABLE

Which of the following commands can be used to make structural changes to an existing table?

ALTER TABLE

Which of the following symbols is a wildcard character that can represent any number of characters in a WHERE clause?

%

Which of the following search patterns could be used to find the word HELLO in Oracle12c?

%H%

If a new table is being created based upon a subquery, the subquery must be enclosed in which of the following symbols?

( )

The column list of the CREATE TABLE command must be enclosed in ____________________.

( )

When defining columns for a table in the CREATE TABLE command, the column list must be enclosed in which of the following symbols?

( )

When defining columns for a table, which of the following symbols is used to separate the column names in the column list?

,

A table must have at least ____________________ column(s).

1

A database object is a defined, self-contained structure in Oracle 12c.

True

A datatype identifies the type of data to be stored in a column.

True

SQL*Plus is an Oracle tool used to enter and edit SQL statements

True

A constraint is created at the ____________________ level if it is included as part of the column definition.

column

Any type of constraint can be created at the ____________________ level, unless the constraint is being defined for more than one column.

column

A(n) ____________________ is an alternative column heading displayed in the output of a query.

column alias

If more than one column is listed in the INSERT INTO clause, the column names must be separated by ____.

commas

Combining the contents of two or more columns is known as ____________________.

concatenation

A(n) ____ simply identifies the type of data that Oracle 12c will be expected to store in a column.

datatype

Which of the following keywords can be included in a SELECT statement to suppress duplicate data?

distinct

In an arithmetic expression, multiplication and ____________________ are always solved first in Oracle 12c.

division

Once a table is ____________________, any associated indexes will be removed from the database.

dropped, deleted

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 is a special FOREIGN KEY constraint.

false

A NULL value is the same as a blank space.

false

A database must be shut down before the ALTER TABLE command can be executed.

false

A string literal must be enclosed in double quotation marks. _________________________

false

DML commands are used to create or modify database tables

false

When using a search pattern, a(n) ? symbol is used to indicate exactly one character in that position. _________________________

false

​By default, a column alias is displayed in lower case characters in the results.

false

​By default, a column alias is displayed in lower case characters in the results..

false

​When listing more than one column name in the SELECT clause of a SELECT statement, the column names must be separated by semicolons

false

Which of the following is the standard abbreviation for the constraint FOREIGN KEY?

fk

Which of the following types of constraints is used to enforce referential integrity?

foreign key

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.

four

When used with a FOREIGN KEY, the keyword REFERENCES refers to what?

referential integrity

The SELECT...FOR UPDATE command will automatically obtain a(n) ____________________ lock on the row to be changed.

shared

If a user performs a query that restricts the rows returned based upon a specified date, the date must be enclosed in ____

single quotation marks (' ')

Constraints are always enforced at the ____ level.

table

The duration of a(n) ____________________ is defined by when a COMMIT implicitly or explicitly occurs

transaction

A clause is a section within a SQL statement that begins with a keyword.

true

A(n) constraint can be created during the creation of a database table or added to a table afterwards. _________________________

true

Column headings may be truncated in the results of a SELECT statement.

true

​If more than one column is listed, column names must be separated by commas.

true

Which of the following rules apply to table names in Oracle 12c?

​Names can contain a number sign (#).

Which of the following queries will allow hidden columns to be displayed?

​SELECT which specifically references the hidden column.

The TRUNCATE TABLE command can be used to delete a table from a database. _________________________

FALSE

The default size of the CHAR column is 2. _________________________

FALSE

The name of the table containing the data to be retrieved is specified in the ____________________ clause.

FROM

A foreign key constraint can only be created at the column level.

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

Choosing specific columns to be displayed by a SELECT statement is known as selection.

False

Data manipulation language commands are used to create or modify database tables. _________________________

False

Each section of a SQL command that begins with a keyword is known as a statement.

False

Each section of a statement that begins with a keyword is known as a(n) buffer . _________________________

False

If you omit the mandatory WHERE clause, an error message will be issued.

False

In a WHERE clause, logical operators are evaluated before comparison operators.

False

SQL*Plus can only be accessed via an internet interface.

False

The ALTER TABLE command with the MODIFY clause can be used to disable a constraint. _________________________

False

The ALTER TABLE...DROP COLUMN command can be used to delete multiple columns from a table

False

The SELECT clause of the SELECT statement is used to identify which rows are to be retrieved from a specified table.

False

The columns displayed in the results of a SELECT statement will be in the same order as they are stored in the database table.

False

The only required clauses for a SELECT statement are the WHERE and FROM clauses. _________________________

False

When solving arithmetic expressions, Oracle 12c always resolves addition and subtraction operations first from left to right in the expression. _________________________

False

​Each section of a statement that begins with a keyword is known as a(n) buffer . _________________________

False

​The DIST or UNIQ keywords can be used to suppress duplicate data in the results of a SELECT statement.

False

The ____________________ TABLE command is used to prevent other users from making changes to a portion of a table.

LOCK

A NOT NULL constraint can be added to an existing table using the ALTER TABLE command with the ____________________ clause.

MODIFY

The ____________________ clause of the ALTER TABLE command can be used to change the size of a column.

MODIFY

The ____________________ keywords can be added to the end of the command that creates a FOREIGN KEY constraint to indicate that when a row is deleted from the parent table that is referenced by entries in the child table, the rows in the child table should also be delete

ON DELETE CASCADE

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

The name of a table can be changed with the ____________________ command.

RENAME

The names of the columns to be retrieved are listed in the ____________________ clause.

SELECT

Which of the following commands is used to issue a query

SELECT

The ____________________ TABLE command can be used to delete a table from a database.

DROP

The ____________________ datatype is used to store fixed length data

CHAR

The ____ constraint requires that a specific condition be met before a record can be added to a table.

CHECK

Which of the following is a valid SQL statement?​

CREATE TABLE newname (colA NUMBER, colB DATE);

Which of the following is a valid logical operator?

NOT AND OR

The ____ constraint prevents the user from adding a NULL value in the specified column.

NOT NULL

Is NOT a comparison operator?

No

A SELECT statement is also referred to as a ____________________.

Query

In the USER_CONSTRAINTS view, the value displayed in the CONSTRAINT_TYPE column will be a(n) ____ for a FOREIGN KEY constraint.

R

When the UPDATE command is used to change existing data values, the ____________________ clause is used to specify the new data value and the column being changed

SET

To delete all the rows in a table and free up the storage space that was occupied by those rows, the ____ command should be used.

TRUNCATE TABLE

A(n) FOREIGN KEY constraint can only reference a column in the parent table that has been designated as the primary key for that table. _________________________

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

The default format of a DATE column in Oracle 12c is DD-MON-YY.

True

The first column listed in an ORDER BY clause is considered the primary sort.

True

The syntax of the CREATE TABLE command requires that the column list be enclosed in parentheses. _________________________

True

​If a column alias contains a blank space, it must be enclosed in double quotation marks. _________________________

True

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.

A column alias must be contained within double quotation marks (" ") if it contains which of the following?

all

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

before the AS clause

A table name can consist of numbers, letters, and blank spaces.

false

ALTER TABLE...DROP COLUMN command can be used to delete multiple columns from a table

false

An automatic column will generate a value at runtime and may reference values from other columns.

false

Any type of constraint for a single column can be created at the column level. _________________________

false

By default, a column alias is displayed in lower case characters in the results.

false

Concatenation refers to combining the results of several SELECT statements into one result. ​

false

Each clause of a SELECT statement must be entered on a new line in SQL*Plus. _________________________

false

If a column name is entered in lower case in the SELECT statement, the data for the column will be displayed in lower case in the results.​

false

If more than one data value is being added to a table, the values must be separated by parentheses. _________________________

false

Insignificant zeros are displayed for numeric columns by default to show two decimal places. _________________________

false

Oracle 12c does not allow column names to be omitted from the INSERT INTO clause.

false

The BETWEEN operator is used to determine the rows that match a value in a given list. _________________________

false

The CREATE TABLE cannot contain a subquery.

false

The DROP command can be used to remove rows from an existing table. _________________________

false

The INSERT command is used to modify existing data in a row.

false

The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table. _________________________

false

The SELECT command can be used to display the structure of a database table. _________________________

false

The asterisk symbol (*) can be used in a SELECT statement to indicate that all rows in the table should be displayed in the results.

false

The default size of a VARCHAR2 column is one character.

false

The following arithmetic operations can be performed in the SELECT clause of a SELECT statement: addition (+), subtraction (-), multiplication (*), division (/), and exponential (^).

false

The variable name of a substitution variable is preceded by a(n) percent sign. _________________________

false

Referential ____________________ means that the user is referring to something that actually exists in the referenced table

integrity

When resolving arithmetic expressions, Oracle 12c always performs the operations by starting on the ____________________ side of the expression.

left

​When the WHERE clause contains multiple types of operators, which of the following is resolved last?

logical operators

A referential integrity constraint is usually placed on the ____________________ side of a one-to-many relationship.

many

Which of the following is the standard abbreviation for the constraint NOT NULL?

nn

The entire column heading for a column will be displayed, regardless of the assigned width of the column, if the column is defined as a(n) ____ column.

numeric

The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.

one

In regards to sorting, if a DISTINCT option is used in the SELECT clause of a query then ____.

only columns in the SELECT clause can be used for sorting

If a(n) ____________________ constraint is being dropped, then only the type of constraint needs to be identified in the ALTER TABLE because there can only be one such constraint for each table.

primary key

Choosing specific columns in a SELECT statement is known as ____________________.

projection

The process of retrieving only certain rows based upon a specified condition is known as ____.

selection

A(n) ____________________ can consist of numbers, characters, or special symbols that should be included in the output exactly as entered by the user.

string literal

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.

substitution variable

The ____ for a SQL statement gives the basic structure, or rules, required to execute the statement.

syntax

Constraints are rules used to enforce business rules, practices, and policies.

true

If a user has a shared lock on a table, this will prevent any other user from obtaining a shared or exclusive lock on the same table.

true

The USER_TAB_COLS data dictionary object contains a column to identify hidden columns.

true

The USER_TAB_COLUMNS data dictionary object may be used to identify columns that are assigned an ON NULL clause.

true

The VALUES clause identifies the data values that will be inserted into the table.

true

The WHERE clause of the DELETE command is used to identify the rows to be deleted from the table.

true

The keywords INSERT INTO are followed by the table name.

true

To indicate that data should be sorted in descending order, use the DESC keyword. _________________________

true

​If multiple column names are listed in the SELECT clause of a SELECT statement, the columns must be separated by a comma (,).

true

​In a(n) SELECT statement, keywords, table names, and column names are not case sensitive. _________________________

true

If a column heading is longer than the assigned width of a character column, the column heading will be ____________________.

truncated

Which of the following symbols can be used to combine data from different columns into one column of output?

||

A(n) ____________________ is included in the SELECT clause to indicate that all columns in the specified table should be listed in the results.

*

Which of the following symbols represents all the columns contained in a table?

*

What is the correct answer for the arithmetic expression 9+2*3-2 using the order of operations employed by Oracle 12c when solving equations?

13

Which 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

15

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 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 customersMODIFY (city VARCHAR2(20), lastname VARCHAR2(14));

Which of the following keywords cannot be used to modify an existing table?

ALTER TABLE...AS

The optional keyword ____________________ can be used to distinguish between a column name and a column alias.

AS

When ____________________ operations are performed, an exclusive lock is automatically placed on the specified table.

DDL

The ____________________ command can be used to display the structure of a table.

DESCRIBE

Which command can be used to determine whether or not a column is allowed to contain a NULL value?

DESCRIBE

​The ____________________ command is used to display the structure of a table.

DESCRIBE

Which clause will allow you to disable a constraint?

DISABLE

Which of the following keywords can be included in a SELECT statement to suppress duplicate data?​

DISTINCTA string literal must be enclosed in double quotation marks. _________________________