P.G.D.C.A. (Semester – II),Solapur University Question Paper,DBMS AND RDBMS USING ORACLE (Old) (Paper– VII),2014 Question Paper

Solapur University Question Paper
P.G.D.C.A. (Semester – II) Examination, 2014
DBMS AND RDBMS USING ORACLE (Old) (Paper – VII)
Day and Date : Monday, 21-4-2014 Total Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q. No. 2, 3 and 4.
3) Attempt any one question from Q. No. 5 and 6.
4) Figures to the right indicate full marks.
1. A) Choose the single correct alternative : 16
1) _____________ is a process that helps analysts or database designers to
design table structures for an application.
a) SQL b) Sub-Query c) Normalization d) All of these
2) SQL starts with a _____________
a) Verb b) Adjective c) Noun d) Pronoun
3) _____________ is the area of SQL that allows changing data within the
database.
a) DDL b) DML c) DCL d) DQL
4) The unique column constraint permits multiple entries of NULL into the
column.
a) True b) False
5) The _____________ operator allows the selection of rows that contain
values within a specified lower and upper limit.
a) ** (Exponentiation) b) AND
c) OR d) BETWEEN
6) A _____________ is a form of an SQL statement that appears inside
another SQL statement.
a) PL/SQL b) Join c) View d) Sub-query
7) The PL/SQL code block starts with a _____________ section.
a) BEGIN b) START c) DECLARE d) None of these
8) IF ..... THEN .... ELSE .... END IF; is a valid iterative control structure in
PL/SQL.
a) True b) False
9) _____________ changes the flow of control within a PL/SQL block.
a) If .. Then .. else ... end if. b) While
c) Goto d) All of these
10) In PL/SQL, _____________ is valid assignment operator.
a) := b) = c) =: d) = =
11) In a cursor, _____________ statement moves the data held in the Active
Data Set into the memory variables.
a) Copy b) Open c) Move d) Fetch
12) Database triggers can be used to prevent invalid transactions.
a) True b) False
B) Suppose there is a table named CLIENT_MASTER exist on the disk. The
columns of the table are – clientno, name, address, city, pincode, state. 4
Write SQL statements for the following :
1) Change the city of clientno ‘C0005’ TO ‘Bangalore’.
2) List the names of all clients having ‘a’ as the second letter in their names.
3) List the clients who stay in a city whose first letter is ‘M’.
4) Add a column called TELEPHONE of data type ‘Number’ and size = 10 to
the CLIENT_MASTER table.
2. a) What is data ? How DBMS is differ from RDBMS ? 6
b) Who is oracle DBA ? Explain the responsibilities of oracle DBA. 6
c) Explain “Classification of SQL Commands”. 4
3. a) Explain group by and having clause with suitable example. 6
b) Explain any three aggregate functions with example of each. 6
c) What is the term privilege ? How will you give and take out privileges to other
users ? 4
SLR-R – 9 -2-
4. Write short notes on the following :
1) Normalization 4
2) Multiple sub-queries 4
3) Iterative Control Structures 4
4) Historical development of oracle. 4
5. a) Write a PL/SQL code to accept, calculate and store the details of employees
into the table EMPLOYEE. Columns of the table will be EMPNO, EMPNAME,
BASIC_SALARY, DA, HRA and NET_SALARY. Rules for DA. HRA etc.
calculation : 8
• DA should be 75% on BASIC_SALARY
• HRA should be 10% on BASIC_SALARY
• NET_SALARY = BASIC_SALARY + DA + HRA.
b) Why triggers are used ? Explain with suitable example. 8
6. a) Discuss on ‘Codd’s Rules. 8
b) Explain Explicit Cursor Management. 8
7. a) Discuss on “Integrity Constraints”. 8
b) Explain Like Operator, Between Operator, Where Clause and Order By clause. 8
_______________

ASP.NET USING C # (New) (Paper – 8),P.G.D.C.A. (Semester – II),2014 Question Paper,Solapur University

Solapur University Question Paper
P.G.D.C.A. (Semester – II) Examination, 2014
ASP.NET USING C # (New) (Paper – 8)
Day and Date : Thursday, 8-5-2014 Total Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q. No. 2, 3 and 4.
3) Attempt any one question from Q. No. 5 and 6.
4) Figures to the right indicate full marks.
1. Choose the single correct alternative. 16
1) ___________ is small amount of data that is stored in the text file or in
memory.
a) cookie b) session
c) both a) and b) d) none of these
2) Which of these is not a feature of ASP.NET ?
a) Easy development b) Data access
c) Compiled execution d) None of these
3) Which of the following contains web application setting ?
a) app.config b) web.config
c) assembly.config d) machine.config
4) What data type is return is IsPostback property ?
a) bit b) boolean
c) int d) string
5) Which namespace is used when we connect our ASP.NET page to SQL
Server ?
a) System.data.sqlclient b) System.data.sql
c) System.Sqlserver d) System.url
SLR-R – 13 -2-
6) Which method do you invoke on the DataAdapter control to load your
generated dataset with data.
a) DataBind( ) b) Populate( )
c) Bind( ) d) Fill( )
7) Which of the following is the object of .NET data provider ?
a) Connection b) Command
c) Data reader d) All of these
8) ASP.NET provides way of authenticate
a) Forms Authentication b) Windows Authentication
c) Passport Authentication d) All of these
9) Which data control does not exists in ASP.NET. ?
a) Grid View b) Data List
c) Table View d) Repeater
10) Which of the following is the correct size of a Decimal datatype in C# ?
a) 8 bytes b) 4 bytes
c) 10 bytes d) 16 bytes
11) Which of the following is not an arithmetic operator in C#.NET ?
a) ** b) + c) / d) %
12) Code that targets the Common Language Runtime is known as
a) Unmanaged b) Distributed
c) Managed Code d) Legacy
13) Which of the following allow writing formatted output ?
a) Response.Write() b) Response.Output.Write()
c) Both a) and b) d) None of the above
14) Which of the following languages can be used to write server side scripting
in ASP.NET ?
a) C# b) C c) Visual Basic d) All of these
15) The Asp.net server control, which provides an alternative way of displaying
text on web page, is
a) <asp:label> b) <asp:listitem>
c) <asp:button> d) None of these
16) CSS stands for ___________
a) Code Server Style b) Cascading Style Server
c) Cascading Style Sheet d) Control Security Style
-3- SLR-R – 13
2. a) Explain Internet Information Server (IIS). 6
b) What is variable ? Explain variable rules in C#. 6
c) Write a program in C# to check the given number is even or odd. 4
3. a) Explain functions in C#. 6
b) What are the OOPs concepts ? 6
c) Explain Common Language Runtime (CLR). 4
4. Write short notes on the following : 16
1) Cookies
2) CSS
3) Application state
4) Command object.
5. a) Discuss on .NET Framework Classes. 8
b) How will you create new web site in ASP.NET (Visual Studio 2008) ? Give
detail steps. 8
6. a) Discuss on State Management in ASP.NET. 8
b) Explain Data types in C#. 8
7. a) Write on Master Pages. 8
b) Explain Data Sets and Data Adapter. 8
_____________________

P.G.D.C.A. (Semester – II) ,Solapur University Question Paper,PROGRAMMING IN C (Paper – IX),2014 Question Paper

Solapur University Question Paper
P.G.D.C.A. (Semester – II) (Old) Examination, 2014
PROGRAMMING IN C (Paper – IX)
Day and Date : Wednesday, 23-4-2014 Total Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q. No. 2, 3 and 4.
3) Attempt any one question from Q. No. 5 and 6.
4) Figures to the right indicate full marks.
1. Choose the single correct alternative : 16
1) Which of the following are format specifiers ?
i) %f ii) %c iii) %q
iv) %z v) %u
a) i), ii), iv) and v) b) ii), iii), iv) and v)
c) i), ii) and v) d) i), ii), iii) and iv)
2) Find invalid rule for an identifier.
a) It can start and end with alphabet
b) It can start and end with digit character
c) It can start and end with underscore
d) All are valid rules
3) Which files contain prototype of standard (library) functions ?
a) .c b) .obj c) .h d) .cpp
4) Which of the following are unary operators ?
i) %(modulus) ii) =(assignment)
iii) –(Subtraction) iv) / (Division)
a) i) and iv) b) only iii) c) i), ii) and iii) d) ii) and iii)
SLR-R – 11 -2-
5) Output of the following code will be
void main( )
{
int x=1,y=2,z=3;
printf(“%d %d %d”, ++x,x+y,z);
}
a) 1 3 3 b) 2 3 3 c) 2 4 3 d) 1 4 3
6) Which operator works like if else ?
a) : : b) ? : c) –> d) >>
7) In for(....) how many semicolons are allowed.
a) <=2 b) exactly 2 c) >=2 d) >=0
8) Output of the following code will be –
void main( )
{
while(4<5)
{
 printf(“hi !”);
}
}
a) hi ! b) hi ! printed infinitely
c) No output d) Error
9) How many times and when memory is allocated to formal parameters ?
a) Only once during compilation time
b) Only once during execution time, at the start of program
c) Only once during execution time, before function call
d) For every call of that function
10) ________________ dimensional array is not possible.
a) 0 b) 2 c) 3 d) 6
-3- SLR-R – 11
11) Which of the following statements are correct regarding arrays :
i) Array is a collection of similar type of elements
ii) Array is a group of same type of variables
iii) Array has sequential storage
a) all are true b) iii) only c) i) and iii) d) ii) and iii)
12) Which storage class is used to increase scope of a variable ?
a) auto b) static c) extern d) register
13) What is the use of fseek( ) function ?
a) Copying data in file
b) Searching a number in file
c) Positioning a file pointer
d) Reading a data at specified location
14) Which of the following can not take file pointer to beginning of file ?
a) rewind( ) b) fseek( ) c) fopen( ) d) fflush( )
15) C language was developed by Deniss Ritchie.
a) True b) False
16) ____________ operator is used to negate the condition.
a) - b) ~ c) ! d) ^
2. a) What is flowchart ? What are the principles of flowcharting ? 6
b) Explain character set, keywords and symbolic constants. 6
c) Write a program to print the largest number among three numbers. 4
3. a) What are the control structures ? Explain bi-directional conditional control
structure with suitable example. 6
b) What is function ? Explain function declaration and function definition with
example. 6
c) What is pointer ? Explain the features of pointer. 4
SLR-R – 11 -4-
4. Write short notes on the following :
a) Pass by reference 4
b) Pointers to structures 4
c) Recursion 4
d) Algorithm. 4
5. a) Discuss on “Operator Precedence and Associativity”. 8
b) Write a program to print the factorial of given number 8
(Use do...while loop).
6. a) What is an array ? Explain it’s types with suitable example. 8
b) Explain structures in brief. 8
7. a) What is file ? Explain different file opening modes. 8
b) Write a program to accept employee details like empno, empname,
joining_date, salary and store in the file EMP.DAT. 8
_____________________