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
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
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
