SOLUTION

The steps to generate the report are: 
• Select the table from the “Tables Pane”.
• Right click on it.
• Select the “Report Wizard” from the short menu.
• Go to “Available Fields” window. Click on  icon.
• Click on Finish to generate the report.  

SOLUTION

The steps to insert the data in the table are: 
• Go to “Tables” pane. 
• Select the table. 
• Right click on the table. 
• Select the “Open”. 
• Select the field and start entering the data in the table.

SOLUTION

The date [DATE] field type stores the dates only and the Time [TIME] field type stores the times only. But the field type Date/Time [TIMESTAMP] is a combination of both Date and Time types and hence, can store the combination of data and time, also known as timestamp. So Leena can set the “DATE” data type to DOB field.

SOLUTION

Steps to set the Primary Key are:
• To set a field as Primary Key, click on the row of the field.
• Now, right click on the leftmost button which is showing an arrow or known as row selector button.
• Right click on it.
• Select the primary key from the shortcut menu.

SOLUTION

Steps to open an existing database are:
• Select “Open an existing database” from the opening dialog when BASE starts.
• Select the desired database either from “Recently used list” or by clicking at “Open button”. •  Click on “Finish”.

SOLUTION

We can use Record Navigation Bar to navigate in a table. These buttons are available when you open a table in Datasheet View. With these buttons you can go to the very first line or very last record in the table. You can also move to the next and previous record and even a specific record.

SOLUTION

If you are a frequent user of OpenOffice.org base, you can create a shortcut on the desktop and for that you have to follow steps like –  Start-> Programs-> OpenOffice.org 3.0 -> Right Click on Base ->Create a shortcut. Thus, a short cut will be there on your desktop.

SOLUTION

The steps are as follows: Step1 - Click on Start. Step2 - Click on Programs/All Programs. Step3 - Click on OpenOffice.org 3.0. Step 4 - Click on OpenOffice.org Base.

SOLUTION

Memo data type is preferred over Text data type when a large text is to be entered. Memo data type allows upto 2 Giga byte characters.

SOLUTION

To move a record up & down, you should select the row and drag the row to the desired position.

SOLUTION

Mr. Sanjeev should use the concept of primary key to identify the unique records from the relational table. He can define this by selecting the row selector from the field.

SOLUTION

Whenever we create a field in OOo Base, the default data type is Varchar.

SOLUTION

To store the date of joining of the employees, Manthan should use the date/time data type that contains the predefined format of data and time.

SOLUTION

Italic Tag - < i > is used to make the text italic in html.

SOLUTION

Document Type Definition (DTD) is a set of rules defining relationships within a document.

SOLUTION

XML stands for eXtensible Markup Language.

SOLUTION

The expansion of the following are:
(i) < UL > – unordered list

SOLUTION

In the given code, the colour attribute should be bgcolor.

SOLUTION

The font size of a single line on a webpage can be changed by using the HTML code:

SOLUTION

To display an image on a webpage, Rahul has used the src(source) attribute with < IMG > tag. He can align the image by alignment tag.

SOLUTION

The given XML code is not well-formed as it has number of root elements where a XML document must contain only one root element.

SOLUTION

XML elements are represented by tags. Elements usually consist of an opening tag and a closing tag. Opening tag consists of <, followed by the element name and ending with >. Closing tags are same but have a forward slash inserted between the less than symbol and the element name.

SOLUTION

XML is used in many aspects of web development, often to simplify data storage and sharing.

The following are the uses:
· XML separates data from HTML.
· It simplifies data sharing and transport.
· It makes your data more available.
· XML simplifies platform changes.

SOLUTION

Subscript Tag(SUB): This tag is used to define the subscript text. Subscript can be defined by using the following tags:

< SUB > …. < /SUB >

Superscript Tag(SUP): This tag is used to define superscript text. Tags that are used to define superscript are:

< SUP >…… < /SUP >

SOLUTION

The br tag is used to insert a single carriage or break into the html document. The line break is like a type writer’s carriage return. It just takes you back to the left margin. The line break element indicates that a new line is going to start at the given point.

Example: 

< p >

< Manik chand > < br >

< Plam street, A-102 > < br >

< 110021> < br >

< /p >

SOLUTION

The output for the given code:

SOLUTION

The expansions of the following tags are:
(i) < HR > – Horizontal Rules Tag
(ii) < OL > – Ordered List Tag
(iii) < A > – Anchor Tag
(iv) < sub > – Subscript Tag

