Last week at the BI forum I ran a quiz.

It was a a light hearted affair with specialist subject questions mixed with general knowledge.

The winning team overall was JEH, and the most obiee skilled team was the Dream Team. Top prizes included some Brighton rock and a pencil!!

I had to dig around in the documentation to find some of the questions, and found a few tough ones, so I was delighted that everyone did pretty well. If you were in a team you may want to see the results below!

Here are the questions. See how many you can get.

I may post the answers later!

1. What can’t you ‘manage’ in the Admin tool

a) Projects

b) Sessions

c) Security

d) Variables

e) Models

f) Cache

2. Who thinks Coding in UDML is fun

a) Andreas Nobbman

b) Christian Berg

c) Mark Rittman

3. Which if these is NOT a view in OBIEE

a) Text

b) Legend

c) Static Text

d) Narrative

4. Which of these is NOT a table type in the physical layer.

a) Materialized View

b) Stored Procedure

c) Physical Table

d) Select

5. What is this Icon used for?

a) See who has access to a page

b) See more details on a group

c) Add a column to a page

d) Add a user to a group

e) Add a page to a dashboard

6. What does the UDML statement “DECLARE ENTITY FOLDER” create

a) Presentation Catalog

b) Presentation Table

c) Physical Display Folder

d) Logical Display Folder

7. Which of the following is NOT valid UDML

a) DECLARE ATTRIBUTE

b) DECLARE FOLDER

c) DECLARE TABLE KEY

d) DECLARE COLUMN

8. Which of these is NOT a real utility

a) nQSStartup.exe

b) nQSChangePassword.exe

c) nQLogViewer.exe

d) nQCmd.exe

e) nQUDMLGen.exe

9. Which of the following is NOT a real setting in the privileges section of the web based admin

a) Analyze BI Publisher Reports

b) Access to RSS Feeds

c) Manage Privileges

d) Edit My Dashboard

e) Add/Edit Nested Request View

10. What year saw the release of Siebel Analytics 7.5

a) 2002

b) 2000

c) 1998

d) 2004

11. Which of these is NOT a real Oracle Function

a) NEXT_DAY

b) TRUNK

c) NEW_TIME

d) EXTRACT

e) MONTHS_BETWEEN

12. Which of these is NOT a real Admin Tool Utility

a) Repository Documentation

b) Remove Unused Physical Objects

c) Aggressive Persistence Wizard

d) Oracle BI Event Tables

e) Rename Wizard

13. What setting do you add to instanceconfig.xml if you want group dashboards together in a single hyperlink

a) DashboardMenuLinks

b) PortalBannerLinkItems

c) DashboardMaxBeforeMenu

d) DashboadLinkItems

14. Which SQL statement is valid

a) CREATE OR REPLACE FUNCTION AW3(vInt IN PLS_INTEGER)

b) CREATE OR REPLACE MATERIALIZED VIEW AW2 AS SELECT * FROM AW1

c) CREATE OR UPDATE VIEW AW4(COL1) AS SELECT COL1 FROM AW1

d) CREATE OR REPLACE TABLE AW1(COL NUMBER)

15. What was the name of the original company that developed OBIEE

a) Nquire

b) Majendi

c) Oracle

d) Siebel

16. Which of the following functions is NOT valid

a) Week_Of_Year.

b) DayOfQuarter

c) Week_of_Quarter

d) DayOfWeek

e) DayOfYear

f) DayOfMonth

17. Which function returns the first item in the list that the user has permission to see

a) INDEXCOL

b) CHOOSE

c) CHOOSECOL

d) INDEX

18. True or False: To make a dashboard visible to one group only, that group needs to be added to the repository

a) TRUE

b) FALSE

19. Which well known blogger has his own brewery

a) Venkat

b) Adrian Ward

c) Jeff Mcquigg

d) John Minkjan

20. Which of these is a real professional LinkedIn group

a) Oracle Business Intelligence Group

b) Oracle BI Nerds Group

c) OBIEE Unlimited Group

d) OBIEE for Beginners Group

21. What is the maximum number of characters that display in a textbox

a) 125

b) >100000

c) 256,000

d) 255

22. What is the default size parameter of the CHAR datatype in a Cast function

a) 30

b) 100

c) 2000

d) 255

23. Which of these is NOT a real configuration file

a) NQSConfig.xml

b) NQclusterconfig.ini

c) catalogmanager.ini

d) config.ini

e) rtfm.ini

24. Which of the following is a valid interval

a) TSI_SECOND

b) TIME_SECOND

c) SQL_SECOND

d) SQL_TSI_SECOND

25. In the instanceconfigl.xml there is a tag called DSN. In which file does this tag look for more details?

a) tnsnames.ora

b) odbc.INI

c) NQClusterconfig.INI

d) NQServer.INI

26. True or False: To use LDAP based Authorisation, you have to import the groups into the catalog

a) TRUE

b) FALSE

27. Which of these is NOT related to Security

a) Usage Tracking

b) Authorisation

c) Authentication

d) Data Restrictions

28. Which of these is NOT a real icon?

a) Happy Face

b) Fish

c) Table

d) Heart

e) Laptop

f) Bear

29. Using an embedded URL, How do you include a dashboard from another catalog, without the top border (the one with the dashboard links in)

a) &nfi

b) &Border=False

c) &Syndicate=Sibel

d) &PageOnly=True

e) It just does it for you

30. At the BI Forum in 2009, Who said, ‘Don’t try this at home kids’

a) Christian Berg

b) John Minkjan

c) @drian

d) @lex

31. Which of these of NOT a real obiee object

a) Narrative

b) Text Box

c) Edit box

d) Speech Bubble

32. Which is the lowest logging level that will include the actual SQL sent to the database

a) 4

b) 1

c) 2

d) 3

33. Which of these is NOT a real function in OBIEE?

a) MAVG

b) CURRENT_DAY

c) SPACE

d) RMAX

e) REPEAT

34. What Query Restrictions are NOT available on User Permission settings

a) Time Restriction

b) Max Rows

c) Max Minutes

d) Max tables

35. In which config file do you set the path for your java files that called in an iBot?

a) instanceconfig.xml (in OracleBIData\web\config)

b) NQSConfig.INI

c) config.xml

d) filemap.xml

e) instanceconfig.xml (in the other place!)

36. Which of these is NOT a real Oracle Function

a) LEADING

b) BIN_TO_NUM

c) NANVL

d) SOUNDEX

e) REGEXP_COUNT

37. What Command is used to embed a dashboard Page into another web page?

a) Dashboard&GoURL

b) Dashboard&PortalPath

c) Go&Path

d) Dashboard&GoPath

e) Dashboard&Portal

38. Who won the Americas cup in 2004

a) Switzerland

b) Australia

c) Larry Elison

d) Spain

e) Oracle

39. On February 25th, From the list below, who has the highest number of points on the OBIEE forum on OTN

a) Christian Berg

b) Gerard Nico

c) Jon Mead

d) Goran O

e) Phil Henson

40. How many arguments does the OBIEE function INSERT have?

a) 5

b) 1

c) 4

d) 3

e) 2

41. What is the standard Port number used in 10g for the javahost?

a) 9706

b) 9810

c) 9803

d) 9703

e) 9710

42. Which of the following is NOT a report link

a) Copy

b) Save

c) Modify

d) Refresh

e) Download

43. Which ‘Operator’ is NOT available in a ‘Column Filter Prompt’

a) is less than

b) is in top

c) begins with

d) contains all

e) is LIKE (pattern match)