in Education by
In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction? (a) CREATE PACKAGE (b) CREATE SCHEMA (c) CREATE CLUSTER (d) All of the mentioned The question was asked in class test. Query is from A Simple Transaction Model in chapter Transactions of Database Management

1 Answer

0 votes
by
The correct answer is (b) CREATE SCHEMA Easy explanation - 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

0 votes
    SQL structure such as table names, column names, and so on cannot be escaped, and thus user-supplied structure names are ... issue in a report-writing software. 1. True 2. False...
asked Mar 20, 2021 in Technology by JackTerrance
0 votes
    What is the use of GRANT option in IMP command?...
asked Dec 18, 2020 in Technology by JackTerrance
0 votes
    ________ dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which of the following SQL command can be used to modify existing data in a database table? (a) ... Simple Transaction Model topic in chapter Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    A transaction is delimited by statements (or function calls) of the form __________ (a) Begin ... from Transaction Concept in chapter Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    How to concatenate multiple rows into a single string in sql a. COALESCE b. STRING_AGG C. Option 1 & 2 d. None of the above...
asked Feb 19, 2023 in Technology by JackTerrance
0 votes
    Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into ... Peter, Paul, Mary? Select the correct answer from above options...
asked Jan 28, 2022 in Education by JackTerrance
0 votes
    I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked Jan 26, 2022 in Education by JackTerrance
0 votes
    I have multiple set of data to insert at once, say 4 rows. My table has three columns: Person, Id and ... a single SQL statement? Select the correct answer from above options...
asked Jan 26, 2022 in Education by JackTerrance
0 votes
    Which is the method used in MongoDB to Grant user? (1)db.grantRole() (2)All the Options (3)db.grantRolesToUser() (4)db.grantToUser()...
asked May 23, 2021 in Technology by JackTerrance
+1 vote
    Which is the method used in MongoDB to Grant user? (1)db.grantRole() (2)All the Options (3)db.grantRolesToUser() (4)db.grantToUser()...
asked Oct 13, 2020 by JackTerrance
0 votes
    Which of the following statements is used to create an empty set in Python? a) ( ) b) [ ] c) { } d) set()...
asked Jan 2, 2023 in Technology by JackTerrance
0 votes
    Which of the following statements is used to create an empty set in Python? a) ( ) b) [ ] c) { } d) set()...
asked Jan 2, 2023 in Technology by JackTerrance
0 votes
    I need to write SQL statement that will return an html table and specify font size to its content. ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 13, 2022 in Education by JackTerrance
...