70-561-VB Study Notes: Exam Passing Tips

June 21st, 2009 by uCertify Leave a reply »
    Connecting to Data Sources (12 percent)

  • The NT LAN Manager Security Support Provider (NTLMSSP) is a binary messaging protocol used by the Microsoft Security Support Provider Interface.
  • The Integrated Security keyword whenever set to false, user ID and password have to be specified in the connection string. However, whenever it set to true, the current Windows account credentials are used for authentication.
  • The DbProviderFactory class is used to represent a set of methods for creating instances of a provider’s implementation of the data source classes.
  • The Persist Security Info property is used to specify whether the data source can persist sensitive authentication information such as a password.
  • The Open method of the SqlConnection Class is used to open the connection to a database so that an application is able to retrieve data from the database.
  • The OleDbConnection class represents an open connection to an OLE DB data source, a Microsoft SQL Server 7.x database, or earlier version.
  • The OleDbCommand class represents a stored procedure or a SQL statement to execute at a data source.
  • The Min Pool Size value of the ConnectionString property of the SqlConnection class is used to specify the minimum number of connections allowed in a pool.
  • The ConnectionString property of the SqlConnection class is used to connect to a data source.
  • The ConnectionString property of the SqlConnection class is used to connect to a data source.
  • The Data Source attribute of the ConnectionString property specifies the name or the network address of the server instance to which a connection is to be established.
  • The Initial Catalog attribute of the ConnectionString property specifies the name of the database.
  • The Min Pool Size value of the ConnectionString property of the SqlConnection class is used to specify the minimum objects in the connection pool.
  • The Connection Timeout parameter of the ConnectionString property specifies the time period (in seconds) required to wait for a connection to the server.
  • The Max Pool Size parameter of the ConnectionString property determines the maximum number of connections allowed in the connection pool.
  • SQL Server Configuration Manager and Surface Area Configuration Manager tools are used to configure and enable database connection.
  • Multiple Active Result Sets (MARS) is a feature of ADO.NET. It allows execution of multiple batches on a single database connection.
  • Stored procedures can be used to implement business logic or be used as a security mechanism.
  • The ReleaseObjectPool method of the OleDbConnection class is used to specify that an OleDbConnection object pool can be released as soon as the last connection is released.
  • Use the Pooling = False connection string attribute to tell the .NET data provider that you do not want to pool the connection.
  • Multiple Active Result Sets (MARS) is a latest feature supported by ADO.NET 2.0. MARS allows the execution of several batches on a particular connection.
  • SQL Server Embedded Edition (SSEE) is a specially configured named instance of the SQL Server Express database engine, which can be accessed only by certain Windows services.
  • SQL Server Express Edition is a free edition of SQL Server, which includes the core database engine. While there are no limitations on the number of databases or users supported, it is limited to using one processor, GB memory and GB database files.
  • A DataReader object not only retrieves a read-only, forward-only stream of data from a database but also offers better performance than reading data into a DataSet object.
  • The OLE DB .NET data provider is used by applications to connect to a SQL Server 2005 database or its earlier versions. The ODBC .NET data provider can be used to create a connection with any data source that can be accessed through ODBC.
  • The AcceptChanges method of the DataTable class commits all changes made to a table since the AcceptChanges method was last called.
  • The DataRelation class represents a parent/child relationship between the matching columns in the parent and child tables.
  • The OleDbDataAdapter class is used to represent a database connection and a set of data commands that are used to fill the DataSet and update the data source. It is used as a bridge between a DataSet and data source to save and retrieve data.
  • The SqlConnection class represents an open connection to a Microsoft SQL Server. It is used to represent a unique session to a Microsoft SQL Server 7.x database or later.
  • The Fill method of the SqlDataAdapter class is used to add or refresh rows in a DataSet to match rows in the data source. This method can also be used to populate a DataSet object.
  • The Prepare method of the SqlCommand class is used to create a prepared version of the command on an instance of SQL Server. This method prepares a compiled version of the command on the data source.
  • The CommandType property specifies how the command string is interpreted. The SqlParameter class represents a parameter to a SqlCommand object. The SqlParameter constructor accepts two parameters, parameter name and its datatype.
  • The Direction property of the SqlParameter class is used to get or set a value, which indicates the type of a parameter. A parameter can be input-only, output-only, bi-directional, or a stored procedure return value parameter.
  • The Database property of the OleDbConnection class is used to get the name of the current database.
  • The ResetCommandTimeout method of the SqlCommand class is used to reset the CommandTimeout property to the default value, i.e. seconds.
  • The DbConnectionStringBuilder class is used to provide a base class for strongly typed connection string builders. The connection string builders allow developers to create syntactically correct connection strings, and parse and rebuild existing connection strings.
  • The DbCommandBuilder is used to provide the convenience to provider writers for creating their own command builders. Developers can implement provider specific behavior in their own code by using this class.
  • The IdentifierCase enumeration is used to specify how identifiers are treated by a data source when searching a system catalog.
  • The DbMetaDataCollectionNames class is used to provide a list of constants for the well known MetaDataCollections such as the DataSourceInformation.
  • The SqlDataAdapter class is used in conjunction with the SqlConnection and SqlCommand classes to enhance the performance while connecting to a SQL Server database.
  • The Unrelated member of the GroupByBehavior enumeration is used to specify that there is no relationship between columns in the GROUP BY clause and the non-aggregated columns in a SELECT list.
  • The ResourceManager class provides access to culture-specific resources at runtime. It looks up culture-specific resources, provides resource fallback when a localized resource does not exist, and supports resource serialization.
  • The SqlConnection class represents an open connection to a SQL Server database.
  • ADO.NET supports connection pooling where the SqlConnection class is used to improve the performance of the application.
  • The DataAdapter class raises DBConcurrencyException, if the update operation does not affect any row.
  • The InnerException property of the SqlException class is used to get the Exception instance that caused the current exception.
  • Named parameters are non-compulsory parameters and can be specified in any order following any positional parameters.
  • The Class property of the SqlException class is used to get the severity level of the error returned from the .NET Framework Data Provider for SQL Server. A value from to decides the severity level of an error.
  • Whenever rows in the master (referenced) table are deleted, the respective rows of the child (referencing) table with a matching foreign key column will get deleted as well. This is called a cascade delete.
  • An InvalidCastException is thrown when a user tries to load data that does not match the datatype specified for the column.
  • The SqlException exception is raised, if an error occurs on executing a stored procedure and SQL Server returns an error or warning.

    • Selecting and Querying Data (22 percent)

  • The Database property of the OleDbConnection class is used to get the name of the current database.
  • The ExecuteScalar method of the SqlCommand class is used to execute query commands that return a single value such as an average from a data source irrespective of the number of rows actually selected.
  • The SqlDataReader class avoids creating unnecessary objects or making unnecessary copies of data. Hence, it provides optimal performance.
  • A stored procedure should be used instead of any dynamic command text, because it does not need to be compiled or interpreted by the client application each time the program is being executed.
  • Initialize a Command object in such a way that it uses the GetCustOrdHist stored procedure and returns the details for @CustomerID with a value of “WILLI”.
  • The ROWNUM pseudo column is used to avoid a massive sort of large result sets.
  • An index is a data structure that improves the performance of queries issued against a table. The partitioning of large data tables is implemented to improve data access speed.
  • The ApplyDefaultSort property of the DataView object is used to automatically sort data, in ascending order, based on the primary key column(s) of a table. This property applies to a table only when the table has a primary key defined and the Sort property of the DataView object is set to a null reference or an empty string.
  • The ApplyDefaultSort property of the DataView class is used to automatically sort data in ascending order based on the primary key column(s) of a table. This property applies to a table only when the table has a primary key defined and the Sort property of the DataView object is set to a null reference or an empty string.
  • The ResetCommandTimeout method of the SqlCommand class is used to set the CommandTimeout property to the default value, i.e. seconds.
  • The Read method of the SqlDataReader class advances the SqlDataReader object to the next record if the next record exists. It returns true if another record exists. Otherwise, it returns false.
  • The ExecuteReader method of the SqlCommand class is used to send the CommandText to the Connection and builds a SqlDataReader.
  • SqlDataAdapter is a class used to represent a set of data commands and a database connection that are used to fill a DataSet and update a SQL Server database.
  • The ExecuteScalar method of the SqlCommand class is used to execute a query against a data source. It returns the first column of the first row in the resultset returned by the query.
  • In the MySqlReader.Item(”Name”) statement, data is retrieved from a field named Name. The Item property of the SqlDataReader class returns the value of a column or a field in a specified table. The ordinal number of a field can also be used instead of field name.
  • The SqlDataReader object is used to store the return results from a procedure call.
  • The GetInt method receives the value from a specified column as a -bit int data type.
  • The SqlDataReader class avoids creating unnecessary objects or making unnecessary copies of data. Hence, it provides optimal performance.
  • The DataReader class is used to retrieve a read-only and forward-only stream of data. It optimizes the performance of an application because only one row at a time remains in the memory.
  • The SqlDataReader class avoids creating unnecessary objects or making unnecessary copies of data. Hence, it provides optimal performance.
  • The Read method of the SqlDataReader class advances the data reader to the next result. It returns true if there are more results to be returned, otherwise it returns false.
  • The SqlDataReader object is used to store the return results from a procedure call.
  • A stored procedure is a group of Transact-SQL statements compiled into a single execution plan. It provides better performance, as a fully compiled execution plan is created and retained in the SQL Server procedure cache.
  • Use the CommandText property of the SqlCommand class to get or set a SQL statement, table name, or stored procedure for execution at a data source.
  • The ContinueUpdateOnError property of the SqlDataAdapter class is used to get or set a value that specifies whether to generate an exception, or the row in error when an error is encountered during a row update.
  • The Fill method of the DataAdapter class returns the number of rows that are successfully added or refreshed in the DataSet.
  • The Update method of the DataAdapter class is used to call an INSERT, DELETE, or UPDATE statement for each inserted, deleted, or updated row in a DataSet from a DataTable.
  • The DataRowState value that is stored in the RowState property of the DataRow class specifies whether the DataRow object is added, deleted, detached, modified, or unchanged.
  • The SqlDataAdapter(QueryString, conn) constructor initializes a new instance of the SqlDataAdapter class with a SQL query string variable and a SqlConnection object. This SqlDataAdapter constructor requires a minimum amount of code.
  • The IDataAdapter interface allows an object to implement the DataAdapter class.
  • The RowChanging event of the DataTable class occurs when a DataRow is changing. The DataRowChangeEventArgs class is used to provide data for the RowChanged, RowChanging, OnRowDeleting, and OnRowDeleted events.
  • LOB (large object) is an Oracle datatype that is used to store large, unstructured, multimedia data such as text, graphic images, video clippings, etc.
  • Use the ElementInit(MethodInfo, Expression) method to create an ElementInit that represents calling the Add method to initialize an element of a dictionary collection.
  • The MemberBinding member of the MemberBindingType enumeration is used to recursively initialize members of a member.
  • The TypeBinaryExpression class is used to represent an operation between an expression and a type.
  • The Call method is used to create a MethodCallExpression object. The ArrayIndex method is used to create a MethodCallExpression object that represents applying an array index operator.
  • The Expression(TDelegate) class is used to represent a strongly typed lambda expression as a data structure in the form of an expression tree. It cannot be inherited.
  • The MemberMemberBinding class is used to initialize the members of a newly created object.
  • The InvocationExpression class is used to represent an expression that applies a delegate or lambda expression to a list of argument expressions.
  • A lambda expression consists of two types of parameters implicit and explicit.

    • Modifying Data (24 percent)

  • An isolation level of RepeatableRead allows new data to be added and allows you to read but not alter volatile data during the transaction.
  • The IEnlistmentNotification interface is used to describe an interface. A resource manager must implement the interface to offer two phases commit notification callbacks for the transaction manager.
  • A COM+ transaction consists of a series of operations connected together to form a single unit. A transaction can succeed only when all its tasks have been completed successfully. For performing the application-based tasks, the COM+ uses the transaction model.
  • The IsolationLevel enumeration specifies the transaction locking behavior for a connection.
  • When IsolationLevel is specified as a parameter for the BeginTransaction method of the SqlConnection class, the method begins the transaction with the specified isolation level. If the Serializable value is specified for the IsolationLevel enumeration, it prevents more than one user from updating the dataset until the transaction is complete.
  • The Dispose method of the OleDbTransaction class is used to release all unmanaged resources.
  • While processing a transaction, the Aborted state occurs when the transaction fails due to unsuccessful execution of a task.
  • The SqlConnection.BeginTransaction method starts a database transaction. The SqlTransaction.Connection property returns a SqlConnection object in association with a transaction that can take place for each new database connection.
  • The SqlConnection.BeginTransaction(IsolationLevel) method is used to begin a transaction with a specified isolation level and the IsolationLevel attribute specifies the transaction locking behavior for a connection.
  • The FOREIGN KEY constraint specifies that each value in a specified column or set of columns must match a value in another table’s unique or primary key column or set of columns.
  • The CHECK constraint is used to validate the data inserted by users.
  • Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table.
  • Entity integrity enforces the uniqueness of rows in a table. The uniqueness of rows can be enforced by the identifier column(s) through indexes, UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties.
  • The DeleteRule property of the ForeignKeyConstraint class states the action to be taken when the user tries to delete or update a row in a related table. None specifies that no action will occur, but exceptions are generated.
  • The Clone method of the DataSet class clones the DataSet structure containing DataTable schemas, constraints, and relations. It does not copy data from a DataSet object.
  • Use the DROP TABLE Table_Name statement to remove a table from a database, commit all pending transactions, and drop all indexes that are based on the table.
  • Use the TRUNCATE TABLE Table_Name statement to truncate a table.
  • Use the ALTER TABLE [Table name] DISABLE VALIDATE PRIMARY KEY; statement to disable a constraint.
  • The ON UPDATE CASCADE constraint specifies that if an attempt is made to update a primary key value in a row, the value for the foreign key referencing the key column will also be updated with the same value.
  • In a logical data model, a FOREIGN KEY constraint is specified in a table to maintain interdependency between two tables.
  • In a table, constraints, indexes, stored procedures, and views can be created to make a column unique, and to enter valid data values in columns.
  • Create an application that populates a DataSet from related Customers and Orders tables, and ensure that when a Customer row is deleted from the DataSet, the child Orders rows are also deleted.
  • WriteSchema specifies that only the current values of a DataSet have to be written as XML data with the relational structure as inline XSD schema. It is the default XmlWriteMode.
  • The Procedure property of the SqlError class is used to return the name of the stored procedure or Remote Procedure Call (RPC) from which an error has generated.
  • Triggers are a special class of stored procedures defined to execute automatically when an UPDATE, INSERT, or DELETE statement is issued against a table.

    • Synchronizing Data (15 percent)

  • The SqlDependency class is used to represent a query notification dependency between an application and an instance of SQL Server. It is ideal for caching scenarios and allows users to receive notifications when the original data in a database changes.
  • The SqlDependency.Start is used to start the listener for the AppDomain for receiving dependency notifications from an instance of the SQL Server database provided by the connectionString parameter.
  • The SyncTable class is used to provide the client settings for a table involved in synchronization. A synchronization table is constructed for each and every table that is synchronized.
  • The DataColumn class represents a single column in the DataTable class. It manipulates, determines, and changes the structure of the DataTable class. The Expression property of the DataColumn class is used to get or set the expression used to filter rows, calculate the values in a column, or create an aggregate column.

    • Working with Disconnected Data (16 percent)

  • Use the DataSet object to create a component that reads data from a database and returns data from multiple tables as an XML stream.
  • The DataSet and DataRelation objects are used to create a relationship between two tables for retrieving records.
  • When data tables are fetched from databases, they must be stored in DataSet. Datagrid is used to show data tables on the application form.
  • The XmlValidatingReader class is inherited from the XmlReader class and is used for data validation.
  • The NextResult method of the SqlDataReader class is used to process multiple results that are generated by executing a stored procedure.
  • The LoadDataRow method of the DataTable class finds the matching value and updates a specific row in the primary column of a specific table. If the value does not match, a new row is created.
  • If you do not have access to a dataset schema at design time, use an un-typed dataset.
  • The DataTable.Compute method is used to compute the specified expression on the current rows that pass the filter condition.
  • A DataRelation object relates two DataTable objects to each other through DataColumn objects. It can be accessed through the Relations property of the DataSet object.
  • The Expression property of the DataColumn class creates an aggregate column. It can be used to calculate values in a column or filter records.
  • The GetChanges method of the DataSet class returns a copy of the DataSet, containing all changes made to the DataSet since it was last loaded, or since the AcceptChanges method was last called.
  • The Fill method of the DbDataAdapter class is used to add rows in a DataSet to match those in a data source.
  • The SqlDataAdapter class is used to select, update, or delete data from a table. It does not create a table.
  • The Namespace property of the DataTable class is used to get or set the namespace for the representation of data stored in the DataTable in XML format.
  • The Copy method of the DataSet class copies both the structure and data of a DataSet object. It returns a new DataSet object having the same structure that includes all DataTable schemas, relations, and constraints and data as the existing DataSet object.
  • The DataBindings property of the TextBox control is used to bind the control with the data source.
  • The RowFilter property of the DataView class is used to get or set the expression to filter the rows that are to be viewed in a DataView object. The expression for the RowFilter property includes a column name defined in a database table, an operator, and a value to filter on. The expression should be enclosed in double quotes.
  • The GetErrors method of the DataTable class returns an array of DataRow objects that have errors.
  • The HasErrors property of the DataTable class returns a value that specifies whether any error exists in any rows of the data table.
  • The AllowDBNull property is used to set restrictions on the column of a table. It is used to restrict the null values in a particular column, if its value is set to false.
  • The Add method is a member of the Control.ControlCollection class. It is used to add a specified control to the control collection. The Add method takes a single parameter that specifies the control object to be added to the control collection.
  • The CreateDataReader method of the DataSet class is used to return a DataTableReader class object with one result set for each DataTable, in the matching order as the tables appear in the Tables collection.
  • The Merge method of the DataSet class is used to incorporate the latest changes from a data source into an existing DataSet object.
  • When an application is executed, all type mismatch errors will be caught during compile time by creating an XML schema for a specified table and then by creating a typed DataSet object based on this schema.
  • The proper approach to synchronize a DataSet object with an XmlDataDocument object is to first populate the DataSet object with data and then to synchronize it with the XmlDataDocument object.

    • Object Relational Mapping by Using the Entity Framework (11 percent)

  • RowType is similar to ComplexType, which is an aggregate of multiple properties of type SimpleType, ComplexType, or RowType and it cannot be inherited.
  • The Programming layers option of the ADO.NET Entity Framework exposes the EDM as programming constructs, which can be consumed by programming languages.
  • RowType is similar to ComplexType, which is an aggregate of multiple properties of type SimpleType, ComplexType, or RowType and it cannot be inherited.
  • The XML Schema Definition Tool (Xsd.exe) is used to generate XML schema or Common Language Runtime classes from XDR, XML, and XSD files, or from classes in a runtime assembly.

Posted in MCPD, MCPD Enterprise Applications Developer, MCTS, MCTS Microsoft Visual Studio 2008

Tags:

You can follow any responses to this entry through the RSS 2.0 Feed. You can leave a response , or trackback from your own site.

Advertisement

Leave a Reply

uCertify.com | Our Company | Articles | Contact Us | News and Press Release | uCertify India | Entries (RSS)
MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD    Cisco Certification: CCNA, CCENT    A+, Network+, Security+ Project+
Oracle Certification: OCP 11g, OCP 10g, OCA 11g, OCA 10g    CIW foundation    EC-212-32,    CISSP    Photoshop ACE CS4    Adobe Flash ACE, PMP, CAPM
© 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.