How are fields, record and a table related to each other? Explain with the help of an example. -Technology

How are fields, record and a table related to each other? Explain with the help of an example. -Technology
by

1 Answer

Answer :

Fields are one type of information. A record contains logically related fields. A table Emp name contains logically related records.Emp NoNameSalary1.Shridhar200002.Raghav40000Here EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20000 represents one complete record.
by

Related questions

Distinguish between a record and a field in a table, with an example. -Technology

Description : Distinguish between a record and a field in a table, with an example. -Technology

Last Answer : Distinguish between a record and a field in a table are as follows:RecordFieldIt is a collection of data items, which represent a complete unit of information about a thing or a person.It is an ... called a record.e.g. if Employeeis a table, then empId, empName, department, salary arethe fields.

Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Description : Anjali writes the following commands with respect to a table employee having fields, empno, name, department, commission. -Technology

Last Answer : This is because the column commission contains a NULL value and the aggregate functions do not take into account NULL values. Thus Command1 returns the total number of records in the table whereas Command2 returns the total number of non NULL values in the column commission.

A ……… is a group of related fields. -Technology

Description : A ……… is a group of related fields. -Technology

Last Answer : A databaseis a group of related fields.

How can you add a record in the table in Datasheet View? -Technology

Description : How can you add a record in the table in Datasheet View? -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3When you have finished adding records in the datasheet, save it and close it.

Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Description : Key field is a unique identifier for each record. It is defined in the form of (a) rows (b) columns -Technology

Last Answer : (b) Key is a data item that allows you to uniquely identify individual occurrences which is defined as the column or set of columns.

…………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Description : …………. is a field which is used as a primary key and numbers each record sequentially. -Technology

Last Answer : AutoNumberis a field which is used as a primary key and numbers each record sequentially.

What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Description : What is the name of the column heading for each category in a data source? (a) Data field (b) Field (c) Field name (d) Record -Technology

Last Answer : (c) Field name is the name of the column heading for each category in a data source.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Description : Which of the following fields will not make a suitable primary key? (a) A customer’s account number -Technology

Last Answer : (b) From the given options, the data field can not be set as a primary key because it can’t be fixed for an object.

How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Description : How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Last Answer : NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

Description : Predict the output displayed in text fields named jTextField2 and jTextField3 after running the above code. -Technology

Last Answer : (i) GREEN WORLD, CLEAN WORLD76 more characters can be entered(ii)length(),toUpperCase()

What is the use of <tr> tag in an HTML table? Give a suitable example. -Technology

Description : What is the use of tag in an HTML table? Give a suitable example. -Technology

Last Answer : The tag creates a table row in an HTML table. A table must have atleast one row and also, it can have as many table rows as you want. A table row is divided into table cells. A table must have atleast one table cell per table row.e.g.CheadXtitle> TR Tag

A command that lets youchange one or more fields in a record is A. Insert B. Modify C. Look-up D. All of theabove E. None of the above

Description : A command that lets youchange one or more fields in a record is A. Insert B. Modify C. Look-up D. All of theabove E. None of the above

Last Answer : Modify

The ascending order or a data Hierarchy is a. bit - bytes - fields - record - file - database b. bit - bytes - record - field - file - database c. bytes - bit- field - record - file - database d. bytes -bit - record - field - file - database

Description : The ascending order or a data Hierarchy is a. bit - bytes - fields - record - file - database b. bit - bytes - record - field - file - database c. bytes - bit- field - record - file - database d. bytes -bit - record - field - file - database

Last Answer : a. bit - bytes - fields - record - file - database

Write any two attributes for each tag: (a) <img> (b) <Table> (c) <A> -Technology

Description : Write any two attributes for each tag: (a) (b) (c) -Technology

Last Answer : img tag-src, alt, height, widthtable tag - align, bgcolor, border, cellpadding, cellspacinga tag -href, name

Distinguish between <BASEFONT> tag and <FONT> tag with the help of an example of each. -Technology

Description : Distinguish between tag and tag with the help of an example of each. -Technology

Last Answer : tag is used to specify the default setting of the text. It takes the same attributes as tag. The only difference is that the tag affects all the text that follows until a new tag affect that is encountered. tag affects the text that comes upto its closing tag.e.g.

Technology: What is the best way to record a lecture/class?

Description : Technology: What is the best way to record a lecture/class?

Last Answer : Your phone is probably the best tool for the job. But if you don’t have one (or have one of those old flip-phones), you can get a recorder. My wife uses this to record lectures.

A Web page is located using a (a) Universal Record Linking (b) Uniform Resource Locator -Technology

Description : A Web page is located using a (a) Universal Record Linking (b) Uniform Resource Locator -Technology

Last Answer : (b) URL (Uniform Resource Locator) specifies the location of a specific Web page on the Internet.

A computer is a mechanical machine, which is used only for record keeping. -Technology

Description : A computer is a mechanical machine, which is used only for record keeping. -Technology

Last Answer : FalseComputer is an electronic device that has the ability to store, retrieve and process data.

Computer based record keeping system is known as (a) Data Manipulation System -Technology

Description : Computer based record keeping system is known as (a) Data Manipulation System -Technology

Last Answer : (d) DBMS is a collection of programs that enable the user to create and maintain the database. Also, it is a computer-based record keeping system.

RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Description : RDBMS provides relational operators to manipulate the data. Here, RDBMS refers to (a) Record Database Management System -Technology

Last Answer : (b) RDBMS stands for Relational Database Management System, which provides the operator to manipulate the data stored in the database table.

Primary key is used to …………….. identify the record. -Technology

Description : Primary key is used to …………….. identify the record. -Technology

Last Answer : Primary key is used to uniquelyidentify the record.

Primary key field gives us permission to record duplicate entry. -Technology

Description : Primary key field gives us permission to record duplicate entry. -Technology

Last Answer : False A primary key is a key which identifies records uniquely in a table so it does not give us permission to record duplicate entry.

Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Description : Which field property specifies whether the field can be left empty when entering data into a record? -Technology

Last Answer : Required property.

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

Explain the width attribute of <table> tag. -Technology

Description : Explain the width attribute of tag. -Technology

Last Answer : The width attribute is used to set the absolute width of the table. The values in width attribute can be either in pixels or in percentage of the browser window,e.g.CelllCell2CellCell4

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

A relationship cannot be created with the help of a table. -Technology

Description : A relationship cannot be created with the help of a table. -Technology

Last Answer : False A relationship is a connection between two tables of data.

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)

Explain the following with the help of an example: 1. <U>……..</U> 2. <I>……..</I> -Technology

Description : Explain the following with the help of an example: 1. …….. 2. …….. -Technology

Last Answer : 1. ……... This element is used to underline the text.e.g. School OutputSchool2. …….. This element marks up text in italic form.e.g. Hello OutputHello

Explain the following with the help of an example. (a) <B>……..</B> (b) <OL type =“1”> -Technology

Description : Explain the following with the help of an example. (a) …….. (b) -Technology

Last Answer : (a) tag makes the text bold.e.g. This is a bold text OutputThis is a bold text(b) tag with attribute type of value “1” displays the lists of items with arabic numerals,e.g. Mango Apple Banana Output1. Mango2. Apple3. Banana

Explain with a help of an example, how root elements are placed in a XML document? -Technology

Description : Explain with a help of an example, how root elements are placed in a XML document? -Technology

Last Answer : XML documents must contain one element that is the parent of all other elements. This element is called the root element. The root element encloses all other elements in XML. All other elements inside the ... then comes the child element which in turn stores the and of the employee in the tags.

Explain with the help of an example that why should atransaction be executed as a whole or it should be not executed at all -Technology

Description : Explain with the help of an example that why should atransaction be executed as a whole or it should be not executed at all -Technology

Last Answer : A transaction is a set of changes that must be made together. It is a program unit whose execution mayor may not change the contents of a database. Transaction is executed as a single unit. ... from one bank account to another requires two changes to the database both must succeed or fail together

What is series? Explain with the help of an example. -Technology

Description : What is series? Explain with the help of an example. -Technology

Last Answer : Pandas Series is a one-dimensional labeled array capable of holding data of any type (integer, string, float, python objects, etc.). The axis labels are collectively called index. Example import pandas as pd# simple arraydata =pd.series([1,2,3,4,5])print data

What do you mean by Identity theft? Explain with the help of an example. -Technology

Description : What do you mean by Identity theft? Explain with the help of an example. -Technology

Last Answer : Identity theft is the crime of obtaining the personal or financial information of another person for the sole purpose of assuming that person's name or identity to make transactions or use it to ... using the computer. He used Flex's email account to send inappropriate messages to his contacts.

Write one example of each field, for which you would use 1. Text data type -Technology

