orchestrapit.co.uk Report : Visit Site

Technical data of the orchestrapit.co.uk

Geo IP provides you such as latitude, longitude and ISP (Internet Service Provider) etc. informations. Our GeoIP service found where is host orchestrapit.co.uk. Currently, hosted in United Kingdom and its service provider is GBServers Network .

HTTP Header Analysis

HTTP Header information is a part of HTTP protocol that a user's browser sends to called Apache containing the details of what the browser wants and will accept back from the web server.

DNS

HtmlToText

the ramblings of an oracle developer home rss feed certified at last! boneist december 15, 2017 uncategorized 2 today saw me trundling off to dear old birmingham for the second time in 2 weeks (the first time being for the ukoug tech17 conference) and doing a fair impression of a nervous wreck. that’s because i was heading to take both the sql (1z0-061) and pl/sql (1z0-144) oracle certification exams. i don’t like doing exams, mainly because i’m rubbish at revising (seriously; the most revision i did throughout all my university career consisted of 10-15 minutes before each exam. thankfully, the maths degree i did (and got!) involved practising stuff as part of the coursework, so i learnt by doing, rather than rote memorisation). i was very worried that i’d fail these exams because the questions in the exam (certainly in the practice exams) don’t necessarily reflect anything like what you’d do in real life. for example, i would never consider using natural joins in any of my code, and i’d certainly flag it up if i ever saw it in someone else’s meant-for-production code! why guess at what join conditions you want, rather than specifying them explicitly? especially when that opens you up to a potential bug (what if someone adds a new column that ends up being included in the join condition?). even the join … using form is not something i’d recommend, because then you will end up aliasing some columns but not the columns in the join; why make life hard for yourself when you can use join … on and simply alias all the columns? anyway, i digress. i passed both exams relatively convincingly, fortunately. it would have been embarrassing if i’d failed them, given how long i’ve worked with sql and pl/sql! the main reason i’m writing this post is because tim hall basically asked me for an interview, and i thought i would humour him (because he definitely didn’t have a good idea. nope! no siree! *{;-) ). and also, it’s been waaay too long since i last updated this blog! on with the interview: you’re a very experienced oracle developer. what made you decide to do some oracle certification exams at this point in your career? i can’t take the credit for this; basically my department was allocated some budget to get everyone certified to either associate (most of the developers) or professional (the team leads) in 2017. before you say “didn’t you leave it a bit late?” i had planned on doing it at the beginning of october, but emergency surgery (i’m fine now!) the week before i was due to do it meant i had to postpone it. today was the day! what materials (books, blogs, training, practise questions) did you use to prepare for the exams? the books i used were roopesh ramklass’s oca oracle database 12c sql fundamentals i exam guide and matthew morris’s study guide for 1z0-144: oracle database 11g: program with pl/sql: oracle certification prep . roopesh’s book included a cd with some practice questions, so i worked my way through those. matthew morris’s book had a link (and discount) to a test you had to pay for, which i took and failed (this did *not* help my nerves one little bit!) and had to retake. plus, of course, there was the official oracle training course for the pl/sql exam (although i only managed the first 3 days of the online course!), plus the official practice exams provided by transcender. how long did you spend revising specifically for the exams? i’ve been working with sql for nearly 19 years and pl/sql for at least 13 years, so you could say that i’ve been working towards the exams for a while now. however, in terms of actually boning up for the sql and pl/sql exams? i’d already done a bit before life interfered – i’d read the first 3 chapters of roopesh’s sql book and done 3/5ths of the official pl/sql training (i ran out of time on that one; i can’t blame the surgery for that!) plus the official practice exams. then i had a break of about two-and-a-bit-months, until last monday (four days before the exams) when work very kindly gave me four days off for revision before the exams. i finished reading the sql book over monday and tuesday (finishing up with the practice exams from the cd), and then read the pl/sql book over wednesday and thursday (finishing up with the practice exams from the website linked to the book). as revision goes, i couldn’t recommend my technique to anyone. i should have actually practised things more (e.g. actually creating triggers on tables, etc) but that would have taken far longer than the four days i had. also, the sql book didn’t cover some topics, such as listagg (which i knew about) and the new fetch first… etc functionality (which i hadn’t realised would be tested), so perhaps a wider reading selection would have helped cover these extra topics. now you’ve passed the exams, how do you feel about the certification process? i feel relieved, to be honest! these exams have been hanging over me for at least the past 6 months, and now they are done! more seriously, i think they’re probably a good way to get beginners to learn a broad subset of sql and pl/sql, but like most text books, the examples given/questions in the exams are terribly contrived and are nothing like what you’d actually do in real life. i think for our department (which consists of lots of pl/sql developers, not all of whom are that familiar with sql and/or pl/sql) it was a good idea – at least everyone should now be at a similar level of knowledge. i think some of the questions on the actual exams were very ambiguous. i had to spend time analysing the requirement and trying to work out what the heck they meant. did they want employees earning over x salary that were hired in the last n months that have a manager, or was it employees with a manager plus employees hired within n months who earn over x salary? or something else? *scratches head* i’m still not sure on that one, but i’m bloomin’ sure i wouldn’t provide an answer using set operations, which is what all the suggested answers used! i’m convinced at least one of the questions in each exam didn’t have an answer. *that’s* not helpful. i think someone really needs to go through the exam and point out all these inconsistencies to oracle. also i’m confused about why regexp and analytic functions were completely missing from the sql exam and prep; there was one question where i could have ticked all four boxes, except it wouldn’t allow me to. i left the box that would have been covered by regexp_count unticked since that wasn’t in the training gumph. are you likely to do any more certifications? part of me is like “noooooo, are you kidding? why would i put myself through this again?!” but the completist side of me thinks that maybe i should go the whole hog and try for the ocp. whether work would have enough budget for that (seeing as i’m not one of the team leads), i don’t know. i’m still debating whether i should ask or not. do you think you’ve benefited from the process? i get an extra three letters to add after my name? i guess that’s a benefit. i don’t think i learnt much of anything new, or at least nothing that i couldn’t google as part of my day-job (i mean, who remembers the syntax for creating a ddl trigger, if you only ever do it once in a blue moon?). possibly the only thing i learnt was about plsql_optimize_level, which i may bring up at work on monday, if we aren’t already set at the highest level! personally, i don’t feel the need to “prove my worth” by having a piece of paper stamped with “oca”, since i have other means of proving my capabilities, but i do think this might be of use to new sql and pl/sql developers. it’s not something that should be taken to indicate the person is an expert, though – experience is needed long before you can call yourself that! to be fair, i did see that mentioned on the transcender practice exam page. dropping constraint… what about the index? boneist may 26, 2016 uncategorized 0 in a recent release that i’ve been working on, we had to drop and recre

