SASANK@TECHNOMANIA

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