Advanced SQL – True or False 1. Triggers are stored blocks of code that have to be called in order to operate. A. True…
Advanced SQL – General Questions 1. What type of join is needed when you wish to include rows that do not have matching…
SQL Server 2000 – True or False 1. There is only one way to create and modify tables in SQL Server. Write SQL code using…
SQL Server 2000 – General Questions 1. With which type of SQL Server recovery model are all database changes logged except those that cause…
SQL for Database Construction – True or False 1. The SQL statement used to create a view is CREATE VIEW. A. True B. False 2. The…
SQL for Database Construction – General Questions 1. The SQL command to create a table is: A. MAKE TABLE. B. ALTER TABLE. C. DEFINE TABLE.…