Bachelor of Science (B.Sc.) Sem V 2015 2016 2016 Comp.prog & Syst.Analysis Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 What is the purpose of for loop?
2. Q2 What is the use of && Operator? q 3) What is the purpose of ++, -- operator? Attempt any Two 6
3. Q1 Explain strch() function with suitable example 4 2) Write a note on Nested
4. Q3 loop that will calculate and print the square of every third beginning with 3. for all values less than 100
5. Q1 Write a program in C to input an integer and find whether the divisible by 7 or not
6. Q2 Write a program in C to input an integer and find whether the number is a prime or not. 7
   • A) Attempt any 7
7. Q1 What !
8. Q2 What is header file? q 3) What is the use of escape sequence \t and
9. Q1 printf() function and scanf() function 4 2) Write a short note on identifiers in C a 3) State the output of the following program giving step by step is and y is %d y); Attempt any One a 1) Write a program in C to find the series a 2) Write a program in C to input names persons and arrange these names in
10. Q3 A) Attempt any Two Create table employee with following specification
11. Q1 Insert 3records in the employee table Display all fields
12. Q3 Drop the table
    • B) Attempt any Two 4
    • i) Explain the following functions in SQL with suitable example
    • ii) Explain the following SQL commands ili) Write a sql query for the following : Create a table called product containing the columns(P_no int name varchar2(10), with the following constraint
    • i) P_no is primary key ti) Price should be by
    • C) Attempt any One 5
    • (1) Write a note on DDI and DML
    • (i) To remove the leading blank spaces from the College”
    • (ii) To display the square root of 27
    • (b) Write a short note on DBMS 3 Attempt any Two
    • i) How to write a comments in PL/SQL code? Explain with example
    • ii) Explain the types of loop in PL/SQL Explain case statement in PL/SQL block
    • B) Attempt any Two
    • i) Write down the different data types in PL/SQL with one each
    • ii) Write a short note with relerence to the SQL that explain the and
    • iii) Explain group by & having clause
    • C) Attempt any One
    • (1) Write a PL/SQL block to find the sum of first 10 natural humbers,
    • (2) Write a SQL Statement to create table student hav ing
    • (i) To display all rows where student ID is
    • (ii) To display students name in Upper Case
13. Q5 Attempt any Five
    • (a) the output of the following program
    • (b) Explain the term mapping cardinalities with example
    • (c) Explain the Attribute and Entity with reference to the SOL
    • (d) Write a PL/SQL code block that uses a simple such that all natural from one are printed and message is displayed when loop exceeds 9
    • (e) Write a PL/SQL code to accept a number from user and find and print whether it is even
    • (f) Write aC program to interchange the variable without using temporary variable
    • (g) Explain first Normal Form (1 NF) with example
    • (h) Give the difference between
    • ii) and Rtrim()

Read from the scan above, so a character or two may differ. The scan is the original.