SOLUTION

The < LI > tag is opened but not closed. In place of < /UL >, the < /OL > tag is used.

The correct code is given below and the errors are underlined.

< HTML >

< Body >

< UL > STYLE:SQUARE

< LI > Water Bottles < /LI >

< LI > Lunch box < /LI >

< LI > Handkerchief < /LI >

< /UL >

< /Body >

SOLUTION

(i) # is used to place the anchor in same document.
(ii) When the user clicks on Welcome, the marked anchor will display the related page on the screen.

SOLUTION

The < HTML > tags that are written for page display are enclosed within < and >. These are the first and the last tag on the document. These are the tags that tell a web browser where the HTML in your document begins and ends. The most basic of all possible web documents is:

< HTML >

    …..

    …..

SOLUTION

< ?xml version = “1.0”? >

< message data = “2/12/2011” >

< sender > Prerna < /sender >

< receivers >

< receiver > Pranav < receiver >

< receiver > Piyush < receiver >

< /receivers >

< text > Let us meet up on the coming weekend < /text >

< /message >

SOLUTION

< student-list >

< student >

< name > Akash < /name >

< rollno > 5 < /rollno >

< subject > Mathematics < /subject >

< /student >

< student >

< name > Bhavna < /name >

< rollno > 11 < /rollno >

< subject > Biology < /subject >

< /student >

< student-list >

SOLUTION

Code for the given table format:

< html >

< body >

< table border="1" >

< caption > < font color = "blue" > < b >Student Record< b >< /font >

< /caption >

< tr >

    < th >Add No.< /th >

    < th >Name< /th >

    < th >Age< /th >

    < th >Address< /th >

    < th >Contact No.< /th >

  < /tr >

  < tr >

    < td >111< /td >

    < td >Pooja< /td >

    < td >20< /td >

    < td >XYZ< /td >

    < td >1234< /td >

  < /tr >

< tr >

    < td >112< /td >

    < td >Prerna< /td >

    < td >20< /td >

    < td >abc< /td >

    < td >2567< /td >

  < /tr >

< /table >

< /body >

SOLUTION

Comments are basically a type of textual content which appears in the HTML code. But these are not rendered by the user’s browser. They are given between special < !- - - and --- > markup elements. For example, < !- - - This is a comment - - ->

SOLUTION

The tag to include a background color is included in the body statement as an attribute. For example, < body bgcolor = “blue” >.

SOLUTION

To write H₂O, Sarika should use the < SUB > tag. Similarly, for writing something like Y², the < SUP > tag is used.

SOLUTION

The length of the horizontal rules can be controlled with the width attribute. The value of the width attribute can either be an absolute number of pixels or a certain percentage of the browser window’s width. For example, < hr width = 30% > will extend the horizontal rule across 30% of the width. Similarly, < hr width = 60% > will extend the horizontal rule across 60% of the width.

SOLUTION

The width and height attributes are very useful when we have to specify the exact dimensions of the image in pixels. This also allows image-loading browsers to reserve the proper amount of space for the image and continue to render the rest of the document, thus giving the appearance of a faster-loading page.

SOLUTION

Hemant should write the title between the opening < title > and closing < /title> tags. This tag contains the document title. This title specified inside < title > tag appears on the browser title bar.

SOLUTION

The color or text links can be changed by using LINK attribute. The two types of links are visited links and active links. VLINK refers to visited links and ALINK refers to active links.

SOLUTION

To give the heading of the webpage, one can use the heading tag that makes your heading big and bold. The syntax is: < h > Text < /h >. The number between 1 and 6 (like h1, h2 etc) specifies the level of the heading. Headings are typically displayed in larger and/or bolder fonts than normal body text.

SOLUTION

The < hr > tag creates a horizontal line spread across the width of the browser window. The thickness and width can be varied as required. The default size of horizontal rule is 3. Since, Priyanka desires to have a horizontal line of size 4 and width 50%, therefore the correct html that should be used by her is:
< hr size = 4 and width = 50% >.

SOLUTION

An ordered list (also known as numbered list) is an indented list that has numbers or letters in front of each item. These lists are marked by < ol > and < /ol > tags.

SOLUTION

To change the color, style and size of the text, Abha should use the < font > tag. The < font > tag is used for changing the appearance of a short segment of text.

SOLUTION

The < pre > tag defines preformatted text. The text in a pre-element is displayed in a fixed-width font and it preserves both spaces and line breaks.

SOLUTION

When a segment of text needs to be centralized, the < center > tag is used. The correct form to make the text appear in center is: < center >. Text appears in center < /center >.  Here, text will appear at center on browser window.

SOLUTION

To set the top margin, i.e., distance from the top edge, Shikha can use TOPMARGIN attribute. For example, < body topmargin = “70” >, will make the body-text appear 70 pixels away from top edge of the page.

SOLUTION

Most of the HTML tags come in pairs like < html >…< /html >, < head >…< /head >, < strong >… etc. The < strong > style is used for strong emphasis. It displays the text in bold. The < /strong > is used for closing.

SOLUTION

The HTML < strong > tag is used for indicating stronger emphasis. The strong tag surrounds the emphasized word/phrase. This tag is used to make the text appear in bold. Therefore, it will print Life is beautiful in bold letters.

SOLUTION

Every HTML document should follow the general form as follows: < html > < head > < title > Title goes here < /title > < /head > < body > Content of the document goes here < /body > < /html >

SOLUTION

To save the file in the correct format, we should use filename .htm or filename.html.

SOLUTION

The < hr > tag creates a horizontal line spread across the width of the browser window. The thickness and width can be varied as required. The default size of horizontal rule is 3. Since Ramya desires to have a horizontal line of size 4 and width 40%, the correct html that should be used by her is:
< hr size = 4 and width = 40% >.

SOLUTION

To change the font type of the text, Sidhi should use the face attribute. Face attribute provides a list of font-names enclosed within quotes. The web browser tries to find out whether the first font-name in the list (i.e., Georgia) is supported by it or not. If the first font-name is supported by the browser, then it displays the text in this font otherwise it will display the text in the next font (i.e., Times New Roman), which is supported by it.

SOLUTION

< QuestionPaper >

< Question category = “MCQ” >

< title > Who is the Father Of Nation? < /title >

< optionA > A) Jawahar Lal Nehru < /optionA >

< optionB > B) Mahatma Gandhi< /optionB >

< optionC > C) Subhash Chandra Bose < /optionC >

< optionD > D) Bhagat Singh < /optionD>

< answer > B) < /answer >

< /Question >

< /QuestionPaper >

SOLUTION

< ?XML version =“1.0” encoding = “UTF-8” standalone = “yes”? >

< emps >

< EMP No. > E609 < /EMP No. >

< Name > Pooja < /Name >

< Department > CSc < /Department >

< Phone > 9093892800 < /Phone >

< /emps >

SOLUTION

< ?xml version="1.0" encoding="UTF-8"? >

< !DOCTYPE recipeml PUBLIC "-//FormatData//DTD RecipeML 0.5//EN"

http://www.formatdata.com/recipeml/recipeml.dtd >

< ?xml-stylesheet href="dessert.css" type="text/css"? >

< recipeml version="0.5" >

< recipe >

< head >

< title >The Chocolate Chip Cookie< /title >

< /head >

< ingredients >

< ing >

< amt >< qty >2< /qty >< unit >cups< /unit >< /amt >

< item >butter< /item >

< /ing >

< ing >

< amt >< qty >4< /qty >< unit >cups< /unit >< /amt >

< item >flour< /item >

< /ing >

< ing >

< amt >< qty >2< /qty >< unit >tsp.< /unit >< /amt >

< item >soda< /item >

< /ing >

< ing >

< amt >

< qty >2< /qty >< unit >cups< /unit >

< /amt >

< item >sugar< /item >

< /ing >

< ing >

< amt >< qty >5< /qty >< unit >cups< /unit >< /amt >

< item >blended oatmeal< /item >

< /ing >

< ing >

< amt >< qty >24< /qty >< unit >oz.< /unit >< /amt >

< item >chocolate chips< /item >

< /ing >

< ing >

< amt >< qty >2< /qty >< unit >cups< /unit >< /amt >

< item >brown sugar< /item >

< /ing >

< ing >

< amt >< qty >1< /qty >< unit >tsp.< /unit >< /amt >

< item >salt< /item >

< /ing >

< ing >

< amt >< qty >1< /qty >< /amt >

< item >Hershey Bar, grated< /item >

< /ing >

< ing >

< amt >< qty >4< /qty >< /amt >

< item >eggs< /item >

< /ing >

< ing >

< amt >< qty >2< /qty >< unit >tsp.< /unit >< /amt >

< item >baking powder< /item >

< /ing >

< ing >

< amt >< qty >3< /qty >< unit >cups< /unit >< /amt >

< item >chopped nuts (your choice)< /item >

< /ing >

< ing >

< amt >< qty >2< /qty >< unit >tsp.< /unit >< /amt >

< item >vanilla< /item >

< /ing >

< /ingredients >

< directions >

< step >Measure oatmeal and blend in a blender to a fine powder< /step >

< step >Cream the butter and both sugars< /step >

< step >Add eggs and vanilla; mix together with

flour, oatmeal, salt, baking powder, and soda

< step >Add chocolate chips, Hershey Bar and nuts

< /step >

< step >

Roll into balls and place two inches apart on a cookie sheet

< /step >

< step >Bake for 10 minutes at 375 degrees< /step >

< /directions >

< /recipe >

< /recipeml >

SOLUTION

The code for the given webpage:

< html >

< head > < title > Recycle < /title >  < /head >

SOLUTION

XML document must contain a root element. This element is “the parent” of all other elements. The elements in an XML document form a document tree. The tree starts at the root and branches to the lowest level of the tree.

All elements can have sub elements (child elements):

< root >

< child >

< subchild > …… < /subchild >

< /child >

< /root >

SOLUTION

The important rules for an XML document are:

1. XML documents must contain at least one element.

2. XML documents must contain a unique opening & closing tag that contains the whole document, known as a root element.

3. All other tags must be closed properly, i.e., there must be a proper opening & a closing tag. In XML, empty tags must end with a following slash.

4. All other tags must be nested properly, i.e., the start and end tags of child elements cannot overlap.

5. Tags in XML are case-sensitive. That is, < Audio >, < AUDIO > and < audio > are not the same.

6. Attribute values must always be quoted.

SOLUTION

i. Rohan can use the hard disk and CD for the backup.

ii. The general protections are:
• Do not leave a floppy disk in the floppy disk drive when you restart or shutdown your computer.
• Be suspicious of email attachments from unknown sources.
• Scan the attachment before downloading.
• Do not set your email program to “auto-run attachments.”

iii.

a. Quick Heal

b. Restoration

c. Typhoon

d. Notepad

SOLUTION

Once you have created a database, the next step is to create the table forms. Now, you can perform queries on that.

SOLUTION

In the database, we can have many tables and we can correlate those with the common field. That common field can be a primary key which is uniquely identified.

SOLUTION

Memo files can store upto 2 GB. They are used for storing large information about fields like library database – book name, book number, author name etc.

SOLUTION

A valid XML document is the one that is well-formed as it confirms to the DTD or schema of the document. A well-formed XML document is the one that follows the syntax rules described in "XML Syntax Rules".

SOLUTION

A style sheet is made up of style rules that tells a browser how to present a document. Each style rule is made up of selector – usually HTML elements such as BODY, P, EM etc. or XML elements of XML documents.

SOLUTION

The document type declaration consists of Markup code that indicates grammar rules for the particular class of the document. Grammar rules are called Document Type Definition (DTD). A DTD begins with !DOCTYPE declaration.

SOLUTION

Processing instructions are information for the application. They allow documents to contain instructions for applications. It takes the following form – < ?piname pseudo-attributes >.

SOLUTION

The document type declaration consists of Markup code that indicates grammar rules for the particular class of the document. Grammar rules are called Document Type Definition (DTD). A DTD begins with !DOCTYPE declaration.

SOLUTION

The root element or document element is the first element of XML document. It is the parent element of all other elements in data instance. XML documents must contain one element that is parent of all other elements. This parent element is known as root element or document element.

SOLUTION

Basically, an XML-file contains a prolog (optional) and a data instance. Prolog should be the first logical component. It is an optional structural element, but for well-formed documents, it must be included. In data instance, a single element contains all data of XML document, which is the root element or document element.

SOLUTION

The fundamental data element in an InkML file is < trace >. Trace represents a sequence of contiguous ink points. The sequence of traces accumulates to meaningful units such as characters, words or diagrams.

SOLUTION

The < IMG > tag element specifies an inline image. The required SRC attribute specifies the location of the image. The image can be of any format, though browsers generally only support GIF, JPEG and PNG images.

SOLUTION

