John works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server
database. John wants to insert records in a table where the database is structured in a fixed format.
Which of the following data models will he use to accomplish the task?

You manage a database named Customers, which includes a table named Orders. The Orders table is
frequently queried, but only orders with a sales total of more than $1000.00 are required in the
query. You want to create an index to speed up these types of queries at the same time, ensuring
the index is as small as possible. What type of index should you use?

Which of the following database terms is described in the statement below? “It prevents the current
database operation from reading or writing a data item while the data item is being accessed by
another operation.”