QA Tester Sql Interview questions

QA Tester Sql Interview questions

• What does RDBMS stand for?
• What do DDL, DML and DCL stand for?
• What is a primary key?
• What is the main role of a primary key in a table?
• What is a foreign key?
• Can a table have more than one foreign key defined?
• What types of joins are possible with database server?
• What's the difference between an inner join and an outer join?
• What is a stored procedure?
• What is trigger?
• What is view?
• What is cursor?
• What is difference between DELETE, TRUNCATE and DROP commands?
• Explain the difference between function and stored procedure?
• What is SQL Profiler?
• What default TCP Port is Microsoft SQL Server running under?
• What default TCP Port is Oracle SQL Server running under?
• What default TCP Port is MySQL running under?
•