Sawaal
  • Home/
  • Searching for queries

 Searching for "queries"

Q:

The question below consists of a set of labelled sentences. Out of the four options given, select the most logical order of the sentences to form a coherent paragraph.

Finally, what is left are an

 

A-innocuous bunch of audit

B-queries, useful for auditors and

C-harmless for staff members

 

A) ABC B) CBA
C) CAB D) BCA
 
Answer & Explanation Answer: A) ABC

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

Q:

Which of the following statements is true concerning subqueries?

A) Does not start with the word SELECT. B) Involves the use of an inner and outer query.
C) Cannot return the same result as a query that is not a subquery. D) All of the above
 
Answer & Explanation Answer: B) Involves the use of an inner and outer query.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer

Q:

Define "Correlated Subqueries" ?

Answer

In a SQL Database, a 'correlated subquery' is a kind of sub query yet connected subquery is dependent on another query for a value that is returned. In case of execution, the sub query is executed first and afterwards the correlated query will be executed.

Report Error

View answer Workspace Report Error Discuss

Subject: Data Warehousing
Job Role: IT Trainer , Database Administration , Analyst

Q:

What are the properties and different Types of Sub-Queries?

Answer

Properties of Sub-Query


- A sub-query must be enclosed in the parenthesis.


- A sub-query must be put in the right hand of the comparison operator, and


- A sub-query cannot contain an ORDER-BY clause.


- A query can contain more than one sub-query.


Types of Sub-Query


- Single-row sub-query, where the sub-query returns only one row.


- Multiple-row sub-query, where the sub-query returns multiple rows,. and


- Multiple column sub-query, where the sub-query returns multiple columns

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

Q:

Which object types can you merge when using Multi Queries in a Web Intelligence document (WID)?

A. Dimension - Measure

B. Dimension - Detail

C. Measure - Measure

D. Dimension - Dimension

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Can Queries be used after changes are made to the InfoProvider?

A. Maybe

B. No

C. Yes

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

What needs to be done to make the queries work after changes are made to an InfoProvider?

A. Re-Generate the queries.

B. Nothing can be done.

C. Delete and re-create the queries.

Answer

Answer : A

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW