0

databases Online Quiz - 76

Description: databases Online Quiz - 76
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. A view can be created before creating the base table

  2. A view cannot be created before creating the base table

  3. A view will become invalid if the base table's column referred to in the view is altered

  4. A view will become invalid if any column in the base table is altered


Correct Option: A,C

The following statement will raise an exception on which line?

  1. select dept_name, avg(all salary), count(*) “number of employees”

  2. where deptno = dept_no

  3. and count(*) > 5

  4. group by dept_name


Correct Option: C
  1. INSERT INTO salaries VALUES (101, 23400, SYSDATE);

  2. UPDATE salaries

  3. AND effective_dt = SYSDATE

  4. There is no error

  5. WHERE empno = 333;


Correct Option: D

Which are not valid views under concept of scheduling ?

  1. All_scheduler_program_args

  2. dba_scheduler_job_run_details

  3. dba_scheduler_running_jobs

  4. dba_scheduler_program_args

  5. All the above


Correct Option: E

what is the view that provides all schedules ?

  1. all_scheduler_schedules

  2. all_scheduler_schedule

  3. all_schedule_schedules

  4. all the above

  5. None


Correct Option: A
  1. FREQ=DAILY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  2. FREQ=WEEKLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  3. FREQ=YEARLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  4. FREQ=YEAR; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  5. A,B and C options


Correct Option: E

What funcion is used to kill a job scheduled in scheduler?

  1. kill

  2. kill_job

  3. stop_job

  4. stop

  5. None


Correct Option: C

which is invalid funcion of scheduler ?

  1. drop_job

  2. copy_job

  3. kill_job

  4. stop_job

  5. None


Correct Option: C
  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE


Correct Option: C
  1. Oracle 8

  2. Oracle 7

  3. Oracle 10g

  4. Oracle 9i

  5. None


Correct Option: A
  1. all_scheduler_job_log_

  2. dba_scheduler_job_logs

  3. users_scheduler_job_log

  4. all the above

  5. None


Correct Option: E

Which package in plsql provides scheduling ?

  1. DBMS_SCHEDULER package

  2. DBMS_SCHEDULE package

  3. DBMS_JOB package

  4. Both A & C

  5. None


Correct Option: D
  1. All_scheduler_program_args

  2. dba_scheduler_job_run_details

  3. dba_scheduler_running_jobs

  4. dba_scheduler_program_args

  5. All the above


Correct Option: E
  1. all_scheduler_schedules

  2. all_scheduler_schedule

  3. all_schedule_schedules

  4. all the above

  5. None


Correct Option: A
  1. FREQ=DAILY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  2. FREQ=WEEKLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  3. FREQ=YEARLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  4. FREQ=YEAR; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;

  5. A,B and C options


Correct Option: E
  1. drop_job

  2. copy_job

  3. kill_job

  4. stop_job

  5. None


Correct Option: C
  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE


Correct Option: C
- Hide questions