Database
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| show | EXCEPTION HANDLER
🗑
|
||||
| show | True
🗑
|
||||
| show | True
🗑
|
||||
| show | PREDEFINED
🗑
|
||||
| show | True
🗑
|
||||
| What is missing in line 3? | show 🗑
|
||||
| The block below will display the country name and the area of each country in a chosen region. The region_id should be passed to the cursor as a parameter. The block is tested using region 5 (South America). | show 🗑
|
||||
| What is missing in the given construct in order to remove an entire package? DROP ________ PACKAGE_NAME; | show 🗑
|
||||
| show | INSTEAD OF
🗑
|
||||
| show | BEFORE
🗑
|
||||
| show | INSERTING
🗑
|
||||
| A ________ fires once for each row affected by the triggering DML statement, either just BEFORE the row is processed or just AFTER. | show 🗑
|
||||
| The ________trigger is the default type of DML trigger. | show 🗑
|
||||
| show | TRUE
🗑
|
||||
| show | TRUE
🗑
|
||||
| show | CREATE, ALTER, DROP
🗑
|
||||
| The ________ declared in the package specification are initialized to null by default. | show 🗑
|
||||
| show | SUBPROGRAMS
🗑
|
||||
| The implementation (i.e., the detailed code) of a procedure or function that is declared in a ________ is done in the package body. | show 🗑
|
||||
| TCL statement is allowed in triggers. | show 🗑
|
||||
| show | TRUE
🗑
|
||||
| show | FALSE
🗑
|
||||
| A MUTATE table is an object that is currently being modified by a DML statement. | show 🗑
|
||||
| A ON DATABASE fires the trigger for DDL on all schemas in the database. | show 🗑
|
||||
| The ON SCHEMA cannot be used with ____________ events. | show 🗑
|
||||
| show | ON SCHEMA
🗑
|
||||
| A ________ fires the trigger for DDL on all schemas in the database. | show 🗑
|
||||
| Every subprogram declared in the package specification must also be included in the _____. | show 🗑
|
||||
| Package body contains only subprograms that are declared in the package specification. | show 🗑
|
||||
| show | TRUE
🗑
|
||||
| show | SYSTEM
🗑
|
||||
| show | AFTER
🗑
|
||||
| The _______ trigger fires only once for each execution of the triggering statement (even if no rows are affected). | show 🗑
|
||||
| A DML trigger may have more than one triggering event. | show 🗑
|
||||
| A DML trigger is a trigger that is automatically fired (executed) whenever an SQL DML statement (INSERT, UPDATE, or DELETE) is executed. | show 🗑
|
||||
| show | TRUE
🗑
|
||||
| show | TRUE
🗑
|
||||
| show | TRUE
🗑
|
||||
| show | ROW-LEVEL
🗑
|
||||
| show | MUTATING TABLE
🗑
|
||||
| show | Database Event Trigger
🗑
|
||||
| The _____ is the interface to your applications that declares the constructs (procedures, functions, variables, and so on) which are visible to the calling environment. | show 🗑
|
||||
| The implementation (i.e., the detailed code) of a procedure or function that is declared in a ________ is done in the package body. | show 🗑
|
||||
| Triggers can either be column-level or statement-level. | show 🗑
|
||||
| show | APPLICATION
🗑
|
||||
| DBA shutting down the database is a ______ event. | show 🗑
|
||||
| In creating trigger you need to consider the timing and _______. | show 🗑
|
||||
| DML Trigger is classified in two ways: when they execute, how they execute. | show 🗑
|
||||
| In creating trigger you need to consider the timing and event. | show 🗑
|
||||
| You specify a row trigger using FOR EACH ROW clause. | show 🗑
|
||||
| The ______ triggers can either be ON DATABASE or ON SCHEMA. | show 🗑
|
||||
| The _______ is a statement is used to invoke procedure in a trigger. | show 🗑
|
||||
| The OR REPLACE options _______ and re-creates the package specification. | show 🗑
|
||||
| The package specification is the interface to your applications that declares the constructs (procedures, functions, variables, and so on) which are visible to the calling environment. | show 🗑
|
||||
| show | FALSE
🗑
|
||||
| show | TRUE
🗑
|
||||
| To create triggers in other user’s schemas, you need to the __________ privilege. | show 🗑
|
||||
| Which will view the detailed code and status of the trigger in data dictionary? | show 🗑
|
||||
| The following determines when a DML trigger will execute: BEFORE, AFTER, INSTEAD. | show 🗑
|
||||
| show | FALSE
🗑
|
||||
| show | TRUE
🗑
|
||||
| Which will not cause a trigger to fire? | show 🗑
|
||||
| show | Implicitly
🗑
|
||||
| show | DELETE
🗑
|
||||
| show | TRUE
🗑
|
||||
| show | FALSE
🗑
|
||||
| Event determines which DML operation causes the trigger to fire. Values are INSERT, UPDATE [OF column], and DELETE. | show 🗑
|
||||
| A row trigger fires once for each row affected by the triggering DML statement, either just BEFORE the row is processed or just AFTER. | show 🗑
|
||||
| show | TRUE
🗑
|
||||
| You cannot create a DDL trigger that refers to a specific database object. | show 🗑
|
||||
| DML Triggers can either be ON DATABASE or ON SCHEMA.  | show 🗑
|
||||
| The Database Event Trigger are fired by non-SQL events in the database. | show 🗑
|
||||
| Which trigger is applicable in the following scenario: The DBA starts up, or shuts down, the database. | show 🗑
|
||||
| The ON SCHEMA fires the trigger only for _______ sessions. | show 🗑
|
||||
| show | BODY
🗑
|
||||
| show | FALSE
🗑
|
||||
| TCL are not allowed in triggers. | show 🗑
|
||||
| show | TRIGGER
🗑
|
||||
| show | DML, DDL
🗑
|
||||
| show | APPLICATION
🗑
|
||||
| You specify a row trigger using __________clause. | show 🗑
|
||||
| A _______ trigger is a trigger that is automatically fired (executed) whenever an SQL DML statement (INSERT, UPDATE, or DELETE) is executed. | show 🗑
|
||||
| show | FALSE
🗑
|
||||
| show | TRUE
🗑
|
||||
| The given trigger header below contains no error. CREATE OR REPLACE TRIGGER emp_del_trigg AFTER DELETE ON employees BEGIN <assume valid PL/SQL statements here> END; | show 🗑
|
||||
| The CALL is a statement is used to invoke procedure in a trigger. | show 🗑
|
||||
| The database triggers are fired by non-SQL events in the database. | show 🗑
|
||||
| show | FALSE
🗑
|
||||
| show | FALSE
🗑
|
||||
| show | DDL
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
XiuElias26