Bissoy.com
Doctors Medicines MCQs Q&A

In SQL, the CREATE command can be put under which of the following category?

In SQL, the CREATE command can be put under which of the following category? Correct Answer DDL (Data Definition Language)

In SQL, the CREATE command comes under the category of DDL (Data Definition Language) which is used to define the structure of the table. DML (Data Manipulation Language) is used to manipulate the data inside the table. DCL (Data Control Language) is used by the database administrator to configure security access to relational databases. TCL (Transaction Control Language) is used to commit or rollback the changes made by DML commands.

Related Questions

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?
Some small cubes of same height 7 cm but variable length and width are put inside a large cuboid of height 21 cm. Length and width of cuboid is 32 cm and 24 cm, respectively. Small cubes are put such that cubes at the bottom most layer is of similar base area; second layer contains all the cubes of similar base area and third layer have all the cubes of similar base area. Which of the following statement(s) given below is / are TRUE? A: If side of each small cubes at bottom most layer is 8 cm, then maximum number of small cubes that can be put at bottom most layer is 12. B: If maximum of 48 cubes can be put at second layer, then side of each cube at second layer is 6 cm. C: If side of each small cubes at third layer is 1.6 cm, then maximum number of small cubes that can be put at third layer is 300.
Rohan put 9 cards on a table, some face up and the rest face down. How many were put face down? A. Rohan put an even number of the cards face up. B. Rohan put twice as many of the cards face up as he put face down. Select the correct answer from the options given below:
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?
In all the four zones of India, the sales of scooters (in percentage) in four categories are as given in the chart. If the sale under category 1 is 4593 and under category 3 is 3297, then what percentage east zone of category 1 is of west zone of category 3.
In SQL, the DROP command can be put under which of the following category?
In SQL, the ALTER command can be put under which of the following category?
Each material circumstance appearing in evidence against the accused must be put to the accused specifically, distinctly and separately. In this context, the propositions are
1. Failure to put the material evidence to the accused always vitiates the trial
2. Failure to put the material evidence amounts to a serious irregularity which can not be cured and vitiates the trial, if it has prejudiced the accused.
3. Failure to put the material evidence is not considered to services & is curable if infact no failure of justice has occasioned to the accused.
Now which of the following is correct
A garments factory employs 3 categories of workers K, M and N. The efficiency of the 3 categories of workers to do a specific task is in the ratio of 3 : 5 : 6 respectively and the factory employs 15 of category K, 12 of category M and 3 of category N. If the total wages paid to the entire group of 30 workers is Tk. 492 per hour, what will be the wages earned by a category N worker for an 8-hour day?
You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?