IT 314 Final - Weeks 1 & 2

Ace your homework & exams now with Quizwiz!

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


Related study sets

Some (possibly) confusing chromosome terminology...

View Set

Intro To Chemistry Chpt 4 Chemical Bonds

View Set

AP Psychology: Cognition: Thinking, Language and Individual Differences

View Set

CARDIAC- CH 25 - Assess. of Cardiac F(x)

View Set

Chapter 6 Smartbook Int'l Business

View Set

Carbohydrates, Fats, and Proteins

View Set