Question
WITH max_budget (VALUE) AS
(SELECT MAX(budget)
FROM department)
SELECT budget
FROM department, max_budget
WHERE department.budget = MAX budget.value;a.
Budget
b.
Department
c.
Value
d.
Max_budget
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. In the query given above which one of the following is a temporary relation ?
Similar Questions
Discover Related MCQs
Q. Subqueries cannot:
View solution
Q. Which of the following is not a aggregate function ?
View solution
Q. A Delete command operates on ______ relation.
View solution
Q. Delete from r where P;
The above command
View solution
Q. Which one of the following deletes all the entries but keeps the structure of the relation .
View solution
Q. Which of the following is used to insert a tuple from another relation.
View solution
Q. Which of the following deletes all tuples in the instructor relation for those instructors associated with a department located in the Watson building which is in department relation.
View solution
Q. UPDATE instructor
_____ salary= salary * 1.05;
Fill in with correct keyword to update the instructor relation.
View solution
Q. _________ are useful in SQL update statements,where they can be used in the set clause.
View solution
Q. The problem of ordering the update in multiple update is avoided using
View solution
Q. Which of the following is the correct format for case statements.
View solution
Q. Which of the following relation updates all instructors with salary over $100,000 receive a 3 percent raise, whereas all others receive a 5 percent raise.
View solution
Q. SELECT *
FROM student JOIN takes USING (ID);
The above query is equivalent to
View solution
Q. In SQL the statement select * from R, S is equivalent to
View solution
Q. For the view Create view instructor_info as
SELECT ID, name, building
FROM instructor, department
WHERE instructor.dept name= department.dept name;
If we insert tuple into the view as insert into instructor info values (’69987’, ’White’, ’Taylor’);
What will be the values of the other attributes in instructor and department relations?
View solution
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
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!
