Examine the description of the EMPLOYEES table: Name Null? Type EMP_ID NOT NULL NUMBER EMPNAME VA ...
Examine the description of the EMPLOYEES table: Name Null? Type EMP_ID NOT NULL NUMBER EMPNAME VA ...
Which three statements are true about GLOBAL TEMPORARY TABLES? A) GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table. ...
Which three statements are true about performing Data Manipulation Language (DML) operations on a view In an Oracle Database? A) Insert statements can always be done on a table through a view. B) The ...
Which two are true about the WITH GRANT OPTION clause? A) The grantee can grant the object privilege to any user in the database, with of without including this option, B) The grantee must have the GR ...
Which three statements are true about the Oracle join and ANSI Join syntax? A) The Oracle join syntax only supports right outer joins, B) The Oracle join syntax supports creation of a Cartesian produc ...
Examine the description of the PRODUCT_STATUS table: Name Null? Type PROD_ID NOT NULL NUMBER(2) STATUS NOT NULL ...
Examine these SQL statements which execute successfully: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, ename VARCHAR ...
You execute this command: TRUNCATE TABIE depts; Which two are true? A) A ROLLBACK statement can be used to retrieve the deleted data. B) It drops any triggers defined on the table. C) It retains the i ...