Tags Science

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Science>General Science

What is the difference between alter system and alter database?

Anonymous

∙ 16y ago

Updated: 4/28/2022

Hi, According to Rauf Sarwar on http://comp.mailarchive.ca/databases.oracle.server/2003-06/1028.html ALTER DATABASE:

Changes the operation of a database with respect to redo logs and data files. Backs up control files. Mounts, Dismounts, Opens, Closes a database. Performs media recovery. ALTER SYSTEM:

Performs a specialized system function e.g. Kill session, Start/Stop archiving etc. Regards Mwamba Mutale

Wiki User

∙ 16y ago

Still curious? Ask our experts.

Chat with our AI personalities

Ezra

Faith is not about having all the answers, but learning to ask the right questions.

Chat with Ezra

Steve

Knowledge is a journey, you know? We'll get there.

Chat with Steve

Beau

You're doing better than you think!

Chat with Beau

Add your answer:

Earn +20 pts

Q: What is the difference between alter system and alter database?

Write your answer...

Submit

Still have questions?

imp

Continue Learning about General Science

What difference in a note does the amplitude of a sound wave make?

Changing the amplitude of a note will alter its volume.

What is an alter in a church?

The part of the church that the pries stands, at the back

You can alter human evolution?

I believe that yes you can alter human evolution not in the sense that you can change our very exsistence but in the sense that you could"ve postponed it. Such as the way we and other people interbreed some of the evolution of homo sapiens definitley formed that way but they were also already in exsistence and in competition with neanderthals. So yes I say you can alter it but no to that much of an extent.

What do scientists typically transgenically alter to produce more desirable species?

Plants

What role did the first computer play in the development of current computer technology?

The First computer play a big role because of its slow data precess system "10100110101" "binary codes" this alter or inspired makers such as apple or Microsoft to built smaller and faster data processing units.

Trending Questions

How many meters around the world? I want to make a science fair project about computer viruses. What recommendations do you have? Is science better than social studies? How to Know If Your Home Has Asbestos Insulation? What can be the possible method of performing meta-analysis on the single arm type of studies? What does physical and chemical mean in science? Why do scientists take measurements in a standard way? How do you evaluate scientific explanations? What state of matter is fire? Is it normal to have a period 5 days? Name two examples of simple compound and complex sentences? Why is rising salinity called white plague? Best for growing most plants witch soil has good drainage and sufficient moisture? Why is heater is not keeping house warm? Can matter change into a gas to a solid? What type of reasoning uses the general knowledge of science to make productions about specific cases? What is purpose of doing an experiment? What does conglomerate change into after heat and pressure? Why it is important to remember theories that are discredited? What kind of gradient would be necessary to form an oxbow?

Related Questions

What is the difference between alter session and alter system?

Use the ALTER SESSION statement to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database. Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted. Ankit Kapse

Difference between alter and update commands in sql?

Update and Alter are two SQL (Structured Query Language) commands used for modifying databases. Update statement is used to update existing records in a database. Update is a Data Manipulation Language (DML) statement. Alter SQL command is used to modify, delete or add a column to an existing table in a database. Alter is a Data Definition Language (DDL) statement.Commands that are used to define the structure of a database (database schema) are called DDL statements.

What is the difference between edit and browse?

Browse is "To look for", and edit is "to alter or change."

What are the components of oracle database?

DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.

What is difference between alter and modify on oracle?

MODIFY is a clause used within an ALTER statement, such as ALTER TABLE, ALTER INDEX or ALTER MATERIALIZED VIEW, etc. That is, MODIFY isn't a command by itself. For example, you might change the length of a text column in a table with the following: ALTER TABLE employee MODIFY (email_address VARCHAR(132));

What is Database state?

The database state refers to the collection of data stored in the database at a specific point in time. It represents the current values of all data elements, tables, and relationships within the database. Changes to the database, such as insertions, updates, or deletions, can alter its state.

What is the use of computer database in sales and marketing?

to easily find and alter information, to check stock etc. pickles

You are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands givenwhether it will update and alter the table or not?

Your update should be recorded in the database. It depends on what type of crash. You should have hardware redundency, which if one component fails, a backup will ensure your update. All you can really do, is once the system is back up, check the table to see if the update is there.

Can you add new columns to a database after creating the structure?

Columns are added to a table, not a database (which is a collection of tables). Adding a column to a table is achieved by using the Alter Table SQL command.

Is there a difference between a mixture and a solution?

the ingredients, types of things put in, of a mixture do not change the ingredients in solutions react with and alter each other chemically

Basic commands in oracle?

See the list of Commands in Oracle ANALYZE AUDIT CALL CREATE CLUSTER ALTER CLUSTER DROP CLUSTER COMMENT COMMIT CONNECT CONSTRAINT CREATE CONTEXT DROP CONTEXT CREATE CONTROLFILE CREATE DATABASE ALTER DATABASE DELETE DESCRIBE CREATE DIMENSION ALTER DIMENSION DROP DIMENSION CREATE DIRECTORY DROP DIRECTORY EXEC EXECUTE IMMEDIATE EXPLAIN PLAN CREATE FUNCTION ALTER FUNCTION DROP FUNCTION GRANT CREATE INDEX ALTER INDEX DROP INDEX CREATE INDEXTYPE DROP INDEXTYPE INSERT INTERSECT CREATE JAVA ALTER JAVA DROP JAVA CREATE LIBRARY DROP LIBRARY CREATE DATABASE LINK DROP DATABASE LINK LOCK TABLE CREATE MATERIALIZED VIEW ALTER MATERIALIZED VIEW DROP MATERIALIZED VIEW CREATE MATERIALIZED VIEW LOG ALTER MATERIALIZED VIEW LOG DROP MATERIALIZED VIEW LOG MINUS NOAUDIT CREATE OUTLINE ALTER OUTLINE DROP OUTLINE CREATE PACKAGE/BODY ALTER PACKAGE DROP PACKAGE CREATE PFILE CREATE PROCEDURE ALTER PROCEDURE DROP PROCEDURE CREATE PROFILE ALTER PROFILE DROP PROFILE RECOVER RENAME ALTER RESOURCE COST REVOKE RMAN CREATE ROLE SET ROLE ALTER ROLE DROP ROLE ROLLBACK CREATE ROLLBACK SEGMENT ALTER ROLLBACK SEGMENT DROP ROLLBACK SEGMENT SAVEPOINT CREATE SCHEMA SELECT CREATE SEQUENCE ALTER SEQUENCE DROP SEQUENCE ALTER SESSION SHUTDOWN SNAPSHOT CREATE SPFILE STARTUP ASSOCIATE STATISTICS DISASSOCIATE STATISTICS CREATE SYNONYM DROP SYNONYM ALTER SYSTEM CREATE TABLE ALTER TABLE DROP TABLE CREATE TABLESPACE ALTER TABLESPACE DROP TABLESPACE CREATE TEMPORARY TABLESPACE SET TRANSACTION CREATE TRIGGER ALTER TRIGGER DROP TRIGGER TRUNCATE UPDATE UNION CREATE USER ALTER USER DROP USER CREATE VIEW ALTER VIEW DROP VIEW WHERE

How did the enlightenment alter the relationship between owners and slaves?

we are all humans so we should not keep any difference in slaves and owners so we should treat them as our friends.

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.