Tag: databases

Questions Related to databases

Which of the following are valid table-partitioning methods?
technology databases

  1. Range

  2. Freelist

  3. Hash

  4. Index

Show answer
Correct Option: C

INTERVAL PARTITIONING IS NOT SUPPORTED FOR INDEX-ORGANIZED TABLES.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

CAN WE SPECIFY MULITPLE PARTITIONING KEY COLUMNS IN INTERVAL PARTITIONING TECHNIQUE
technology databases

  1. True

  2. False

Show answer
Correct Option: B

CAN WE SPECIFY VARCHAR DATATYPE FOR THE PARTITIONING KEY IN INTERVAL PARTITIONING TECHNIQUE
technology databases

  1. True

  2. False

Show answer
Correct Option: B

IS IT POSSIBLE TO SPECIFY THE EXECUTION ORDER OF TRIGGERS IN ORACLE 10G
technology databases

  1. True

  2. False

Show answer
Correct Option: B

CAN SIMPLE_INTEGERS CONTAIN NULL VALUES
technology databases

  1. True

  2. False

Show answer
Correct Option: B

REGEXP_COUNT TAKES STRING AND REGULAR EXPRESSION AND RETURNS NUMBER OF TIMES THE EXPRESSION IS PRESENT IN THE STRING
technology databases

  1. True

  2. False

Show answer
Correct Option: A

INTERVAL PARTITIONING IS A PARTITIONING TECHNIQUE BASED ON
technology databases

  1. HASH

  2. MODULUS

  3. RANGE

  4. RANDOM

Show answer
Correct Option: C

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 ?
technology databases

  1. FOR EACH ROW trigger on the EMP table

  2. Statement-level Trigger on the EMP table

  3. FOR EACH ROW trigger on the AUDIT_TABLE table

  4. Statement-level Trigger on the AUDIT_TABLE

Show answer
Correct Option: A

what part of DB trigger determines the number of times the trigger body executes ?
technology databases

  1. Trigger type

  2. Trigger body

  3. Trigger event

  4. Trigger Timing

Show answer
Correct Option: A