databases Online Quiz - 82
Description: databases Online Quiz - 82 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which two parameters can be set to tell the Oracle to use OMF (Oracle Managed Files)?
Why is searching for large-table full-table scans critical to SQL tuning?
Which character is used to continue a statement in SQL*Plus?
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
What best describes the relationship between indexes and SQL performance?
Which is a major problem with SQL?
What was a problem with navigational data access languages?
Which of the following are valid table-partitioning methods?
INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.
CAN WE SPECIFY MULITPLE PARTITIONING KEY COLUMNS IN INTERVAL PARTITIONING TECHNIQUE
CAN WE SPECIFY VARCHAR DATATYPE FOR THE PARTITIONING KEY IN INTERVAL PARTITIONING TECHNIQUE
IS IT POSSIBLE TO SPECIFY THE EXECUTION ORDER OF TRIGGERS IN ORACLE 10G
CAN SIMPLE_INTEGERS CONTAIN NULL VALUES
REGEXP_COUNT TAKES STRING AND REGULAR EXPRESSION AND RETURNS NUMBER OF TIMES THE EXPRESSION IS PRESENT IN THE STRING
INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON
Need to create a trigger on the EMP table that monitors every row that is changed and place this info into the AUDIT_TABLE What type of Trigger to be used ?
what part of DB trigger determines the number of times the trigger body executes ?
Examine this code CREATE OR REPLACE TRIGGER SECURE_emp BEFORE LOGON ON EMP BEGIN ............. END WHAT TYPE OF TRIGGER IS IT ?
CREATE OR REPLACE TRIGGER update_emp AFTER UPDATE ON EMP BEGIN INSERT INTO AUDIT_TABLE values(user ,sysdate ); END ; you issue an update command in the EMP tables that result in a update of 10 rows. How many rows are inserted into the AUDIT_TABLE ?