Which command is used to create a new relation in SQL

Related MCQs

• Given the relation Supplier(s_id, p_order, s_name, qty) Given that there is a unique s_name for each s_id and that s_id, p_order is a composite key, find the correct statement among the following: i. this relation is a BCNF ii. this is 3 NF relation iii. this is a 2 NF relation iv. this is a 1 NF relation
• In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?
•                  dump, writes out SQL DDL statements and SQL insert statements to a file, which can then be reexecuted to re- create the database.
• A command to remove a relation from an SQL database
• A command to remove a relation from an SQL database
• To remove a relation from an SQL database, we use the              command.
• Which SQL function is used to count the number of rows in a SQL query?
• An attribute in a relation is a foreign key if the                key from one relation is used as an attribute in that relation.
• An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
• A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .