Practical Slip 16 - 2019 Pattern

 Web Technology:

Q1) Write a java script code to accept a sentence from the user and alters it as follows: Every space is replaced by * and digits are replaced by ?           [15 M]

Q2) Write HTML code which generates the following output and display each element of list in different size, color & font. Use inline CSS to format the list.                                                                      [25 M]

• Honda

     Petrol

        1) Honda City

        2) Brio

     Diesel

        1) Amaze

        2) Brio

• Maruti-Suzuki

     Petrol

        1) Swift

        2) Ritz

     Diesel

        1) Swift-Desire

RDBMS:

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

Game (game_name, no_of_players, coach_name)

Player (pid, pname, address, club_name)

Relation between Game and Player is Many to Many.

Constraint: Primary key, no_of_players should be > 0.

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

1) Write a procedure which will display games details having number of players more than 5.

2) Write a trigger which will fire before insert or update on Game having no_of_players less than or equal to zero. (Raise user defined exception 

and give appropriate message).