Chapter 5, Problem 6MC

Which of the following statements is correct? A table can contain a maximum of only one column marked as unused. You can delete a table by removing all columns in the table. Using the SET UNUSED clause allows you to free up storage space used by a column. None of the above statements are correct.

Assume you have these table  CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID) references MemberOf(ClubID));   Write in SQL queries to populate the above tables by inserting minimum 4…

Which of the following commands creates a new table containing two columns?a. CREATE TABLE newname (coll DATE, col2 VARCHAR2);b. CREATE TABLE newname AS (SELECT title, retail, cost FROM books);c. CREATE TABLEnewname (coll, col2);d. CREATE TABLE newname (coll DATE DEFAULT SYSDATE, col2 VARCHAR2 (1));

Which of the following commands removes all data from a table but leaves the table’s structure intact? (refer to the tables in the JustLee Books databasea. ALTER TABLE secustomerorders DROP UNUSED COLUMNS;b. TRUNCATE TABLE secustomerorders;c. DELETE TABLE secustomerorders;d. DROP TABLE secustomerorders;

Which of the following commands drops any columns marked as unused from the SECUSTOMERORDERS table?a. DROP COLUMN FROM secustomerorders WHERE column_status =       UNUSED;b. ALTER TABLE secustomerorders DROP UNUSED COLUMNS;c. ALTER TABLE secustomerorders DROP (unused);d. DROP UNUSED COLUMNS;

Which of the following statement is true?a) DELETE does not free the space containing the table and TRUNCATE free the space containing the tableb) Both DELETE and TRUNCATE free the space containing the tablec) Both DELETE and TRUNCATE does not free the space containing the tabled) DELETE free the space containing the table and TRUNCATE does not free the space containing the table

Database  Q1: Which one of the following INSERT statements will successfully insert a single row? The following table has been created: CREATE TABLE student_table ( stud_id NUMBER (6), last_name VARCHAR2 (20), first_name VARCHAR2 (20), lunch_num NUMBER (4) ; a) INSERT VALUES INTO student_table (143354, ‘Roberts’, ‘Cameron’, 6543); b) INSERT INTO student_table COLMUNS (stud_id, last_name, lunch_num) VALUES (143352, ‘Roberts’, 5543, ‘Cameron’); c) INSERT TO student_table (stud_id, lunch_num, first_name, last_name) VALUES (143352, 6543, ‘Cameron’, ‘Roberts’); d) INSERT INTO student_table VALUES (143354, ‘Roberts’, ‘Cameron’, 6543); Q2: What does the following SQL statement display: SELECT EMP_ID, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY > (SELECT MIN (E. SALARY) FROM EMPLOYEES E) ORDER BY SALARY DESC; a) Employees information who earn less money than the maximum salary b) Employees information who earn more money than the highest employee salary c) Employees information who earn…

Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)

Which of the following commands creates a new table containing two columns? CREATE TABLE newname (coll DATE, col2 VARCHAR2); CREATE TABLE newname AS (SELECT title, retail, cost FROM books); CREATE TABLE newname (col1, co12); CREATE TABLE newname (col1 DATE DEFAULT SYSDATE, co12 VARCHAR2 (1));