Learning New Skills - Languages, Oracle Certification, etc

Learning Urdu and Spanish - Basic Vocabulary 1

2007-06-12T14:01:00.000-07:00

English - Spanish - Urdu

1) Ache - Dolor- Dard
2) Address - Direccion - Pata
3) Friend - Amigo - Dost
4) Wife - Esposa - Biivii
5) Brother - Hermano - Bhai
6) Water - Agua - Pani
7) Bread - Pan - Agua
8) Banana - Banana - Kela
9) Bed - Cama - Bistar
10) Room - Cuarto - Kamara
11) Son - Hijo - Beta
12) Daughter - Hija - Beti
13) Father - Padre - Valid
14) Mother - Madre - Valida
15) Cheese - Queso - Panir
16) Black - Negro - Kala
17) Two - Dos - Do
18) Three - Tres - Tin
19) All - Todo -Sab
20) Alone - Solo - Akela
21) Animal - Animal - Janvaar
22) Again - Denuevo - Phir
23) Crazy - Loco - Pagal
24) Cry - Llorar - Rona
25) Day - Dia - Din

Please share your spanish or urdu vocabulary with us, so you can practice your words online and help more people to learn these languages.

Proposal for Object Relational Data Mart

2006-09-03T00:49:00.000-07:00

Requirement Specifications for object relational database and SQL-3 as query language
The requirement specification for the store which loans Books, CDs and DVDs. For this purpose the requirements are oracle as an object relational database and SQL-3 as query language. The other requirement is to make this system as a data mart, so the concern is to consider all possible approaches of Object Relational databases to make it as data mart. The main entities and transactions of the system are:
PERSON
This entity contains two sub entities Customer and Employee. The main properties of both are like, Name, Address, Rented Items for customer, over due items, balance amount, likely wise for employees the main properties will be, Name, Address, salary, department.
ITEM
This Entity contains three sub entities, Books, CDs and DVD. The possible attribute for each item will be, Name of the item, quantity, price, type, authors, detail of contents.
LOAN
In this Entity the person and Item entity will be used, so the user can see the record of Customer and particular Item for loan, rent, availability, due date, overdue rent date, customer info etc.
PURCHASE
This Entity will contain the record of Items, which are purchased, and the availability of different Items in Stock.
ACCOUNT
This Entity will contain the rent price, defaulters, and salaries of Employees. It will also contain the information of Person Entity, Purchase and Loans.
Possible Transactions:

Rent Items to the Customers.
Return items in Stock and update items available.
Add new item in stock.
Calculate rent for the rental Items.
List of all rented Items.
List of all over due rented Items.
List of particular customer rented items.
Calculate most rented Item.
List for all rented Items for any particular month.

Advance Feature

As this is a data mart, so the features of object relational databases will be use like triggers, the possible trigger will be, rent the item which is not available or short in stock, so the trigger will generate a massage for upgrading the stock, the other trigger can be defaulter customer, in this trigger after over due date it will give the massage for the particular item, name of the customer. These feature will use in the data mart of the store.

Post Gress Queries

2006-08-13T03:10:00.000-07:00

Drop table cdvdtab;
Drop table booktab;
Drop table loantab;
Drop table itemtab;
Drop table copytab;
Drop table custab;
create table custab (customer_id integer primary key ,customer_name varchar(20),customer_sex varchar(10), customer_adress varchar(20),customer_rented_item varchar(20), customer_overdue_item varchar(10), customer_phone_No integer,customer_account_info varchar(10));
create table copytab (copy_id integer primary key,integer_of_copies integer, integer_of_rented_copies integer,integer_of_remaining_copy integer);
create table itemtab( item_id integer primary key,item_name varchar(20),item_purchase_date date,item_price varchar(10),item_loan_type integer,copy_id INTEGER REFERENCES copytab(copy_id) ON DELETE cascade);
create table booktab (Book_id integer primary key,book_name varchar(20),book_author_name varchar(20),book_published_year date)inherits(itemtab);create table cdvdtab (cdvd_id integer primary key,cdvd_name varchar(20),cdvd_manfc_name varchar(20),cdvd_release_year Date )inherits(itemtab);
create table loantab (loan_id integer primary key,loan_day integer,loan_date date,due_date date,return_date date,customer_id INTEGER REFERENCES custab(customer_id) ON DELETE cascade,item_id INTEGER REFERENCES itemtab(item_id) ON DELETE cascade);

MCAD Certification

2006-07-10T13:52:00.000-07:00

MCAD Certification

Developing and Implementing Web Applications with Microsoft (Visual Basic .NET or C#) and Microsoft Visual Studio .NET. It is the complete title of the first MCAD test. Are you familiar with application web, how long have you been using .net. Well, I will tell you what do you have to learn before going to do your Microsoft exam. Fortunatelly, I got most of the resources and information you will need in order to pass all your MCAD MCSD exams. I did a lot of reasearch to find the rigth places and MCSD and MCAD resources. I do not want you to waste your time and money, you must pass at first try and I will do my best to help you. Here, a pretty material about what you have to study for your first MCAD / MCSD exam. Please do not get up set if it looks to much I will show you how you can pass you MCAD / MCSD exam.

What do I have to study?

Create ASP.NET pages by Using Visual StudioAdd and set directives on ASP.NET pages. Rember do not get scare about the programming language. Many of my examples will be in Visual Basic, but it does not mean that they are not usefull for you.Separate user interface resources from business logic. It is a pretty feature of Visual Studio.Add Web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages. Set properties on controls. I will show you the diffreces between them.Load controls dynamically. It improves the application performance.

Apply templates. Set styles on ASP.NET pages by using cascading style sheets. Instantiate and invoke an ActiveX control. Control the deisng of your page.Implement navigation for the user interface. Manage the view state. Manage data during postback events. Use session state to manage data across pages. Validate user input. Validate non-Latin user input.Implement error handling in the user interface. Configure custom error pages. Implement Global.asax, application, page-level, and page event error handling. Implement online user assistance. Incorporate existing code into ASP.NET pages.

Display and update data. Transform and filter data. Bind data to the user interface. Use controls to display data. Instantiate and invoke Web services or components. Instantiate and invoke a Web service. Instantiate and invoke a COM or COM+ component. Instantiate and invoke a .NET component. Call native functions by using platform invoke.Implement globalization. Implement localizability for the user interface. Convert existing encodings. Implement right-to-left and left-to-right mirroring. Prepare culture-specific formatting. Handle events. Create event handlers. Raise events.Implement accessibility features. Use and edit intrinsic objects. Intrinsic objects include response, request, session, server, and application. Retrieve values from the properties of intrinsic objects. Set values on the properties of intrinsic objects. Use intrinsic objects to perform operations. Creating and Managing Components and .NET Assemblies Create and modify a .NET assembly. Create and implement satellite assemblies. Create resource-only assemblies.

Create Web custom controls and Web user controls. Consuming and Manipulating Data Access and manipulate data from a Microsoft SQL Server database by creating and using ad hoc queries and stored procedures. Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO.NET.

Handle data errors. Testing and Debugging Create a unit test plan. Implement tracing. Add trace listeners and trace switches to an application. Display trace output.Debug, rework, and resolve defects in code. Configure the debugging environment. Create and apply debugging code to components, pages, and applications. Provide multicultural test data to components, pages, and applications. Execute tests. Resolve errors and rework code. Deploying a Web Application Plan the deployment of a Web application. Plan a deployment that uses removable media. Plan a Web-based deployment. Plan the deployment of an application to a Web garden, a Web farm, or a cluster.Create a setup program that installs a Web application and allows for the application to be uninstalled.Deploy a Web application. Add assemblies to the global assembly cache. Maintaining and Supporting a Web Application Optimize the performance of a Web application.Diagnose and resolve errors and issues. Configuring and Securing a Web Application Configure a Web application. Modify the Web.config file. Modify the Machine.config file. Add and modify application settings. Configure security for a Web application. Select and configure authentication type. Authentication types include Windows Authentication, None, forms-based, Microsoft Passport, Internet Information Services (IIS) authentication, and custom authentication.

Configure authorization. Authorization methods include file-based methods and URL-based methods. Configure role-based authorization. Implement impersonation.Configure and implement caching. Caching types include output, fragment, and data. Use a cache object. Use cache directives. Configure and implement session state in various topologies such as a Web garden and a Web farm. Use session state within a process. Use session state with session state service. Use session state with Microsoft SQL Server.Install and configure server services. Install and configure a Web server. Install and configure Microsoft FrontPage Server Extensions.

MCSD 70-305/70-316: Example1:If you want to pass your MCAD Exam 70-305, check this examples of questions, you can also check the correct answer at the bottom.MCSD 70-305/70-316: Example1:What are the rules for a Well-formed XML document? (Choose 2 answers)

The document must have only 1 top-level element.

2) The document could have any number of top-level elements.

3) Each element must have a start tag.

4) Each element must have an end tag.

5) The document must have 2 top-level elements, one for the header and one for the body

6) Each element must have a start tag and an end tag.

MCSD 70-305/70-316: Example2: (Choose True or False)

Each Satellite assembly file (src) containt resources or data for a simple culture.

MCSD 70-305/70-316: Example3: (Choose True or False)

An application can have more than one Satellite.

MCSD 70-305/70-316: Example4: (Choose one)

Your application need the dynamic creation of a custom server text control. If you want to change the font name of the control, which property name should you use?

1)Font_Name

2)FontName

3)NameFont

4)Font-Name

5)Font:Name

6)Font:FontName

7)FontNames

MCSD 70-305/70-316: Example5: (Choose True or False)

A rule to define an attribute is that it must begin with a letter or (&).

MCSD 70-305/70-316: Example6: (Choose one)

Internet applications are stalles: Why are stateless objects used to build an application?, because it improves:

1) Usability

2) extensibility

3) security

4) usability and scalability

5) usability and security

6) scalability

MCSD 70-305/70-316: Example7: (Choose one)

Duncan is creating an application for his department. He needs to read xml files provider by theaccounting department. He needs to populated a dataset with the xml information. Which of the following senteces is usedto read XML schema and data into a Dataset?

1) Read

2) ReadXmlFile

3) ExecuteXmlReader

4) ExecuteXml

5) ReadXml

6) LoadXml

MCSD 70-305/70-316: Example8: (Choose one)

Paul is working with an application that requires the use of 2 dataset objects namedmyDataset1 and myDataset2. They both have similar structure. He wants to merger myDataset2 with my Dataset1, without preserving the changes made to myDataset1. Which is of the following expresion can Paul use?

1)myDataset 2.Merge(myDataset1,NULL)

2) myDataset2.Merge(myDataset1)

3) myDataset2.Merge(myDataset1,True)

4)myDataset1.Merge(myDataset2)

5) myDataset1.Merge(myDataset2,NULL)

6) myDataset1.Merge(myDataset2,True)

MCSD 70-305/70-316: Example9: (Choose one)

Duncan want to check how response are cached on the server. Which of the following properties and methods of the Pageobject should he be using to check it?

1) Trace

2) Session

3) CacheControl

4) Cache

5) Controls

6) ViewState

MCSD 70-305/70-316: Example10: (Choose one)

Which of the following code segments forces a transaction to commict automatically after a sucessful completion?

1) ContextUtil.AutoCommit = true

2)AutoCommit()

3) ContextUtil.AutoComplete()

4) ContextUtil.EnableCommit()

5) AutoComplete()

for the answer of these question click on the link ecommerce software solution