Which three actions can you perform only with system privileges? (Choose three.)

• A.Access flat files via a database, which are stored in an operating system directory.
• B.Log in to a database.
• C.Query any table in a database.
• D.Execute a procedure in another schema.
• E.Truncate a table in another schema.
• F.Use the WITH GRANT OPTIONclause.

Comment: *

Name: *

Email: *

Verification: *

Which statement adds a column called SALARYto the EMPLOYEEStable having 100 rows, which cannot contain null?
ALTER TABLE EMPLOYEES

• A.ADD SALARY NUMBER(8,2) DEFAULT NOT NULL;
  ALTER TABLE EMPLOYEES
• B.ADD SALARY NUMBER(8,2) DEFAULT 0 NOT NULL;
  ALTER TABLE EMPLOYEES
• C.ADD SALARY NUMBER(8,2) NOT NULL;
• D.ADD SALARY NUMBER(8,2) DEFAULT CONSTRAINT p_nn NOT NULL;
  ALTER TABLE EMPLOYEES

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?

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding indexes?

• A.A SELECT statement can access one or more indices without accessing any tables.
• B.A table belonging to one user can have an index that belongs to a different user,
• C.When a table is dropped and is moved to the RECYCLE BIN, all Indexes built on that table are permanently dropped.
• D.A UNIQUE index can be altered to be non-unique.
• E.An update to a table can result in no updates to any of the table's indexes.
• F.An update to a table can result in updates to any or all of the table's indexes.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTM ENT_ID?

• A.UPDATE employees e1
  SET salary =(SELECT e2. salary + MIN(e2.salary)
  FROM employees e2
  WHERE e1.department_ id = e2. department_id GROUP BY e2. department_id) ;
• B.UPDATE employees e1
  SET salary = salary +
  (SELECT MIN(e1. salary)
  FROM employees e2
  WHERE e1.department_id = e2 .department_id);
• C.UPDATE employees e1
  SET salary = salary+(SELECT MIN (salary)
  FROM employees e2) ;
• D.UPDATE employees e1
  SET salary=
  (SELECT e1.salary + MIN(e2.salary)
  FROM employees e2
  WHERE e1. department_ id = e2.department_id);

Comment: *

Name: *

Email: *

Verification: *