URL analysis for orchestrapit.co.uk

http://www.orchestrapit.co.uk/?p=160#comments
http://www.orchestrapit.co.uk/?tag=constraints
http://www.orchestrapit.co.uk/?p=171
http://www.orchestrapit.co.uk/?p=118#comments
http://www.orchestrapit.co.uk/?p=98#comments
http://www.orchestrapit.co.uk/?p=152
http://www.orchestrapit.co.uk/?p=55#respond
http://www.orchestrapit.co.uk/?tag=social
http://www.orchestrapit.co.uk/?tag=agenda
http://www.orchestrapit.co.uk/?p=181#respond
http://www.orchestrapit.co.uk/?tag=dbas-vs-devs
http://www.orchestrapit.co.uk/?tag=tabibitosan
http://www.orchestrapit.co.uk/?m=200909
http://www.orchestrapit.co.uk/?m=200901
http://www.orchestrapit.co.uk/?m=200907
amazon.co.uk
2012.ukoug.org
2011.ukoug.org

Whois Information

Whois is a protocol that is access to registering information. You can reach when the website was registered, when it will be expire, what is contact details of the site with the following informations. In a nutshell, it includes these informations;

Domain name:
orchestrapit.co.uk

Registrant:
Dawn Rigby

Registrant type:
UK Individual

Registrant's address:
The registrant is a non-trading individual who has opted to have their
address omitted from the WHOIS service.

Data validation:
Nominet was able to match the registrant's name and address against a 3rd party data source on 10-Dec-2012

Registrar:
Nexus Data Systems Ltd [Tag = KTHOSTING]
URL: http://www.kthosting.net

Relevant dates:
Registered on: 15-Jul-2003
Expiry date: 15-Jul-2026
Last updated: 22-Jul-2016

Registration status:
Registered until expiry date.

Name servers:
ns0.ivarch.com
ns1.ivarch.com

WHOIS lookup made at 05:31:49 22-Oct-2017

--
This WHOIS information is provided for free by Nominet UK the central registry
for .uk domain names. This information and the .uk WHOIS are:

Copyright Nominet UK 1996 - 2017.

You may not access the .uk WHOIS or use any data from it except as permitted
by the terms of use available in full at http://www.nominet.uk/whoisterms,
which includes restrictions on: (A) use of the data for advertising, or its
repackaging, recompilation, redistribution or reuse (B) obscuring, removing
or hiding any or all of this notice and (C) exceeding query rate or volume
limits. The data is provided on an 'as-is' basis and may lag behind the
register. Access may be withdrawn or restricted at any time.

  REFERRER http://www.nominet.org.uk

  REGISTRAR Nominet UK

SERVERS

  SERVER co.uk.whois-servers.net

  ARGS orchestrapit.co.uk

  PORT 43

  TYPE domain

OWNER

  ORGANIZATION Dawn Rigby

TYPE
UK Individual

ADDRESS
The registrant is a non-trading individual who has opted to have their
address omitted from the WHOIS service.
Data validation:
Nominet was able to match the registrant's name and address against a 3rd party data source on 10-Dec-2012

DOMAIN

  SPONSOR Nexus Data Systems Ltd [Tag = KTHOSTING]

  CREATED 2003-07-15

  CHANGED 2016-07-22

STATUS
Registered until expiry date.

NSERVER

  NS0.IVARCH.COM 185.10.200.180

  NS1.IVARCH.COM 185.10.200.180

  NAME orchestrapit.co.uk

DISCLAIMER
This WHOIS information is provided for free by Nominet UK the central registry
for .uk domain names. This information and the .uk WHOIS are:
Copyright Nominet UK 1996 - 2017.
You may not access the .uk WHOIS or use any data from it except as permitted
by the terms of use available in full at http://www.nominet.uk/whoisterms,
which includes restrictions on: (A) use of the data for advertising, or its
repackaging, recompilation, redistribution or reuse (B) obscuring, removing
or hiding any or all of this notice and (C) exceeding query rate or volume
limits. The data is provided on an 'as-is' basis and may lag behind the
register. Access may be withdrawn or restricted at any time.

  REGISTERED yes

Mistakes

The following list shows you to spelling mistakes possible of the internet users for the website searched .