Tag: databases

Questions Related to databases

What does the ‘Help Table’ display?

technology databases

  1. Column names, data type, Comments

  2. Column names, Indexes, data types, Comments

  3. Displays the table id, Column names, data types, Comments

  4. Tell the session number of the user

Show answer
Correct Option: A

Which operator will be evaluated first in the following SELECT statement?

technology databases

  1. +

  2. *

  3. -

  4. /

Show answer
Correct Option: B

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