Question
a.
Where, from
b.
From, select
c.
Select, from
d.
From, where
Posted under SQL Queries,Constraints and Triggers DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Similar Questions
Discover Related MCQs
Q. Select ID, name, dept name, salary * 1.1
where instructor;
The query given below will not give an error. Which one of the following has to be replaced to get the desired output?
View solution
Q. The ________ clause is used to list the attributes desired in the result of a query.
View solution
Q. Select name, course_id
from instructor, teaches
where instructor_ID= teaches_ID;
This Query can be replaced by which one of the following ?
View solution
Q. Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?
View solution
Q. Which of the following statements contains an error?
View solution
Q. Insert into employee _____ (1002,Joey,2000);
In the given query which of the keyword has to be inserted ?
View solution
Q. SELECT * FROM employee WHERE dept_name="Comp Sci";
In the SQL given above there is an error . Identify the error .
View solution
Q. ’_ _ _ ’ matches any string of ______ three characters. ’_ _ _ %’ matches any string of at ______ three characters.
View solution
Q. In SQL the spaces at the end of the string are removed by _______ function .
View solution
Q. _____ operator is used for appending two strings.
View solution
Q. The union operation is represented by
View solution
Q. The intersection operator is used to get the _____ tuples.
View solution
Q. The union operation automatically __________, unlike the select clause.
View solution
Q. If we want to retain all duplicates, we must write ________ in place of union.
View solution
Q. For like predicate which of the following is true.
i) % matches zero OF more characters.
ii) _ matches exactly one CHARACTER.
View solution
Q. The number of attributes in relation is called as its
View solution
Q. _____ clause is an additional filter that is applied to the result.
View solution
Q. _________ joins are SQL server default
View solution
Q. The _____________ is essentially used to search for patterns in target string.
View solution
Q. A _____ indicates an absent value that may exist but be unknown or that may not exist at all.
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!
