Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.(a) Where, having(b) Having, where(c) Group by, having(d) Group by, whereI got this question in an interview for internship.This interesting question is from Aggregate Functions and Nested Subqueries in chapter SQL : Queries, Constraints and Triggers of Database Management

Aggregate functions can be used in the select list or the_______clause

1.	Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.(a) Where, having(b) Having, where(c) Group by, having(d) Group by, whereI got this question in an interview for internship.This interesting question is from Aggregate Functions and Nested Subqueries in chapter SQL : Queries, Constraints and Triggers of Database Management
Answer» Right option is (b) Having, where To EXPLAIN: To include aggregate FUNCTIONS having clause MUST be included after where.

Discussion

No Comment Found

Related InterviewSolutions

Which of the following is the right syntax for the assertion?(a) Create assertion ‘assertion-name’ check ‘predicate’;(b) Create assertion check ‘predicate’ ‘assertion-name’;(c) Create assertions ‘predicates’;(d) All of the mentionedThe question was asked in an international level competition.My question is from Integrity Constraints in chapter SQL : Queries, Constraints and Triggers of Database Management
In order to maintain the consistency during transactions, database provides(a) Commit(b) Atomic(c) Flashback(d) RetainI have been asked this question in a job interview.This is a very interesting question from Transactions in chapter SQL : Queries, Constraints and Triggers of Database Management
In case of any shut down during transaction before commit which of the following statement is done automatically?(a) View(b) Commit(c) Rollback(d) FlashbackThe question was asked by my college director while I was bunking the class.This is a very interesting question from Transactions in portion SQL : Queries, Constraints and Triggers of Database Management
In SQL the cross-tabs are created using(a) Slice(b) Dice(c) Pivot(d) All of the mentionedThe question was posed to me in an online interview.This question is from OLAP topic in division SQL : Queries, Constraints and Triggers of Database Management
In authorization graph, if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct?(a) If DBA revokes authorization from u1 then u2 authorization is also revoked(b) If u1 revokes authorization from u2 then u2 authorization is revoked(c) If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked(d) If u2 revokes authorization then u1 authorization is revokedThe question was asked in an online quiz.The above asked question is from Authorizations topic in division SQL : Queries, Constraints and Triggers of Database Management
The user defined data type can be created using(a) Create datatype(b) Create data(c) Create definetype(d) Create typeThe question was asked in my homework.I'd like to ask this question from SQL Data Types and Schemas topic in portion SQL : Queries, Constraints and Triggers of Database Management
Which of the following is used to store movie and image files?(a) Clob(b) Blob(c) Binary(d) ImageI have been asked this question in unit test.This intriguing question originated from SQL Data Types and Schemas in portion SQL : Queries, Constraints and Triggers of Database Management
Data integrity constraints are used to:(a) Control who is allowed access to the data(b) Ensure that duplicate records are not entered into the table(c) Improve the quality of data entered for a specific property (i.e., table column)(d) Prevent users from changing the values stored in the tableThis question was posed to me during an interview for a job.This question is from Integrity Constraints topic in portion SQL : Queries, Constraints and Triggers of Database Management
The number of attributes in relation is called as its(a) Cardinality(b) Degree(c) Tuples(d) EntityThe question was asked by my school principal while I was bunking the class.This interesting question is from Set Operations topic in portion SQL : Queries, Constraints and Triggers of Database Management
If we want to retain all duplicates, we must write ________ in place of union.(a) Union all(b) Union some(c) Intersect all(d) Intersect someThe question was posed to me during an internship interview.This interesting question is from Set Operations topic in portion SQL : Queries, Constraints and Triggers of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment