Suggest the suitable data type for Issue_Date column. -Technology

Suggest the suitable data type for Issue_Date column. -Technology
by

1 Answer

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

Related questions

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.

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)

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

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.

A cell is an intersection of a row and a column. -Technology

Description : A cell is an intersection of a row and a column. -Technology

Last Answer : True A cell is an intersection of a row and a column.

The <td> tag (column setting) have higher priority than <tr> tag (row setting). -Technology

Description : The tag (column setting) have higher priority than tag (row setting). -Technology

Last Answer : True The tag (column setting) have higher priority than tag (row setting).

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

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

Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Description : Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell? -Technology

Last Answer : First row and ninth column address will be II.

First row and ninth column address will be II. -Technology

Description : First row and ninth column address will be II. -Technology

Last Answer : There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.

What will be the column names of the below statement? -Technology

Description : What will be the column names of the below statement? -Technology

Last Answer : 1. 26th column: Z2. 28th column: AB

A cell range starting from first row, first column to fourth row and fifth column be can be represented as -Technology

Description : A cell range starting from first row, first column to fourth row and fifth column be can be represented as -Technology

Last Answer : (a) [A1: E4] because row count starts from 1 and column count starts from A andfirst we write the starting cell address.

Address of the cell at 10th column and 30th row is ……………… -Technology

Description : Address of the cell at 10th column and 30th row is ……………… -Technology

Last Answer : Address of the cell at the 10th column and 30th row is J30.

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;

Identify the primary key column of Train and Reservation. -Technology

Description : Identify the primary key column of Train and Reservation. -Technology

Last Answer : (i) Train-TrainIdReservation-RefNo(ii) (d) By default, the UNION operator selects all the values.

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)

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

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

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;

Could you suggest a good book for research on how technology is changing how we live?

Description : Could you suggest a good book for research on how technology is changing how we live?

Last Answer : Nonzero by Robert Wright. Changed my life! (Well, it made me way less pessimistic.)

Sweety wants to use an operating system based on graphical user interface, suggest her a name. -Technology

Description : Sweety wants to use an operating system based on graphical user interface, suggest her a name. -Technology

Last Answer : Windows is an operating system based on graphical user interface. Graphical user interface means that it has pictures (graphics) that you use to communicate (interface) with the computer.

Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Description : Ram wants to create a text file to store name and roll number of his students. Suggest, which program he should use. -Technology

Last Answer : He can create a text file using Notepad or WordPad. Follow these steps to create a file using Notepad:(a) Step 1:Click Start.(b) Step 2:Choose All Programs -> Accessories -> Notepad.(c) Step 3: ... dialog box will appear.(g) Step 7:Give file name with extension.(h) Step 8: Click Save button.

Suggest the appropriate functions for the following situations: -Technology

Description : Suggest the appropriate functions for the following situations: -Technology

Last Answer : 1. = MIN(A1 : C5)2. = IF(D5>5,000, “Discount”, “NoDiscount”)

Suggest the appropriate function for the following situations: -Technology

Description : Suggest the appropriate function for the following situations: -Technology

Last Answer : 1. = MAX(A1 : B20)2. = AVG(E5:15)3. =IF(J10 >= 40, “Pass”, “Fail”)

Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -Technology

Description : Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -Technology

Last Answer : getText(), setText()

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.

Twisted pair cable is suitable for broadband application. -Technology

Description : Twisted pair cable is suitable for broadband application. -Technology

Last Answer : FalseTwisted pair cable has low bandwidth capabilities and broadband application requires high bandwidth.

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

Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Description : Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Last Answer : The analysis of newspaper content suggests two broad categories of newspaper formatBroadsheet Press (quality or serious press)…. Explanation with examplesTabloid Press (Popular or sensational press)… Explanation with examples

Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Description : Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Last Answer : P: Personality-the facet indicates the core point of the subject at handM: Matter-reflects substance or material of the subjectE: covers problem, action including methods, functioning, and other ... their subdivisions, continent, etc.Time: represents periods, like, years, decades, centuries, etc.

Differentiate between <OL> and <UL> tag with suitable example. -Technology

Description : Differentiate between and tag with suitable example. -Technology

Last Answer : stands for Ordered List which can be either numerical or alphabetical while stands for Unordered List which can be either ... AND OUTPUTCODEHobbiesprogrammingDramaticsCODEHobbiesGamesProgrammingDramaticsOUTPUTHobbies1. Games2. Programming3. DramaticsOUTPUTHobbies1. Games2. Programming3. Dramatics

Explain the purpose of pow() method with the help of suitable java code. Also mention that pow() method belongs to which class? -Technology

Description : Explain the purpose of pow() method with the help of suitable java code. Also mention that pow() method belongs to which class? -Technology

