Answers --- Interview Questions for SQL - 1

Q1. What are SQL functions?

Ans: SQL functions are

• Execute queries against a database
• Retrieve data from a database
• Insert records in a database
• Update records in database
• Delete records from a database
• Create new database
• Create new tables in a database
• Create stored procedures in a database
• Create views in a database

Q2. "SQL is not case sensitive.". Is this statement true or false?

Ans: True

Q3. What is SQL?

Ans: SQL is a structured query language for accessing and manipulating databases. It is an "American National Standards Institute" Standard(ANSI).

Q4. "Some database systems require a semicolon at the end of each SQL statement.". Is this statement true or false?

Ans: True

Q5. What is RDBMS?

Ans: RDBMS stands for Relational Database Management System. A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as invented by E. F. Codd, of IBM's San Jose Research Laboratory.