- Waterfall model - What is cursor in SQL - Normalization and denormalization - SDLC Lifecycle - Why we need SQL - Function and procedure in SQL - What are the main blocks of T-sql or Pl-sql - Column in left table is NULL and Column in right table is NULL, if we compare both then what will be the final output?

Question

Accepted Answer

Interview questions for Database Developer

Waterfall model is a linear approach to software development
Cursor is a database object used to manipulate data row by row
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity, while denormalization is the process of intentionally introducing redundancy to improve performance
SDLC Lifecycle is a process followed by a development team to create a software product
SQL is used to manage and manipulate relational databases
Functions and procedures are used to encapsulate a set of SQL statements for reuse
T-SQL and PL/SQL are the main blocks of SQL used in Microsoft SQL Server and Oracle databases respectively
If both columns are NULL, the output will be NULL when comparing them

Popular interview questions of Database Developer