Last Answer : pow() method, a mathematical method, helps in calculating the power of any number.For example:int num=2,power=4;int ans=Math.pow(num,power);t1.setText(''+ans);The above code will calculate the value of 24 and will give answer 16.pow() method belongs to math class.

Which software model is best suitable for client server application? -Technology

Description : Which software model is best suitable for client server application? -Technology

Last Answer : Concurrent Process model is best suitable for client server application.

Discuss the significance of having clause with group by statement with suitable example. -Technology

Description : Discuss the significance of having clause with group by statement with suitable example. -Technology

Last Answer : Sometimes we do not want to see the whole output produced by a statement with Group By clause. We want to see the output only for those groups which satisfy some condition. It means we want ... the total amount of all type of transactions, it will only display the total of credit transactions only.

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.

Suggest the suitable diode type for rectifier circuit.

Description : Suggest the suitable diode type for rectifier circuit. 

Last Answer : Any general purpose diodes 1N4001 to 1N4007 series  Or Silicon diode & Germanium diode 

__________ column is the most suitable for achieving the best performance for mass transfer operations involving liquid with dispersed solids. (A) Wetted wall (B) Packed (C) Plate (D) Spray

Description : __________ column is the most suitable for achieving the best performance for mass transfer operations involving liquid with dispersed solids. (A) Wetted wall (B) Packed (C) Plate (D) Spray

Last Answer : C) Plate

Pick out the wrong statement: (A) Reboiler is not used in open steam distillation (B) The separation of solutes of different molecular sizes in a liquid solution by use of a suitable membrane is called dialysis (C) Freeze drying is used for the drying of fish (D) Fenske-Underwood equation is used for calculating theoretical number of plates in a distillation column at normal operating reflux condition

Description : Pick out the wrong statement: (A) Reboiler is not used in open steam distillation (B) The separation of solutes of different molecular sizes in a liquid solution by use of a ... is used for calculating theoretical number of plates in a distillation column at normal operating reflux condition

Last Answer : (D) Fenske-Underwood equation is used for calculating theoretical number of plates in a distillation column at normal operating reflux condition

Which antivirus is suitable for gaming purpose on my computer. Please Suggest?

Description : Which antivirus is suitable for gaming purpose on my computer. Please Suggest?

Last Answer : Kaspersky or Bitdefender Antivirus Plus 2014. AVG and Avast are also good and they are free.

Suggest any three methods of soil conservation suitable to Indian conditions. -SST 10th

Description : Suggest any three methods of soil conservation suitable to Indian conditions. -SST 10th

Last Answer : Methods of Soil Conservation: (i) Construction of terraces farming. (ii) Afforestation (iii) Control of overgrazing (iv) Control of mining activities

Can you suggest me a car suitable for the off-road journey?

Description : Can you suggest me a car suitable for the off-road journey?

Last Answer : Need answer

Suggest a courier management software suitable for any size of business?

Description : Suggest a courier management software suitable for any size of business?

Last Answer : InstaDispatch courier management software is one of the leading courier software that suitable for any size of business. It has the ability to streamline your courier services the best management facilities. You can sign-up for your free 14-days demo on the official site of InstaDispatch.

Suggest a suitable subject for this letter. (i) Thefts are on the increase. (ii) Increasing threat of theft in Shyam Nagar. (iii) necessity of appointing day and night guards by the RWA. (iv) to call a meeting of the area residents.

Description : Suggest a suitable subject for this letter. (i) Thefts are on the increase. (ii) Increasing threat of theft in Shyam Nagar. (iii) necessity of appointing day and night guards by the RWA. (iv) to call a meeting of the area residents.

Last Answer : Increasing threat of theft in Shyam Nagar Gurgaon

(i) Suggest suitable scale for following: (1) Location plan (2) Poor details

Description :  (i) Suggest suitable scale for following: (1) Location plan (2) Poor details 

Last Answer : Suitable scale for- (1) Location plan – 1:1000 (2) Poor details – 1:20 or 1:10

Suggest suitable situation for Raft foundation and Pile foundation.

Description : Suggest suitable situation for Raft foundation and Pile foundation.

Last Answer : Suitability of Raft foundation:  1) Where the allowable bearing capacity of soil is less or the bridge load is heavy. 2) Where the hard soil is not available within 1.5m to 2.5m below the ... heavy scouring of river bed is expected. 4) Where heavy concentrated loads are to be taken by foundation.

Suggest the diode material suitable to rectify 0.5V AC signal.

Description : Suggest the diode material suitable to rectify 0.5V AC signal.

Last Answer : The diode material suitable to rectify 0.5V AC signal is silicon