Question
Find the error in this query .
CREATE VIEW faculty AS
SELECT ID, name, dept name
FROM instructor;a.
Instructor
b.
Select
c.
View …as
d.
None of the mentioned
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Find the error in this query .
Similar Questions
Discover Related MCQs
Q. A _________ consists of a sequence of query and/or update statements.
View solution
Q. Which of the following makes the transaction permanent in the database ?
View solution
Q. In order to undo the work of transaction after last commit which one should be used ?
View solution
Q. Consider the following action:
TRANSACTION.....
Commit;
ROLLBACK;
What does Rollback do?
View solution
Q. In case of any shut down during transaction before commit which of the following statement is done automatically?
View solution
Q. In order to maintain the consistency during transactions database provides
View solution
Q. Which of the following is used to get back all the transactions back after rollback ?
View solution
Q. ______ will undo all statements up to commit?
View solution
Q. Domain constraints, functional dependency and referential integrity are special forms of _________
View solution
Q. Create index studentID_index on student(ID);
Here which one denotes the relation for which index is created ?
View solution
Q. Values of one type can be converted to another domain using which of the following ?
View solution
Q. CREATE DOMAIN YearlySalary NUMERIC(8,2)
CONSTRAINT salary VALUE test __________;
In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:
View solution
Q. In contemporary databases the top level of the hierarchy consists of ______ each of which can contain _____
View solution
Q. The database administrator who authorizes all the new users, modifies database and takes grants privilege is
View solution
Q. Which of the following is a basic form of grant statement ?
View solution
Q. Which of the following is used to access the database server at time of executing the program and get the data from the server accordingly ?
View solution
Q. Which of the following header must be included in java program to establish database connectivity using JDBC ?
View solution
Q. DriverManager.getConnection(_______ , ______ , ______)
What are the two parameters that are included ?
View solution
Q. Which of the following invokes functions in sql ?
View solution
Q. Which of the following function is used to find the column count of the particular resultset ?
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!