Description : Write one example of each field, for which you would use 1. Text data type -Technology

Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.

Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Description : Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Last Answer : Distinguishing between Number and AutoNumber dataNumberAutoNumberIt holds numeric values whichare used for calculations.It allows to store numbers thatare automatically generatedfor each record.The field ... for every newcustomer, this field willautomatically increase and willprovide a new number.

Write one example each of URL and IP address. -Technology

Description : Write one example each of URL and IP address. -Technology

Last Answer : Example of URL → http: // www. microsoft. com Example of IP address → 192.168.0.0

Differentiate between Web sites and Web pages with suitable example of each. -Technology

Description : Differentiate between Web sites and Web pages with suitable example of each. -Technology

Last Answer : Thedifference between awebsiteand aweb pageis that awebsiteis a collection ofwebpages with information on a subject, and aweb pageis a smaller part of a largerwebsiteusually containing more specific information. If awebsitewere a book, then awebpagewould be a chapter in that book.

Differentiate between Websites and Webpages with suitable example of each. -Technology

Description : Differentiate between Websites and Webpages with suitable example of each. -Technology

Last Answer : Using the same book analogy, while awebpageis apagefrom a book, awebsiteis the book itself. It is a collection of thepagesthat share a common thread. Similarly, all thewebpagesof yourwebsitecome together to form yourwebsite.

Cryptography is an interdisciplinary subject, drawing from several fields. Before the time of computers, it was closely related to linguistic. Nowadays the emphasis has shifted, and cryptography makes extensive use of technical ares of mathematics, especially those areas collectively known as _______mathematics: a) Increte b) Discrete c) Both of Above d) None of These

Description : Cryptography is an interdisciplinary subject, drawing from several fields. Before the time of computers, it was closely related to linguistic. Nowadays the emphasis has shifted, and cryptography makes extensive use ... as _______mathematics: a) Increte b) Discrete c) Both of Above d) None of These

Last Answer : b) Discrete

Cryptography is an interdisciplinary subject, drawing from several fields. Before the time of computers, it was closely related to linguistic. Nowadays the emphasis has shifted, and cryptography makes extensive use of technical ares of mathematics, especially those areas collectively known as _______mathematics: a) Increte b) Discrete c) Both of Above d) None of These

Description : Cryptography is an interdisciplinary subject, drawing from several fields. Before the time of computers, it was closely related to linguistic. Nowadays the emphasis has shifted, and cryptography makes extensive use ... as _______mathematics: a) Increte b) Discrete c) Both of Above d) None of These

Last Answer : b) Discrete

(Visual) The sandstone structure is about 23 metres tall, located in Natrona County, Wyoming. Which bribery scandal, considered one of the biggest before Watergate and related to leasing of oil fields near the structure, happened in 1922-23 and is named after the structure?

Description : (Visual) The sandstone structure is about 23 metres tall, located in Natrona County, Wyoming. Which bribery scandal, considered one of the biggest before Watergate and related to leasing of oil fields near the structure, happened in 1922-23 and is named after the structure?

Last Answer : Teapot Dome scandal OR Teapot Rock scandal.

Which of the following fields in IPv4 datagram is not related to fragmentation? (A) Type of service (B) Fragment offset (C) Flags (D) Identification

Description : Which of the following fields in IPv4 datagram is not related to fragmentation? (A) Type of service (B) Fragment offset (C) Flags (D) Identification

Last Answer : (A) Type of service 

In twisted pair cable, two insulated wires are twisted around each other which provides protection against noise. Explain. -Technology

Description : In twisted pair cable, two insulated wires are twisted around each other which provides protection against noise. Explain. -Technology

Last Answer : Twisting the cables keep them close together so that, any external magnetic fields must cross both cable at the same time, so the interference created in one cable is cancelled by the almost exact opposite amount of interference in the other.

Write the relationship between a database and a table. -Technology

Description : Write the relationship between a database and a table. -Technology

Last Answer : A database contains multiple tables whereas, a table cannot exist outside a database.

Name two possible primary keys for an Employee table. -Technology

Description : Name two possible primary keys for an Employee table. -Technology

Last Answer : Possible primary keys for an Employee table are emp code, emp phone number.

What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Description : What is the difference between ‘Rows’ and ‘Columns’ in a table? -Technology

Last Answer : Distinguish between data and information are as follows:DataInformationIt is a raw fact.It is a process form of data.It considers facts symbols, images for reference or analysis.It considers knowledge derived from study, experience or instruction.e.g. 23 is data.e.g age = 23 is information