Bissoy.com
Doctors Medicines MCQs Q&A

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction? Correct Answer CREATE SCHEMA

A database schema of a database system is its structure described in a formal language supported by the database management system and refers to the organization of data as a blueprint of how a database is constructed.

Related Questions

Which of the following distinction(s) is/are not correct between public issue and rights issue? (A) In public issue, applications for shares are invited from the general public and in rights issue, the shares are offered to existing shareholders. (B) In public issue there is no question of any over-subscription and in rights issue the shares may be under subscribed or over subscribed leading to prorata allotment. (C) The price of public issue is generally less than the market price and in rights issue, the price is deliberately made less than the market price. (D) In a public issue, the communication of the issue is through prospectus or advertisements and in a rights issue the communication is between the company and the existing members of the company. Choose the most appropriate answer from the options given below:
__________ command is used in SQL to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction.
Five politicians F, K, H, M and D not necessary in the same order conducted a meeting to put various issues like Budget, Employment, Poverty, Digitalization and Security. They all are sitting around a circular table facing center. F who is not the neighbor of H and K, puts issue on employment. H who is sitting between D and K puts issue on digitalization. M does not put issue on poverty. The one who puts issue on security sits immediate right of the one who puts issue on Budget. Determine the immediate neighbor of person who puts issue on digitalization?
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?
Which one of the following is true with regard to a CPU having a single interrupt request line and single interrupt grant line? i) Neither vectored nor multiple interrupting devices is possible. ii) Vectored interrupts is not possible but multiple interrupting devices is possible. iii) Vectored interrupts is possible and multiple interrupting devices is not possible. iv) Both vectored and multiple interrupting devices are possible.
To constitute a matter of res judicata which of the following conditions must concur?
1. The matter directly and substantially in issue in the subsequent suit or issue must be the same matter which was directly and substantially in issue either actually (section 11, explanation III) or constructively (section 11, explanation IV) in the former suit
2. The former suit must have been a suit between the same parties under whom they or any of them claim. Explanation VI of Section 11 must be read with this condition
3. The parties as aforesaid must have litigated under the same title in the former suit
4. The court which decided the former suit must have been a court competent to try the subsequent suit of the suit in which such issue has been subsequently raised. Explanation II of section 11 is to be read with condition
5. The matter directly and substantially in issue in the subsequent suit must have been heard and finally decided by the court in the first suit. Explanation V of section 11 is to be read with this condition
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;
Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table R (a, b, c) where a and b together form the primary key, the following is a valid table definition. CREATE TABLE S (                 a INTEGER,                 d INTEGER,                 e INTEGER,                 PRIMARY KEY (d)                 FOREIGN KEY (a) references R) Which one of the following statements is CORRECT?
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?
In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?