Correct Answer : Natural join
Explanation : A NATURAL JOIN is an inner join where the RDBMS automatically selects the join columns based on common columns names. Some RDBMS vendors, like Oracle but not SQL Server, implement a NATURAL JOIN operator.
Correct Answer : Master
Explanation : The master database records all of the system level information for a SQL Server system.
Correct Answer : Model
Explanation : When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database.
Correct Answer : Msdb
Explanation : The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.
