SQL PL/SQL Interview Questions 1

1: What is SQL?
A: SQL stands for 'Structured Query Language'.

2: What is SELECT statement?
A: The SELECT statement lets you select a set of values from a table in a
database. The values selected from the database table would depend on the
various conditions that are specified in the SQL query.

3: How can you compare a part of the name rather than the entire name?
A: SELECT * FROM people WHERE empname LIKE '%ab%'
Would return a recordset with records consisting empname the sequence 'ab' in
empname .

4: What is the INSERT statement?
A: The INSERT statement lets you insert information into a database.

5: How do you delete a record from a database?
A: Use the DELETE statement to remove records or any particular column
values from a database.