Color or text links can be changed by LINK attribute. The two types of links are visited links and active links. VLINK refers to visited links and ALINK refers to active links. Active links are the links that are currently being clicked on.

SOLUTION

The value of #FFFFFF is white and #000000 is black. For example, < body bgcolor =”#000000” >, will create a window with a black background (BGCOLOR’s value).

SOLUTION

The < caption > tag defines a table caption. It must be inserted immediately after the < table > tag. You can specify only one caption per table.

SOLUTION

HTML tag is used to mark-up HTML elements. The HTML tags are surrounded by angle brackets. These tags usually come in pairs like < b > and < /b >.

SOLUTION

Headings are defined with the < h1 > to < h6 > tags. The < h1 > tag defines the largest heading whereas < h6 > defines the smallest heading.

SOLUTION

HTML is the basic language used to write web pages. It allows websites to bring together graphics, music, videos and links. The HTML code can be saved, given the desired file name along with .html or .htm extension.

SOLUTION

The char stores exactly the length specified by the user. The default length is 50. This value can be altered using Length Property.

SOLUTION

Varchar is the default field type applied when you create a new field. Its default length is 50, which can be changed using Length Property.

SOLUTION

Database is a collection of related data and an application to maintain these data is known as Database Management System.

SOLUTION

A database contains the information of related enterprise in sorted manner through which we can modify the data very easily.

SOLUTION

While designing the database, the first thing that we should keep in mind is the purpose of the database. Example: Students database – If student database is used by the transport people, then we should include the transport information of each child in it so that it can be easily used by the transport people.

SOLUTION

A table is divided into rows (with the < tr > tag) and each row is divided into data cells (with the tag). The td stands for "table data," and holds the content of a data cell. A < td > tag can contain text, links, images, lists, forms, other tables etc.

SOLUTION

The comments are not processed by XML parsers. The comments are inserted for purposes like: to add notes about document structure and to break a document into sections.

SOLUTION

The XML declaration is a declaration that identifies the following through pseudo-attributes: the xml version, encoding and stand-alone or not. XML declaration begins with a special tag < ?xml…? >.

SOLUTION

SGML stands for Standard Generalized Markup Language. It is powerful but very complex, suffers from lack of industry support. It is the basis for XML.

SOLUTION

Every XML file or document has both logical structure and physical structure. The logical structure tells about what all elements are to be included in the document and the order of the elements. The physical structure contains the actual content.

SOLUTION

Every XML file or document has both : logical structure and physical structure. The logical structure tells about: what all elements are to be included in the document and the order of the elements.

SOLUTION

RecipeML is a format for representing recipes on computer. Recipes can be either represented online or in software.

SOLUTION

To process an XML document on web in a desired manner, we need an XML document system and not just an XML-file. An XML document system mainly comprises the following: i. A style sheet presentation through CSS or XSL. ii. A grammar structure through DTD. iii. Semantics of data through XML file.

SOLUTION

XML tags are case-sensitive whereas HTML tags are not case-sensitive. In XML, < parts >, < Parts > and < PARTS > are not the same. The XML processing instruction must be all lowercase. However, our own elements and attributes may be in any case.

SOLUTION

XML tags are not predefined. We can create and define new tags as per our needs.

SOLUTION

XML can run on all platforms. It is created by using standard text files. These files are compatible with all platforms such as Windows, Macintosh, Unix etc.

SOLUTION

XML tags are not predefined, rather these are to be created by the author to describe the content in appropriate manner. Therefore, each XML document is unique in it and is able to describe its contents without any prior knowledge.

SOLUTION

XML documents can be viewed only if proper stylesheet file is also available along with XML file. The extension to save a style sheet is “.css”. We just have to give the link of style sheet link in the XML file.

SOLUTION

HTML is basically used for displaying the information, while XML is about describing the information. HTML is designed to display data and hence, focussed on the ‘look’ of the data.

SOLUTION

XML is a subset of SGML, i.e., SGML minus its complex and optional features. XML is based on SGML. It includes only the parts of SGML required for web publishing. XML does not include complex and optional features of SGML.

SOLUTION

SGML stands for Standard Generalized Markup Language. It is powerful but very complex and suffers from lack of industry support. It is the basis for XML.

SOLUTION

XML means “Extensible Markup Language”. Extensible means it do not have fixed format like HTML. Markup is a set of rules to define structure and format of text.