SASANK@TECHNOMANIA

A comprehensive repository of commonly asked Interview Q&A and a collaboration tool for sharing them.Contains questions from most of the possible topics asked in interviews.. This site provides answers to all these most frequently asked interview questions and also answers to these questions!. Most of the interviews conducted by leading IT companies hover around the questions. visit http://www.cracktheinterview.org/ for...

hare2diggsdiggmail share /**/ As widely expected, Facebook has announced that it has passed the 500 million member mark. In a blog post, CEO Mark Zuckerberg writes that, “I could have never imagined all of the ways people would use Facebook () when we were getting started 6 years ago. I want to thank you for being part of making...

Oracle Interview Questions and Answers : SQL 1.     To see current user name  Sql> show user; 2.     Change SQL prompt name  SQL> set sqlprompt “Manimara > “ Manimara > Manimara > 3.     Switch to DOS prompt  SQL> host 4.     How do I eliminate the duplicate rows ?  SQL> delete from table_name where rowid not in (select max(rowid) from table group...

1. Explain the difference between a database administrator and a data administrator. Database Administrator :- A person (or group of people) responsible for the maintenance and performance of a database and responsible for the planning, implementation, configuration, and administration of relational database management systems. Data Administrator :- The individual or organization responsible for the specification, acquisition,...

...

Question: What are the wildcards used for pattern matching. Answer: _ for single character substitution and % for multi-character substitution.  Question: How can I hide a particular table name of our schema? Answer: you can hide the table name by creating synonyms.  e.g) you can create a synonym y for table x  create synonym y for x;  Question: When we give SELECT * FROM EMP; How does oracle respond: Answer:...