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?
  •  

No comments:

 
Top Blogs