The Productlnventory table and the ReorderList table are shown in the exhibit. The ReorderlD column is an identity column. The ReorderList table stores a record for each product that has been ordered. You need to add rows to the ReorderList table that includes the ProductlD, the current date, and a Quantity of 100 for all products that have a Quantity of 0 in the Productlnventory table. Which statement should you use?
- C. INSERT INTO ReorderList (ProductID, ReorderDate, Quantity) VALUES (SELECT ProductiD FROM Productlnventory WHERE Quantity = 0, getdateQ, 100)
Which data type can store a whole number between -200 and 200 with the least amount of storage?
Using a relational database allows you to minimize redundant data and index the data so data can be retrieved:
You are creating a stored procedure that accepts a UserlD of type int and retrieves a value that is the concatenated FirstName and LastName values for the user. Which parameter list should you use?
- A. UserlD int
- D. @UserlD int
Which type of constraint is used to enforce referential integrity?
You are creating a relational database that includes the tables shown in the exhibit. The InStock and OnOrder columns should have a value of 0 if no value is specified. You have already created the Products table and the Stores table, and need to create the Inventory table. Which statement should you issue?
- A. Create a table that has a single PRIMARY KEY constraint, two FOREIGN KEY constraints, and two DEFAULT constraints.
- B. Create a table that has two PRIMARY KEY constraints, two FOREIGN KEY constraints, and two columns that allow Nulls.
- C. Create a table that has two PRIMARY KEY constraints, two FOREIGN KEY constraints, and two DEFAULT constraints
Which command can be used with a previously taken fully backup to recover a database?
You have a database that uses three read/write filegroups. The database is configured to use the Full recovery model. You are planning the backup strategy for the database. You need to meet the following requirements: • Disk space required to store the backups should be minimized • The number of transaction log backups that need to be replayed during restoration should be minimized What should your backup plan include?
How is data about each instance of an entiry stored in a relational database?
Which DDL statement should you use to create a database object that can store information?
You are designing a database to track customer and sales information. You want to minimize redundant data that will be stored in the database. Each customer can place one or more orders. For each order, the customer may order one or more products sold by your company. Which tables should your database design include?
What data type can store between one and five characters of alphanumeric data and supports multiple languages with minimal storage space requirements?
The EmployeeDependents table includes the following columns: EmployeelD Spouse Childl Child2 Child3 Which statement correctly identifies the normalization level of this table?
A reason to use a relational database instead of a flat file database would be to:
The requirement that each field value in a table is associated with only one row, is an example of normalizing a database to which form?
You need to create a module that performs the following tasks: • Accepts an order number • Sets the value of the Status column in the Orders table for that order number to Shipped * Retrieves a tracking number from a table ' Logs shipping information to the Shipping table ▪ Returns the number of items shipped and the customer's e-mail address What should you create?
Which database object should you create to optimize how the underlying data is phycially accessed by queries?
What is the purpose of including a COLLATE clause in a column definition?
Your database includes the tables shown in the exhibit. You need to allow users to query the ProductlD, StorelD, Description, and Price for only products at stores in California. Which statement should you use?
You have an empty Product table that you created with the following statement: CREATE TABLE Product ProdID int PRIMARY KEY, CategorylD int NOT NULL, Description varchar(35), QtyOnHand int CHECK (QtyOnHand > 0 AND QtyOnHand <= 50)) Which statement will successfully insert data into the Product table?
- C. INSERT INTO Product (ProdID, CategorylD, Description, QtyOnHand) VALUES (101, 2, 'Oval Wall Mirror', 65)
Users in the Market Analysis department require data from the Customers table and the SalesHistory table. They need to be able to issue a SELECT statement that retrieves the data. They should not be able to access the CreditCard or Expiration column of the Customers table. Which statement should you use to create the object?
What data structure physically stores data in a relational database table that has a single nonclustred index?
What is one difference between a stored procedure and a function?
Which of the following is a server scoped securable?
Which data type can store a floating point value between 0 and 200,000 to four decimal places of accuracy with the least amount of required storage?
An index that includes all column used by the query is known as a :
What should you do to allow a user specific permissions on a database object and also allow the user to pass along those permissions to others?
What is one reason to denormalize a database?
Which clause of an UPDATE statement specifies the columns to be updated and the values to which they should be updated?
A table named Members exists in a SQL Server 2008 database. The table has a column named Mernt that is configured as an Identity column. You need to write a query that creates a row for a member named Renee Smith with a MemberlD of ; Which Transact-SQL should you use?
- B. SET IDENTITY INSERT Members ON GO INSERT INTO Members (MemberlD, FirstName, LastName) VALUES (75, 'Renee', 'Smith') SET IDENTITY INSERT Members OFF
- C. INSERT INTO Members (FirstName, LastName) VALUES ('Renee', 'Smith') UPDATE Members SET MemberlD = 75 WHERE FirstName='Renee' AND LastName='Smith'
About Individual Course:
|Learning Style||Self-Paced Learning|
|Course Duration||1 Hour|