Searching for "Query"

Q:

In a certain code language, f CHECK is coded as 97294 and QUERY is coded as 51238, then CHERRY will be coded as?

 

 

A) 729833 B) 792338
C) 972338 D) 338972
 
Answer & Explanation Answer: C) 972338

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Coding and Decoding
Exam Prep: Bank Exams

Q:

In the following question, a sentence has been given in Active/Passive voice. Out of four alternatives suggested, select the one, which best expresses the same sentence in Passive/Active voice.

 

No one responded to Rahul's query.

 

A) Rahul's query was not responded to by anyone. B) Rahul's query is not being responded to by anyone.
C) Rahul's query has not been responded to by anyone. D) Rahul's query had not been responded to by anyone.
 
Answer & Explanation Answer: A) Rahul's query was not responded to by anyone.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: English
Exam Prep: Bank Exams

Q:

In the following question, two statements are given each followed by two conclusions I and II. You have to consider the statements to be true even if they seem to be at variance from commonly known facts. You have to decide which of the given conclusions, if any, follows from the given statements.

 

Statements:
(I) Library is a place where one may find any answer to his/her question.
(II) Books in any form whether physical or electronic are advantageous for resolving any kind of query.

 

Conclusion:
(I) Every question has an answer and one can find it in a book.
(II) Books give all related information pertaining to the title they have.

 

A) Only conclusion II follows B) Conclusion I and II both follow
C) Neither I nor II follow D) Only conclusion I follows
 
Answer & Explanation Answer: B) Conclusion I and II both follow

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Statement and Conclusions
Exam Prep: Bank Exams

Q:

A subquery in an SQL SELECT statement is enclosed in

A) [ ] B) { }
C) < > D) ( )
 
Answer & Explanation Answer: D) ( )

Explanation:

A subquery in an SQL SELECT statement is enclosed in parenthesis (...).

Report Error

View Answer Report Error Discuss

Q:

A DBMS query language is designed to

A) Specify the structure of a database B) Support in the development of complex applications software
C) Support end users who use English-like commands D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:
Report Error

View Answer Report Error Discuss

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

Q:

A UNION query is which of the following?

A) Combines the output from multiple queries and does not include the same number of columns. B) Combines the output from multiple queries and must include the same number of columns.
C) Combines the output from no more than two queries and does not include the same number of columns. D) Combines the output from no more than two queries and must include the same number of columns.
 
Answer & Explanation Answer: B) Combines the output from multiple queries and must include the same number of columns.

Explanation:

A UNION query combines the output from multiple queries and must include the same number of columns.

Report Error

View Answer Report Error Discuss

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

Q:

A subquery in an sql select statement.

Answer

A Subquery or Inner query or a Nested query is a query within another SQL query and embedded within the WHERE clause.


Subqueries are most frequently used with the SELECT statement. The basic syntax is as follows::


SELECT column_name [, column_name ]
FROM table1 [, table2 ]
WHERE column_name OPERATOR
(SELECT column_name [, column_name ]
FROM table1 [, table2 ]
[WHERE])



A subquery is used to return data that will be used in the main query as a condition to further restrict the data to be retrieved.


Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN, etc.


 


There are a few rules that subqueries must follow −


 


1. Subqueries must be enclosed within parentheses.


2. A subquery can have only one column in the SELECT clause, unless multiple columns are in the main query for the subquery to compare its selected columns.


3. An ORDER BY command cannot be used in a subquery, although the main query can use an ORDER BY. The GROUP BY command can be used to perform the same function as the ORDER BY in a subquery.


4. Subqueries that return more than one row can only be used with multiple value operators such as the IN operator.


5. The SELECT list cannot include any references to values that evaluate to a BLOB, ARRAY, CLOB, or NCLOB.


6. A subquery cannot be immediately enclosed in a set function.


7. The BETWEEN operator cannot be used with a subquery. However, the BETWEEN operator can be used within the subquery.

Report Error

View answer Workspace Report Error Discuss

Q:

What is an ABAP/4 Query?

Answer

ABAP/4 Query is a powerful tool to generate simple reports without any coding. ABAP/4 Query can generate the following 3 simple reports: Basic List: It is the simple reports. Statistics: Reports with statistical functions like Average, Percentages. Ranked Lists: For analytical reports. - For creating a ABAP/4 Query, programmer has to create user group and a functional group. Functional group can be created using with or without logical database table. Finally, assign user group to functional group. Finally, create a query on the functional group generated.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP