0

web technology Online Quiz - 149

Description: web technology Online Quiz - 149
Number of Questions: 20
Created by:
Tags: web technology
Attempted 0/20 Correct 0 Score 0

Calculates the standard deviation based on the entire population of selected database entries

  1. DVAR

  2. DSTDEV

  3. DSTDEVP

  4. DAVERAGE


Correct Option: C

Adds the numbers in the field column of records in the database that match the criteria

  1. DSUM

  2. DSTSUM

  3. SUMDATA

  4. ADD_DATA


Correct Option: A

Estimates variance based on a sample from selected database entries

  1. DVARIABLE

  2. DVARP

  3. DVAR

  4. None of the Above


Correct Option: C

Returns the serial number of the date that is the indicated number of months before or after the start date

  1. EDATE

  2. DDATE

  3. DATEVALUE

  4. None of the Above


Correct Option: A

Returns the serial number of the last day of the month before or after a specified number of months

  1. LASTDAYMONTH

  2. DMONTH

  3. EMONTH

  4. EOMONTH


Correct Option: D

Returns the serial number of a particular date

  1. DATE

  2. DATEVALUE

  3. DAY

  4. DGET


Correct Option: A

Converts a date in the form of text to a serial number

  1. DATE

  2. DATEVALUE

  3. DAYS360

  4. DGET


Correct Option: B

Returns the average of selected database entries

  1. DAVERAGE

  2. AVERAGEDATE

  3. AVGDATE

  4. DGET


Correct Option: A

Converts a serial number to a second

  1. ESECOND

  2. GETSECOND

  3. CONVSECOND

  4. SECOND


Correct Option: D

Converts a serial number to a day of the week

  1. COUNTWEEK

  2. WEEKNUM

  3. WEEKDAY

  4. COUNTDAY


Correct Option: C

Converts a serial number to a number representing where the week falls numerically with a year

  1. GETWEEK

  2. GETWEEKNUM

  3. WEEKNUM

  4. COUNTWEEK


Correct Option: C

Returns the serial number of the date before or after a specified number of workdays

  1. WORKDAY

  2. WEEKNUM

  3. DAYS

  4. None of the Above


Correct Option: A

Converts a serial number to a year

  1. YEAR

  2. YEARS

  3. YEARFRAC

  4. YEARSFRAC


Correct Option: A

Returns the year fraction representing the number of whole days between start_date and end_date

  1. YEARSFRAC

  2. YEAR

  3. YEARFRAC

  4. None of the Above


Correct Option: C

Returns the serial number of a particular time

  1. TIME

  2. NOW

  3. DATE

  4. None of the Above


Correct Option: A

Converts a time in the form of text to a serial number

  1. TIMEVALUES

  2. TIME

  3. STRINGTIME

  4. TIMEVALUE


Correct Option: D

Returns the serial number of today's date

  1. NOW

  2. TODAY

  3. TIME

  4. WEEKDAY


Correct Option: B
  1. A stateful session bean:
  1. Can be shared between multiple clients

  2. Is created when the client invokes create on the Home

  3. Is the most scalable type of bean

  4. None


Correct Option: B

A message-driven bean:

  1. Has a client view

  2. Has a Remote interface

  3. Has a Local interface

  4. Doesn’t feature a Component interface


Correct Option: D

For remote objects Java passes objects

  1. By reference

  2. By object copy

  3. By producing a serialized copy

  4. None


Correct Option: B,C
- Hide questions