Question
SELECT emp_name
FROM department
WHERE dept_name LIKE ’ _____ Computer Science’;a.
%
b.
_
c.
||
d.
$
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. Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string ?
Similar Questions
Discover Related MCQs
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
Q. If the attribute phone number is included in the relation all the values need not be entered into the phone number column . This type of entry is given as
View solution
Q. The predicate in a where clause can involve Boolean operations such as and.The result of true and unknown is_______ false and unknown is _____ while unknown and unknown is _____
View solution
Q. In a employee table to include the attributes whose value always have some value which of the following constraint must be used ?
View solution
Q. Using the ______ clause retains only one copy of such identical tuples.
View solution
Q. You attempt to query the database with this command:
SELECT nvl (100 / quantity, NONE)
FROM inventory;
Why does this statement cause an error when QUANTITY values are null?
View solution
Q. The result of _____unknown is unknown.
View solution
Q. Aggregate functions are functions that take a ___________ as input and return a single value.
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!
