A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table

 AWR baselines are always created as repeating baselines.

 AWR baselines can be created on the basis of two time values.

 AWR baselines are always created with infinite expiration duration.

 AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.

Define a Key-Exit trigger for all the blocks in the form.  

In the Object Navigator, highlight all the items and define a Key-Exit trigger. 

Define a Key-Exit trigger on the primary key item in the master block.

No additional key-trigger definition is necessary.

The copy of the datafile created is stored in the RMAN repository.

The copy of the datafile created can be viewed using the LIST BACKUP command.

The copy of the datafile created using this COPY command can be placed only on the disk.

The copy of the datafile created is similar to the backup of the file created using the BACKUP command.

The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

Domains can be created using the Configuration Wizard.

Domains can be created using WLST.

Domain configuration files are located in the WebLogic home directory.

Domains can be created based on a domain template.

AWR baselines are always created as repeating baselines.

AWR baselines can be created on the basis of two time values.

AWR baselines are always created with infinite expiration duration.

AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

Constraint names must start with SYS_C

All constraints must be defines at the column level

Constraints can be created after the table is created

Constraints can be created at the same time the table is created

Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

 The index can be changed from NOLOGGING to LOGGING

 The index cannot be recovered even in the ARCHIVELOG mode.

 The index can only be created if the base table is created with the NOLOGGING option.

 The index can be recovered if you perform a backup after the CREATE INDEX statement.

Synonyms can be created only for a table 

Synonyms are used to reference only those tables that are owned by another user 

A public synonym and a private synonym can exist with the same name for the same table 

The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.

To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.

To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.

To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.

Constraint names must start with SYS_C

All constraints must be defines at the column level.

Constraints can be created after the table is created.

Constraints can be created at the same time the table is created.

Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

External tables can be updated.

External tables are read-only tables.

Indexes can be created on external tables.

Indexes cannot be created on external tables.

Music can lead to the enlargement of all the layers of gray.

Music can cause the brain to emit magnetic field.

Music can stimulate to some degree the change of brain structure.

Music can trigger physical change when he / she is playing the instrument.

View

Catalog Table

Stored Procedure

Global Temporary Table

A subquery that defines a view cannot include the GROUP BY clause

A view that is created with the subquery having the DISTINCT keyword can be updated

A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders

DROP TRIGGER trg InsertOrders

DISABLE TRIGGER trg InsertOrders ON Orders

ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

Before parameter form. 

After parameter form. 

Before report. 

After report.

A view can be created as read only.

A view can be created as a join on two or more tables.

A view cannot have an ORDER BY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.

A view must have aliases defined for the column names in the SELECT statement.

Once created, a sequence belongs to a specific schema.

Once created, a sequence is linked to a specific table.

Once created, a sequence is automatically available to all users.

Only the DBA can control which sequence is used by a certain table.

Once created, a sequence is automatically used in all INSERT and UPDATE statements.

ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders

DROP TRIGGER trg_InsertOrders

DISABLE TRIGGER trg_InsertOrders ON Orders

ALTER TRIGGER trg_InsertOrders  ON Orders NOT FOR REPLICATION

sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'