Tag: technology

Questions Related to technology

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

technology databases

  1. 8

  2. 2

  3. 3

  4. 4

  5. 5

Show answer
Correct Option: C

Which of the following factor which is not suitable to practice SOA?
technology architecture

  1. a) Broad and Complex Business Ecosystem

  2. b) Flexible Computer Systems

  3. c) Unable to Connect your Software Assets to Entities outside the Organization

  4. d) None of the above

Show answer
Correct Option: C

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

technology databases

  1. 03-JUL-00

  2. 10-JUL-00

  3. 12-JUL-00

  4. 11-JUL-00

  5. 17-JUL-00

Show answer
Correct Option: E
Explanation:

To solve this question, the user needs to understand the function of each element of the SQL statement and how it affects the output.

The SQL statement is selecting a date and formatting it according to the given format string. Specifically:

  • sysdate returns the current date and time.
  • NEXT_DAY(sysdate, 'MONDAY') returns the next occurrence of the day specified as the second argument, after the current date and time (sysdate). In this case, it returns the next Monday after 10 July 2000, which is 17 July 2000.
  • to_char() converts the resulting date into a string using the format specified as the second argument. In this case, the format is 'DD-MON-RR', which returns the day of the month (DD), the abbreviated month name (MON), and the 2-digit year (RR).

Therefore, the correct answer is E. 17-JUL-00, as the SQL statement returns the formatted date of the next Monday after 10 July 2000, which is 17 July 2000.

Why SOA?
technology architecture

  1. a) Makes systems more responsive to business needs, simpler to develop, and easier to maintain and manage.

  2. b) Programs the workflow engine to carry out the business process

  3. c) Helps organizations plan ahead for change, rather than responding reactively.

  4. d) The job of getting the message from the sending component to the receiving component.

Show answer
Correct Option: A,C

What type of software services does SOA use to support the requirements of business processes and software use?
technology architecture

  1. a) Tightly Coupled

  2. b) Loosely Coupled

  3. C) Highly Coupled

  4. d) Heavily Coupled

Show answer
Correct Option: B

Which character is used to continue a statement in SQL*Plus?

technology databases

  1. *

  2. /

  3. -

  4. @

Show answer
Correct Option: C

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
technology databases

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Oracle will give an error

  5. Undefined

Show answer
Correct Option: C

What all technologies SOA can be implemented?
technology architecture

  1. a) CORBA

  2. b) Web Service

  3. c) TEST

  4. d) DCOMM

Show answer
Correct Option: A,B

What are some of the Guiding Principles of SOA?
technology architecture

  1. a) Services identification and categorization, provisioning and delivery, and monitoring and tracking

  2. b) Reuse, Granularity

  3. c) Compliance to standards (both common and industry-specific)

  4. d) All the above

Show answer
Correct Option: D

What is Service Loose coupling in SOA?
technology architecture

  1. a) Logic is divided into services with the intention of promoting reuse

  2. b) Services maintain a relationship that minimizes dependencies and only requires that they maintain an awareness of each other

  3. c) Services have control over the logic they encapsulate

  4. d) Beyond what is described in the service contract, services hide logic from the outside world

Show answer
Correct Option: B