CS405 Quiz 1

Q1. How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?

1. UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'
2. MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'
3. UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'
4. MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

Correct answer: UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

Q2. Sequence is a feature supported by Oracle database systems to produce ________ values on demand.

1. Unique
2. Duplicate
3. Character
4. String

Correct answer: Unique

Q3. In procedure __________will simply exit the control from subprogram.

1. EXIT
2. RETURN
3. UPDATE
4. SELECT

Correct answer: RETURN

Q4. Return datatype is mandatory at the time of ________in the function.

1. Selection
2. Calculation
3. EXIT
4. Creation

Correct answer: Creation

Q5. Exceptions are of_________types.

1. 2
2. 4
3. 6
4. 8

Correct answer: 2

Q6. You need to implement a virtual private database (vpd). In order to have the vpd functionality, a trigger is required to fire when every user initiates a session in the database. What type of trigger needs to be created?

1. Application trigger
2. DML trigger
3. System event trigger
4. INSTEAD OF trigger

Correct answer: System event trigger

Q7. The_________exceptions are executed in case of violations of any database rule by the program.

1. Internally defined
2. System exceptions
3. Database exceptions
4. User defined

Correct answer: Internally defined

Q8. In PL/SQL there can be block ____ blocks.

1. Within
2. Outside
3. Inward
4. Outward

Correct answer: Within

Q9. In PL/SQL variables can only be declared in _____ section.

1. END
2. None of the given.
3. BEGIN
4. DECLARE

Correct answer: DECLARE

Q10. To display output on screen ________________ command is used in PL/SQL.

1. Output_line
2. Output.put
3. Dbms_output.put_line
4. Dbms_output

Correct answer: Dbms_output.put_line