Practical Slip 20 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a number n from user and display first n terms of Fibonacci series                                                                           [15 M]

Q2) Create HTML page with following specifications

i) Title should be about your Car.

ii) Color the background by Pink color. 

iii) Place your car name at the top of page in large text and in green color.

iv) Add names of features in your car, each in different color, style and font

v) Add scrolling text about your Car.

vi) Add any image at the bottom.

(Use external CSS to format the web page)                          [25 M]

RDBMS:

Q3) Consider the following entities and their relationships.                       [40 M]

Driver (driver_id, driver_name, address)

Car (license_no, model, year)

Relation between Driver and Car is Many to Many with date and time

as descriptive attribute.

Constraint: Primary key, driver_name should not be null.

Create a RDB in 3NF and write PL/SQL blocks in Oracle for the following:

1) Write a procedure to display car details used on specific day.

2) Write a cursor which will display driver wise car details in the year 2018.