dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.

Related MCQs

• A dump of the database contents is also referred to as an                            dump.
•                    dump schemes have been developed that allow transactions to be active while the dump is in progress.
• Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values>
• Which of the following information does an SQL DDL not specify?
• Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
• Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
• In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
• Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
• Which of the following is/are the DDL statements?
• Which of the following is not a DDL command?