OMIS 452 EXAM 1 QUESTIONS AND ANSWERS

OMIS 452 EXAM 1 QUESTIONS AND ANSWERS

Save




Terms in this set (77)


What is Information? Organized Data

Hana
Name 4 different
DB2
relational database
MySQL
management systems
Oracle

What do the following DBMS is Database management system
stand for
DBMS SQL is structured query language
SQL

What is the purpose of a To answer a question or request
query

Given the table Select zid, lname, fname, email, major
student(zid,lname,fname,e from student;
mail,major)


Write a query to display all
columns, all rows of the
table student

,Given the table SELECT zid, fname
student(zid,lname,fname,e FROM student
mail,major,age) WHERE age = 23 or age = 24;


Write a query to display
the columns zid and
fname for all students
whose age is either 23 or
24

Find the names of Select lname, fname from student where lname like
students who have a last 'N%';
name that starts with a N

,GIVEN the following Select classes.cl_id
tables and relationships from classes, courses
where classes.c_num=courses.c_num and
Underlined attributes are course_name='Operating Systems 649';
the primary keys
bolded attributes are
foreign keys


student(zid, fname, lname,
zipcode, email_address,
adv_id)
faculty(fid, fname, lname,
zipcode, email_address)
zip(zipcode, city, state)
courses(c_num,
course_name,
course_description,
credit_hrs)
classes(cl_id, c_num, fid)
grades(zid,cl_id, grade)


with the following
referential integrity
courses(c_num) ->
classes(c_num)
student(zid) -> grades(zid)
classes(cl_id) ->
grades(cl_id)
faculty(fid) -> classes(fid)
faculty(fid) ->
student(adv_id)
zip(zipcode) ->
student(zipcode)
zip(zipcode) ->
faculty(zipcode)


Write a query to display all

, cl_id's of classes that have
a course name of
Operating Systems 649