• databases Online Quiz - 76
Back
0

databases Online Quiz - 76

Description: databases Online Quiz - 76
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Which two of the following statements are true?

technology databases

  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

Show answer
Correct Option: A,C

Which function can return a non-NULL value if passed a NULL argument?

technology databases

  1. NULLIF

  2. LENGTH

  3. CONCAT

  4. INSTR

Show answer
Correct Option: C

The following statement will raise an exception on which line?

technology databases

  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

Show answer
Correct Option: C

Review the code segment. Which line has an error?

technology databases

  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;

Show answer
Correct Option: D

Which are not valid views under concept of scheduling ?

technology databases

  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

Show answer
Correct Option: E

what is the view that provides all schedules ?

technology databases

  1. all_scheduler_schedules

  2. all_scheduler_schedule

  3. all_schedule_schedules

  4. all the above

  5. None

Show answer
Correct Option: A

To run a job every Tuesday at 11:24 What could use in the following ?

technology databases

  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

Show answer
Correct Option: E

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

technology databases

  1. kill

  2. kill_job

  3. stop_job

  4. stop

  5. None

Show answer
Correct Option: C

which is invalid funcion of scheduler ?

technology databases

  1. drop_job

  2. copy_job

  3. kill_job

  4. stop_job

  5. None

Show answer
Correct Option: C

what should be program type of a program that is of 'STORED PROCEDURE' ?

technology databases

  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE

Show answer
Correct Option: C

What code modificaiton should be made to run the below code ? begin dbms_scheduler.create_job ( job_name => 'RUN_SHELL1', schedule_name => 'DEMO_SCHEDULE', job_type => 'EXECUTABLES', job_action => '/home/test/run_script.sh', enabled => true, comments => 'Run shell-script' ); end; /
technology databases

  1. No change is required,job can be scheduled.

  2. Enabled option should be set to False.

  3. Job type should be changed to Executable

  4. Job type should be changed to Executable Block

  5. None

Show answer
Correct Option: C

In which oracle verion scheduling concept is introduced ?

technology databases

  1. Oracle 8

  2. Oracle 7

  3. Oracle 10g

  4. Oracle 9i

  5. None

Show answer
Correct Option: A

what is the view that provides the job history ?

technology databases

  1. all_scheduler_job_log_

  2. dba_scheduler_job_logs

  3. users_scheduler_job_log

  4. all the above

  5. None

Show answer
Correct Option: E

Which package in plsql provides scheduling ?

technology databases

  1. DBMS_SCHEDULER package

  2. DBMS_SCHEDULE package

  3. DBMS_JOB package

  4. Both A & C

  5. None

Show answer
Correct Option: D

Which are not valid views under concept of scheduling ?

technology databases

  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

Show answer
Correct Option: E

what is the view that provides all schedules ?

technology databases

  1. all_scheduler_schedules

  2. all_scheduler_schedule

  3. all_schedule_schedules

  4. all the above

  5. None

Show answer
Correct Option: A

To run a job every Tuesday at 11:24 What could use in the following ?

technology databases

  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

Show answer
Correct Option: E

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

technology databases

  1. kill

  2. kill_job

  3. stop_job

  4. stop

  5. None

Show answer
Correct Option: C

which is invalid funcion of scheduler ?

technology databases

  1. drop_job

  2. copy_job

  3. kill_job

  4. stop_job

  5. None

Show answer
Correct Option: C

what should be program type of a program that is of 'STORED PROCEDURE' ?

technology databases

  1. PLSQL_BLOCK

  2. EXECUTABLE

  3. STORED_PROCEDURE

  4. STORED_PROCEDURE_EXECUTABLE

  5. STORED_EXECUTABLE

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions