- Envisioning and Designing an Application
- A business requirement defines what the business believes to be important for the success of a project.
- The Smart client is deployed through a Web browser but runs it as a Windows application on a client’s computer.
- Use the appropriate criteria to evaluate the requirements for an application.
- The available ASP.NET client technologies are standard browser-based client, AJAX-enabled client, smart client, Microsoft office client, and Windows mobile client.
- Choose the appropriate security requirement with respect to security.
- An ASP.NET application can be divided into three logical layers: User Interface, Middle Tier, and Database layers.
- UML class diagram is a static structure that represents classes and relationships between the classes.
- Define relationships between entities so that the database can ensure that the data stored in the database is consistent and integral.
- The strings, numbers, date and time, and Boolean data types are used to determine the manner in which they are to be stored in a specific schema.
- 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 Data Definition Language to create a new database on a database server.
- The UPDATE statement is a Data Manipulation Language (DML) statement, which is used to change the values of specified columns in one or more rows in a table or view.
- Use the ALTER TABLE [Table name] DISABLE VALIDATE PRIMARY KEY; statement to disable a constraint.
- Create a database trigger and fire it when an INSERT statement is issued on a table.
- 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.
- Triggers are special classes of stored procedures that are defined to execute automatically when an UPDATE, INSERT, or DELETE statement is issued against a table.
- Use the ORDER BY clause to perform the following operations:
- Listing all the sales person’s identification numbers
- Sales amount
- Sales dates
Pass MCPD certification exam in first attempt. Download latest exam simulation, questions, tutorial and study guide for MCPD:






