Microsoft 70-461 Online Practice Questions and Exam Preparation

Microsoft 70-461 Online Questions & Answers

• Question 231:

  Which of the following columns would be appropriate as a surrogate key? (Choose all that apply.)

  A. The time (in hundredths of a second) that the row was inserted
  B. An automatically increasing integer number
  C. The last four digits of a social security number concatenated with the first eight digits of a user's last name
  D. A uniqueidentifier (GUID) newly selected from SQL Server at the time the row is inserted
  B. An automatically increasing integer number
  D. A uniqueidentifier (GUID) newly selected from SQL Server at the time the row is inserted

• Question 232:

  What kind of optimizer hints does SQL Server 2012 support? (Choose all that apply.)

  A. Query
  B. Join
  C. Order
  D. Table
  A. Query
  B. Join
  D. Table

• Question 233:

  What kind of XML indexes can you create? (Choose all that apply.)

  A. PRIMARY
  B. PATH
  C. ATTRIBUTE
  D. PRINCIPALNODES
  A. PRIMARY
  B. PATH

• Question 234:

  In which case out of the following are you normally not allowed to specify the target column in an INSERT statement?

  A. If the column has a default constraint associated with it
  B. If the column allows NULLs
  C. If the column does not allow NULLs
  D. If the column has an IDENTITY property
  D. If the column has an IDENTITY property

• Question 235:

  How do the inserted and deleted tables work with a DML statement in an AFTER trigger?

  A. For a DELETE statement, the inserted table contains new rows and the deleted table contains the deleted rows.
  B. The inserted table only contains rows from the INSERT statement, and the deleted table contains only rows from the DELETE statement.
  C. For an INSERT statement, the inserted table contains new rows and the deleted table is empty.
  D. For an UPDATE statement, the inserted table is empty and the deleted table contains all the changed rows.
  C. For an INSERT statement, the inserted table contains new rows and the deleted table is empty.

• Question 236:

  You develop a Microsoft SQL Server database that contains a table named Products. The Products table has columns named ProductId, CategoryId, Name, and Price. Product prices are often updated as follows:

  For a single product by a specific value by using the ProductId column For an entire category by a percentage by using the CategoryId column

  You need to log the change price to a new table named PriceChange by using the ProductId' ChangedValue, and ChangedDate columns. You also need to ensure that increases in price are recorded as positive values and decreases in price as negative values.

  Which Transact-SQL query should you use?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

  ---

  Incorrect Answers:

  A, B: Price change would be displayed incorrectly. Price increases would be displayed as negative numbers.

• Question 237:

  How can you use output parameters in T-SQL stored procedures? (Choose all that apply.)

  A. You can pass data into a procedure by using an output parameter, but you cannot receive information back from it.
  B. You can pass data into a procedure by using an output parameter, and any change made to the parameter will be passed back to the calling routine.
  C. You cannot pass data into a procedure by using an output parameter; it is only used for passing data back to the caller.
  D. You cannot pass data into a procedure by using an output parameter, nor can you receive data back from a procedure from an output parameter.
  B. You can pass data into a procedure by using an output parameter, and any change made to the parameter will be passed back to the calling routine.

• Question 238:

  What is the importance of the ability to assign attribute aliases in T-SQL? (Choose all that apply.)

  A. The ability to assign attribute aliases is just an aesthetic feature.
  B. An expression that is based on a computation results in no attribute name unless you assign one with an alias, and this is not relational.
  C. T-SQL requires all result attributes of a query to have names.
  D. Using attribute aliases, you can assign your own name to a result attribute if you need it to be different than the source attribute name.
  B. An expression that is based on a computation results in no attribute name unless you assign one with an alias, and this is not relational.
  D. Using attribute aliases, you can assign your own name to a result attribute if you need it to be different than the source attribute name.

• Question 239:

  What are the mandatory clauses in a SELECT query, according to T-SQL?

  A. The FROM and SELECT clauses
  B. The SELECT and WHERE clauses
  C. The SELECT clause
  D. The FROM and WHERE clauses
  C. The SELECT clause

• Question 240:

  You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements.

  -Takes an input parameter.

  -Returns a table of values.

  -

  Can be referenced within a view. Which object should you use?

  A. inline table-valued function
  B. user-defined data type
  C. stored procedure
  D. scalar-valued function
  A. inline table-valued function

  ---

  Incorrect answers:

  Not B: A user-defined data type would not be able to take an input parameter.

  Not C: A stored procedure cannot be used within a view.

  Not D: A scalar-valued would only be able to return a single simple value, not a table.