Evaluate the following SQL statements:DELETE FROM sales;There are no other uncommitted transactions on the SALES table.Which statement is true about the DELETE statement?
Examine the structure of the EMP_DEPT_VU view:Which SQL statement produces an error?
Examine the structure of the EMPLOYEES table:You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below:Which INSERT statement meets the above requirements?
You own a table called EMPLOYEES with this table structure:EMPLOYEE_ID NUMBER Primary Key -FIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)HIRE_DATE DATE -What happens when you execute this DELETE statement?DELETE employees;
Which two statements are true regarding constraints? (Choose two.)
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)
