State any two differences between single row functions and multiple row functions. -Technology

1 Answer

Answer :

Differences between single row functions and multiple row functions.(i) Single row functions work on one row only whereas multiple row functions group rows(ii) Single row functions return one output per row whereas multiple row functions return only one output for a specified group of rows.

Related questions

Description : Name SQL Single Row functions (for each of the following) that 1. returns a number. -Technology

Last Answer : (i) ASCII () function returns a number.(ii) LCASE () function returns lowercase letters .(iii) DAYNAME () function returns names of days.(iv) DAYOFWEEK () function returns weekday number

Description : Write down the steps to insert a new row into the table. -Technology

Last Answer : Insert a RecordSteps to insert a record in a Datasheet View are as follows:Step 1 When you create a table, a new blank record automatically appears in the second row of the table or If you enter ... into the fields.Step 3 When you have finished adding records in the datasheet, save it and close it.

Description : HTML tag for row is (a) (b) -Technology

Last Answer : (b) HTML tag for row is .

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

Description : The rowspan attribute with < table > tag is used to merge more than one cells row wise. -Technology

Last Answer : True The rowspan attribute merges the cells row wise in a table.

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

Description : Table row tag can accept one attribute. -Technology

Last Answer : False The tag can accept many attributes.

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.

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.

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.

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.

Description : Write a small python code to drop a row from data frame labeled as 0. -Technology

Last Answer : # Drop rows with label 0df = df.drop(0)print(df )

Description : State any two differences between the works of Lumiere Brothers and Georges Melies. -Technology

Last Answer : Lumiere-Realism, Documentary. Melies- Non-realism, Fantasy.

Description : Having multiple perceptrons can actually solve the XOR problem satisfactorily: this is because each perceptron can partition off a linear part of the space itself, and they can then combine their results. ... have to be explicitly hand-coded d) False - just having a single perceptron is enough

Last Answer : c) True – perceptrons can do this but are unable to learn to do it – they have to be explicitly hand-coded

Description : When I sneeze, why is it always multiple (usually 6-8 times) in a row?

Last Answer : some people have what I call the “multiple sneeze gene” where they never sneeze just once. My mom has it, my coworker has it. I don’t have it, i sneeze just once.

Description : The“““.enables you tosimultaneously keep multiple Web pagesopen in onebrowser window. (A) tab box (B) pop-up helper (C) tab row (D) addressbar (E) Esc key

Last Answer : tab row

Description : The _____enables you to simultaneously keep multiple Web pages open in one browser window: a) tab box b) pop - up helper c) tab row d) address bar e) Esc Key

Last Answer : c) tab row

Description : State any two functions of operating system,. -Technology

Last Answer : 1. Device managementIn a computer system, there is a tremendous speed mismatch between the CPU and the I/O devices. The job of an operating system is to maintain a balance between the CPU and I/O ... execution, a process needs certain resources such as CPU time, memory space, files and I/O devices.

Description : State three functions of the Slides Pane. -Technology

Last Answer : Three functions of the Slides Pane are as follows:1. New slides may be added to the presentation.2. Allows marking a slide as hidden for not showing it during a slide show.3. Deleting a slide from the presentation in case it is no longer neede

Description : Write down any two points of differences between LAN, MAN and WAN. -Technology

Last Answer : Two major points of differences among LAN, MAN and WAN are as follows:1. Distance Covered LAN can cover an area upto 5 km. More than 5 km and upto 100 km comes under MAN. Beyond 100 km, the area can be covered by WAN only.2. Cost LAN has lower cost as compared to MAN and WAN.

Description : Write two points of differences between XML and HTML. What is meant by a well_formed XML document -Technology

Last Answer : The differences between XML and HTML are as follows:1. HTML has predefined tags while XML has user-defined tags.2. HTML document can be viewed directly by the Web browser while XML document cannot be ... tags are case sensitive.The XML code is Singapore 200000 8 Aeroplane Shimla 10000 4 Bus

Description : Mention any two main differences between HTML and XML. Also mention any two main features of XML for which it’s used extensively now a days. -Technology

Last Answer : Two main differences between HTML and XML:HTML is used to display data and to focus on formatting of data, whereas XML is used to describe data and focus on what data is.HTML tags are predefined, ... for which it's used extensively nowadays:XML is used to store data.XML is used to exchange data.

Description : List any two differences betweenIncremental model and Spiral model in developing complex software projects. -Technology

Last Answer : Incremental model works on the stage-wise development of a complex project that involves real time data whereas Spiral model works on risk analysis of a real time situation.Spiral model is a combination of both Incremental as well as Waterfall method.

Description : Mention any two main differences between HTML and XML. Also mention any two main features of XML for which it’s used extensively now a days. -Technology

