0
What kind of query can change the contents of a table A selection query cannot?
Wiki User
∙ 14y ago
There are several types that can do it. A Delete Query, an Update Query and an Append Query can. You can also create and delete entire tables with queries.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Why selection query is first done than projection query?
Selection has more power to reduce size (Number of rows) while projection can not reduce number of tuples
What command is used to change contents of one database using the contents of another database by linking them on a common key field?
The SQL command UPDATE can be used to change contents of one database using the contents of another database by joining them on a common key field. You would typically use a query with a join condition between the two tables based on the common key field to update the fields in the target table with values from the source table.
Is a placeholder for data whose contents can change?
A variable is a placeholder for data whose contents can change. In database programming, there is also an SQL results area usually called a cursor. This will hold the results of a particular query when it is executed. How these are implemented change based on the programming language and database being accessed.B. 4/2009 - In MS Word (Office 2007), the answer is a field. (source: this was on a test I just took and I guessed on it, but the answer was right)
What is is a placeholder for data whose contents can change?
A variable is a placeholder for data whose contents can change. In database programming, there is also an SQL results area usually called a cursor. This will hold the results of a particular query when it is executed. How these are implemented change based on the programming language and database being accessed.B. 4/2009 - In MS Word (Office 2007), the answer is a field. (source: this was on a test I just took and I guessed on it, but the answer was right)
How do you find average in query?
You need at least one numeric field in your query. Turn on the Total line in the query. Change the option under the numeric field to Average. When you run the query, you will get an average.
What does a query mean in a database?
to change and analyse answers
From this list select the format that you cannot export your query results to.?
Doc
What is a sigma query?
The Greek letter sigma is used to denote a selection operation: select * from foo where bar = 10;
What is reserved words in Microsoft Access?
These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.These are words that cannot be used for anything else as they have designated uses. So in a query there are key words that cannot be used as names for other things. So you could not use a field in a query called select, as select is a command in an SQL query. They are reserved for particular uses in Access. The same concepts applies all across computing, like in programming languages and commands for operating systems. A computer cannot be given two meanings for one word, so anything that already has a use cannot also be used for something else.
How to change a field to Uppercase in a query?
Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.Use an Update query and in it you would use the Upper function.
Why create view in database?
A View is similar to a Table and can be mistaken for a table by a novice application developer. CREATE VIEW VIEW_NAME AS SQL QUERY Here the SQL Query includes the Select query on a table that is to be displayed as a View. The view is a read only structure that only displays contents from a table and the user cannot insert or update or delete any data in the underlying table. Views are generally created to impose access restrictions to a specific subset of users whom you do not want to give full access but at the same time want them to view the data.
What are query string used for online?
Query strings online are used for searching information on the internet. When a person enters a a topic to research, the website a person is asking the information on will change the information into a query string to find the information for the person inquiring about.
