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.

Comments

  1. 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

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...

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...

Infosys delays 17,000 campus recruitment offers

Bangalore: With a challenging environment, and low visibility into client spend, Infosys has said that it will be deferring joining dates, and the management is also putting some cost saving measures in place, reports Shreya Roy of CNBC-TV18. Infy had decided that with its current business needs in mind it will defer its campus recruitment process. The company had initially made 27,000 campus offers, but now the company says that 17,000 of these will be deferred by up to three months. However, the firm has reiterated that it plans to honour each of these offers in due course of time. In fact the company which prided itself on a six-month long extensive training programme for fresh intakes has also decided to cut the period short by two months, four months of this training programme will be conducted at its sprawling Mysore campus, while two months will be an online programme. With a challenging environment, and low visibility into client spend, Infy said it will delay...