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

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
by

1 Answer

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

Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Description : Rishi, a class XII student has given following commands for the given purposes: (i) To add a new column “Rating” : -Technology

Last Answer : No, above commands will not be able to achieve desired task as update and alter commands have been interchanged.In order to achieve desired result, following corrections should be incorporated in the previously used ... give an increase of 50 Rs. to all the books:Update library set price=price+50;

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

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

How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Description : How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Last Answer : SQL is definitely not my specialty but you can use regular expressions within your select statement is this something you want to pull on the fly each time though? It seems like as your data set grows it ... ve got me wondering if I can write one SQL statement for it though, let me take a look.

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

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.

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)

Mr. Harry wants to draw a line chart using a list of elements named LIST. -Technology

Description : Mr. Harry wants to draw a line chart using a list of elements named LIST. -Technology

Last Answer : (i) PLINE.plot(LIST)(ii) PLINE.ylabel(“Sample Numbers”)

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.

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

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.

Consider the following table: Employee EmpNo EmpName Designation -Technology

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.

Consider the table ‘Employee’. -Technology

Description : Consider the table ‘Employee’. -Technology

Last Answer : SELECT DISTINCT (Location) FROM Employee ;

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.

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

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

What is table? Name the basic commands for creating a table. -Technology

Description : What is table? Name the basic commands for creating a table. -Technology

Last Answer : Tables are made up of rows and columns. In HTML, tables are used to display tabular data in Web pages.The basic commands for creating tables are as follows:Table tags Row tags Cell tags andCaption tags .

Of the four traditional roles of an artist as cited in your textbook, specifically identify which of those traditional roles was the most important for Warhol in creating the artwork depicted in Fig. 1-29, page 27 Explain why you chose that role?

Description : Of the four traditional roles of an artist as cited in your textbook, specifically identify which of those traditional roles was the most important for Warhol in creating the artwork depicted in Fig. 1-29, page 27 Explain why you chose that role?

Last Answer : When Warhol was creating the artwork they were using the role a visual record of the people, places, and events of their time and place. I wouldn't say any of the other roles really hit ... . This role was important for Warhol due to capturing the events that actually went down during these times.

Why do you think Mr Keesing chose the title - ̳An Incorrigible Chatterbox‘? i) Anne to express her inability to elaborate on such a topic. ii) That this would embarrass Anne and would check her indiscipline. iii) Her to apologise and not repeat her talkative behaviour. iv) Anne to explore her creative writing skills

Description : Why do you think Mr Keesing chose the title - ̳An Incorrigible Chatterbox ? i) Anne to express her inability to elaborate on such a topic. ii) That this would embarrass Anne and would check ... Her to apologise and not repeat her talkative behaviour. iv) Anne to explore her creative writing skills

Last Answer : ii) That this would embarrass Anne and would check her indiscipline.

Mr. (A) is a manager in a manufacturing company, he attempts to establish a culture of quality affecting the attitudes and actions of every employee and relies on a workforce that wants to improve quality. He focuses on establishing: (a) Total Quality Management ; (b) Knowledge management ; (c) Operations Management (d) Management of Information System

Description : Mr. (A) is a manager in a manufacturing company, he attempts to establish a culture of quality affecting the attitudes and actions of every employee and relies on a workforce that wants to ... Management ; (b) Knowledge management ; (c) Operations Management (d) Management of Information System

Last Answer : (c) Operations Management

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)

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

Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Description : Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Last Answer : ASCII: It is a 7 bit code that can represent 27 characters. It is platform dependent.UNICODE: It is 8 bit, 16 bit and 32 bit code to represent 28, 216, 232 characters respectively. It is platform independent.

Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Description : Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Last Answer : ASCII: It is a 7 bit code that can represent 27 characters. It is platform dependent. UNICODE: It is 8 bit, 16 bit and 32 bit code to represent 28 , 216, 232 characters respectively. It is platform independent.

Mr. Sebastine, a famous author, recently got his new novel released. To his utter dismay, he found that for the 1974 pages on an average there were 3 mistakes in every page. While, in the first 1024 pages there were only 2122 mistakes, they seemed to increase for latter pages. Find the average number of mistakes per page for the remaining pages. A) 5 B) 2 C) 3 D) 4

