No products in the cart.

Create a Table Salesman' with the …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Create a Table Salesman' with the following structure Field Name Data Type Number(NUMERIC) SMID Text (35 Characters) Text (40 Characters) Text (40 Characters) SM. Name Address1 Address2 Text(15 Characters) Text(15 Characters) City State Number Number Number PinCode Sell Amt Comm Phone Number (a) Insert a new field 'Gender (Use default value of Gender field as 'Male'). (b) Insert at least 15 records in the Table. (c) Save and Close the Table. (d) Open the Table Salesman' again and Delete Record number 3 and 6 (e) Modify the width of the Address1 and Address2 field as Text (50 Characters). (f) Sort the records of the table in ascending order of SM_NAME field (g) Sort the records of the table in descending order of SM_NAME field.
  • 0 answers
http://mycbseguide.com/examin8/

Related Questions

Define goal seek
  • 1 answers

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App