Question 1

Which two of the following statements are true?

technology databases

A view can be created before creating the base table
A view cannot be created before creating the base table
A view will become invalid if the base table's column referred to in the view is altered
A view will become invalid if any column in the base table is altered

Answer

Correct Option: A,C

Question 2

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

technology databases

NULLIF
LENGTH
CONCAT
INSTR

Answer

Correct Option: C

Question 3

The following statement will raise an exception on which line?

technology databases

select dept_name, avg(all salary), count(*) “number of employees”
where deptno = dept_no
and count(*) > 5
group by dept_name

Answer

Correct Option: C

Question 4

Review the code segment. Which line has an error?

technology databases

INSERT INTO salaries VALUES (101, 23400, SYSDATE);
UPDATE salaries
AND effective_dt = SYSDATE
There is no error
WHERE empno = 333;

Answer

Correct Option: D

Question 5

Which are not valid views under concept of scheduling ?

technology databases

All_scheduler_program_args
dba_scheduler_job_run_details
dba_scheduler_running_jobs
dba_scheduler_program_args
All the above

Answer

Correct Option: E

Question 6

what is the view that provides all schedules ?

technology databases

all_scheduler_schedules
all_scheduler_schedule
all_schedule_schedules
all the above
None

Answer

Correct Option: A

Question 7

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

technology databases

FREQ=DAILY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
FREQ=WEEKLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
FREQ=YEARLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
FREQ=YEAR; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
A,B and C options

Answer

Correct Option: E

Question 8

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

technology databases

kill
kill_job
stop_job
stop
None

Answer

Correct Option: C

Question 9

which is invalid funcion of scheduler ?

technology databases

drop_job
copy_job
kill_job
stop_job
None

Answer

Correct Option: C

Question 10

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

technology databases

PLSQL_BLOCK
EXECUTABLE
STORED_PROCEDURE
STORED_PROCEDURE_EXECUTABLE
STORED_EXECUTABLE

Answer

Correct Option: C

Question 11

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

No change is required,job can be scheduled.
Enabled option should be set to False.
Job type should be changed to Executable
Job type should be changed to Executable Block
None

Answer

Correct Option: C

Question 12

In which oracle verion scheduling concept is introduced ?

technology databases

Oracle 8
Oracle 7
Oracle 10g
Oracle 9i
None

Answer

Correct Option: A

Question 13

what is the view that provides the job history ?

technology databases

all_scheduler_job_log_
dba_scheduler_job_logs
users_scheduler_job_log
all the above
None

Answer

Correct Option: E

Question 14

Which package in plsql provides scheduling ?

technology databases

DBMS_SCHEDULER package
DBMS_SCHEDULE package
DBMS_JOB package
Both A & C
None

Answer

Correct Option: D

Question 15

Which are not valid views under concept of scheduling ?

technology databases

All_scheduler_program_args
dba_scheduler_job_run_details
dba_scheduler_running_jobs
dba_scheduler_program_args
All the above

Answer

Correct Option: E

Question 16

what is the view that provides all schedules ?

technology databases

all_scheduler_schedules
all_scheduler_schedule
all_schedule_schedules
all the above
None

Answer

Correct Option: A

Question 17

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

technology databases

FREQ=DAILY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
FREQ=WEEKLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
FREQ=YEARLY; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
FREQ=YEAR; BYDAY=TUE; BYHOUR=11; BYMINUTE=24;
A,B and C options

Answer

Correct Option: E

Question 18

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

technology databases

kill
kill_job
stop_job
stop
None

Answer

Correct Option: C

Question 19

which is invalid funcion of scheduler ?

technology databases

drop_job
copy_job
kill_job
stop_job
None

Answer

Correct Option: C

Question 20

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

technology databases

PLSQL_BLOCK
EXECUTABLE
STORED_PROCEDURE
STORED_PROCEDURE_EXECUTABLE
STORED_EXECUTABLE

Answer

Correct Option: C

Description: databases Online Quiz - 76
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 76

Find more quizzes from top tags