programming languages Online Quiz - 46
|Description: programming languages Online Quiz - 46|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
|Tags: programming languages|
Which of the following is TRUE about Views in SQL?
SQL is a
Which of the following is TRUE about subqueries in SQL?
To answer this question, let's go through each option to understand why it is correct or incorrect:
Option A) Sub queries must be enclosed in parenthesis - This option is correct. In SQL, sub queries are enclosed in parenthesis to separate them from the main query. This helps in defining the scope of the sub query and makes it clear to the database engine where the sub query begins and ends.
Option B) BETWEEN cannot be used with a sub query - This option is incorrect. In SQL, the BETWEEN operator can be used with a sub query. The sub query can provide the range of values for the BETWEEN operator to compare against.
Option C) Both A. and B. - This option is incorrect. Option A is correct, but option B is incorrect.
Option D) None of the Above - This option is incorrect. Option A is correct, so the correct answer cannot be "None of the Above".
Therefore, the correct answer is Option C. This option is correct because sub queries in SQL must be enclosed in parenthesis, but the BETWEEN operator can be used with a sub query.
The database programming language which is used for retrieving data and updating data on a database is called
Which of the following SQL command represent character data type?
SQL stands for
A developer has a requirement to expose a Web service interface to an existing order processing system. The order processing system is quite old and the company has doubts about its compatibility with newer technologies. What is the appropriate design?
A client sends a required SOAP header as a SOAP message. The server-side process determines that information in the header is invalid and generates a SOAP fault. What is the appropriate fault code for this type of SOAP fault?
A Web service needs to validate the credit rating for a loan. The service requires a social security number, full name, and date of birth as input and returns one of many possible documents. Which statement is true?
A document-style service defines a document passed to the Web service using xsd:anyType in the WSDL file that describes the service. How should the document be typed in Java
A company is designing a new application to track the materials used by their construction firm on a large industrial construction project. They want their suppliers to be able to see what materials the company needs for a competitive bid process. As the architect for the Service Oriented Architecture, why would a developer use UDDI?
Which operators can be used in an Input calculation context? i)Input ii)ForAll iii)ForEach iv)In
Search help can not be attach to:
You are creating a report to summarize the number of cars sold by region. Which object should you use to aggregate the number of cars sold?
Full Buffering would be appropriate for
To answer this question, the user needs to have a basic understanding of buffering techniques used in database management systems.
Full buffering is a buffering technique in which the entire table is read into the buffer pool. This technique is appropriate for tables that are small and static, as well as tables that are accessed frequently and require fast access times.
Now, let's go through each option and explain why it is right or wrong:
A. Transaction Tables: Transaction tables are large and frequently updated, so full buffering is not appropriate for them. Instead, partial buffering or no buffering may be more appropriate.
B. Small Static tables: Small static tables are ideal for full buffering, as they are easy to load into memory and can be accessed quickly.
C. Internal Tables: Internal tables are usually small and accessed frequently, so full buffering may be appropriate for them.
D. Tables with generic Keys: Whether or not full buffering is appropriate for tables with generic keys depends on the size and usage patterns of the table.
Therefore, the answer is:
The Answer is: B. Small Static tables
What is the basic object of data Dictionary
Sub query usually more efficient because:
To answer this question, we need to understand the concept of subqueries and their efficiency in filtering data.
A subquery is a query that is nested within another query. It is used to retrieve data that is based on the results of another query. Subqueries can be written in different parts of a SQL statement, such as the SELECT, FROM, WHERE, or HAVING clauses.
The correct answer is A) data is filtered in the database. Subqueries are typically more efficient because they allow the database to perform the filtering of data.
When a subquery is used, the database can optimize the query execution by evaluating the subquery first and then using the result of the subquery to filter the data in the outer query. This approach reduces the amount of data that needs to be transferred over the network and processed by the application server.
On the other hand, options B, C, and D are incorrect:
B) data is filtered on the network - Subqueries do not involve filtering data on the network. The network is primarily used for transferring data between the client and the database server.
C) data is filtered in the sapgui - Subqueries do not directly filter data in the SAP GUI (Graphical User Interface). The SAP GUI is a client interface that allows users to interact with the SAP system, but the actual data filtering is performed by the database server.
D) data is filtered at the application server - Subqueries do not directly filter data at the application server. The application server typically processes business logic and handles client requests, but the actual data filtering is performed by the database server.
Therefore, the correct answer is A) data is filtered in the database because subqueries allow the database to efficiently filter data based on the results of another query.
You can create query on which of the following? i) DSO ii) Infocube iii) Multiprovider iv) Virtual Provider
What is the transaction-code for viewing batch-runs of a program?
You are planning to use Calculated Key Figures. Which of the following statements are true? i) Calculated Key Figures can be stored at Infoprovider level. ii) Calculated Key Figures can be stored in the PSA iii) Calculated Key Figures can be stored at Query level iv) Calculated Key Figures stored at Query level can be reused