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

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

1 Answer

Answer :

Column NameData TypeRollNoIntegerNameVarchar(20)
by

Related questions

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

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.

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

Ramesh is a student of standard X. He organized many activities in his school to convey the students about the various advantages and disadvantages of using renewable and non-renewable sources of energy. Many students of the school took part and concluded about the best choices of energy sources on this basis. Answer the following questions: (i) What activities Ramesh might have had assigned for the students? (ii) Name any two renewable sources of energy. (in) Which two values are reflected in Ramesh’s thought and action? -Science

Description : Ramesh is a student of standard X. He organized many activities in his school to convey the students about the various advantages and disadvantages of using renewable and non-renewable sources of energy. Many ... of energy. (in) Which two values are reflected in Ramesh's thought and action? -Science

Last Answer : (i) Activities that Ramesh have had assigned for the students are: (a) Hands on projects related to renewable and non-renewable sources of energy. (b) Photograph exhibitions on the topic ... of renewable source of energy. Ramesh’s action: Concern for community advantage and good management.

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

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.

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

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.

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

In a table, columns are called ………. and rows are called ………… . -Technology

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.

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

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.

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

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

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

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

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

Name the Indian table tennis player who won gold medal in 18th commonwealth games. (a) A. Sharat Kamal (b) Ramesh Kumar (c) Krishan Kumar (d) Raj Singh

Description : Name the Indian table tennis player who won gold medal in 18th commonwealth games. (a) A. Sharat Kamal (b) Ramesh Kumar (c) Krishan Kumar (d) Raj Singh

Last Answer : (a) A. Sharat Kamal

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

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.

Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Description : Observe the table named “Training” given above carefully and predict the output of the following queries: -Technology

Last Answer : (i) New DelhiFaridabadGurugram(ii) 2(iii) 11000(iv) Ms. Neena

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Description : Observe the given table named “Loan” carefully and predict the output of the following queries: -Technology

Last Answer : (i)(ii)(iii)(iv)

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

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

What is the degree and cardinality of the above given table named ‘Training’. -Technology

Description : What is the degree and cardinality of the above given table named ‘Training’. -Technology

Last Answer : Degree: 6Cardinality: 5

It’s an era of online financial transactions. Help Julie in identifying any two challenges which a common man may face for the same. -Technology

Description : It’s an era of online financial transactions. Help Julie in identifying any two challenges which a common man may face for the same. -Technology

Last Answer : (i)A common man should have an electronic gadget like smart phone or computer.(ii) A common man should be oriented for online financial safety measures.

It’s an era of online financial transactions. Help Julie in identifying any two challenges which a common man may face for the same. -Technology

Description : It’s an era of online financial transactions. Help Julie in identifying any two challenges which a common man may face for the same. -Technology

Last Answer : i. A common man should have an electronic gadget like smart phone or computer.ii. A common man should be oriented for online financial safety measures

Help Manish in identifying the incorrect variable name with justification from the following: -Technology

Description : Help Manish in identifying the incorrect variable name with justification from the following: -Technology

Last Answer : I. (i)[emailprotected]; // Special symbols like '@' is not allowed in variable name(iv) avg marks;// Spaces are not allowed in variable nameII.int price;price=10;price=price*2;price=price-5;

On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Description : On the basis of the Table Student, write the output(s) produced by executing the following queries: -Technology

Last Answer : (i)Max(Average)Min(Average)9565(ii)NameShrishtiAdityaRitu RajSaumyaAshutoshAman

In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology

Description : In the table “Student”, Priya wanted to increase the Marks (Column Name: Marks) of those students -Technology

Last Answer : Correct SQL statement :UPDATE Student SET Marks = Marks +5 WHERE Marks

While creating the table Student last week, Ms. Sharma forgot to include the column -Technology

Description : While creating the table Student last week, Ms. Sharma forgot to include the column -Technology

Last Answer : ALTER TABLE Student ADD Game_Played VARCHAR (30) ;

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;

Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology

Description : Mrs. Sharma is the classteacher of Class ‘XII A’. She wants to create a table ‘Student’ to -Technology

Last Answer : (i) RolINo, Name can be the attributes of Student table.(ii) Primary key of the table Student is RolINo, because RolINo is a field in Student table which uniquely identifies each rows/records in a database table.

Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Description : Consider the table STUDENT given below: RollNo Name Class DOB Gender City Marks 1 Anand XI 6/6/97 M Agra 430 -Technology

Last Answer : (1)b. Both (iii) and (iv)(2) b.RollnoNameClassDOBGenderCityMarks6734MaakhiyNehaGeetPreetiXIXXIXII12/12/948/12/956/5/978/8/95FFFFDubaiMoscowAgraMumbai256324470492

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

Suggest the suitable data type for Issue_Date column. -Technology

