QUESTION 79

The ____ TABLE command is used to modify an existing column's data declaration.

		CHANGE
		RESET
		MODIFY
		ALTER

1.5 points

QUESTION 80

To assign a value to a variable, use the ____ operator.

		=
		:=
		=:
		= =

1.5 points

QUESTION 81

What would be the value of variable str_length after executing the following: str_length := LENGTH('123345');

		2
		3
		6
		8

1.5 points

QUESTION 82

To connect information about different entities, you must create ____, which are links that show how different records are related.

		relationships
		records
		rows
		foreign keys

1.5 points

QUESTION 83

In a SQL query, the search condition begins with ____.

		WHERE
		FROM
		BY
		COND

1.5 points

QUESTION 84

DDL queries may be used in PL/SQL programs.

True

False

1.5 points

QUESTION 85

What will be the results in the Name column: INSERT INTO StudentData VALUES (1,'John Smith','55 Street','Columbus','OH','43215-0984')

		55 Street
		John
		John Smith
		John A. Smith

1.5 points

QUESTION 86

You must include a ____ at the end of a PL/SQL command.

		,
		:
		;
		.

1.5 points

QUESTION 87

What section of a PL/SQL program is used for exception handling?

		BEGIN
		DECLARE
		EXCEPTION
		ERROR Given: CREATE TABLE StudentData ( StudentID NUMBER, Address VARCHAR2(50), Name VARCHAR2(50), City VARCHAR2(50), State CHAR(2), Zip VARCHAR2(10) )

1.5 points

QUESTION 88

The query INSERT INTO student ____ ('abc', '123'); inserts a new row into the student table.

		VALUE
		COLS
		ROWS
		VALUES

1.5 points

QUESTION 89

____ data takes up extra storage space.

		Inconsistent
		Redundant
		Overused
		Foreign

1.5 points

QUESTION 90

Using the CHAR data type causes a column value to be padded to the maximum declared size of the column.

True

False

1.5 points

QUESTION 91

A ____ key is a unique key that you create by combining two or more columns.

		composite
		primary
		foreign
		secondary

1.5 points

QUESTION 92

____ relationships are rare in a relational database; usually you work with ____ relationships.

		One-to-many, one-to-one
		One-to-one, one-to-many
		One-to-one, many-to-one
		Many-to-one, many-to-many

1.5 points

QUESTION 93

It is necessary to use the TO_CHAR function and a format model to display"01/01/2007" from an SQL Select Query.

True

False

1.5 points

QUESTION 94

In a subquery, the results of the main query is used by the subquery?

True

False

1.5 points

QUESTION 95

What will happen when the following query is executed: UPDATE student SET s_class='SR';

		All records in the student table will be updated
		No records in the student table will be updated
		An error will occur
		The first record in the student table will be updated

1.5 points

QUESTION 96

Oracle11g stores character data in VARCHAR2 and CHAR columns using ____ encoding.

		Unicode
		ASCII
		EBCDIC
		Java

1.5 points

QUESTION 97

Which of the following characterizes unnormalized data?

		does not have a foreign key identified
		does not have a primary key identified and/or contains repeating groups
		has transitive dependencies
		has partial dependencies

1.5 points

QUESTION 98

Which of the following does not match the string '_T%' when used with the LIKE operator?

		MT
		MTW
		T
		MTWRF

1.5 points

QUESTION 99

A ____ key is a field in a relational database table whose value must be unique for each row.

		foreign
		primary
		secondary
		unique

1.5 points

QUESTION 100

____ is the default date format.

		YY-DD-MON
		DD-MON-YY
		DD-MON-YYYY
		MON-DD-YYYY