1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lady bird [3.3K]
2 years ago
15

How can structure of a table change in sql. What general types of changes are possible.

Computers and Technology
1 answer:
frez [133]2 years ago
3 0

One can structure of a table change in sql and the general types of changes that are possible is that:

  • One can use the  MODIFY STRUCTURE to alter the structure of the current table that one is in and this is done by adding or deleting fields.
  • One can also change or alter a field name, width, or that of the data type and this is done by Issuing the MODIFY STRUCTURE command that tends to opens the Table designer, an interactive place in which a person can create or change the structure of a table.

<h3>How can we modify the structure of a table in SQL?</h3>

The SQL ALTER TABLE command is known to be the tool that is often used to alter the structure of an existing table.

Note that it is one that can helps to add or delete columns, make or destroy indexes, alter the type of existing columns, and others.

Hence, One can structure of a table change in sql and the general types of changes that are possible is that:

  • One can use the  MODIFY STRUCTURE to alter the structure of the current table that one is in and this is done by adding or deleting fields.
  • One can also change or alter a field name, width, or that of the data type and this is done by Issuing the MODIFY STRUCTURE command that tends to opens the Table designer, an interactive place in which a person can create or change the structure of a table.

Learn more about table structure from

brainly.com/question/26125587

#SPJ1

You might be interested in
After clicking the Start button on your computer screen desktop, what option would you then select to examine system components
Gekata [30.6K]
Cacky fart face diareaah and farts= mc2 because  youfhvh h h h hh h h hh h h h h hh h h hh h hh h h snd that is the answer rk rjhd wkesryn
8 0
3 years ago
Write a public static method diagSum, which takes a 2d array of int values as a parameter, and returns the sum of the elements i
saveliy_v [14]

A 2d array (i.e. 2 dimensional array) represents its elements in rows and columns

<h3>The program in Java</h3>

The method in Java, where comments are used to explain each line is as follows

//This defines the method

public static int diagSum(int[][] myArray) {

    //This initializes sum to 0

    int sum = 0;

    //This iterates through each row of the array

               for (int i = 0; i < myArray.length; i++) {

                   //This calculates the sum of the diagonals

                       sum+=myArray[i][i];

               }

               //This returns the sum

               return sum;

       }

Read more about methods at:

brainly.com/question/15969952

6 0
3 years ago
Signs of mastery include?
katrin2010 [14]
1. You know it. Self-explanatory.
2. You know you know it. This means you didn’t guess or get lucky, or answer with a question mark in your voice.
3. You know it quickly, independently and efficiently.
- Quickly means you have this skill ready, with no playing around in order to figure it out. While it is an invaluable skill to be able to figure out a math problem, what we’re going for with our basic skill list is FLUENCY, meaning you’re past the figuring it out phase and your ability is more automatic. A very simple example of this would be: for the basic subtraction problem 11-9, figuring it out would mean counting up from 9 to 11 (either on your fingers or in your head) to get 2. Automaticity, on the other hand, would mean looking at 11-9 and knowing the answer is 2, as if it were a sight word. The processing speed is so fast that there may as well be no processing involved. It’s that automatic. At every new level of math, there is a whole new layer of skills that we want at this ‘automatic’ level, freeing the brain up to do it’s ‘figuring out’ with the next level.
- Independently means with ZERO help, no reminders & no hints.
- Efficiently. An example of doing a skill the most efficient way is simplifying fractions before multiplying them, rather than multiplying first, then simplifying.
4. You know it cold. Three months can go by without you actively practicing it, and you STILL know it. This is perhaps the most important criteria, and often the most overlooked.
4 0
3 years ago
A profit of ₹ 1581 is to be divided amongst three partner P,Q and R in ratio 1/3:1/2:1/5.theshareof R will be?​
Burka [1]

Answer:

R's share = 306

Explanation:

Sum of ratio = 1/3 + 1/2 + 1/5

LCM = 30

Sum of ratio = (10 + 15 + 6) / 30 = 31 /30

Profit to be shared = 1581

P = 1/3 ; Q = 1/2 ; R = 1/5

Share of R :

(Total profit / sum of ratio) * R ratio

[1581 / (31/30)] * 1/5

(1581 / 1 * 30/31) * 1/5

51 * 30 * 1/5

51 * 6 = 306

5 0
3 years ago
Define and describe PaaS. List the benefits of PaaS solutions. Describe potential disadvantages of PaaS. Describe how a cloud-ba
Volgvan

Answer:

PaaS has become a cloud technology that offers a way for consumers just to establish, successfully manage implementations without any of the sophistication of preserving but instead developing the technology related to the development and start-up of apps.

Explanation:

<u>Benefits</u>:

  • Not no need to purchase hardware as well as raise revenues throughout leisure time.
  • There was no need to consider throughout configurations.

<u>Disadvantages</u>:

  • These have privacy concerns, during which data security contributes to the problem as well as monitored.
  • These have problems with the portability of implementation.

<u>Difference between Cloud base DBMS and On-site database</u>:

  • On-site DBMS data couldn't be accessed from just about any location as either a cloud-based management solution.
  • DBMS Cloud base documentation to ensure mostly with highly valued information collected to provide direct exposure to everybody else together whilst on-site DBMS functionalities such as SQL.

<u>Computing recourses</u>:

  • The architecture of web applications.
  • Prebuilt techniques for developing, managing, and testing applications.
6 0
3 years ago
Other questions:
  • A nurse is reviewing the different cloud office applications available. When comparing the iCloud to other cloud office applicat
    14·1 answer
  • Provides images of weather systems, and helps to track storms at different altitudes
    7·1 answer
  • Which category of management information systems (MIS) combines the forecasting capability of decision support software with the
    12·1 answer
  • The first step in the information processing cycle is _____, which involves entering data into the computer.
    8·1 answer
  • What is the most likely reason that a digital artist would use a program such as Autodesk Maya or Max to create 3-D images for a
    12·1 answer
  • A _____ is a collection of rules for formatting, ordering, and error checking data sent across a network.
    7·1 answer
  • Jim wants to shoot a video. This requires him to move from one place to another. Which type of camera support should Jim use?
    13·1 answer
  • A variable is assigned a value on line 328 of a program. Which of the following must be true in order for the variable to work?
    12·2 answers
  • What allows customers to use the Web to find answers to their questions or solutions to their problems?
    5·2 answers
  • …….. and ……...are called binary digits. (Computer Science)
    13·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!