SQL Server 2000 Which of the following is a way to create and modify tables using SQL Server? Both of the two methods above will work Use the graphical facilities of SQL Server Enterprise Manager only Neither of the two methods above will work Write SQL code using either CREATE or ALTER SQL statements only Both of the two methods above will work Use the graphical facilities of SQL Server Enterprise Manager only Neither of the two methods above will work Write SQL code using either CREATE or ALTER SQL statements only ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports two kinds of indexes: clustered and nonclustered. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 SQL Server supports INSTEAD OF, AFTER and BEFORE triggers. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Which of the three possible types of triggers does SQL Server support? INSTEAD OF and AFTER only BEFORE only AFTER only INSTEAD OF only INSTEAD OF and AFTER only BEFORE only AFTER only INSTEAD OF only ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures? # @ % & # @ % & ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS