Tag: databases

0

NULL

Results in a compilation error

An exception will be raised

Header

Declarative

Exception

Executable

AFTER statement trigger

INSERT row trigger

DELETE row trigger

UPDATE row trigger

SQL statements are not case-sensitive, unless indicated.

Keywords can be abbreviated.

SQL statements can be on one or more lines.

Keywords cannot be split across lines.

A cursor is SQL keyword specifying a retrieved data order.

Cursor is acronym for Current Set Of Records and is a database object pointing to a currently selected set of records.

A blinking vertical line that indicates the location of the next input on the display screen.

None of the above.

Access. Constraint. Index. Data.

Atomicity. Consistency. Isolation. Durability.

Access. Consistency. Isolation. Data.

None of the above

foo_text varchar2(10) := 'hello world';

foo_char char(1) := 'Y';

foo_number varchar2(10);

foo_text number(10);

SHOW MISTAKES;

SHOW ERRORS;

DISPLAY ERRORS;

DISPLAY MISTAKES;

None of the above.

1

2

3

0

None of the above

NO_DATA_FOUND ORA-01403

DUP_VAL_ON_INDEX ORA-00001

TWO_MANY_ROWS ORA-01422

OTHERS

None of the above. These are all valid.