Tag: teamwork

Questions Related to teamwork

we can call the stored procedure in ports like :SP.Identifier(arguments)
softskills teamwork

  1. True

  2. False

Show answer
Correct Option: A

Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? (Choose two.)
softskills teamwork

  1. SUM(start_date)

  2. AVG(start_date)

  3. COUNT(start_date)

  4. AVG(start_date, end_date)

  5. MIN(start_date)

  6. MAXIMUM(start_date)

Show answer
Correct Option: C,E

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?
softskills teamwork

  1. SELECT TO_DATE (SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;

  2. SELECT TO_CHAR (SYSDATE, 'FMDD, DY Month, YYYY') FROM dual;

  3. SELECT TO_CHAR (SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;

  4. SELECT TO_CHAR (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

  5. SELECT TO_DATE (SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;

Show answer
Correct Option: C

Which four are valid Oracle constraint types? (Choose four.)
softskills teamwork

  1. CASCADE

  2. UNIQUE

  3. NONUNIQUE

  4. CHECK

  5. PRIMARY KEY

  6. NOT NULL

Show answer
Correct Option: B,D,E,F

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
softskills teamwork

  1. DROP emp_dept_vu;

  2. DELETE emp_dept_vu;

  3. REMOVE emp_dept_vu;

  4. DROP VIEW emp_dept_vu;

  5. DELETE VIEW emp_dept_vu;

  6. REMOVE VIEW emp_dept_vu;

Show answer
Correct Option: D

Which is an iSQL*Plus command?
softskills teamwork

  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE

  6. RENAME

Show answer
Correct Option: D

Which are DML statements? (Choose all that apply.)
softskills teamwork

  1. COMMIT

  2. MERGE

  3. UPDATE

  4. DELETE

  5. CREATE

  6. DROP

Show answer
Correct Option: B,C,D

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?

softskills teamwork

  1. ALTER TABLE students ADD PRIMARY KEY student_id;

  2. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

  3. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

  4. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY

  5. ALTER TABLE studentsMODIFY CONSTRAINT stud_id_pk PRIMARY KEY

Show answer
Correct Option: D

Which two statements complete a transaction? (Choose two.)
softskills teamwork

  1. DELETE employees;

  2. DESCRIBE employees;

  3. ROLLBACK TO SAVEPOINT C;

  4. GRANT SELECT ON employees TO SCOTT;

  5. ALTER TABLE employeesSET UNUSED COLUMN sal;

  6. SELECT MAX(sal) FROM employees WHERE department_id = 20;

Show answer
Correct Option: D,E

Find the word that is most related to the given place: Aruba
softskills teamwork

  1. Kiev

  2. Sofia

  3. Amharic

  4. Dutche

  5. Serbian

Show answer
Correct Option: D