IT 314 Final - Weeks 1 & 2
When adding a column to an existing table, the ____________________ clause must be used with the ALTER TABLE command.
ADD
A foreign key appears on the many side of a one-to-many relationship.
True
It is possible to temporarily disable constraints in an Oracle database.
True
You cannot delete the last column in a table.
True
The ____ data type stores variable-length character data.
VARCHAR2
A field is referred to as a(n) ____________________ in the physical database.
column
Data is in second normal form if it is in first normal form and has no ____________________.
partial dependencies
Adding a new column to a database table is a(n) ____________________ action.
unrestricted
____ constraints define specific data values or data ranges that must be inserted into columns and whether values must be unique or not NULL.
value
If a new table is being created based upon a subquery, the subquery must be enclosed in which of the following symbols?
()
The column definition of NUMBER(7, 4) indicates a precision of ____.
7
When modifying data in existing columns, which of the following is correct?
A column must be as wide as the data it already contains.
The ____ TABLE command is used to modify an existing column's data declaration.
ALTER
The DROP UNUSED COLUMNS clause can be used with the ____________________ command to delete any column previously set as unused.
ALTER TABLE
Which of the following commands can be used to make structural changes to an existing table?
ALTER TABLE
Which command is used to disable the constraint named faculty_loc_id_fk in the faculty table?
ALTER TABLE faculty DISABLE CONSTRAINT faculty_loc_id_fk;
Which command instructs Oracle11 g to create a new table?
CREATE TABLE
In which format does Oracle10 g display a date value?
DD-MON-YY
The ____________________ clause of the ALTER TABLE command can be used to delete a column from an existing table.
DROP COLUMN
Which of the following keywords is used to remove a database table in Oracle11 g?
DROP TABLE
Which of the following is used to create and maintain the physical database?
Database Management System (DBMS)
A NOT NULL constraint is an example of a table constraint.
False
A composite key is created using a value constraint.
False
A database is a physical storage device for data
False
A database must be shut down before the ALTER TABLE command can be executed.
False
An entity is represented by a column in the Entity-Relationship Model.
False
Data manipulation language commands are used to create or modify database tables.
False
If the column S_ID is the primary key of the STUDENT table, the constraint name would be pk_STUDENT_S_ID according to the constraint naming convention.
False
Only one column can be added to an existing table at one time.
False
Only one type of relationship can be represented in an Entity-Relationship Model.
False
The ALTER TABLE name can be used to rename a table.
False
The CHAR data types stores up to 4,000 characters.
False
The CHAR datatype is used to store variable-length data that can consist of letters and numbers.
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
The MODIFY TABLE command can be used to change the size of a table.
False
The MODIFY clause can be used with the ALTER TABLE command to add a column to an existing table.
False
The SQL command to create a database table is an example of DML.
False
The TRUNCATE TABLE command can be used to delete a table from a 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 ____________________ clause of the ALTER TABLE command can be used to change the size of a column.
MODIFY
The ____ constraint specifies whether the user must enter a column for a specific record, or whether the value can be NULL (indeterminate or unknown).
NOT NULL
SQL commands can be issued in Oracle 12c through ____________________ which is an interface that allows users to interact with the database
SQL*Plus
Which of the following is an interface tool that allows a user to create, edit, and manipulate data in Oracle11g?
SQL*Plus
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
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.
A bridging table can be used to eliminate a many-to-many relationship in a relational database.
True
A character is a basic unit of data and can consist of a number, letter, or special symbol.
True
A many-to-many relationship cannot exist in a relational database.
True
A primary key is defined using an integrity constraint.
True
Partial dependency can only exist if the data is uniquely identified by a composite primary key.
True
Structured Query Language (SQL) is generally used to interact with a database.
True
The CREATE TABLE command is used to create a table in Oracle11g.
True
The DROP COLUMN clause of the ALTER TABLE command can only be used to delete one column at a time.
True
The DROP TABLE command can be used to remove a table and all its data from a database.
True
The Systems Development Life Cycle is a series of steps that can be used to guide the development process for a database management system.
True
The occurrence of data anomalies would indicate an unnormalized database design.
True
To check that the value entered into a CHAR column is either 'M' or 'F', you would use a check condition constraint.
True
Using the CHAR data type causes a column value to be padded to the maximum declared size of the column.
True
Which of the following data types is used to store variable length ASCII character data?
VARCHAR2
Data mining refers to ____.
analyzing data already stored in a database
A(n) ____________________ table can be added to the physical database to eliminate a many-to-many relationship.
bridging
Fixed-length character data is stored in the ____________________ data type.
char
The ____________________ datatype is used to store fixed length data.
char
A(n) ____________________ is a basic unit of data that can consist of a letter, number, or special symbol.
character
A field is a group of related ____________________.
characters
A(n) ____________________ enables you to specify that a column value must be a specific value or fall within a range of values.
check constraint
A(n) ____________________ constraint limits the value that can be placed in a specific column, irrespective of values that exist in other table rows.
column
Each ____________________ name within a table must be unique.
column
Which of the following can be used to link the data in two or more tables together?
common field
____________________ are restrictions on the data values that a column can store.
constraints
Which of the following terms refers to commands that are used to create or modify database tables?
data definition language (DDL)
A ____ is a storage structure designed to hold a collection of data.
database
A(n) ____________________ is a storage structure that contains data.
database
A(n) ______________________________ is used to create and maintain the structure of a database.
database management system (DBMS)
A column's ____________________ identifies the type of data that can be stored in a column.
datatype
Which command would be used to delete table x and all foreign key constraints to x?
drop x cascade constraints
A(n) ____________________ constraint defines a primary or foreign key.
integrity
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?
many-to-many
Which of the following types of relationships cannot exist in a relational database?
many-to-many
Which of the following declares a column named "name" that always contains exactly 30 characters?
name CHAR(30)
The DROP COLUMN clause of the ALTER TABLE command can be used to drop a maximum of ____________________ column(s) at a time.
one
A solid straight line in an E-R Model depicts a(n) ____________________ relationship.
one-to-one
The ____________________ of a NUMBER column indicates the total number of digits that can be stored in the column.
precision
Adding a check condition constraint to a table is a(n) ____________________ action.
restricted
A record in the logical design of a database corresponds to a ____ in the physical database.
row
A record in the logical design of a database is represented by what in the physical database?
row
_________________________ is a data sublanguage that processes sets of data.
structured query language SQL
Which of the following is not created using an integrity constraint?
surrogate key
In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?
systems analysis
A file is referred to as a(n) ____________________ in an Oracle10 g database.
table
A(n) ____________________ constraint restricts the data value with respect to all other values in the table.
table
The multi-step process used when creating a new system is referred to as ____.
the Systems Development Life Cycle
If at least one value in a record does not depend upon the primary key, then a _________________________ exists.
transitive dependency
A(n) ____________________ constraint is a table constraint that specifies that a column must have a unique value for every table row.
unique
Which of the following is a table constraint?
unique
Deleting columns from a table is a(n) ____ action.
unrestricted