1. What is SQL? 2. What is the difference between SQL and ORACLE? 3. What is called self join? 4. Please describle Insert,Update and Delete statement. 5. How do you join outer join in in MySql? Hope you guys know these questions answers.
Those are very basic questions. If you don't know them, maybe you shouldn't be interviewing for that position
Question #2 is for people who haven't learned anything about databases yet - it's pre-"very basic". And if it's asked, you can bet that the person asking it is an HR type, not a tech type. I'd rather see a question like "what's the maximum number of selects you can use in a union in X database?"
I am trying .... -SQL is structure query language. -ORACLE is most widely used database in corporate world - -insert for inserting raw data into database,update is for updating the data ,delete for delete item for any database -
These all are very easy and simple question. Just go to Google you have will get the answers very easily in details.
#1 SQL stands for Structured Query Language. It is a logical plain English coding language which allows users to interrogate and manipulate databases, bringing back answer sets containing records that match search criteria. #4 INSERT - Used for importing data into a table, whether this be from an already existing table or external source (such as an excel doc) UPDATE - Used for updating records in a table. DELETE - allows you to delete records from tables. Again probably should just Google it.
1. What is SQL? SQL stands for structured query language. It is a language that is designed for managing the data RDBMS.Its scopes used insert, delete, update queries. 2. What is the difference between SQL and ORACLE? Oracle is an object relational database management system, which allows objects to be stored in tables, in a manner similar to numbers and words being stored in an RDBMS system SQL SQL stands for structured query language. It is a language that is designed for managing the data RDBMS.Its scopes used insert, delete, update queries. 3. What is called self join? A JOIN is a means for combining fields from two tables by using values common to each. ANSI standard SQL specifies four types of JOIN: INNER, OUTER, LEFT, and RIGHT. As a special case, a table (base table, view, or joined table) can JOIN to itself in a self join. 4. Please describle Insert,Update and Delete statement. -Insert means used to insert new rows in a database. -Delete means used to delete rows from the database. -Update means used to update or edit data from the database.