Which three actions can you perform by using the ALTER TABLE command?

• A.Restrict all DML statements on a table.
• B.Drop all columns simultaneously from a table.
• C.Lock a set of rows in a table CE Rename a table.
• D.Drop pseudo columns from a table.
• E.Rename a table
• F.Enable or disable constraints on a table.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about aggregate functions?

• A.Aggregate functions can be nested to any number of levels.
• B.Aggregate functions can be used in any clause of a SELECT statement.
• C.The MAX and MIN functions can be used on columns with character data types.
• D.The AVG function implicitly converts NULLS to zero.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about current_timestamp?

• A.It always returns the same value as SYSTIMESTAMP.
• B.It returns the same date as CURRENT_date.
• C.The date Is In the time zone of DBTIMEZONE.
• D.The time is In the time zone of DBTIMEZONE.
• E.The value varies depending on the setting of SESSIONTIMEZONE.
• F.It returns a value of data type timestamp.

Comment: *

Name: *

Email: *

Verification: *

View the exhibit for the structure of the STUDENTand FACULTYtables.
STUDENT
Name Null? Type
------------------ ------------------- -------------
STUDENT_ID NOT NULL NUMBER(2)
STUDENT_NAME VARCHAR2(20)
FACULTY_ID VARCHAR2(2)
LOCATION_ID NUMBER(2)
FACULTY
Name Null? Type
- ----------------- ------------------- -------------
FACULTY_ID NOT NULL NUMBER(2)
FACULTY_NAME VARCHAR2(20)
LOCATION_ID NUMBER(2)
You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:
Statement 1
SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;
Statement 2
SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;
Which statement is true regarding the outcome?

• A.Only statement 1 executes successfully and gives the required result.
• B.Only statement 2 executes successfully and gives the required result.
• C.Both statements 1 and 2 execute successfully and give different results.
• D.Both statements 1 and 2 execute successfully and give the same required result.

Comment: *

Name: *

Email: *

Verification: *

View the Exhibit and examine the description of the EMPLOYEEStable.

You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission.
Which SQL statement would you execute to get the desired output?
SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct,

• A.salary,salary+commission_pct))"Total"
  FROM EMPLOYEES;
  SELECT first_name, salary, salary*12+salary*commission_pct "Total"
• B.FROM EMPLOYEES;
  SELECT first_name, salary (salary + NVL (commission_pct, 0)*salary)*12 "Total"
• C.FROM EMPLOYEES;
  SELECT first_name, salary, salary*12 + NVL(salary,0)*commission_pct, "Total"
• D.FROM EMPLOYEES;

Comment: *

Name: *

Email: *

Verification: *