Practical Slip 8 - 2019 Pattern

 Web Technology:

Q1) Write a java script program to accept a string and character from user and check the count of occurrences of that character in string.                          [15 M]

Q2) Create HTML page with following specifications 

i) Title should be about your self.

ii) color the background should be pink.

iii) Place your name at the top of page in large text and centered.

iv) Add names of your family members each in different size, color, style

and font.

v) Add scrolling text about your family.

vi) Add any image at the bottom. (Use internal CSS to format the web page)                                                                                              [25 M]

RDBMS:

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

Plan (plan_no, plan_name, nooffreecalls, freecalltime, fix_amt)

Customer (cust_no, cust_name, mobile_no)

Relation between Plan and Customer is One to Many.

Constraint: Primary key, fix_amt should be greater than 0.

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

1) Write a function which will accept plan number from user and display all the details of the selected plan.

2) Write a cursor which will display customer wise plan details.(Use Parameterized

Cursor).