Which four are valid Oracle constraint types? (Choose four.)
CASCADE
UNIQUE
NONUNIQUE
CHECK
PRIMARY KEY
NOT NULL
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
DROP emp_dept_vu;
DELETE emp_dept_vu;
REMOVE emp_dept_vu;
DROP VIEW emp_dept_vu;
DELETE VIEW emp_dept_vu;
REMOVE VIEW emp_dept_vu;
Which is an iSQL*Plus command?
INSERT
UPDATE
SELECT
DESCRIBE
DELETE
RENAME
Which are DML statements? (Choose all that apply.)
COMMIT
MERGE
CREATE
DROP
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?
ALTER TABLE students ADD PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY
ALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY
Which two statements complete a transaction? (Choose two.)
DELETE employees;
DESCRIBE employees;
ROLLBACK TO SAVEPOINT C;
GRANT SELECT ON employees TO SCOTT;
ALTER TABLE employeesSET UNUSED COLUMN sal;
SELECT MAX(sal) FROM employees WHERE department_id = 20;
plz find next one no. 5,11,21,35,53
101
73
75
85
E, ? , P, T, W, Y, Z Find ?
g
a
k
h
Santa has 32 pairs of red socks and 16 pairs of white socks in his big sack. If Santa picks out 3 socks at random from his sack, he is certain to get a matching pair.
True
False