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 Stakeholders

Essay about Stakeholders

Just about every business provides stakeholders engaged. A stakeholder is those who have a claim in some way into a company's goods, operations, markets, industry, and outcomes (Ferrell, Fraedrich…...

Read
 Essay regarding Rational Decision Making Model

Essay regarding Rational Decision Making Model

Fuzy What is a decision? The word decision can be defined as, " the work of getting to a conclusion or perhaps making up a person's mind" (American Heritage…...

Read