QUESTION 79 The ____ TABLE command is used to modify an existing column\'s data

Question

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

CHANGE

RESET

MODIFY

ALTER

Explanation / Answer

79: ALTER

80: =

81: 6

82: foreign key

83: WHERE

84: YES

85: John Smith

88: Values

94: True

95:All records in the student table will be update

96:ASCII

97: does not have a primary key identified and/ or contains repeating groups

98:T

99:primary

100: MON-DD-YYYY

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.