Question 49: A developer plans to use data-bound controls to display data in an ASP.NET application. This will include both list controls and template controls. The data will be supplied through several different data sources.
Which of the following scenarios will require the use of the DataBinder.Eval method to display data?
A. When it is necessary to evaluate late-bound data-binding expressions
B. When the data source does not support the IList interface
C. When binding any data to a list control
D. When the data source does not support the IEnumerable interface
E. When the data must be bound to non-database content
Question 50: Which of the following statements accurately describe a function of the SQL Server 2000 trigger in the script below?
CREATE TRIGGER conditionalinsert
ON Sales
AFTER INSERT AS
IF
(SELECT COUNT(*) FROM Titles, Inserted
WHERE Titles.title_id = Inserted.title_id) <> @@ROWCOUNT
BEGIN
DELETE Sales FROM Sales, Inserted
WHERE Sales.title_id = Inserted.title_id AND
Inserted.title_id NOT IN
(SELECT title_id
FROM Titles)
PRINT 'Only sales records with matching title_ids added.'
END
A. When unacceptable titles have been inserted, the transaction is not rolled back.
B. When unacceptable titles have been inserted, the trigger deletes the unwanted rows from the Titles table.
C. When unacceptable titles have been inserted, the trigger deletes the unwanted rows from the Sales table.
D. When the number of rows in the Sales table exceeds the number of rows in the Titles table, the trigger deletes rows from the Sales table.
E. The trigger displays the message when a row from the Sales table is deleted.
Question 51: An application needs to parse the contents of XML files before displaying the contents on the console. The files do not need to be validated but an exception needs to be thrown if the files are not well-formed and the parsing must be done as quickly as possible. Which of the following solutions meet these requirements?
A. Load the files through an XMLTextReader object, displaying the contents to the console as they're parsed.
B. Load the files through an XMLTransform object, displaying the contents to the console as they're parsed.
C. Load the files into an XMLDocument object and then iterate over the DOM's nodes to display the contents on the console.
D. Load the files into an XMLDataDocument object and then iterate over the DOM's nodes to display the contents on the console.
E. Load the files through an XMLValidatingReader object, displaying the contents to the console as they're parsed.
|
| Author: Aravind PK 14 May 2008 | Member Level: Gold | Rating:  Points: 2 |
Ques 50: (D)
|