close

Inquiries on Database Concepts and Standards

 Essay about Questions on Database Principles and Criteria

A. В DatabaseВ concepts

1

BasicВ SQLВ Command:

SQLВ commandsВ whichВ areВ worthВ knowingВ:

В­В TRIM

(forВ strippingВ spaces)

В­В LEFT

(forВ fetchingВ theВ dataВ fromВ leftВ sideВ ofВ string)

В­В RIGHT

(forВ fetchingВ theВ dataВ fromВ rightВ sideВ ofВ string)

В­В REPLACEВ В В (forВ replacementВ inВ string)

В­В CONVERTВ В В (forВ convertingВ dataВ fromВ oneВ typeВ toВ another) В­В LEN

(forВ fetchingВ lengthВ ofВ string)

В­В STUFFВ В В В В В В В В (wayВ toВ insertВ oneВ stringВ intoВ another) В­В DIFFERENCEВ (diffВ betweenВ twoВ stringsВ В­В returnВ 4В representsВ noВ diffВ orВ strongВ similarity)

two

WhatВ isВ normalizationВ andВ whyВ doВ weВ needВ deВ­normalizationВ?

several

WhatВ areВ indexesВ inВ databaseВ?

5

WhatВ isВ differenceВ betweenВ clusteredВ indexВ andВ nonВ­clusteredВ indexВ?

5

Should a condition be used in where clause or " having by” clause�

6

WhatВ isВ CASCADEВ inВ SQL?

7

WhatВ isВ theВ useВ ofВ DEFAULT?

8

TwoВ tablesВ Employee(ID, В name, В DeptВ ID)В andВ Department(ID, Name). В В PrintВ allВ theВ departmentsВ with theВ numberВ ofВ employeesВ inВ it.

being unfaithful

WriteВ aВ queryВ toВ getВ theВ employeeВ withВ secondВ highestВ salary

W. В JavaВ Questions

one particular

JavaВ 7В haveВ someВ issueВ withВ codeВ optimization. В PriorВ toВ javaВ 7, В optimizersВ wereВ notВ enabledВ byВ default butВ nowВ withВ thisВ releaseВ theyВ haveВ beenВ enabledВ byВ default. AlthoughВ optimizationВ issuesВ occurВ whenВ loopingВ isВ forВ moreВ thanВ 10, 000В iterations.

2

WriteВ aВ programВ toВ testВ ifВ givenВ stringВ isВ aВ palidrome

3

WriteВ aВ programВ toВ printВ theВ givenВ statementВ inВ theВ reverseВ orderВ ofВ words. В (Part2: В tryВ theВ same withoutВ usingВ anyВ libraryВ function)

5

WhatВ isВ SIngleton?

five

DifferentiateВ InheritenceВ andВ Composition

6

WriteВ aВ programВ toВ testВ ifВ twoВ givenВ stringsВ areВ anagrams

7

ProgramВ toВ replaceВ allВ spacesВ withВ %20В inВ aВ givenВ string

almost 8

a)В WriteВ aВ programВ toВ findВ duplicateВ elementsВ inВ aВ givenВ arrayВ andВ printВ them. В В b)В WriteВ aВ programВ toВ findВ uniqueВ elementsВ inВ aВ givenВ arrayВ andВ printВ them.

9

WhatВ isВ RuntimeВ Polymorphism

10

C. В Testing

one particular

DifferenceВ betweenВ regressionВ testingВ andВ retestВ?

a couple of

WhatВ isВ differenceВ betweenВ sanityВ testingВ andВ smokeВ testingВ?

3

GivenВ aВ webВ serviceВ inВ anВ orderВ managermentВ systemВ whichВ fetchesВ theВ listВ ofВ orders. В В ServiceВ isВ a RESTВ CallВ withВ PostВ Method. В WriteВ allВ testsВ cases

4

WriteВ aВ testВ caseВ forВ aВ formВ whichВ hasВ oneВ dateВ fieldВ andВ SubmitВ buttonВ only

5

WriteВ testВ casesВ forВ LIft/ElevatorВ (includeВ functional, В securityВ etc)

six

TestВ CasesВ forВ PCВ Keyboard

M. В UNIX

D1. В CheckВ Sum

В В В В 

AВ checksumВ orВ hashВ sumВ isВ aВ fixedВ­sizeВ datumВ computedВ fromВ anВ arbitraryВ blockВ ofВ digitalВ dataВ forВ the purposeВ ofВ detectingВ accidentalВ errorsВ thatВ mayВ haveВ beenВ introducedВ duringВ itsВ transmissionВ orВ storage. В The integrityВ ofВ theВ dataВ canВ beВ checkedВ atВ anyВ laterВ timeВ byВ recomputingВ theВ checksumВ andВ comparingВ itВ withВ the storedВ one. В IfВ theВ checksumsВ match, В theВ dataВ wereВ almostВ certainlyВ notВ alteredВ (eitherВ intentionallyВ or unintentionally).

CheckSumВ Utilities:

a)В cksum

$В cksumВ test. txt

4038471504 75

test. txt

" 4038471504" В representsВ theВ checksumВ value. В " 75" В representsВ theВ fileВ sizeВ ofВ test. txt.

b)В md5sum

md5sumВ fileВ > В file. md5

CheckВ forВ validityВ with:

md5sumВ В­cВ file. md5

D2. В SearchВ andВ ReplaceВ inВ UNIXВ:

simplyВ useВ: В perlВ В­piВ В­e ‘s/search_string/replace_string/g'В file_names

1 . В HowВ toВ viewВ specificВ linesВ ofВ fileВ withoutВ usingВ tailВ orВ headВ? PleaseВ noteВ thatВ thisВ canВ beВ doneВ throughВ Sed.

sedВ В­nВ 5, 7pВ test3. txt

whereВ 5, 7В representsВ theВ rangeВ andВ test3. txtВ isВ theВ fileВ name. $В sedВ В­nВ В­eВ 1, 2pВ В­eВ 4pВ somefile. txt

whereВ eВ specifiesВ theВ wayВ toВ executeВ anВ expression. В ItВ willВ helpВ usВ toВ extractВ multipleВ linesВ inВ aВ file. 2 . В HowВ toВ checkВ forВ aВ specificВ stringВ andВ printВ 10В linesВ aboveВ andВ belowВ thatВ matchВ? grepВ В­nВ В­AВ number_of_linesВ В­BВ number_of_linesВ " search_pattern" В file_nameВ[PleaseВ noteВ thatВ AВ parameterВ will printВ theВ linesВ belowВ theВ matchВ whileВ BВ willВ printВ theВ linesВ aboveВ theВ match]. http://www.thegeekstuff.com/2009/03/15В­practicalВ­unixВ­grepВ­commandВ­examples/...

References: RESTfulВ ServicesВ andВ SOAPВ:

http://geeknizer.com/restВ­vsВ­soapВ­usingВ­httpВ­choosingВ­theВ­rightВ­webserviceВ­protocol/

http://spf13.com/post/soapВ­vsВ­rest

 Essay about Reasons for Attending College or University

Essay about Reasons for Attending College or University

Reasons behind Attending University or college Summary:  People attend university for many different reasons, including new experience, career planning, and improved knowledge. A large number of people attend…...

Read
 Essay about shakespeare

Essay about shakespeare

Within the class system of Elizabethan England,  William Shakespeare did certainly not seem most likely going for greatness. He was not really born to a family of the aristocracy or significant wealth.…...

Read