Which function is used to find the count of distinct departments?

Related MCQs

• View the Exhibit and examine the structure of the EMPLOYEES and DEPARTMENTS tables. Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers? SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL;
• Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
• Which of the following function is used to find the column count of the particular resultset?
• Which SQL function is used to count the number of rows in a SQL query?
• Select distinct Dept_name from instructor ; How many row(s) are displayed ?
•                                allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.
• Which function is used to identify the title with Least scope?
• Which character function can be used to return a specified portion of a character string?
• If h is any hashing function and is used to hash n keys in to a table of size m, where n<=m, the expected number of collisions involving a particular key x is :
• Which of the following in not a function of DBA?