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

1 Answer

Answer :

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

Related questions

Description : A table named School (containing data of students of the whole school) is created -Technology

Last Answer : AdmissionNo should be set as the primary key because admission numbers are unique for each and every student of the school, which is not possible in the case with RollNo and Name.

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.

Description : What are table sections? How can they be created? -Technology

Last Answer : In HTML tables, there are three different sections: header, body and footer. These sections can be created using (header section), (body section) and (footer section) tags.e.g MonthSavings January$100February$80Sum$180

Description : Ms. Shalini has just created a table named “Employee” containing columns Ename, Department, Salary. -Technology

Last Answer : SQL command to add a primary key column:Alter table employee add empid int primary key;Importance of Primary key in a table:Primary key column is used to uniquely identify each record of the table. A column defined as primary key cannot have a duplicate entry and can't be left blank.

Description : Mr. Manav, a database administrator in “Global Educational and Training Institute” has created following table named “Training” -Technology

Last Answer : i. Select count(name) from training where name like ‘Ms.%’;ii. Select * from training where fee is NULL;iii. Select city, fee from training where topic = ‘Cyber Security’;iv. Alter table training add feedback varchar(20);

Description : You cannot insert ………………… into a main document until after the data source has been created in Word. -Technology

Last Answer : fields into a main document until after the data source

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.

Description : The small area network created around a bluetooth device is called ………….. -Technology

Last Answer : The small area network created around a bluetooth device is calledPAN (Personal Area Network).

Description : ……. are used to connect Web pages. They are created with tag. -Technology

Last Answer : Hyperlinksare used to connect Web pages. They are created with tag.

Description : Hyperlinks can also be created for links within the same document. Linking -Technology

Last Answer : False Linking within the same document is called internal linking.

Description : Yesterday, Rahul created a file named detail.txt and saved it. -Technology

Last Answer : He can find his file by using Search option.

Description : A new text document can be created by (a) File —> Open (b) File —> New —> Blank Document —> Create -Technology

Last Answer : (b) Steps to create a new document.File —> New —> Blank Document —> Create

Description : When the Edit Individual Documents option is selected, how does each letter appear in the new document created after the merge? -Technology

Last Answer : (b) When the Edit Individual Documents option is selected, separate sections for each letter appear in the new document created after the merge.

Description : Copy of data created for safe storage is ………… -Technology

Last Answer : Copy of data created for safe storage isback up.

Description : How are charts created in Excel? Write the steps. -Technology

Last Answer : Creating a Chart:Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:1. Select the data that you want to show, including the ... Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

Description : A chart is created on the basis of values in ……………… (a) mail merge -Technology

Last Answer : (c) A chart is a pictorial representation of data that created on the basis of values in a spreadsheet.

Description : Copy of data created for safe storage is a) Saved copy b) Backup c) Dcopy d) Stored copy -Technology

Last Answer : Copy of data created for safe storage isBackup

Description : List any 3 items that can be created using DHTML. -Technology

Last Answer : DHTML can be used to create the following:AnimationPop-up menusInclusion of Web page content from external data sourcesElements that can be dragged and dropped within the Web page

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()

Description : Albert works as a Website developer in Global Website Designers company. Currently he has created following tags in XML : -Technology

Last Answer : These tags are part of XML code. These are different because XML is a case sensitive language.

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

Last 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.

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)

Description : ……….. helps to create and maintain social relationship. -Technology

Last Answer : Social networkinghelps to create and maintain social relationship.

Description : The …………. tag is considered to establish a hypertext relationship between the current document and another URL. -Technology

Last Answer : The tag is considered to establish a hypertext relationship between the current document and another URL.

Description : Which mathematical symbol set expresses a negated relationship? -Technology

Last Answer : Negated Relations symbols that express a negated relationship.

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.

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

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.

Description : Consider the following table: Employee EmpNo EmpName Designation -Technology

Last Answer : 1. EmpNo can be selected as a primary key.2. EmpName is having unique values, but there is no guarantee that if more employees are included then there would not be multiple people with similar names.So, in future, its values may be duplicate. Thus, it cannot be made as a primary key.

Description : Sanchita is working for a nationalized bank and is in the process of creating a table to store the details of customers of the bank. -Technology

Last Answer : Primary key AccountNoCandidate key AccountNo and PAN NumberAlternate key PAN Number

Description : Data is stored in RDBMS in the form of (a) table (b) query -Technology

Last Answer : (a) Relational Database Management System stores data in the form of relation. As we know, relations are known as table.

Description : Out of the following, which one is the most appropriate data field in context of employee table, if only one of these is required? -Technology

Last Answer : (b) Date of birth is the most appropriate data field in the context of the employee table.

Description : Table is also known as ………… . -Technology

Last Answer : Table is also known asrelation.

Description : A field in a table is also called as ………………… . -Technology

Last Answer : A field in a table is also called ascolumn.

Description : ………….. is the smallest part of a table in which one data item can be kept. -Technology

Last Answer : Fieldis the smallest part of a table in which one data item can be kept.

Description : A foreign key is a reference of the ………….. key in another table. -Technology

Last Answer : A foreign key is a reference of the primary keyin another table.

Description : A database can have only one table. -Technology

Last Answer : False No, database does not have a limit on the number of tables. It depends on the disk space.

Description : A table can have multiple primary keys. -Technology

Last Answer : False If we create multiple primary keys in a table, the primary key will be unable to find the unique key value.

Description : A foreign key is a primary key in another table. -Technology

Last Answer : True When a table’s primary key field is added to a related table in order to create the common field which relates two tables, it is called a foreign key in the related table.

Description : What are two areas of the Design View of the table? -Technology

Last Answer : Field description and Field properties.

Description : Write down the steps to insert a new row into the table. -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1 When 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 3 When you have finished adding records in the datasheet, save it and close it.

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.

Description : The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla. -Technology

Last Answer : 1. Number of fields-62. Number of records-73. If a new child joins the SummerCamp, then SummerCamp would add a record to the table.4. If a child is shifted from one group to another, then ... the SummerCamp, then SummerCamp would delete a record of that child from the table.6. Text and Date/Time.

Description : Look at the given table called ‘Item’ and answer the questions. ItemId ItemName ItemStock ItemDOP Quanity Purchased -Technology

Last Answer : 1. ItemID —> TextItemName —> TextItemStock —> NumberItemDOP —> DateQuantityPurchased —> Number2. ItemID and ItemName can act as primary key.

Description : Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Last Answer : (d) From the given options Field Name, Field Type Primary Key are the part of a table.

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

Description : Which field property helps in setting data validation in a table? -Technology

Last Answer : (d) Validation Rule property specifies a condition that must be met before the data is accepted into the database.

Description : What is the purpose of the description column in table Design View? -Technology

Last Answer : (a) A Design View of the table provides three columns as Field Name, Data Type, and Description. The description column provides the facility to write the description about Field Name.

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.