Question 1
What does the ACID property 'Atomicity' ensure in SQL transactions?
Question 2
Which type of Join returns all rows when there is a match in either table?
Question 3
What type of SQL function returns a single value for each row?
Question 4
Which type of SQL Index alters the physical storage order of the data?
Question 5
In SQL, which constraint ensures that all values in a column are unique?
Question 6
Which subset of SQL is used to manage transaction operations?
Question 7
What type of integrity does a Foreign Key primarily maintain?
Question 8
What SQL command is used to display the current date?
Question 9
Which level of normalization aims to eliminate partial dependency?
Question 10
What is a key difference between DELETE and TRUNCATE commands in SQL?
Question 11
What does TCL stand for in SQL?
Question 12
What is the primary purpose of a trigger in SQL?
Question 13
Which SQL command is used to count the number of rows in a table?
Question 14
Which type of database management system is MySQL?
Question 15
What is the primary difference between CHAR and VARCHAR data types?