SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.(a) Group by(b) With(c) Where(d) HavingI got this question by my college professor while I was bunking the class.This question is from Aggregate Functions and Nested Subqueries in portion SQL : Queries, Constraints and Triggers of Database Management

SQL applies predicates in the _______ clause after groups have been fo

1.	SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.(a) Group by(b) With(c) Where(d) HavingI got this question by my college professor while I was bunking the class.This question is from Aggregate Functions and Nested Subqueries in portion SQL : Queries, Constraints and Triggers of Database Management
Answer» Right choice is (b) With Easy EXPLANATION - The with clause provides away of defining a TEMPORARY relation whose DEFINITION is AVAILABLE only to the query in which the with clause occurs.

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