Description : Suggest the suitable data type for Issue_Date column. -Technology

Last Answer : (i)Date(ii) alter table library modify name varchar(50);(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.(iv) Select name from library order by status desc;

Suresh and Ramesh are twins. In a form by mistake, Suresh reverses the last 2 digits of his year of birth, and this makes him 9 years older than Ramesh. With this mistake, the sum of their ages in 2015 becomes 43. How old will Ramesh be 2021? a) 17 b) 19 c) 21 d) 23 e) 25

Description : Suresh and Ramesh are twins. In a form by mistake, Suresh reverses the last 2 digits of his year of birth, and this makes him 9 years older than Ramesh. With this mistake, the sum of their ages in 2015 becomes 43. How old will Ramesh be 2021? a) 17 b) 19 c) 21 d) 23 e) 25

Last Answer : Let the correct ages of Ramesh and Suresh be X in 2015 (since they are twins, they will have the same age) Given: 2x + 9 = 43 Or x = 17 years in 2015. Age in 2021 = 17 + 6 = 23 Note: year of birth = 2015 – 17 = 1998. Reversing, Suresh = 1989 or 9 year older. Answer: d)

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

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.

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

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

Last Answer : (i) DateofBirth(ii) Admno(iii) Phonenumber

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.

Which tag is used to add columns in the tables? (a) <colspan> (b) <td> -Technology

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.

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

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.

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

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

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

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.

...method in Pandas can be used to change the index of rows and columns of a Series or Dataframe : -Technology

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

Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?

Description : Statistical table is the systematic arrangement of numerical data presented in rows and columns. What are the rules to be followed while constructing such a table?

Last Answer : Statistical table is the systematic arrangement of numerical data presented in rows and columns. ... be followed while constructing such a table?

In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Description : In a relational database, this is a data structure that organizes the information about a single topic into rows and columns. 1) Block 2) Record 3) Tuple 4) Table 5) Command line interface

Last Answer : Answer :4

In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To avoid confusion with actual legitimate data values like 0 (zero) for integer columns and ‘’ (the empty string) for string columns. (C) To leave columns in a tuple marked as “unknown” when the actual value is unknown. (D) To fill a column in a tuple when that column does not really “exist” for that particular tuple.

Description : In a relational database model, NULL values can be used for all but which one of the following? (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL. (B) To ... D) To fill a column in a tuple when that column does not really exist for that particular tuple.

Last Answer : (A) To allow duplicate tuples in the table by filling the primary key column(s) with NULL.

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

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.

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.

Memo data type allows you to store character type values in a table. -Technology

Description : Memo data type allows you to store character type values in a table. -Technology

Last Answer : True Memo data type allows upto 65536 characters.

Memo data type allows you to store only 255 characters in the table. -Technology

Description : Memo data type allows you to store only 255 characters in the table. -Technology

Last Answer : False Memo data type is used when character size is more than 255.

Ramesh Of name Money What ?

Last Answer : Ramesh Of name Money Yes Vishnu.

Ramesh bought 30 Rs.200 shares of a company available at a - premium of Rs.25. Find the investment made by Ramesh, and also the rate of interest (retu

Description : Ramesh bought 30 Rs.200 shares of a company available at a - premium of Rs.25. Find the investment made by Ramesh, and also the rate of interest (retu

Last Answer : Ramesh bought 30 Rs.200 shares of a company available at a - premium of Rs.25. Find the investment ... the company pays a dividend of `8%` per annum.

Satish can do 1/5th of a work in 5 days while he and Ramesh together can do 9/10th of the same work in 10 days. They start the work together and work

Description : Satish can do 1/5th of a work in 5 days while he and Ramesh together can do 9/10th of the same work in 10 days. They start the work together and work

Last Answer : Satish can do 1/5th of a work in 5 days while he and Ramesh together can do 9/10th of ... days in which Ramesh alone can finish the remaining work.

If Ramesh can complete 2/5th of a work in 24 days and Satish can complete 1/3rd of the work in 30 days, then in how many days can they complete the wo

Description : If Ramesh can complete 2/5th of a work in 24 days and Satish can complete 1/3rd of the work in 30 days, then in how many days can they complete the wo

Last Answer : If Ramesh can complete 2/5th of a work in 24 days and Satish can complete 1/3rd of the work ... days can they complete the work if they work together?

Who is the Metro Man of India? A. Elattuvalapil Sreedharan B. Ramesh Mishra C. Sumay Roy D. Himanshu Pradhan

Description : Who is the Metro Man of India? A. Elattuvalapil Sreedharan B. Ramesh Mishra C. Sumay Roy D. Himanshu Pradhan

Last Answer : A [Elattuvalapil Sreedharan] Explanation: Elattuvalapil Sreedharan is an Indian civil engineer and a retired IRSE officer popularly known as the "Metro Man".