Following are four different types of constraints in database. You want to enforce referential integrity. Can you identify which of these constraints will you use for that purpose?

Can you identify from the options below, the data type that has the ability to store a whole number between -200 and 200 with the least amount of storage?

Complete the sentence by choosing one of the options. With a relational database you can minimize data that is redundant and index the data in order to retrieve data:

Which command can be used with a previously taken fully backup to recover a database?

You company is operating a database that uses three read/write filegroups. The configuration of database allows the use of Full recovery model. The database needs to have a backup strategy and you decide to prepare it. Following are some requirements that are a must: -Storing backups requires disk space. That disk space must be minimized. -Transaction log backups are required to be replayed while restoration. The number of transaction log backups must be minimized What should your backup plan include?

You create a stored procedure. A UserlD of type int is accepted by the procedure and reflects a concatenated value of FirstName and LastName of the user. Identify the parameter list you should use given the situation above.

Can you identify the form how a relational database stores data about each instance of an entry?

You want to create a database object in which information can be stored. Identify the correct DDL statement for this purpose.

Identify the type of data that can store alphanumeric data between one and five characters. This data type also supports multiple languages. Keep in mind the data type needs minimal storage space for this. Which data type is it?

Following are the columns in the table EmployeeDependents: EmployeelD Spouse Childl Child2 Child3 You want to identify the normalization level of this table. Choose a statement that correctly does that.

You will use a relational database in place of a flat file database because it will:

There is a requirement that says each field value in a table is associated with only one row. Can you identify which form of database normalizing can this be?

You want to optimize how the underlying data is accessed by queries physically. Identify the database object you must create.

A COLLATE clause is included in a column definition. What could be the purpose of that?

Following is the statement you used to create an empty Product Table: CREATE TABLE Product ProdID int PRIMARY KEY, CategorylD int NOT NULL, Description varchar(35), QtyOnHand int CHECK (QtyOnHand > 0 AND QtyOnHand <= 50)) Can you identify the statement with which you can insert data into the Product table successfully?

You have employees working in the Market Analysis department. These users need data from the Customers table and the SalesHistory table. They have to retrieve data by issuing a SELECT statement. They must be prevented from accessing the data in CreditCard or Expiration column of the Customers table. Identify the statement you would use to create the object.

There is a relational database table with a single nonclustered index. Can you identify the data structure that can physically store data in that type of relational database table?

Can you identify one valid difference between a function and a stored procedure?

From the options below, can you identify a server scoped securable?

There is a data type that can store a floating-point value between 0 and 200,000 to four decimal places of accuracy with the least amount of required storage. Can you identify which of the following is that type?

You want to provide a user specific permission on a database object. You also want that user to be able to pass along permissions to other users when needed. What would be your step of action?

You want to denormalize a database. Can you identify one reason of doing that?

From the following options, choose the right clause of an UPDATE statement that specifies the columns to be updated and also specifies the values to which they should be updated?

You need to identify the index that includes all columns a query has used.