Identify the columns out of the given three, which should not be present in each of the following tables: -Technology

1 Answer

Answer :

(i) DateofBirth(ii) Admno(iii) Phonenumber

Related questions

Description : Which tag is used to add columns in the tables? (a) (b) -Technology

Last Answer : (b) is used to add columns in the tables.

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Description : How many rows and column will be there in the Cartesian product of the above given tables. Also mention the degree and cardinality -Technology

Last Answer : Cartesian Product:Number of Rows: 20Number of Columns: 9Degree: 9Cardinality: 20

Description : Consider the tables given below. Salesperson -Technology

Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.

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.

Description : Given the table ‘Player’ with the following columns : -Technology

Last Answer : Output of the given statements(i)AVG (POINTS)30(ii)COUNT(POINTS)2

Description : A database is typically composed of one or more: a) Columns b) Files c) Rows d) Tables e) None of These

Last Answer : d) Tables

Description : Database is made up of all the following components except (a) tables (b) queries -Technology

Last Answer : (d) A database is made up of tables, queries, and forms.

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.

Description : A report allows you to represent data retrieved from one or more tables so that, it can be analysed and printed if required. -Technology

Last Answer : True When you want to print those records which are fetched from your database then, reports are more useful for this purpose.

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

Description : Which of the following is used to specify the beginning of a table’s row? (a) -Technology

Last Answer : (b) tag indicates the beginning of a table’s row.

Description : Which tags divide HTML tables in multiple section? -Technology

Last Answer : , and

Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology

Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. -Technology

Last Answer : (i)Acc_No, Cust_Phone(ii)All the columns having capability to become Primary Key are known as Candidate Keys.(iii)Acc_No(iv)Trans_Id

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Description : Consider the following tables PATIENT and TEST and answer the questions that follow : -Technology

Last Answer : Primary key in PATIENT and TEST tables are PCODE and TESTID respectively. Because primary key of a relational table uniquely identifies each record.Foreign key in PATIENT table is TESTID whose value is derived from the primary key (TESTID) of another table (TEST).

Description : Identify the plants in the given figure and match the columns.

Last Answer : Identify the plants in the given figure and match the columns.

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 : In a table, columns are called ………. and rows are called ………… . -Technology

Last Answer : In a table, columns are called fields and rows are called records.

Description : Which attribute of tag is used to merge two or more columns to form a single column? (a) colspan (b) cellspacing -Technology

Last Answer : (a) colspan attribute is used to merge two or more columns to form a single column.

Description : Which tag is used for giving heading to the columns? -Technology

Last Answer : The tag is used to display the table heading only once for a table column.

Description : The……………… attribute is used to span two or more columns in a table. -Technology

Last Answer : The colspanattribute is used to span two or more columns in a table.

Description : The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Last Answer : True The cols value in the rules attribute is drawn between columns only.

Description : The rowspan attribute is used to make a cell span multiple columns. -Technology

Last Answer : False The rowspan attribute is used to make a cell span multiple rows

Description : …………. splits text in columns at a specific point. (a) Column break (b) Page break (c) Next page (d) Continuous -Technology

Last Answer : (a) Column bj;eak splits text in columns at a specific pointing.

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 : 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 : ...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology

Last Answer : Correct option(ii)reindex

Description : ‘Class’ table has columns RNO and NAME. The following statements are executed: -Technology

Last Answer : Output for the 1st SELECT * FROM Class ; statement -RNONAME5Rajeev6Chris7FerozeOutput for the llnd SELECT * FROM Class; statementRNONAME5Rajeev6Chris

Description : Identify the type of network (out of LAN/PAN/MAN/WAN) formed in the given diagram: -Technology

Last Answer : PAN(Personal Area Network)

Description : Carefully read the following descriptions and identify what is being talked about. 1. It consists of two insulated wires twisted around each other, -Technology

Last Answer : 1. Twisted pair cable2. Crosstalk3. Radiowave4. Wired communication channel5. Resource sharing

Description : Identify the errors in the following HTML code and write the correct code with each correction underlined. -Technology

Last Answer : Error 1 The tag must be within element.Error 2 bgcolor attribute of body element supports a color like red, green or its color value.Error 3 tag needs a source attribute src to place an ... element must be closed not bgcolor attribute.The correct code is as follows:IMAGESHERE IS MY IMAGE FILE

Description : Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Last Answer : (a) Scanner(b) Barcode reader(c) Optical Mark Recognition (OMR)(d) Magnetic Ink Character Recognition (MIGR)(e) Printer (f) Speaker

Description : Carefully study the Web page given here. Identify 10 tags -Technology

Last Answer : 1. . It encloses the entire HTML document and tells the browser that it is reading an HTML document and to display as such.2. It encloses the head of the HTML document and it is used to contain ... It is used to insert a horizontal line.10. .. This tag is used to align the text centrally.

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Last Answer : 1. to specify the title of the Web page.2. contains all the content that is to be displayed on the Web page and all the various formatting and structural tag.3. used to create an unordered ... anchor tag. Use the href attribute to provide the reference of the Web page that you want to hyperlink.

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Last Answer : 1. to specify title of the Web page.2. contains all the text content that is to be displayed on Web page and all the various formatting and structural tag.3. defines the most important and biggest ... provide caption to the table.9. used to create a table row.10. used to define data cells.

Description : Match the columns and identify the correct option. Column I Column II A. Thylakoids (i) Disc-shaped sacs in Golgi apparatus B. Cristae (ii) Condensed structure of DNA C. Cisternae (iii) Flat membranous sacs in stroma D. Chromatin (iv) ... iii), C-(i), D-(ii) (d) A-(iii), B-(iv), C-(i), D-(ii)

Last Answer : (d) A-(iii), B-(iv), C-(i), D-(ii)

Description : Identify the fastest wired media out of the following: Ethernet cable, Optical fiber, Co_axial cable -Technology

Last Answer : Optical fiber

Description : Quantitative data refers to (i) Graphs and tables (ii) Any data you present in your report (iii) Statistical analysis (iv) Numerical data that could be useful to answer your research question(s) and to meet your Objectives

Last Answer : (iv) Numerical data that could be useful to answer your research question(s) and to meet your Objectives

Description : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] Correct combination for `[PtCl_

Last Answer : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78 ... (IV),(iv),P D. (III),(ii),R

Description : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] Correct combination for `[VCl_(

Last Answer : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78 ... (III),(ii),R D. (IV),(iv),Q

Description : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] About `(CrCl_(3)(NH_(3))_(3))`

Last Answer : Matching the information given in the three columns of the following table. [Note: Atomic Number of Cr=24,V=23,Pt=78)] ... (IV),(i), R D. (I),(ii),S

Description : Can you identify examples of refugees utilizing technology to maintain contact with the homeland?

Last Answer : answer:@JonnyCeltics you do realize the vast majority of refugees do not have electricity, basic food and water and therefore little or no access to social networking, right? Those speaking ... (Facebook included) after last years quake/tsunami and the resulting nuclear meltdown in northern Honshu.

Description : Identify the software that helps you in sending and receiving an E_mail: (a) MS_Office (b) Internet Explorer -Technology

Last Answer : (c) MS-Outlook is preferred E-mail client which is used for sending or receiving an E-mail.

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

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

Description : Identify the odd term amongst the following. (a) Microwave (b) Radiowave (c) Bluetooth -Technology

Last Answer : (d) Except optical fibre, all are wireless transmission media.

Description : Identify the error(s) in the following HTML code. Also, write the correct code. -Technology

Last Answer : The error in the code is that in place of color attribute there should be bgcolor.The correct code is

Description : Identify the errors and write the correct HTML code 1. -Technology

Last Answer : 1. 2.