{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Midterm 1 Pg 1 - Foada khan[Mayan tiara“,1 I a 7 3 5 I o...

Info icon This preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Foada khan/[Mayan tiara“; / ,1 I, / a, 7 3' 5 I - o » r) ' /‘7/‘/ 03/13/2008 midi-508 REDIDo Quezglé; (7/0 Midterm I CS 514 Spring 2008 On multiple choice questions, give the BEST answer . / 57 moral“ 4L 1. The author of the required text, Oracle 9i Programming, is 0’) " I; ' 2. cfedb is an example of . t 3 (a) an RDBMS (b) a schema (c) a catalog (d) an instance Q£l_ill§_£§£?C£1. 3. For user moeberg to change his password to ispy, he would enter the line . . a p . cum USU: moebu Joli/2 Md 6 4. To return from SQL*Plus to unix, at the prompt SQL) -4 you would type iM)$t ato escape to unix temporarily, and then type “D to return to SQL*P1us 5. when selecting many rows from a table, the column headings are by default printed annoyingly often. This can be fixed by the SQL*P1us pseudo-op J ‘ +64; "'6 it] >v-..' 711) J h!) J t! , C! ,Ji 6. There is a special Oracle table available to gv%¥§¢%%hema for HP) ' ’ determining J easily the results of simple operations. Complete the following ”; statement with the name of that table. ' . = SELECT 7a * 119 FROM dual ' 7. Write good code to make deptno a foreign key where empbb02 is the child and deptbb02 is the parent. Give a good constraint name using the naming , w? 712 convention given in class. (“fit AV" was 31%;; empbboz ADD {‘OI‘PSTPLSNTAFOREIa-N IcE‘MQFWOie firpinm (K) :25 FIFENM 5‘ caprbbbl [ohpz‘noj‘j 8. Give a select statement that will display every hiredate in the form May 13, 2008. Title the column header: Date Hired W 2.50ch TO-CHAR( HIREDATE ,‘Mnnth ddfi/Yyy') As may ”We," 4’ fxom €mpb/a02; " 9. Define 'candidate key’, carefully; 337"}?5, Wa.m~n;ma1 w a; "(he my; a)” .0401”; a. «an/gm a? 4 pg ,7. ranoédaie KL? 10. (a) What kind of 'langauge’ is described by the phrase ZGL? , MSW/746A] fanguapfe “/ (b) explain what a 'referential integrity violation’ refers to, giving an example that works for our tables AFTER Lab2 was completed. Rifwma/ in 9.455, vj‘oiafion zidw 7:0 ,Z/u via/awn 3;! 4Wfi'10,22}_ W5" 01L F0 ' n kw gig, 7 f n 3512 Write SQL to doubl sala of every'employee who is in the infield department 0 l garter gangsta A: CMM~/”n”mm €mpbe2 aha: Cflpfrfia .: ("Zak-J» ' 'aflzjzw 7§pm d2 tbbDZ (4)604 dname -_—_ 'Fn ' 0/! /’ /) M , 12. Write SQL to remove all the coaches from the team. 4.2 dunk 74m .em/pbboz com/,1 p0£:.wacb,; ...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern