SQL Question & Answer Practice

SQL Practice – Questions & Answers

Beginner Level

Q46. What is a database?

Organized collection of data.

Q47. What is a table?

Data stored in rows & columns.

Q48. What is a row?

Single record.

Q49. What is a column?

Field of data.

Q50. What is RDBMS?

Relational Database Management System.

Q51. TRUNCATE.

TRUNCATE TABLE students;

Q52. Difference DELETE vs TRUNCATE.

DELETE can rollback, TRUNCATE cannot.

Q53. VIEW.

Virtual table.

Q54. Stored Procedure.

Reusable SQL block.

Q55. Function.

Returns a value.

Q56. ACID.

Atomicity, Consistency, Isolation, Durability.

Q57. Normalization.

Remove redundancy.

Q58. Denormalization.

Improve performance.

Q59. Indexing.

Improves speed.

Q60. Cursor.

Row-by-row processing.