Description : Mr. Sebastine, a famous author, recently got his new novel released. To his utter dismay, he found that for the 1974 pages on an average there were 3 mistakes in every page. While, in the first 1024 pages there ... the average number of mistakes per page for the remaining pages. A) 5 B) 2 C) 3 D) 4

Last Answer : D According to the question X is the remaining pages average. 2122+(1974-1024)×x/1974=3 950x=5922-2122=3800 X=3800/950=4

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

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.

<th>‘tag is used to specify the column heading in a table. -Technology

Description : ‘tag is used to specify the column heading in a table. -Technology

Last Answer : True tag is used to specify the column heading in a table.

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

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;

What support package did Chancellor Rishi Sunak announced for UK businesses?

Description : What support package did Chancellor Rishi Sunak announced for UK businesses?

Last Answer : Chancellor Rishi Sunak earlier this week announced a new £4.6bn package in lockdown grants to support businesses and protect jobs as a result of the latest coronavirus restrictions.The further support measures follow ... ready to return when they are able to reopen The top-ups will be granted to c

The constellation `Sapta Rishi' is known to Westerners as the – (1) Seven Monks (2) Alpha Centauri (3) Big Dipper (4) Small Bear

Description : The constellation `Sapta Rishi' is known to Westerners as the – (1) Seven Monks (2) Alpha Centauri (3) Big Dipper (4) Small Bear

Last Answer : (3) Big Dipper Explanation: The Steady State theory (also known as the Infinite Universe theory or continuous creation) was developed in 1948 by Fred Hoyle, Thomas Gold, Hermann Bondi and others as ... asserts that the observable universe is basically the same at any time as well as at any place.

Mr. Pawan works as a programmer in “ABC Marketing Company” where he has designed a Salary -Technology

Description : Mr. Pawan works as a programmer in “ABC Marketing Company” where he has designed a Salary -Technology

Last Answer : (i) We need to double click at the Commission button (jButtonl) and type the following code :int Commission :if (jRadioButtonl. isSelected ( ) = True )Commission = 500 ;elseif ( ... and type the following code :int Net_Sal ;Net_Sal = Gross_Sal-Fac_Charges ;jTextField6. setText (Net_Sal) ;

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;

What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Description : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

Creating An Employee Contract: Reasons For Termination?

Description : Creating An Employee Contract: Reasons For Termination?

Last Answer : It is not difficult to create an employee contract. You just need to make a document that will set down the position that the person will hold, how much they will be paid, what they will be expected ... that those things happened, you will win the case. You will not have to pay the former employee.

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.

(i) Write command to compute sum of every column of the data frame. -Technology

Description : (i) Write command to compute sum of every column of the data frame. -Technology

Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )

what is 2.5 divided by 104 i got really confused?

Description : what is 2.5 divided by 104 i got really confused?

Last Answer : 0.024

If you got to chose between going to Las Vegas and hawaii what would you chose?

Description : If you got to chose between going to Las Vegas and hawaii what would you chose?

Last Answer : Hawaii definitely!

Using Table 2, find one Psalm from the five books that would relate to the topical themes that are noted in the table. Then briefly explain how the Psalm example you chose, fits with the theme?

Description : Using Table 2, find one Psalm from the five books that would relate to the topical themes that are noted in the table. Then briefly explain how the Psalm example you chose, fits with the theme?

Last Answer : bruh

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.

He claimed that he had set himself three goals in life: to be the greatest economist in the world, to be the best horseman in all of Austria and the greatest lover in all of Vienna. He said he had reached two of his goals, but he never said which two. Identify this economist after whom The Economist named a column on business and management.

Description : He claimed that he had set himself three goals in life: to be the greatest economist in the world, to be the best horseman in all of Austria and the greatest lover in all of Vienna ... said which two. Identify this economist after whom The Economist named a column on business and management.

Last Answer : Joseph Schumpeter.

Classify the following as primitive or non-primitive data types: (i) char (ii) arrays (iii) int (iv) classes

Description : Classify the following as primitive or non-primitive data types: (i) char (ii) arrays (iii) int (iv) classes

Last Answer : Ans. (i) char – Primitive (ii) arrays – Non primitive (iii) int – Primitive (iv) Classes – Non primitive