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

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 more money than the average salary

d) Employees information who earn less money than the minimum employee

e) Employees information who earn more money than the least employee salary

Q3:

In SQL, we can write DDL and DML statements inside stored procedures:

Select one:

a) True

b) False