0

programming languages Online Quiz - 46

Description: programming languages Online Quiz - 46
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

Which of the following is TRUE about Views in SQL?

  1. Views are windows of existing table

  2. Creation of view is done by using CREATE VIEW statement

  3. Views do not contain data but table from which it is created contain data

  4. All the Above


Correct Option: D

SQL is a

  1. Non- procedural language

  2. Procedural language

  3. Database Language

  4. Both A. and C.


Correct Option: D

Which of the following is TRUE about subqueries in SQL?

  1. Sub queries must be enclosed in parenthesis

  2. BETWEEN cannot be used with a sub query

  3. Both A. and B.

  4. None of the Above


Correct Option: C

AI Explanation

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

  1. Structured database Language

  2. Structured programming Language

  3. Structured Query Analyzer

  4. Structured Query Language


Correct Option: D

Which of the following SQL command represent character data type?

  1. CHAR

  2. VARCHAR

  3. VARCHAR2

  4. All the Above


Correct Option: D

SQL stands for

  1. Storage Query Language

  2. Structured Query Language

  3. Storage Queuing Language

  4. Standard Query Language


Correct Option: B

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?

  1. only a new interaction layer

  2. only a new processing layer

  3. a new interaction layer and a new processing layer

  4. a new interaction layer and a facade processing layer that uses the existing order processing system

  5. a new processing layer and a facade interaction layer that uses the existing order processing system


Correct Option: D

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?

  1. Client

  2. Server

  3. MustUnderstand

  4. VersionMismatch

  5. HeaderError

  6. InvalidHeader


Correct Option: A

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?

  1. The developer must use an EJB-based endpoint.

  2. The developer must use a procedure-style Web service.

  3. The developer must use a document-style Web service.

  4. The developer can use a procedure-style or document-style Web service.


Correct Option: D

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

  1. use javax.xml.soap.Element

  2. use javax.xml.soap.Node

  3. use javax.xml.soap.SOAPHeader

  4. use javax.xml.soap.SOAPElement

  5. use javax.xml.soap.SOAPFault

  6. use javax.xml.soap.SOAPBodyElement


Correct Option: D

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?

  1. It defines the Web services as a resource.

  2. It defines a stateful behavior for the participating Web services.

  3. It provides a location where services can be dynamically discovered.

  4. It defines a stateless behavior for the participating Web services.

  5. It decouples the Web service from its implementation.


Correct Option: C

Which operators can be used in an Input calculation context? i)Input ii)ForAll iii)ForEach iv)In

  1. i

  2. iii

  3. iv

  4. b & c


Correct Option: D

Search help can not be attach to:

  1. Domain

  2. field of a table

  3. check table

  4. Type


Correct Option: D

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?

  1. Detail

  2. Measure

  3. Dimension

  4. Sum


Correct Option: B

Full Buffering would be appropriate for

  1. Transaction Tables

  2. Small Static tables

  3. Internal Tables

  4. Tables with generic Keys


Correct Option: B
Explanation:

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

  1. Domains

  2. Documentation

  3. Data Models

  4. Dynpro


Correct Option: A

Sub query usually more efficient because:

  1. data is filtered in the database

  2. data is filtered on the network

  3. data is filtered in the sapgui

  4. data is filtered at the application server


Correct Option: A

AI Explanation

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

  1. i

  2. ii

  3. ii & iii

  4. I & iii


Correct Option: C

What is the transaction-code for viewing batch-runs of a program?

  1. SE37

  2. SM37

  3. SM35

  4. SM30


Correct Option: B

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

  1. i

  2. iv

  3. iii

  4. a & d

  5. a,b,d


Correct Option: D
- Hide questions