Question
create table temp_inst like institute
a.
It creates a new relation temp_inst with all the tuples and attributes of the institute relation
b.
It creates a new relation temp_inst with the same schema as that of the institute relation
c.
It creates a new relation named temp_inst with institute as its only attribute
d.
It does not create any relations and returns an error
Posted under Advanced SQL DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. What does the following statement do? create table temp_inst like institute
Similar Questions
Discover Related MCQs
Q. Which of the following is a privilege in SQL standard?
View solution
Q. The _________ statement is used in SQL to confer authorization.
View solution
Q. revoke select on takes from amit;
What does the above query perform?
View solution
Q. Which of the following is/are a function of dynamic SQL?
View solution
Q. What is the full form of JDBC?
View solution
Q. State true or false: Developers cannot write their own functions into SQL
View solution
Q. Which of the following are not a part of PL/SQL
View solution
Q. The part of SQL that deals with the SQL supports constructs is called as _______
View solution
Q. A _________ is a statement that the system executes whenever a database is modified
View solution
Q. State true or false: Recursive queries are permitted in SQL
View solution
Q. How many different types of drivers are present in JDBC?
View solution
Q. Which JDBC Driver is the most efficient of all the JDBC drivers?
View solution
Q. Which package comprises of the core JDBC API?
View solution
Q. What is the full form of OLAP?
View solution
Q. Data that can be modelled as dimension attributes and measure attributes are called ___________
View solution
Q. The operation of changing a dimensions used in a cross-tab is called as ________
View solution
Q. The operation of moving from finer granular data to coarser granular data is called _______
View solution
Q. How many dimensions of multi-dimensional data do cross tabs enable analysts to view?
View solution
Q. The _______ function allows substitution of values in an attribute of a tuple
View solution
Q. Which of the following OLAP systems do not exist?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
