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

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

1 Answer

Answer :

1. 26th column: Z2. 28th column: AB
by

Related questions

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is: (A) Select *from customers where city=’%GAR%’; (B) Select *from customers where city=’$GAR$’; (C) Select *from customers where city like ‘%GAR%’; (D) Select *from customers where city as ’%GAR’;

Description : Consider a CUSTOMERS database table having a column CITY filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have GAR somewhere in its name, ... *from customers where city like %GAR%'; (D) Select *from customers where city as '%GAR';

Last Answer : Answer: C

Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Description : Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Last Answer : Computer network is defined as a group of computers connected to each other by a link.

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.

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.

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.

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.

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;

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

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)

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

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;

Pick out the wrong statement. (A) Different solids have different equilibrium moisture curves (B) Total condenser or reboiler is considered equivalent to one theoretical plate in McCabe-Thiele method of theoretical plate calculation for distillation column (C) Heat removal load on cooler remains constant, even with increase of the reflux ratio in a distillation column (D) Even a forced draft cooling tower cannot cool water below the wet bulb temperature

Description : Pick out the wrong statement. (A) Different solids have different equilibrium moisture curves (B) Total condenser or reboiler is considered equivalent to one theoretical plate in McCabe-Thiele method of ... (D) Even a forced draft cooling tower cannot cool water below the wet bulb temperature

Last Answer : (C) Heat removal load on cooler remains constant, even with increase of the reflux ratio in a distillation column

Domain names always have two or more parts, separated by (a) commas (b) periods (called dots) -Technology

Description : Domain names always have two or more parts, separated by (a) commas (b) periods (called dots) -Technology

Last Answer : (b) A domain name is a hierarchical series of character strings representing different levels of domains separated by dot/period.

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

Give the names of five data types used in MS_Access. -Technology

Description : Give the names of five data types used in MS_Access. -Technology

Last Answer : Text, Memo, Date/Time, Yes/No and Currency.

Write down the names of the components of multimedia. -Technology

Description : Write down the names of the components of multimedia. -Technology

Last Answer : Components of multimedia are text, audio, video, images and animation.

Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Description : Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Last Answer : Two graphic objectsare Picture and AutoShapes

For internal linking, the section names are provided by attribute of <a> tag. (a) title (b) href -Technology

Description : For internal linking, the section names are provided by attribute of tag. (a) title (b) href -Technology

Last Answer : (c) For internal linking, section names are provided by name attribute.

Write names of two attributes each for the following tags: 1. <hr> 2. <body> -Technology

Description : Write names of two attributes each for the following tags: 1. 2. -Technology

Last Answer : TagAttributesalign, widthbgcolor, textsrc, altborder, ruleshref, name

Names in XML document must start either with a letter, number or underscore. -Technology

Description : Names in XML document must start either with a letter, number or underscore. -Technology

Last Answer : False Names in XML must start either with a letter or underscore character.

In XML, tag names cannot contain spaces but can uses underscores. -Technology

Description : In XML, tag names cannot contain spaces but can uses underscores. -Technology

Last Answer : True Tag name must start either with a letter or underscore (_) character.

(i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Description : (i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Last Answer : mysql> Select Name,SalesAmt from Store order by noOfEmp;mysql> Select city, sum(SalesAmt) from store group by City;mysql> Select count(*),City from store group by City having count(*)>2; ... ;Min(DateOpen)2015-02-06mysql> Select Count(StoreId), NoOfEmp from Store group byNoOfemp having max(SalesAmt)

Identify the invalid variable names. State the reason if invalid. -Technology

Description : Identify the invalid variable names. State the reason if invalid. -Technology

Last Answer : Marks Unit is an invalid variable name because variable name does not allow spacing.

1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Description : 1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Last Answer : SQL commands for the given statements :(i) SELECT NAME, TESTID, TESTNAME FROM PATIENT, TESTWHERE PATIENT. TESTID = TEST. TESTID AND DTADMIT BETWEEN 01-DEC-2017' AND '15-DEC-2017' ;(ii) SELECT NAME, TESTNAME, COST ... NAME LIKE '% Sharma %' ;(iii) UPDATE TEST SET COST = COST +50 WHERE COST < 200 ;

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

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

Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Description : Below is the list of various types of application softwares: A. Database B. Desktop publishing C. Drawing -Technology

Last Answer : 1. Drawing2. Word processing3. Desktop publishing4. Spreadsheet5. Database

The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Description : Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Last Answer : 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

Some features of a specific operating system are given below: 1. Free/Open source -Technology

Description : Some features of a specific operating system are given below: 1. Free/Open source -Technology

Last Answer : (i) Linux(ii) With Linux, you get four desktop screens known as workspace.

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998

Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Description : Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Last Answer : The HTML code is

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

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.

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

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.

Draw the XML tree for code given below: -Technology

Description : Draw the XML tree for code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: <MOVIES> <ENGLISH> -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below -Technology

Description : Draw the XML tree for the code given below -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).