Computers and Technology, 07.02.2021 14:00 school7067

Section- Q. 6. Mr. Mohammed, a database administrator in “Al Saif Sports Institute” Has created the
following table named "GYM for the upcoming training schedule:
Table: GYM
PRICE BRANDNAME
ICODE INAME
C101
Power Fit Exerciser
120000
Power Gymea
G102
18000
Reliable
Aquafit Hand Grip
Cycle Bike
G103
Null
Ecobike
C104
Coscore
C105
Protoner Extrem Gym 30000
Message
Belt 5000
Crosstrainer
13000
Message Expert
C106
CTC Fitness
Help him in writing SQL query/command for the following purpose: :
i. To add a column duration with suitable data
type. ii. To display list of free Gym.
iii. To change the brandname to “Fit Trend India" of the item whose icode as "G104".
ix, To count and display the different BrandName

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 00:20

The open systems interconnection (osi) reference model: defines standards for many aspects of computing and communications within a network. is a generic description for how computers use multiple layers of protocol rules to communicate across a network. defines standards for wireless local area network (wlan) communication protocols. details the advantages and disadvantages of various basic network cabling options.

Answers: 1

Answer

Computers and Technology, 23.06.2019 04:31

Which of the following is not a way in which trees benefit the environment? a. they remove a significant amount of carbon dioxide from the atmosphere. b. they remove a significant amount of oxygen from the atmosphere. c. their roots hold soil in place, reducing rates of erosion. d. they remove ozone and particulates from the atmosphere. select the best answer from the choices provided a b c d

Answers: 1

Answer

Computers and Technology, 23.06.2019 10:00

Hey i just logged on and one of the moderators deleted a bunch of my answers to questions, even though the answers were right and the people it doesn't make sense but if anyone wants to talk about anything just message me lol (this is super random lol)

Answers: 1

Answer

Computers and Technology, 23.06.2019 11:20

Http is the protocol that governs communications between web servers and web clients (i.e. browsers). part of the protocol includes a status code returned by the server to tell the browser the status of its most recent page request. some of the codes and their meanings are listed below: 200, ok (fulfilled)403, forbidden404, not found500, server errorgiven an int variable status, write a switch statement that prints out the appropriate label from the above list based on status.

Answers: 2

Answer

You know the right answer?

Section- Q. 6. Mr. Mohammed, a database administrator in “Al Saif Sports Institute” Has created the...

Questions