Transcript
1. What are are the major major content content areas areas covered covered in in the Oracle Oracle Acade Academy? my? Data Modeling, SQL, and PLSQL !"#
$.
%he demand &or 'n&ormation 'n&ormation %echnology (ro&ession (ro&essionals als in today)s mar*et mar*et is increasing. increasing. %r+e %r+e or alse? alse? %r+e %r+e !"#
-.
o/ do yo+ yo+ t+rn t+rn 0dat 0data0 a0 into into 0in&or 0in&ormatio mation0? n0? y 2+erying it or accessing it !"#
3.
What are are the res+lts res+lts o& o& having having all yo+r data data in one central central location? location? !4hoose !4hoose t/o# 'm(roved (er&ormance !"#
5asier access to data !"# 6.
4onsider an e7am(le e7am(le /here /here an Oracle Oracle data8ase /or*s 08ehind 08ehind the the scenes0 &or &or common internet activity. Which o& the &ollo/ing 8est descri8es a data8ase transaction? A (erson searches an airline /e8site to 9nd all availa8le &ares &or a :ight. !"#
;.
Which o& the &ollo/i Which &ollo/ing ng are are e7am(les e7am(les o& o& data vs. vs. in&orma in&ormation tion<< 5. A, , and D !"#
=.
Which o& the &ollo/ing &ollo/ing re(resents re(resents the correct correct se2+ence se2+ence o& ste(s in the Data8ase Data8ase Develo(ment Develo(ment Process? Analy>e, Design, +ild !"#
.
Data Modeling Modeling is the last ste( in in the data8ase data8ase develo(ment develo(ment (rocess. (rocess. %r+e or alse? alse? alse !"#
@.
Oracle /as one one o& the 9rst relational relational data8ase data8ase systems availa8le availa8le commercially commercially. %r+e %r+e or alse? alse? %r+e %r+e !"#
1. %he overall mission o& the Oracle 4or(oration 4or(oration is to +se the internet and &ast (rocessing (rocessing servers to 8+ild its o/n net/or*. BC' so&t/are !"# 'nternet ro/ser so&t/are !"# O(erating System so&t/are !"# 11. 4hanges in com(+ting have aected many o& o+r dayEtoEday activities. Are all o& the &ollo/ing
activities e7am(les o& this change? Fes or Go? 'n the (ast yo+ +sed to +se the (hone system to call directory assistance to get a (hone n+m8er. %oday % oday yo+ can can +se yo+r P4 P4 to loo* +( a (hone n+m8er n+m8er online. 'n the (ast yo+ +sed to have to go to the shoe store to 8+y shoes. %oday yo+ can +se yo+r P4 to order shoes online. 'n the (ast yo+ had to +se yo+r P4 to send a (erson an email. %oday yo+ can +se yo+r (hone to send a te7t message Fes F es !"# 1$. Personal Personal com(+ters !P4s# have 8een in e7istence since 1@6. %r+e %r+e or alse? alse? alse !"# 1-. 'n the grid com(+ting model, reso+rces are (ooled together &or eHciency. eHciency. %r+e %r+e or alse? alse? %r+e %r+e !"# 13. Which o& the &ollo/ing are are e7am(les o& eE8+sinesses eE8+sinesses that +se data8ase so&t/are? so&t/are? Online (ersonal sho((ing service !"# Online clothing store !"# Online 8oo* store !"# 16. Which o& the &ollo/ing &ollo/ing are reasons reasons /e create conce(t+al conce(t+al models? models? All o& the a8ove !"#
1;. An 5ntity Ielationshi( Diagram is an e7am(le o& a Physical Model. %r+e or alse? alse !"# 1=. A c+stomi>ed hat sitting on yo+r &riend)s head is an e7am(le o& /hich modelEEthe conce(t+al model or the (hysical model? Physical Model !"# 1. Many reasons e7ist &or creating a conce(t+al model. 4hoose three a((ro(riate reasons &rom the o(tions 8elo/. %hey acc+rately descri8e /hat a (hysical model /ill contain. !"# %hey ca(t+re c+rrent and &+t+re needs. !"# %hey model &+nctional and in&ormational needs. !"# Aan JJJJJJJJJ is a (iece o& in&ormation that in some /ay descri8es an entity. 't is a (ro(erty o& the entity and it 2+anti9es, 2+ali9es, classi9es, or s(eci9es the entity Attri8+te !"# 'n a (hysical data model, an attri8+te is re(resented as aan 4ol+mn !"# 5ntities are +s+ally ver8s. %r+e or alse? alse !"# Which o& the &ollo/ing entities most li*ely contains invalid attri8+tes? 5ntity< 4ar. Attri8+tes< O/ner Occ+(ation, O/ner Salary, S(eed !"# An entity may have /hich o& the &ollo/ing? 'nstances !"# Which o& the &ollo/ing statements a8o+t attri8+tes are tr+e? !4hoose %/o# %hey descri8e, 2+ali&y, 2+anti&y, classi&y, or s(eci&y an entity. !"# %hey have a data ty(e, s+ch as n+m8er or character string. !"# 'n the &ollo/ing statements, 9nd t/o good e7am(les o& 5G%'%F< 'nstance. !4hoose %/o# DA'IF PIODC4%< mil* !"# OOK< iogra(hy o& Mahatma Bandhi !"# Cni2+e 'denti9ers< Disting+ish one instance o& an entity &rom all other instances o& that entity !"# %he /ord 0olatile0 means< 4hanging constantly +nsta8le !"# Some o& the &ollo/ing co+ld 8e attri8+tes o& an 5G%'%F called P5ISOG select the 'G4OII54% attri8+tes &or P5ISOG. !4hoose %/o# reddy Wilson !"# Priya ansenna !"# All o& the &ollo/ing /o+ld 8e instances o& the entity P5ISOG e7ce(t /hich? Male !"# What is the (+r(ose o& a Cni2+e 'denti9er? %o identi&y one +ni2+e instance o& an entity 8y +sing one or more attri8+tes andor relationshi(s. !"# An 5ntity Ielationshi( model is inde(endent o& the hard/are or so&t/are +sed &or im(lementation. %r+e or alse? %r+e !"# %he (+r(ose o& an 5ID is to doc+ment the (ro(osed system and &acilitate disc+ssion and +nderstanding o& the re2+irements ca(t+red 8y the develo(er. %r+e or alse? %r+e !"# A /ell str+ct+red 5ID /ill sho/ only some (arts o& the 9nished data model. Fo+ sho+ld never try to model the entire system in one diagram, no matter ho/ small the diagram might 8e. %r+e or alse? alse !"# Which o& the &ollo/ing statements are tr+e a8o+t 5ID)s? !4hoose %/o#
A (iece o& in&ormation sho+ld only 8e &o+nd in one (lace on an 5ID. !"# Fo+ sho+ld not model deriva8le data. !"# What are the three (ro(erties that every relationshi( sho+ld have? Game, o(tionality, cardinality !"# Ielationshi(s can 8e either mandatory or o(tional. %r+e or alse? %r+e !"# Ielationshi(s al/ays e7ist 8et/een $ entities !or one entity and itsel !"# 'n a 8+siness that sells com(+ters, choose the 8est relationshi( name &rom 4CS%OM5I to '%5M !com(+ter, in this case#. 5ach 4CS%OM5I m+st 8e the 8+yer o& one or more '%5MS. !"# 4onsider the recommended dra/ing conventions &or 5ID)s. 'ndicate /hich o& the &ollo/ing acc+rately descri8es diagramming conventions &or entities and attri8+tes< %he " means that an attri8+te is mandatory or re2+ired the entity name sho+ld 8e sing+lar. !"# 5ntity names are al/ays (l+ral. %r+e or alse? alse !"# Which sym8ol is +sed to sho/ that a (artic+lar attri8+te is o(tional? o !"# On an 5I diagram, /hich sym8ol identi9es an attri8+te as (art o& a +ni2+e identi9er. N !"# 5ntity 8o7es are dra/n as So&t o7es !"# Attri8+tes are /ritten inside the entity to /hich they 8elong. %r+e or alse? %r+e !"# %/o entities can have one or more relationshi(s 8et/een them. %r+e or alse? %r+e !"# A&ter loo*ing at the diagram, choose the sentence 8elo/ that co+ld 8e 0read0 &rom the e7isting relationshi( !even tho+gh yo+)re missing relationshi( la8els# 5ach St+dent may (artici(ate in one or more Activities. !"# When reading a relationshi( 8et/een $ entities, the relationshi( is only read &rom le&t to right. %r+e or alse? alse !"# A Matri7 Diagram /ill hel( yo+ /ith all o& the &ollo/ing e7ce(t< Gaming Ielationshi(s 4reating a Matri7 Diagram is a mandatory ste( in Data Modeling. %r+e or alse? alse !"# Matri7 Diagrams hel( veri&y that yo+ have identi9ed all (ossi8le relationshi(s 8et/een yo+r e7isting entities. %r+e or alse? %r+e !"#