Database [3i Infotech Placement]: Sample Questions 101 - 102 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 101

Database

Question

MCQ▾

If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated

Choices

Choice (4)

a.

For all the records retrieved

b.

Only for 10 records

c.

For all the records in the referenced table

d.

All of the above

Answer

b.

Explanation

  • If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated only for 10 records.
  • Summary report contains one column with value or values consisting of a summary of other data.
  • Column totalling sales, column that averages commissions, and column that shows maximum amounts are examples of summary columns.
  • Counts for regular or aggregate records beneath a given refinement are retrieved, using these properties:
    • As a property on each dimension value.
    • As a property on each dimension value- for aggregated records.
  • Value summary columns are calculated by summarizing data retrieved from another column.

Question 102

Database

Question

MCQ▾

REPLACE ( ‘JACK AND JUE’ , ‘J’ , ‘BL’ ) will return

Choices

Choice (4)

a.

BLACK AND JACK

b.

BLACK AND BLUE

c.

JACK AND BLUE

d.

All of the above

Answer

b.

Explanation

  • REPLACE function replaces a sequence of characters in a string with another set of characters.
  • replacement_string is omitted or null, then all search_string are removed.
  • search_string is null, then char is return.

Syntax:

REPLACE (string1, string_to_replace [, replacement_string] )

EX:

REPLACE ( ‘JACK AND JUE’ , ‘J’ , ‘BL’ )

J = search_string

BL = replacement_string

So, JACK = BLACK

JUE = BLUE

So, return string is BLACK AND BLUE

Developed by: