Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

How do you handle an Exception?

a) Trap it with a Handler
b) Propagate it to the Calling Environment
c) a & then b
d) b & then a

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?

a) Row
b) Statement
c) ORACLE FORM trigger
d) Before

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which type of argument passes a value from a calling environment?

a) VARCHER2.
b) BOOLEAN.
c) OUT.
d) IN.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

All users currently have the INSERT privileges on the PLAYER table. You want only your users to insert into this table using the ADD_PLAYER procedure. Which two actions must you take? (Choose two)

a) GRANT SELECT ON ADD_PLAYER TO PUBLIC;
b) GRANT EXECUTE ON ADD_PLAYER TO PUBLIC;
c) GRANT INSERT ON PLAYER TO PUBLIC;
d) GRANT EXECUTE, INSERT ON ADD_PLAYER TO PUBLIC;
e) REVOKE INSERT ON PLAYER FROM PUBLIC;

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

SQL is a procedural language?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

With optimistic locking a user may have to redo their work when a conflict occurs?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

The two types of SQL environment are interactive and embedded?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Catch_#22 valid column name?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

In a select with a group by clause, a where clause, and a having clause, the where conditions are applied before the having conditions?

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which statement about a table is true?

A table can have up to 10,000 columns.
The size of a table does NOT need to be specified
A table CANNOT be created while users are using the database
The structure of a table CANNOT be modified while the table is online

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases