DBMS and Tools
These are the features of Oracle, Postgres and SQL3.
Oracle 8i database is best way to make object-relational database with SQL3 along with Postgres.
Oracle provide advance tools to manage to all data found in the today’s business, and it also provide scalability and performance for the applications, Oracle8i (Technical data sheet 2000).
As data storage database is available in Oracle, so I used internal functionality like Oracle functions, to transfer and filter data from database to data mart, but for the purpose of providing any manipulation, I have to use SQL3.
Oracle 8i is best defined to work in multi-tier enterprise applications.
For security reasons Oracle can be use confidently.
SQL3 data model is completely support inheritance and reusability of objects.

for more detail visit ecommerce software solution

Comparison to Oracle and Postgres SQL

The system is implemented in two ORDBMS, Oracle and PostgreSQL. According to the needs we choose one of them. But both of them are capable of supporting many of the object relational features. There are some points which were noted while developing the systems. The system is implemented in two ORDBMS, Oracle and PostgreSQL. According to the needs we choose one of them. But both of them are capable of supporting many of the object relational features. There are some points which were noted while developing the systems. Oracle is costly and very heavy DBMS where as PostgreSQL is totally free and consumes lesser sources than Oracle. Installation of PostgreSQL is easier than Oracle and also the code and queries which are written in PostgreSQL are portable.
Postgres was little complex but as Oracle claims to easily take common database beyond ordinary numbers and text. ORDBMS is used only because its good for making data ware house and for data mart. The draw back of using OODMMS for this particular data mart might be able to cause the problems due to its nature of immaturity in using of UML, case tools support, and it is widely varied in its capability, DBMS used here is ORDBMS (Blaha, 1998).

Creation of Subtype in Post Gress
create type custype as object
(
customer_id number(10),
customer_name varchar2(20),
customer_sex varchar2(10),
customer_adress varchar2(20),
customer_rented_item varchar2(20),
customer_overdue_item varchar2(10),
customer_phone_No number(10),
customer_account_info varchar2(10)
);
/
--------------------------------------------
create type copytype as object
(
copy_id number(10),
number_of_copies number(10),
number_of_rented_copies number(10),
number_of_remaining_copy number(10)
);
/
-----------------------------------------------
----------------------------------------------
create type itemtype as object
(
item_id number(10),
item_name varchar2(20),
item_purchase_date date,
item_price varchar2(10),
item_loan_type number(10),
copy_id REF copytype
);
/
-----------------------------------------------
create type Booktype as object
(
Book_id number(10),
book_author_name varchar2(20),
book_published_year date,
item_id REF itemtype
);
/
----------------------------------------------
create type loantype as object
(
loan_id number(10),
loan_day number(10),
loan_date date,
due_date date,
return_date date,
customer_id REF custype,
item_id REF itemtype
);
/

--------------------------------------------------
create type cdvdtype as object
(
cdvd_id number(10),
cdvd_manfc_name varchar2(20),
cdvd_release_year Date,
item_id REF itemtype
);

Free SQL Server 2000 Examples????

Here you can get answer to all your sql server 200o problems. Passs your SQL Server exams?


How to create a Table in SQL Server 2000

We are going to work with a example Table called Country.


CREATE TABLE [dbo].[Countries] ( [ZoneID] [int] NULL , [Currency] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CountryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [CountryCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) ON [PRIMARY]GO

How to Add Date in the Country Table

Just copy a paste the following code, put it in notepad, and the go to import export data in SQL Server 2000 choose the table Country and the txt file. Do not forget to put ";" as separator for each row. You will have all the countries in your SQL SErver database in only minutes.

"AD","Andorra""AE","United Arab Emirates""AF","Afghanistan""AG","Antigua and Barbuda""AI","Anguilla""AL","Albania""AM","Armenia""AN","Netherlands Antilles""AO","Angola""AQ","Antarctica""AR","Argentina""AS","American Samoa""AT","Austria""AU","Australia""AW","Aruba""AZ","Azerbaijan""BA","Bosnia and Herzegovina""BB","Barbados""BD","Bangladesh""BE","Belgium""BF","Burkina Faso""BG","Bulgaria""BH","Bahrain""BI","Burundi""BJ","Benin""BM","Bermuda""BN",
"Brunei Darussalam""BO","Bolivia""BR","Brazil""BS","Bahamas""BT","Bhutan""BV","Bouvet Island""BW","Botswana""BY","Belarus""BZ","Belize""CA","Canada""CC","Cocos""CF",
"Central African Republic""CG","Congo""CH","Switzerland""CI","Ivory Coast""CK","Cook Islands""CL","Chile""CM","Cameroon""CN","China""CO","Colombia""CR","Costa Rica""CU","Cuba""CV","Cape Verde""CX","Christmas Island""CY","Cyprus""CZ","Czech Republic""DE","Germany""DJ","Djibouti""DK","Denmark""DM","Dominica""DO","Dominican Republic""DZ","Algeria""EC","Ecuador""EE","Estonia""EG","Egypt""EH","Western Sahara""ER","Eritrea""ES","Spain""ET","Ethiopia""FI","Finland""FJ","Fiji""FK","Falkland Islands""FM","Micronesia""FO","Faroe Islands""FR","France""GA","Gabon""GD","Grenada""GE","Georgia""GF","French Guiana""GH","Ghana""GI","Gibraltar""GL","Greenland""GM","Gambia""GN","Guinea""GP",
"Guadeloupe""GQ","Equatorial Guinea""GR","Greece""GS","S. Georgia and S. Sandwich Islands""GT","Guatemala""GU","Guam""GW","Guinea-Bissau""GY","Guyana""HK","Hong Kong""HM","Heard and McDonald Islands""HN","Honduras""HR","Croatia""HT","Haiti""HU","Hungary""ID","Indonesia""IE",
"Ireland""IL","Israel""IN","India""IO","British Indian Ocean Territory""IQ","Iraq""IR","Iran""IS","Iceland""IT","Italy""JM","Jamaica""JO","Jordan""JP",
"Japan""KE","Kenya""KG","Kyrgyzstan""KH","Cambodia""KI","Kiribati""KM","Comoros""KN",
"Saint Kitts and Nevis""KP","North Korea""KR","South Korea""KW","Kuwait""KY","Cayman Islands""KZ","Kazakhstan""LA","Laos""LB","Lebanon""LC","Saint Lucia""LI","Liechtenstein""LK","Sri Lanka""LR","Liberia""LS","Lesotho""LT","Lithuania""LU","Luxembourg""LV",
"Latvia""LY","Libya""MA","Morocco""MC","Monaco""MD","Moldova""MG","Madagascar""MH",
"Marshall Islands"
"MK","Macedonia""ML","Mali""MM","Myanmar""MN","Mongolia""MO","Macau""MP",
"Northern Mariana Islands""MQ","Martinique""MR","Mauritania""MS","Montserrat""MT","Malta""MU",
"Mauritius""MV","Maldives""MW","Malawi""MX","Mexico""MY","Malaysia""MZ","Mozambique""NA","Namibia""NC",
"New Caledonia""NE","Niger""NF","Norfolk Island""NG","Nigeria""NI","Nicaragua""NL","Netherlands""NO","Norway""NP","Nepal""NR","Nauru""NU",
"Niue""NZ","New Zealand""OM","Oman""PA","Panama""PE","Peru""PF","French Polynesia""PG","Papua New Guinea""PH","Philippines""PK","Pakistan""PL","Poland""PM","St. Pierre and Miquelon""PN","Pitcairn""PR","Puerto Rico""PT","Portugal""PW","Palau""PY","Paraguay""QA","Qatar""RE","Reunion""RO",
"Romania""RU","Russian Federation""RW","Rwanda""SA","Saudi Arabia""SB","Solomon Islands""SC","Seychelles""SD","Sudan""SE","Sweden""SG","Singapore""SH","St. Helena""SI","Slovenia""SJ","Svalbard and Jan Mayen Islands""SK","Slovakia""SL","Sierra Leone""SM","San Marino""SN","Senegal""SO","Somalia""SR","Suriname""ST","Sao Tome and Principe""SU","Soviet Union""SV","El Salvador""SY","Syria""SZ","Swaziland""TC","Turks and Caicos Islands""TD","Chad""TF","French Southern Territories""TG","Togo""TH","Thailand""TJ","Tajikistan""TK","Tokelau""TM","Turkmenistan"
"TN","Tunisia""TO","Tonga""TP","East Timor""TR","Turkey""TT","Trinidad and Tobago""TV","Tuvalu""TW","Taiwan""TZ","Tanzania""UA","Ukraine""UG","Uganda""UK",
"United Kingdom""UM","US Minor Outlying Islands""US","United States""UY","Uruguay""UZ","Uzbekistan""VC","Saint Vincent and The Grenadines""VE","Venezuela""VG","British Virgin Islands""VI","US Virgin Islands""VN","Viet Nam""VU","Vanuatu""WF","Wallis and Futuna Islands""WS","Samoa""YE","Yemen""YT","Mayotte""YU","Yugoslavia""ZA","South Africa""ZM","Zambia""ZR","Zaire""ZW","Zimbabwe"



How to Generate a Stored Procedure in SQL Server 2000

Create a Stored Procedure in SQL Server 2000 is really easy, this section will show you how to create a stored procedure for adding, selecting, updating and deleting a country.


SQL Server 2000 - Stored Procedure to Add a Country

CREATE PROCEDURE [AddCountries]( @ZoneID int = NULL, @Currency char(10) = NULL, @CountryName nvarchar(50) = NULL, @CountryCode nvarchar(10))ASBEGIN
SET NOCOUNT ON DECLARE @Err int
INSERT INTO [Countries] ( [ZoneID], [Currency], [CountryName], [CountryCode] ) VALUES ( @ZoneID, @Currency, @CountryName, @CountryCode )
SET @Err = @@Error
RETURN @ErrEND
GO


SQL Server 2000 - Stored Procedure to Update a Country

CREATE PROCEDURE [UpdateCountries]( @ZoneID int = NULL, @Currency char(10) = NULL, @CountryName nvarchar(50) = NULL, @CountryCode nvarchar(10))ASBEGIN
SET NOCOUNT ON DECLARE @Err int
UPDATE [Countries] SET [ZoneID] = @ZoneID, [Currency] = @Currency, [CountryName] = @CountryName WHERE [CountryCode] = @CountryCode
SET @Err = @@Error
RETURN @ErrEND
GO

SQL Server 2000 - Stored Procedure to Delete a Country

CREATE PROCEDURE [DeleteCountries]( @CountryCode nvarchar(10))ASBEGIN
SET NOCOUNT ON DECLARE @Err int
DELETE FROM [Countries] WHERE [CountryCode] = @CountryCode SET @Err = @@Error
RETURN @ErrEND
GO

SQL Server 2000 - Stored Procedure to Select a Country
CREATE PROCEDURE [GetCountries]( @CountryCode nvarchar(10))ASBEGIN SET NOCOUNT ON DECLARE @Err int
SELECT [ZoneID], [Currency], [CountryName], [CountryCode] FROM [Countries] WHERE ([CountryCode] = @CountryCode)
SET @Err = @@Error
RETURN @ErrEND
GO


SQL Server 2000 - Stored Procedure to Select all Countries
CREATE PROCEDURE [GetAllCountries]ASBEGIN
SET NOCOUNT ON DECLARE @Err int
SELECT [ZoneID], [Currency], [CountryName], [CountryCode] FROM [Countries]
SET @Err = @@Error
RETURN @ErrEND
GO

Do you want to become a MCSD,,,,, well i will give you the rigth formula. This website provides you really useful example for your MCSD tests.... Here you are the best example for passing your tests 70-305 and 70-315.

MCSD - 70-305 / 70-315 Q1)

Nancy works for a company called The Ecommerce Solution. She is developing an application called MyApplication.She wants to call a Web services from MyApplication. This web services will returns a Dataset object,named MyDataset, MyDataset containts a list of products. How can Nancy make the services available for MyApplication?

1) The Web Services Discovery (Disco.exe) tool.

2) The web references dialog box.

3) The type library importer (Tlbimp.exe) tool.

4) The Service Reference dialog box.

5) The reference dialog box.

MCSD - 70-305 / 70-315 Q2)

Peter works as a software engineer for The Ecommerce Solution. He is developing an application MyApplicationwhich display employee details from a SQL Server database and using a Datagrid control named MyDatagrid. MyDatagrid is bound to a dataview object named MyDataview. MyApplication has a button "Status". Whenever user click this button, Peter wants to display the details ofemployees with status "Active" in MyDataGrid. Which of the following statements will Peter use to accomplish it?

1)MyDataView1.RowStateFilter = "Status = 'Active'"

2)MyDataView1.RowSelectFilter = "Status = Active"#

3)MyDataView1.RowFilter = "Status = 'Active'"

4)MyDataView1.RowFilter = "Status = Active"

5)MyDataView1.RowStateFilter = "Status = Active"

MCSD - 70-305 / 70-315 Q3)

Peter wants to get list of users who not bougth and product to his company so far. Which of the following SQL syntax will you use for this query?

1) Select u.Username from User u Rigth Outer Join Purchase_Orders on u.UserID = Purchase_Orders.UserID WHere (((Purchase_Orders.Orer_ID) Is Null));

2) Select u.Username from User u Rigth inner Join Purchase_Orders on u.UserID = Purchase_Orders.UserID;

3) Select u.Username from User u Left Outer Join Purchase_Orders on u.UserID = Purchase_Orders.UserID WHere (((Purchase_Orders.Orer_ID) Is Null));

4) Select u.Username from User u Rigth Outer Join Purchase_Orders on u.UserID = Purchase_Orders.UserID;

5) Select u.Username from User u Rigth Outer Join Purchase_Orders on u.UserID = Purchase_Orders.UserID;

MCSD - 70-305 / 70-315 Q4)
Ian is the web developer of The Ecommerce Solution. His company wants to enter in the the Spanish market, so he decides to make an application in bothEnglish and Spanish. For this purpose he creates 2 version of the application.He creates separate resource files for each version, Ian wants to depoy the appropiate resource file based on the current language of the server. What do Ian need to do?

1)A custom action

2)A launch condiction

3)A custom condiction

4)The MsiConfigureProduct function

5)The Installer.Context property

MCSD - 70-305 / 70-315 Q5)

The ecommerce solution is making a small application to apdate the birth of date oftheir users, for this purpose, they make a web page with the user details. In order to validat thedate of brith they are using a CustomValidator control named MyCV which is validating a TextBox controlnamed txtDateOfBirth. The wantto ensure that the users are older than 18, and they do not want to make a tripto the server for validation. Which of the following properties should they use?

1)txtDateOfBirth.AutoPostBack

2)txtDateOfBirth.ClientValidationFunction

3)txtDateOfBirth.Click()

4)MyCV.PostBack

5)MyCV.ClientValidationFunction

MCSD - 70-305 / 70-315 Q6)

Peter want to retrieve HTML help for a specific control. For this purpose he is going touse a HelProvider control. Which of the methods specifies the keywords use to getthe help?

1)GetHTMLHelp

2)ToString

3)ToHelp

4)SetHelpKeyword

5)SetHelpString

MCSD - 70-305 / 70-315 Q7)

Ian is working as web developer for The ecommerce Solution, he is developing an applicationfor an important client. He needs to set security for handlying users, for tihs purpose, he is usingthe security classes of the.NET Framework. Ian wants to give the same permision tothe Manager of Company (Peter) and the Supervisor(Duncan). Which of the following code should he use?
1) Dim permission1 As New PrincipalPermission("Peter","Manager")Dim permission2 As New PrincipalPermission("Duncan","Manager")
permission1 Union permission2

2)Dim permission1 As New PrincipalPermission("Peter","Manager")Dim permission2 As New PrincipalPermission("Duncan","Manager")
permission1 = permission2

3)Dim permission1 As New PrincipalPermission("Peter","Manager")Dim permission2 As New PrincipalPermission("Duncan","Manager")
permission1 Intersect permission2

4) Dim permission1 As New PrincipalPermission("Peter","Manager")Dim permission2 As New PrincipalPermission("Duncan","Manager")
permission1 IsUnrestricted permission2

5)Dim permission1 As New PrincipalPermission("Peter","Manager")Dim permission2 As New PrincipalPermission("Duncan","Manager")
permission1 IsSubSetOf permission2

MCSD - 70-305 / 70-315 Q8)

Ian is testing one of his ASP.net application. He got a button for calculatingthe monthly invoices. He decides to put a breakpoint inthe load page and each time he debugs his application, it stops twice. He wants the application to stop only once. Ian wants to change one of the attributes of the Page Directive, which of the following actionhe has to do.
1) SmartNavigation = "false"

2) SmartNavigation = "true"

3) AutoEventWireup = "true"

4) AutoEventWireup = "false"

5) Codebehind="WebForm1.aspx.vb"

MCSD - 70-305 / 70-315 Q9)
Carols is developing a new application for The Ecommerce Solution.They need to integrate their database with one of their provider database.Carol wants to create a realtionship between these 2 databases. Which ADO.net objectsshould Carol use?
1)Dataset and DataRelation

2)Dataset and DataReader

3)Dataview and DataRelation

4)DataView and DataReader

5)Dataset amd Merge

MCSD - 70-305 / 70-315 Q10)

The ecommerce Solution is located in England, most of their client are located in England too.They got a new client in United Stated and they optimise its main application for this company.However, when they are testing the application the got some problems with the data format anddate validation. Which of the following sections should they change in the web.config file?
1)

2)

3)

4)

5)

Answer:
MCSD - 70-305 / 70-315 A1)

2

MCSD - 70-305 / 70-315 A2)

3

MCSD - 70-305 / 70-315 A3)

3

MCSD - 70-305 / 70-315 A4)

1

MCSD - 70-305 / 70-315 A5)

1 and 5

MCSD - 70-305 / 70-315 A6)

4

MCSD - 70-305 / 70-315 A7)

5

MCSD - 70-305 / 70-315 A8)

4

MCSD - 70-305 / 70-315 A9)

1

MCSD - 70-305 / 70-315 A10)

5