Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
Which of the following is FALSE regarding FOREIGN KEYS in SQL Server 2012?
FOREIGN KEY constraints can reference only tables within the same database on the same server (unless triggers are used)
FOREIGN KEY constraints are applied to the preceding column, unless source columns are specified
FOREIGN KEY constraints are not enforced on temporary tables
FOREIGN KEY constraints cannot reference another column in the same table
That was the correct answer, well done!
Sorry, that was the wrong answer
FOREIGN KEY constraints can reference another column in the same table. This is referred to as a self-reference.
Move on to the next question
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Copyright © Accelerated Ideas 2005-2017
All rights reserved