Bissoy.com
Doctors Medicines MCQs Q&A

What SQL command can be used to add columns to a table?

What SQL command can be used to add columns to a table? Correct Answer ALTER TABLE TableName ADD ColumnName

To add columns to a table in SQL, you can use the ALTER TABLE TableName ADD ColumnName command. Option A is the correct choice for adding new columns to an existing table. Options B, C, and D do not represent the standard SQL syntax for adding columns.

Related Questions

Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;
A data-driven machine is one that executes an instruction if the needed data is available. The physical ordering of the code listing does not dictate the course of execution. Consider the following pseudo-code 1) Multiply E by 0.5 to get F 2) Add A and B to get E 3) Add B with 0.5 to get D 4) Add E and F to get G 5) Add A with 10.5 to get C Assume A, B, C are already assigned values and the desired output is G Which of the following sequence of execution is valid?
Created: 1 month ago | Updated: 1 month ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report
Created: 4 weeks ago | Updated: 4 weeks ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report
Created: 3 weeks ago | Updated: 3 weeks ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report
Created: 1 week ago | Updated: 1 week ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report
When they had a meeting seven company executives __ T, U, V, W, X, Y and Z ___ sit at a rectangular table .Three executives sit along one side of the table , and three sit along the other side, each directly opposite one of the other three. The seventh sits at the head of the table . There is no seat at the foot of the table . Ualways sits in one of te two seats farthest from the head of the table. Y and V always sit next to each other .V never sits next to Z . If Z does not sit at the head of the table, W sits there. If W sits directly opposite T, X must sit next to which of the following excutives?
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
In SQL, the ALTER command can be used to add and drop various constraints on an existing table.
You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01.
The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication.
You want to add a page to your ASP.NET application to display inventory data from FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?