Tag: softskills

Quizzes (0) Questions (7131)

Questions Related to softskills

Multiple choice softskills teamwork

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

  1. CASCADE

  2. UNIQUE

  3. NONUNIQUE

  4. CHECK

  5. PRIMARY KEY

  6. NOT NULL
Reveal answer Fill a bubble to check yourself
B,D,E,F Correct answer
Explanation

Oracle constraint types are PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, and NOT NULL. Options B, D, E, and F are all valid constraint types that enforce data integrity rules. CASCADE is a referential action, not a constraint type itself. NONUNIQUE is not a standard Oracle constraint.

Multiple choice softskills teamwork

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

  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;
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The DROP VIEW statement removes a view from the schema by deleting its definition from the data dictionary. DELETE removes data from tables, not schema objects. REMOVE is not a valid SQL command. The syntax requires both DROP VIEW and the view name.

Multiple choice softskills teamwork

Which is an iSQL*Plus command?

  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE

  6. RENAME
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DESCRIBE is a command used in iSQL*Plus and SQL*Plus to display the structure of a table. INSERT, UPDATE, SELECT, DELETE, and RENAME are standard SQL (DML/DDL) statements, not specific environment commands like DESCRIBE, SET, or SPOOL.

Multiple choice softskills teamwork

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

  1. COMMIT

  2. MERGE

  3. UPDATE

  4. DELETE

  5. CREATE

  6. DROP
Reveal answer Fill a bubble to check yourself
B,C,D Correct answer
Explanation

DML (Data Manipulation Language) statements manipulate data in tables: MERGE combines insert/update/delete operations, UPDATE modifies existing data, DELETE removes rows. CREATE, DROP, and COMMIT are DDL and TCL commands respectively. COMMIT is transaction control, not data manipulation.

Multiple choice softskills teamwork

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?

  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
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Option D shows correct syntax to add a named primary key constraint to an existing table. The ADD CONSTRAINT clause requires a constraint name (stud_id_pk), the constraint type (PRIMARY KEY), and the column in parentheses. Option A is missing CONSTRAINT keyword and parentheses. Option B is missing the constraint name. Option C has wrong column syntax (no parentheses). Option E uses MODIFY incorrectly.

Multiple choice softskills teamwork

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

  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;
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

In Oracle SQL, Data Definition Language (DDL) and Data Control Language (DCL) statements like ALTER and GRANT issue an implicit COMMIT, thereby completing the current transaction. DELETE and SELECT are DML/Query statements that do not end a transaction, and ROLLBACK TO SAVEPOINT only partially reverts it.

Multiple choice softskills communication

plz find next one no. 5,11,21,35,53

  1. 101

  2. 73

  3. 75

  4. 85
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The pattern of differences is: 11-5=6, 21-11=10, 35-21=14, 53-35=18. These differences increase by 4 each time (6, 10, 14, 18). The next difference should be 18+4=22. Therefore, 53+22=75. This is a second-level arithmetic sequence where the increments themselves form an arithmetic progression.

Multiple choice softskills communication
  • + + * * * * + + + + * * * + + + + ? ? * Find ? ?
    • *
    • +
    • *
    • +
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The pattern alternates between + and , with the group lengths increasing by 1 each time: +++ (3), *** (4), +++ (3), **** (4), +++++ (5), ****** (6). The next group after **** should be 7 + symbols, but the position shown with ? ? follows a + group. Since we alternate symbols and the sequence continues, ? ? represents the next two symbols after the established +++++ pattern.

Multiple choice softskills communication

Santa has 32 pairs of red socks and 16 pairs of white socks in his big sack. If Santa picks out 3 socks at random from his sack, he is certain to get a matching pair.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

With only 2 colors (red and white), drawing 3 socks guarantees at least 2 of the same color by the pigeonhole principle. This is a classic application of the principle that with n items and k categories, selecting n-1+1 items ensures at least one category has 2 items. The number of pairs doesn't matter - only the count of distinct colors.