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 mentionedThe question was asked in class test.Query is from A Simple Transaction Model in chapter Transactions of Database Management

In SQL, which command is used to issue multiple CREATE TABLE, CREATE V

1.	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 mentionedThe question was asked in class test.Query is from A Simple Transaction Model in chapter Transactions of Database Management
Answer» 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.

Discussion

No Comment Found

Related InterviewSolutions

Which statement is true regarding external tables?(a) The default REJECT LIMIT for external tables is UNLIMITED(b) The data and metadata for an external table are stored outside the database(c) ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table(d) The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external tableThe question was posed to me in final exam.The query is from Implementation of Isolation Levels topic in section Transactions of Database Management
How many types of recovery control techniques:(a) 2(b) 3(c) 4(d) 5This question was addressed to me in an international level competition.This interesting question is from Querying database part 5 in chapter Transactions of Database Management
Who developed the normalization process:(a) E.F. codd(b) F.F. codd(c) E.E. codd(d) None of the mentionedThe question was asked in an international level competition.Query is from Querying Database in section Transactions of Database Management
The storage structure which do not survive system crashes are ______(a) Volatile storage(b) Non-volatile storage(c) Stable storage(d) Dynamic storageI had been asked this question in an interview.This interesting question is from Storage Structure in section Transactions of Database Management
Which of the following SQL command can be used to modify existing data in a database table?(a) MODIFY(b) UPDATE(c) CHANGE(d) NEWThe question was posed to me in unit test.My question is from A Simple Transaction Model topic in chapter Transactions of Database Management
Which of the following is TRUE for the System Variable $date$?(a) Can be assigned to a global variable(b) Can be assigned to any field only during design time(c) Can be assigned to any variable or field during run time(d) Can be assigned to a local variableThis question was posed to me in examination.Question is taken from A Simple Transaction Model topic in portion Transactions of Database Management
Which character function can be used to return a specified portion of a character string?(a) INSTR(b) SUBSTRING(c) SUBSTR(d) POSI had been asked this question during an interview for a job.Enquiry is from A Simple Transaction Model topic in chapter Transactions of Database Management
In SQL, the CREATE TABLESPACE is used(a) To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace(b) To create a database trigger(c) To add/rename data files, to change storage(d) All of the mentionedThe question was asked in exam.Query is from A Simple Transaction Model in chapter Transactions of Database Management
To delete a database ___________ command is used(a) Delete database database_name(b) Delete database_name(c) drop database database_name(d) drop database_nameI had been asked this question in an international level competition.Asked question is from Querying database part 3 topic in portion Transactions of Database Management
SDL means _____________(a) Storage Discrete Language(b) Storage Definition Language(c) Storage Definition Localisation(d) Storage Discrete LocalisationThis question was addressed to me in an internship interview.I would like to ask this question from Storage Structure in section Transactions of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment