answersLogoWhite

0

ms office

User Avatar

Wiki User

11y ago

What else can I help you with?

Continue Learning about Basic Math

What are some basic database functions that a spreadsheet cannot perform?

A spreadsheet is a computer application that simulates a paper accounting worksheet. It displays data in a two-dimensional matrix or grid consisting of rows and columns. Each column is a field, which used to define and store data and each row is a record, which is a connected set of one or more fields that describes an object such as person. While a spreadsheet allows for the creation of multiple tables, it does not support even the most basic database functionality such as support for self-documentation through metadata, enforcement of data types or domains to ensure consistency of data within a column, defined relationships among tables, or constraints to ensure consistency of data across related tables.


Compare the use of embedded SQL with the use in SQL of functions defined in a general-purpose of Programming language Under what circumstances would you use each of these features?

SQL functions are primarily a mechanism for extending the power of SQL to handle attributes of complex data types (like images), or to perform complex and non-standard operations. Embedded SQL is useful when imperative actions like displaying results and interacting with the user are needed. These cannot be done conveniently in an SQL only environment. Embedded SQL can be used instead of SQL functions by retrieving data and then performing the function's operations on the SQL result. However a drawback is that a lot of query-evaluation functionality may end up getting repeated in the host language code Regards, Jose Deleep. S


Are the php functions overloading allowed?

You cannot overload PHP functions. Function signatures are based only on their names and do not include argument lists, so you cannot have two functions with the same name. Class method overloading is different in PHP than in many other languages. PHP uses the same word but it describes a different pattern.You can, however, declare a variadic function that takes in a variable number of arguments. You would use func_num_args() and func_get_arg() to get the arguments passed, and use them normally.For example:// *******************************************function myFunc() {for ($i = 0; $i < func_num_args(); $i++) {printf("Argument %d: %s\n", $i, func_get_arg($i));}}/*Argument 0: aArgument 1: 2Argument 2: 3.5*/myFunc('a', 2, 3.5);// ********************************************


How many type of SQL?

There are three types of SQL: 1. Cognos SQL 2. Native SQL 3. Pass-through SQL Cognos SQL Framework Manager generates Cognos SQL in a more efficient manner in order to keep its functionality. It is common for Cognos SQL to be translated into Native SQL before being transmitted to the database for processing. Some actions or functions may not be supported by the database in some instances. Only a portion of the Cognos SQL is transmitted to the database in these situations. As a result, the database handles part of the query and the Cognos server handles the rest. Advantages: Has the ability to include metadata from many sources. Reduce the number of database constraints Interact more effectively with Cognos applications. Disadvantages: You cannot use non standard SQL. Native SQL Databases such as Oracle, SQL Server, and DB2 all support SQL. Using Native SQL in a model query subject with many data sources is not possible. Advantages: All relevant query subjects are optimized for performance. You can utilize SQL that is specific to the database you are using. Disadvantages: You cannot use SQL that the data source does not support for sub queries. The query subject may not be compatible with different database types. Pass-through SQL Allows the usage of Native SQL without regard to the limitations imposed on subqueries by the data source. Subqueries are not processed in Pass-Through SQL query subjects. It is instead supplied directly to the data source that generates query results for each subject. It is important to keep in mind that pass-through SQL is delivered straight to the data source rather than being optimized by the Framework Manager, therefore performance will be lower than with the other query options. Using curly brackets around your SQL statement in a Tabular SQL object causes that SQL statement to be passed through to the database. Cognos has not validated this SQL, so take that into consideration. Step1: Create a Tabular SQL object. Write a statement surrounded with { }. Actual: SELECT * FROM ORDER HEADER Pass-Through: {SELECT * FROM ORDER HEADER} Advantages: You can use any SQL supported by the database. Disadvantages: Framework manager does not have the ability to automatically optimize performance. In some cases, the SQL won't function with another data source.


What fraction of these palindromes are multiples of 3?

Since there are no palindromes, the question cannot be answered.Since there are no palindromes, the question cannot be answered.Since there are no palindromes, the question cannot be answered.Since there are no palindromes, the question cannot be answered.

Related Questions

What functions does project management software provide that you cannot do easily using other tools such as a spreadsheet or database?

i would like to know the fuctions that the project management software provide that you cannot doeasily using other tools such as a spreadsheet or data base?


What type of operation can you perform in MS-EXCEL which you cannot do on a database?

d


Why do complex organisms need specialized cell?

Complex organisms need cells that perform many different functions. Complex organisms are capable of a lot of different things, and that variety needs to be supported on the cellular level. Without them, complex organisms cannot perform different functions.


If you cannot perform the essential functions of this job without reasonable accommodation?

yes or no


What could happen if coronary blood vessels cannot perform their functions?

dthjftjh


What are some basic database functions that a spreadsheet cannot perform?

A spreadsheet is a computer application that simulates a paper accounting worksheet. It displays data in a two-dimensional matrix or grid consisting of rows and columns. Each column is a field, which used to define and store data and each row is a record, which is a connected set of one or more fields that describes an object such as person. While a spreadsheet allows for the creation of multiple tables, it does not support even the most basic database functionality such as support for self-documentation through metadata, enforcement of data types or domains to ensure consistency of data within a column, defined relationships among tables, or constraints to ensure consistency of data across related tables.


Why Databases might be better than word processor documents and Spreadsheet documents for the job that they do?

Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.Each are designed for different types of jobs, so you cannot really compare them. All have the capabilities to do things that the others can do, but each is specially designed to do a particular job. If you wanted to create a database you could do it in a word processor or a spreadsheet. However, neither will give you the full facilities to do databasing operations that you would have if you actually used a database application. Some things could be done, but would be more difficult to do in the other applications. If you want to set up a complex database, then you would use a database application, just like if you wanted to do a letter you would use a word processor or if you wanted to create a spreadsheet you would use a spreadsheet application.


why are cell organelles important?

because without it cells cannot perform any functions and so there will be no life


What is difference between Excel and RDBMS?

Excel is a spreadsheet application. RDBMS is a Relational Database Management System. Excel has databasing capabilities, but does not have the capabilities of a relational database. There are many facilities in a RDBMS that Excel cannot do or can only do to a very limited amount. Excel is for numerical analysis and manipulation, which is what a spreadsheet is for. Databases are for managing lists of data. So while they both can manipulate data, they are for different kinds of jobs.


How are databases and spreadsheets similar?

The data relational model is to do with databases. While you can do databases with a spreadsheet, it is limited compared to a standard database product and it is difficult to implement the relational model effectively. Relational databases use tables that are connected to each other. Spreadsheets lay out data in tabular form and it is possible to have relations between separate tables, but not in the way that it is done in a database. A database sets up a table in a more specialised format and only holds the data it needs. A spreadsheet would have a table in it, but it would not be the complete spreadsheet as you would have lots of unused cells in the spreadsheet. So you would not normally implement a relational database in a spreadsheet.


What are the procedures in rdbms?

Procedures in an RDBMS are programs that are written to accomplish a set of functions that cannot be done using a single query. A procedure contains a sequence of SQL Queries that can be executed one after the other by invoking the procedure. There are two kinds of procedures Functions &amp; Stored Procedures.


What main function of ms-Excel are not available in ms-word?

They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.They are very different applications, designed to do different jobs. Although many people don't know it, using tables in Word, it is possible to do some simple spreadsheet functions, like SUM. It would be hard to say what is the main function that it cannot do as there are so many things that it cannot do compared to Excel. Hundreds of more complex functions and formulas are not available and things like creating charts from the data.