Database developer interview questions

Are you a Database Administrator? Need to update DBA technical knowledge or need to prepare for a job interview? Check out this collection of Database developer interview questions...

Which of the following has the highest order of precedence?
When designing a database table, how do you avoid missing column values for non-primary key columns?
Which of the following is the syntax for creating an Index?
Which of the following is not a valid character datatype in SQL Server?
Which of the following statements about SQL Server comments is false?
Consider the following transaction code
Which of the following constraints can be used to enforce the uniqueness of rows in a table?
Which of the following are not date parts?
The IF UPDATE (column_name) parameter in a trigger definition will return TRUE in case of an INSERT statement being executed on the triggered table
Which one of the following must be specified in every DELETE statement?
Which one of the following correctly selects rows from the table myTable that have null in column column1?
Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
Which of the following commands is used to change the structure of table?
When designing a database table, how do you avoid missing column values for non-primary key columns?
Which of the following is the syntax for creating an Index?
Which of the following constraints can be used to enforce the uniqueness of rows in a table?
Which one of the following must be specified in every DELETE statement?
Is this statement true or false: A cursor is a pointer that identifies a specific working row within a set
Which of the following commands is used to change the structure of table?