You execute this command:
TRUNCATE TABIE depts;
Which two are true?

• A.It retains the indexes defined on the table.
• B.A FLASHBACK TABLE statement can be used to retrieve the deleted data.
• C.It always retains the space used by the removed rows.
• D.It retains the integrity constraints defined on the table,
• E.A ROLLBACK statement can be used to retrieve the deleted data.
• F.It drops any triggers defined on the table.

Comment: *

Name: *

Email: *

Verification: *

Examine these statements:
CREATE TABLE dept (
deptno NUMBER PRIMARY KEY,
diname VARCHAR2(10) ,
mgr NUMBER ,
CONSTRAINT dept_fkey FOREIGN KEY(mgr) REFERENCES emp (empno));
CREATE TABLE emp (
Empno NUMBER PRIMARY KEY,
Ename VARCHAR2 (10) ,
deptno NUMBER,
CONSTRAINT emp_fkey FOREIGN KEY (deptno) REFERENCES dept (deptno) DISABLE);
ALTER TABLE emp MODIFY CONSTRAINT emp_fkey ENABLE;
Which two are true?

• A.Both foreign key constraint definitions must be removed from the CREATE TABLE statements, andbe added with ALTER TABLE statements once both tables are created, for the two CREATE TABLEstatements to
  execute successfully in the order shown.
• B.All three statements execute successfully in the order shown
• C.The DEFT FKEY constraint definition must be removed from the CREATE TABLE DEF statement.and be added with an AITER TABLE statement once both tables are created, for the two CREATE TABLE statements
  to execute successfully in the order shown.
• D.The Deptno column in the emp table will be able to contain nulls values.
• E.The CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all threestatements to execute successfully.
• F.The MGR column in the DEPT table will not be able to contain NULL values.

Comment: *

Name: *

Email: *

Verification: *

Examine the data in the CUSTOMERS table:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.)

• A.JOIN
• B.LEFT OUTER JOIN
• C.FULL OUTER JOIN
• D.NATURAL JOIN
• E.RIGHT OUTER JOIN

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement? (Choose two.)

• A.listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
• B.finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
• C.listing of customers who do not have a credit limit and were born before 1980
• D.finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
• E.finding the number of customers, in each city, whose marital status is 'married'.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the data in the EMPLOYEES table.
Exhibit

You want to generate a report showing the total compensation paid to each employee to date.
You issue the following query:

What is the outcome?

• A.It executes successfully but does not give the correct output.
• B.It generates an error because the concatenation operator can be used to combine only two items.
• C.It generates an error because the usage of the ROUNDfunction in the expression is not valid.
• D.It generates an error because the alias is not valid.
• E.IT executes successfully and gives the correct output.

Comment: *

Name: *

Email: *

Verification: *