Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1- Which statement will erase all records in Registration table? a. Drop table Registration b. Delete from Registration c. Delete * from Registration d. B

1- Which statement will erase all records in Registration table?

a. Drop table Registration

b. Delete from Registration

c. Delete * from Registration

d. B and C.

2- To create table semester with a primary Key :

a. Create table Semester ( Semester_id number(5) , Start_date date, End_date date , Description varchar2(50));

b. Create table Semester ( Semester_id number(5) , Start_date date, End_date date , Description varchar2(50), Semester_id primary key );

c. Create table Semester ( Semester_id number(5) , Start_date date, End_date date , Description varchar2(50),primary key Semester_id);

d. Create table Semester ( Semester_id primary key number(5) , Start_date date, End_date date , Description varchar2(50), constraint Semester_pk primary key (Semester_id));

3- The query used to add values to the table courses is:

a. insert into courses values(8444,database,3,4);

b. insert into courses values(8444,'database',4);

c. insert into courses values(8444,'database',3,4);

d. insert into courses values('database',8444,3,4);

4- Based on the data inserted to university database, which of the following is a valid update statement:

a. Update majors set major_id=128 where major_name like c%;

b. Update majors set faculty=Engineering where major_name like %engineering%;

c. Update majors set major_name=law where major_id=124;

d. Update majors set major_name=law and faculty=law where major_name like c%;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Principles Programming And Performance

Authors: Patrick O'Neil, Elizabeth O'Neil

2nd Edition

1558605800, 978-1558605800

More Books

Students also viewed these Databases questions

Question

b. A decline in the number of firms in the tire industry.

Answered: 1 week ago

Question

8-5 How will MIS help my career?

Answered: 1 week ago