Skip to main content

Wipro DBMS Sample Interview Questions

Question 1
(In DBMS like Oracle) Which of the following allow null values ? A Unique Key or Primary Key ?
Answer :
Primary Key constraint does not allow null values to be inserted while it is legal in case of Unique key.
Question 2
Considering an Oracle database as an example, can NULL values be used in arithmetic operations ? Explain your answer ?
Answer :
No, NULL value cannot be used in arithmetic operation. This is because a NULL just denotes an 'absence' of information rather than 'empty' or 'zero' value.
Question 3
How you can delete a duplicate row from Unique key column?
Answer :
This necessity does not arise. First of all Unique key column will not allow duplicate rows to be inserted.
Question 4
Tell any one advantage of using stored procedures in applications?
Answer :
Stored Procedures abstract complex SQL queries from application code. For example, a task involving multiple lines of complex SQL queries can be simplified to a single stored procedure call.
Labels:

Comments

  1. Anonymous2 September 2013 at 10:13

    I do not even understand how I stopped up right here, however I believed this
    submit used to be good. I don't understand who you might be
    however certainly you're going to a famous blogger should you aren't already.
    Cheers!

    Here is my homepage - The Tao of Badass ()

    ReplyDelete

Post a Comment

Your Comment Here!.....

Popular posts from this blog

CIVIL SERVICES' (I.A.S.) EXAMINATION

The Union Public Service Commission (U.P.S.C.)  conducts Civil Services' Examination once a year in two stages. The Preliminary Examination (Objective Type) for selection of candidates for the Main Examination is held in the month of May. The Civil Services Main Examination  is held in the months of October/November. Blank application forms and other particulars are published in the Employment News, generally in the month of December. The last date for the submission of applications to the Secretary, Union Public Service Commission, Dholpur House, Shahjahan Road, NewDelhi-11001 1 is usually the last week of January of the year of examination. The Combined Civil Services Examination is conducted for Recruitment to the following Services/Posts: 1. Indian Administrative Service. 2. Indian Foreign Service. 3. Indian Police Service. 4. Indian P & T Accounts & Finance Service, Group 'A'. 5. Indian Audit and Accounts Service, Group 'A'. 6. Indian Customs and Centr...
1 comment
Read more

Predict the output or error(s) for the following:

1 . void main(){ int const * p=5; printf("%d",++(*p)); } Answer: Compiler error: Cannot modify a constant value. Explanation: p is a pointer to a "constant integer". But we tried tochange the value of the "constant integer". 2. main() {  char s[ ]="man"; int i;  for(i=0;s[ i ];i++) printf("\n%c%c%c%c",s[i],*(s+i),*(i+s),i[s]); } Answer: mmmm aaaa nnnn Explanation: s[i], *(i+s), *(s+i), i[s] are all different ways of expressing the same idea. Generally array name is the base address for that array. Here s is the base address. i is the index number/displacement from the base address. So, indirecting it with * is same as s[i]. i[s] may be surprising. But in the case of C it is same as s[i]. 3 . main(){  float me = 1.1;  double you = 1.1;  if(me==you) printf("I love U"); else printf("I hate U"); } Answer: I hate U Explanation : For floating point numbers (float, double, long double) ...
Post a Comment
Read more

How do I "get" a null pointer in my programs?

Answer : According to the language definition, a constant 0 in a pointer context is converted into a null pointer at compile time. That is, in an initialization, assignment, or comparison when one side is a variable or expression of pointer type, the compiler can tell that a constant 0 on the other side requests a null pointer, and generate the correctly-typed null pointer value. Therefore, the following fragments are perfectly legal: char *p = 0; if(p != 0) However, an argument being passed to a function is not necessarily recognizable as a pointer context, and the compiler may not be able to tell that an unadorned 0 "means" a null pointer. For instance, the Unix system call "execl" takes a variable-length, null-pointer-terminated list of character pointer arguments. To generate a null pointer in a function call context, an explicit cast is typically required: execl("/bin/sh", "sh", "-c", "ls", (char *)0); If the (c...
Post a Comment
Read more