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