Quizzes, Questions & Answers

Recent Quizzes

Designing And Implementing Databases With SQL Server 2000 Quiz

Designing and Implementing Databases with SQL Server 2000 Quiz

Welcome to the "Designing and Implementing Databases with SQL Server 2000" Quiz! This specialized quiz is aimed at IT professionals, database administrators, and students who want to test their knowledge and skills on...

Questions: 40 | Attempts: 670 | Last updated: May 8, 2024

Sample Question
You are a database developer for wide world importers. You are creating a database that will store order information. Orders will be entered in a client/server application. Each time a new order is entered, a unique order number must be assigned. Order numbers must be assigned in ascending order. An average of 10, 000 orders will be entered each day. You create a new table named Orders and add an OrderNumber column to this table. What should you do next?

Set the data type of the column to uniqueidentifier.

Set the data type of the column to int. Create a user-defined function that selects the maximum order number in the table.

Set the data type of the column to int. Create a NextKey table, and add a NextOrder column to the table. Set the data type of the NextOrder column to int. Create a stored procedure to retrieve and update the value held in the NextKey.

Set the data type of the column to int, and set the IDENTITY property for the column.

« Previous 1...6 7 8 910Next »