Option - Databases

Which of the following is a primary key in a database table?

In SQL, which command is used to remove all records from a table but keep the table structure?

What is the purpose of a foreign key in relational databases?

Consider a table STUDENTS with columns (RollNo, Name, Marks). Which SQL query will display the names of students who scored more than 75 marks?

Which normal form eliminates partial dependency in a relational database?

In the context of database transactions, what does ACID stand for?

Which SQL clause is used to combine rows from two or more tables based on a related column between them?

Given two tables: EMPLOYEE(EmpID, DeptID, Name) and DEPARTMENT(DeptID, DeptName), which SQL query retrieves all employees along with their department names?

What is the result of the following SQL query? SELECT COUNT(DISTINCT City) FROM STUDENTS;

In database indexing, which data structure is most commonly used to improve the speed of data retrieval?