· True
You can rename a table with the RENAME or the ALTER TABLE command.
· True
A parent table referenced by a child table may not be dropped.
· True
The following is the CREATE TABLE statement of a table named EMP and the CREATE VIEW statement of the MY_EMP view. Determine the salary for the new employee Smith based on the INSERT statement issued.
CREATE TABLE emp (emp_id NUMBER NOT NULL,last_nmVARCHAR2(50),salary NUMBER(10,2) DEFAULT 0 NOT NULL) CREATE OR REPLACE VIEW my_emp ASSELECT emp_id, last_nm FROM emp INSERT INTO my_emp (emp_id, last_nm)VALUES (110, 'SMITH')Smith's salary is 0. 88. The following index was created on the STUDENT table:
CREATE INDEX stud_reg_dt ON student(registration_date)
Determine if the query takes advantage of the index.
SELECT student_id FROM student WHERE registration_date>= TRUNC(SYSDATE-1) 89. The following index was created.
CREATE INDEX crse_cost_i ON course (cost)Determine which of the following queries takes advantage of the index. SELECT cost FROM course WHERE cost >= 11.2304
A RDBMS groups data in a logical manner into tables and manages the access to the tables.
· Yes
A table always has columns and rows.
· No (A table can exist without rows but must have at least one column.)
A column in a table defined as NOT NULL is a primary or foreign key.
· No
