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

Introduction to JavaScript- Basics

JavaScript is the most popular scripting language on the internet, and works in all major browsers, such as Internet Explorer, Firefox, Chrome, Opera, and Safari. What You Should Already Know Before you continue you should have a basic understanding of the following: HTML and CSS If you want to study these subjects first, find the tutorials on our Languages page . What is JavaScript? JavaScript was designed to add interactivity to HTML pages JavaScript is a scripting language A scripting language is a lightweight programming language JavaScript is usually embedded directly into HTML pages JavaScript is an interpreted language (means that scripts execute without preliminary compilation) Everyone can use JavaScript without purchasing a license Are Java and JavaScript the same? NO! Java and JavaScript are two completely different languages in both concept and design! Java (developed by Sun Microsystems) is a powerful and much more complex programming language ...
Post a Comment
Read more

How to prepare for interview? follow the steps.

Interview Preparation  Research is a critical part of preparing for an interview. If you haven't done your homework, it is going to be obvious. Spend time researching and thinking about yourself, the occupation, the organization, and questions you might ask at the end of the interview. Step 1: Know Yourself The first step in preparing for an interview is to do a thorough self-assessment so that you will know what you have to offer an employer. It is very important to develop a complete inventory of skills, experience, and personal attributes that you can use to market yourself to employers at any time during the interview process. In developing this inventory, it is easiest to start with experience. Once you have a detailed list of activities that you have done (past jobs, extra-curricular involvements, volunteer work, school projects, etc.), it is fairly easy to identify your skills. Simply g...
Read more

Cognizant Company Profile and it's information for Interview

Website: www.cognizant.com HQ Teaneck, NJ Industry Information Technology Services Size 130K+ Employees, $6B+ Revenue NASDAQ CTSH Competitors Infosys, Wipro, Tata Consultancy Services   About cognizant Cognizant Corporate view: Cognizant is an American multinational IT services and consulting corporation headquartered in Teaneck, New Jersey, United States. Cognizant has been named to the 2010 Fortune 100 Fastest-Growing Companies List for the eighth consecutive year. Cognizant has also been named to the Fortune 1000 and Forbes Global 2000 lists. It has consistently ranked among the fastest growing companies including the 2010 Business Week 50 list of the top-performing U.S. companies, the Business Week Hottest Tech Companies 2010, and the Forbes Fast Tech 2010 list of 25 Fastest Growing Technology Companies In America. Founded: 1994 Headquarters: Teaneck, New Jersey, U.S. Key people:  Francisco D'Souza (President & CEO) Lakshmi Naray...
Post a Comment
Read more