Last Answer : Two main differences between HTML and XML:HTML is used to display data and to focus on formatting of data, whereas XML is used to describe data and focus on what data is.HTML tags are predefined, whereas ... it's used extensively now a days:XML is used to store data.XML is used to exchange data

Description : What are the differences between wired and wireless communication channels? -Technology

Last Answer : Wired Communication ChannelWireless Communication ChannelIt is more secure.More security measures need to be considered for providing security.It is faster than wireless communication.It is slower than wired ... device cannot be moved.User device can be moved easily within the wireless range.

Description : Write differences between online backup and offline backup. -Technology

Last Answer : Differences between online backup and offline backup are as follows:Online backupOffline backupYou don't have direct control over your data.The data is totally in your control.If you have a fire, flood, ... about it.If you have a fire or flood, your backupmight be damaged along with your computer.

Description : A two way video conversation among multiple participants is called (a) video chatting (b) video talking -Technology

Last Answer : (c) Two or more people hear and see each other, share the whiteboard and other applications through video conferencing.

Description : How multiple E_mail addresses are defined in To, Cc, Bcc field? -Technology

Last Answer : By using a comma between E-mail addresses.

Description : How multiple E_mail addresses are defined in To, Cc, Bcc field? -Technology

Last Answer : By using a comma between E-mail addresses.

Description : A table can have multiple primary keys. -Technology

Last Answer : False If we create multiple primary keys in a table, the primary key will be unable to find the unique key value.

Description : The time_sharing operating system allows multiple programs share the computer resources simultaneously. -Technology

Last Answer : TrueIn time-sharing OS, a small amount of time is allocated for the processing simultaneously.

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

Last Answer : , and

Description : To keep better track of multiple Windows, ………….. or tiling is used. -Technology

Last Answer : To keep better track of multiple Windows, cascadingor tiling is used.

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 : Can same CSS document be used in multiple XML documents? -Technology

Last Answer : Yes, the same CSS document can be used in multiple XML documents.

Description : In XML, ……….. cannot contain multiple values. -Technology

Last Answer : In XML,attributescannot contain multiple values.

Description : Purchasing of only one licensed copy of a software and distributing/loading it onto multiple systems is called as ………… -Technology

Last Answer : (a) Softlifting is a common type of software piracy in which a legally licensed software program is installed or copied in violation of its licensing agreement.

Description : What is Pivoting? Name any two functions of Pandas which support pivoting. -Technology

Last Answer : Pivoting means to use unique values from specifiedindex/columns to form apex of the resulting dataframe.Pivot() and pivot_table() methods

Description : What are the functions of an interpreter? -Technology

Last Answer : Interpreter is very useful for debugging and suitable for novice programmer. This is a slow process and consumes less memory space.Some basic functions of an interpreter are as follows:1. Translates one instruction at a time.2. It checks the execution of the instructions line-by-line.

Description : What is an operating system? Explain its functions with an examples. -Technology

Last Answer : It is a program that acts as an interface between the user and the hardware (i.e. for all computer resources). An operating system is an important component of a computer system, which controls and ... users cannot access the system e.g. MS-DOS, Windows 95, Windows XP, Windows Vista etc.

Description : Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware and application softwares to be loaded; gives prompts and error reports to the users.2. Antivirus and compression tool.

Description : Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware, enables applications, software to be loaded; gives prompts and error reports to the users.2. Command-driven user interface means CUI, by which a user gives instructions via typing command onto the computer.

Description : Write all the functions of Minimize button. -Technology

Last Answer : The Minimize button is among the three buttons at the right end of the title bar. This button has a small dash (or minus sign). It shrinks the window and places it on the taskbar while leaving the program running. To go back to this window, click on taskbar where it is shrinked.

Description : What is a File? Explain its functions. -Technology

Last Answer : FilesThese are the collection of information. In fact, almost all type of information is stored into the files. There are many types of files stored in different formats including operating system files, program ... period ( )).e.g. A document created using WordPad might have the filename John.rtf.

Description : Write three functions that can be performed in Slide Sorter view of a presentation. -Technology

Last Answer : The three functions that can be performed in Slide Sorter view are as follows:1. We can see the entire presentation.2. We can move slide from one place to another using click-drag method. Also, we can rearrange the order of slides.3. We can insert, rename and delete slides.

Description : ……… is a program that appears harmless but actually performs malicious functions. -Technology

Last Answer : Trojan horse is a program that appears harmless but actually performs malicious functions.

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

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

Description : Explain any five functions that can be used in a worksheet. -Technology

Last Answer : 1. SUM FunctionThis function, as clear from the name, is used to add all the values provided as an argument and to display the result in the cell containing the function.Argument Type All ... 0 (zero).Arguments that are error values or text that cannot be translated into numbers cause errors.

Description : What are the main functions related to information? -Technology

Last Answer : Following are the three main functions related to information:1. Collecting information2. Storing information3. Distributing information