Related InterviewSolutions

• Which of the constraint can be enforced one per table?(a) Primary key constraint(b) Not Null constraint(c) Foreign Key constraint(d) Check constraintI had been asked this question in class test.My enquiry is from Constraints topic in division Manipulating Data with Select of SQL Server
• Which of the following foreign key constraint specifies that the deletion fails with an error?(a) NO ACTION(b) CASCADE(c) SET NULL(d) All of the mentionedThis question was posed to me during an online exam.My question is taken from Constraints topic in portion Manipulating Data with Select of SQL Server
• How many types of constraints are present in SQL Server?(a) 4(b) 5(c) 6(d) 7This question was posed to me in quiz.My question is taken from Constraints in division Manipulating Data with Select of SQL Server
• Purpose of foreign key constraint in SQL Server is __________(a) FOREIGN KEY constraints identify and enforce the relationships between tables(b) A foreign key in one table points to a candidate key in another table(c) You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value(d) None of the mentionedThis question was addressed to me by my school principal while I was bunking the class.I want to ask this question from Constraints in chapter Manipulating Data with Select of SQL Server
• Which of the following is not a foreign key constraint?(a) NO ACTION(b) CASCADE(c) SET NULL(d) All of the mentionedI have been asked this question in a national level competition.My doubt is from Constraints in chapter Manipulating Data with Select of SQL Server
• Point out the wrong statement.(a) Table constraints must be used when more than one column must be included in a constraint(b) A column constraint is specified as part of a column definition and applies only to that column(c) A table constraint is declared independently from a column definition and can apply to more than one column in a table(d) Primary keys allow for NULL as one of the unique valuesThe question was asked in examination.This is a very interesting question from Constraints topic in division Manipulating Data with Select of SQL Server
• Constraints can be applied on ___________(a) Column(b) Table(c) Field(d) All of the mentionedI got this question during an interview for a job.I want to ask this question from Constraints in section Manipulating Data with Select of SQL Server
• Which of the following constraint does not enforce uniqueness?(a) UNIQUE(b) Primary key(c) Foreign key(d) None of the mentionedThis question was addressed to me in a national level competition.My question comes from Constraints topic in section Manipulating Data with Select of SQL Server
• Which of the following is not a class of constraint in SQL Server?(a) NOT NULL(b) CHECK(c) NULL(d) UNIQUEThe question was asked in a job interview.My question is from Constraints topic in section Manipulating Data with Select of SQL Server
• Point out the correct statement.(a) CHECK constraints enforce domain integrity(b) UNIQUE constraints enforce the uniqueness of the values in a set of columns(c) In a UNIQUE constraint, no two rows in the table can have the same value for the columns(d) All of the mentionedThe question was posed to me in my homework.I'm obligated to ask this question of Constraints topic in portion Manipulating Data with Select of SQL Server