What is the function of ALTER command? -Technology

What is the function of ALTER command? -Technology
by

1 Answer

Answer :

Alter command is used to change/modify the structure of database object like a table, index, etc.
by

Related questions

. In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Description : . In SQL, which command(s) is(are) usedto recompilea storedfunction? A. SET FUNCTION B. SET STORED FUNCTION C. ALTER FUNCTION D. All of theabove E. None of the above

Last Answer : ALTER FUNCTION

What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Description : What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ? )

Last Answer : CHOOSE,ALL_ROWS,FIRST_ROWS and RULE.

What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Description : What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Description : What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ? What are the factors that affect OPTIMIZER in choosing an Optimization approach ?

Last Answer : Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

In SQL, which command(s) is(are) used to change atable's storage characteristics? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of theabove E. None of the abov

Description : In SQL, which command(s) is(are) used to change atable's storage characteristics? A. ALTER TABLE B. MODIFY TABLE C. CHANGE TABLE D. All of theabove E. None of the abov

Last Answer : ALTER TABLE

What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

Description : What is the effect of setting the value “CHOOSE” for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?

Last Answer : The Optimizer chooses Cost_based approach and optimizes with the goal of best throughput if statistics for atleast one of the tables accessed by the SQL statement exist in the data dictionary. Otherwise the OPTIMIZER chooses RULE_based approach.

What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command? –

Description : What is the effect of setting the value “ALL_ROWS” for OPTIMIZER_GOAL parameter of the ALTER SESSION command? –

Last Answer : What are the factors that affect OPTIMIZER in choosing an Optimization approach? – Answer The OPTIMIZER_MODE initialization parameter Statistics in the Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER SESSION command hints in the statement.

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.

Write the HTML command to display the following in your Web page. -Technology

Description : Write the HTML command to display the following in your Web page. -Technology

Last Answer : The HTML command is – A2 + B2

Write the output on the Web page for the following HTML command. -Technology

Description : Write the output on the Web page for the following HTML command. -Technology

Last Answer : The output on the Web page will be the Atomic weight of O 2

Explain the given command <a href =”wild.html”>Click Here for wild animals</a> -Technology

Description : Explain the given command Click Here for wild animals -Technology

Last Answer : In this command, anchor tag and its href attribute are included. The text (Click Here for wild animals) will appear underlined and indicates that clicking the text activates the hypertext link. The address ... is an URL or Web page address and Click Here for wild animals is the hyperlinked text.

Which command should be use to link a page with HTML page? (a) <a link = “page.htm” > </a> -Technology

Description : Which command should be use to link a page with HTML page? (a) -Technology

Last Answer : (b) page

Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Description : Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Last Answer : 1. Insert tab2. Picture command in the Illustrations group.3. Yes4. Yes

…….. command is used to move the text to a new page. -Technology

Description : …….. command is used to move the text to a new page. -Technology

Last Answer : Page breakcommand is used to move the text to a new page.

Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Description : Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Last Answer : Animating Text and Objects:We can give sound effects or visual effects, including movement to the text or objects in a presentation. Animation can be used to focus on important points, to control the ... to animate the object.Effects appear in the Custom Animation list in the order that you add them

Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Description : Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Last Answer : c) Rehearse Timings command is present on Slide Show tab.

………………. provides a command to change the layout of your slide. -Technology

Description : ………………. provides a command to change the layout of your slide. -Technology

Last Answer : Home tab provides a command to change the layout of your slide.

The Custom Animation command is present on ………………. tab. -Technology

Description : The Custom Animation command is present on ………………. tab. -Technology

Last Answer : The Custom Animationcommand is present on Animationstab.

Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).

Which command we use to link a page with an HTML page? -Technology

Description : Which command we use to link a page with an HTML page? -Technology

Last Answer : link textuse to link a page with an HTML page .

(i) Write command to compute sum of every column of the data frame. -Technology

Description : (i) Write command to compute sum of every column of the data frame. -Technology

Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )

Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Last Answer : python manage.py startapp users

The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology

Description : The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology

Last Answer : (d)plt.title()

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Last Answer : (a) print(Sequences.head(4))

Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Description : Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Last Answer : print(S1+S2)

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

(1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

In a logic circuit, the NOT gate function _____________. A. does not alter a logical input B. serves to amplify a given signal level C. must be accomplished with a common collector transistor arrangement D. reverses an input logic condition

Description : In a logic circuit, the NOT gate function _____________. A. does not alter a logical input B. serves to amplify a given signal level C. must be accomplished with a common collector transistor arrangement D. reverses an input logic condition

Last Answer : Answer: D

Function of iris is to (a) move lens forward and backward (b) refract light rays (c) bring about movements of eye lids (d) alter the size of pupil.

Description : Function of iris is to (a) move lens forward and backward (b) refract light rays (c) bring about movements of eye lids (d) alter the size of pupil.

Last Answer : (d) alter the size of pupil.

By which of the following means antifungal chemotherapeutic agents may affect fungi? A- Interfere with nuclear division by preventing the aggregation of microtubules needed for mitosis B- Interfere with normal nucleic acid synthesisInterfere with ergosterol biosynthesis and thus alter the structure of the cytoplasmic C- membrane as well as the function of several membrane-bound enzymes like thoseinvolved in nutrient transport and chitin synthesis D- all of these

Description : By which of the following means antifungal chemotherapeutic agents may affect fungi? A- Interfere with nuclear division by preventing the aggregation of microtubules needed for mitosis B- ... membrane-bound enzymes like thoseinvolved in nutrient transport and chitin synthesis D- all of these

Last Answer : all of these

The cotransmitter may serve the following function/ functions: A. Regulate the release of the primary transmitter from the nerve ending B. Alter postjunctional action of the primary transmitter C. Itself act as an alternative transmitter D. All of the above

Description : The cotransmitter may serve the following function/ functions: A. Regulate the release of the primary transmitter from the nerve ending B. Alter postjunctional action of the primary transmitter C. Itself act as an alternative transmitter D. All of the above

Last Answer : D. All of the above

The cotransmitter may serve the following function/ functions: A. Regulate the release of the primary transmitter from the nerve ending B. Alter postjunctional action of the primary transmitter C. Itself act as an alternative transmitter D. All of the above

Description : The cotransmitter may serve the following function/ functions: A. Regulate the release of the primary transmitter from the nerve ending B. Alter postjunctional action of the primary transmitter C. Itself act as an alternative transmitter D. All of the above

Last Answer : D. All of the above

Are voice command/wifi type switches and controls designed for singles?

Description : Are voice command/wifi type switches and controls designed for singles?

Last Answer : I agree that robot vacuums sometimes turn on for no good reason, but Alexa has a whisper mode that works really well.

The conversion of the throttle command voltage to the signal necessary to achieve the desired shaft RPM is accomplished by the _____________. A. ahead or astern function generator of the throttle control circuit B. feedback resistor of the summing amplifier circuit C. operational amplifiers in the autorotation circuit D. long time constant amplifier circuit

Description : The conversion of the throttle command voltage to the signal necessary to achieve the desired shaft RPM is accomplished by the _____________. A. ahead or astern function generator of the ... circuit C. operational amplifiers in the autorotation circuit D. long time constant amplifier circuit

Last Answer : Answer: A

The most basic function of ifconfig command is assigning the …………….. Address. A. Physical address B. Hardware address C. MAC address D. IP address

Description : The most basic function of ifconfig command is assigning the …………….. Address. A. Physical address B. Hardware address C. MAC address D. IP address

Last Answer : D. IP address

What is the function of following UNIX command? WC – l<a >b& (A) It runs the word count program to count the number of lines in its input, a, writing the result to b, as a foreground process. (B) It runs the word count program to count the number of lines in its input, a, writing the result to b, but does it in the background. (C) It counts the errors during the execution of a process, a, and puts the result in process b. (D) It copies the ‘ l ’ numbers of lines of program from file, a, and stores in file b.

Description : What is the function of following UNIX command? WC - lb& (A) It runs the word count program to count the number of lines in its input, a, writing the result to b, as a foreground process. (B) It runs ... (D) It copies the l ' numbers of lines of program from file, a, and stores in file b.

Last Answer : (B) It runs the word count program to count the number of lines in its input, a, writing the result to b, but does it in the background.

Jilted at the Alter, what happened?

Description : Jilted at the Alter, what happened?

Last Answer : I changed.

Is there any way to alter a username once an account is created?

Description : Is there any way to alter a username once an account is created?

Last Answer : Ask the Mods !

Should the government add elements to, or alter our (air, food, whatever) without allowing citizens’ choice in the matter?

Description : Should the government add elements to, or alter our (air, food, whatever) without allowing citizens’ choice in the matter?

Last Answer : answer:Intelligently, yes. The main problem is that citizens (writ large) are stupid. Or at least ignorant and uncaring. As soon as the word would get out that additive x' (assuming it ... rely on the conclusions of experts than a vote of the uneducated citizen. Mob rule is inherently dangerous.

If you could construct an alter ego, what would you focus on and whom would you become?

Description : If you could construct an alter ego, what would you focus on and whom would you become?

Last Answer : It would of course be some kind of Fursona.

On FB, how to I alter the things that people see when they do "Search for all people, places and things" and then "find all people named ____?"?

Description : On FB, how to I alter the things that people see when they do "Search for all people, places and things" and then "find all people named ____?"?

Last Answer : Have you tried logging out, then repeating the same search? You might find that the information was available to you only because you’re, well, you.

If your alter-ego was a person, what would he/she be like?

Description : If your alter-ego was a person, what would he/she be like?

Last Answer : This is my alter ego! MUHAHAHAHAHA

How does smoking weed alter a guy's behavior?

Description : How does smoking weed alter a guy's behavior?

Last Answer : answer:Well, sometimes it makes a person who would choose @punkrockworld as their handle ask what happens to you when you take a toke. I would not smoke it ever, because I observe that the number one ... benefits of your getting high in front of her would accrue to her when you get to divorce court.

Can a vet alter the volume of a rooster's crowing?

Description : Can a vet alter the volume of a rooster's crowing?

Last Answer : How well do(did) you get along with the neighbors? If you are friendly with them, talking about it would be worth a try you could also look into your local ordinances, and see whether roosters are ... to sound pretty good, right?) Unless they are neighbors from hell, I'd try to work things out.

Someone, anyone, alter my essay. Por favor!

Description : Someone, anyone, alter my essay. Por favor!

Last Answer : answer:I sat captivated throughout ...was left with more questions rather than answers, but in a good way. Although I have always been no comma ...how time was not constant but depend depending on an ... speaker, so don't take them for granted, please. I am sure better advice will come along :-)

Do you think that it is unethical for the media to digitally alter images within the news?

Description : Do you think that it is unethical for the media to digitally alter images within the news?

Last Answer : Do you have an example of a news outlet altering a picture? I know rags like the National Enquirer do this, but an actual news outlet? I’m not sure I’ve heard of that lately.