Tag: softskills

Questions Related to softskills

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

AI Explanation

To answer this question, you need to understand the concept of Oracle constraints. Oracle provides various types of constraints to enforce rules on the data stored in a table.

Let's go through each option to understand why it is correct or incorrect:

Option A) CASCADE - This option is incorrect because CASCADE is not a valid Oracle constraint type. CASCADE is used with foreign key constraints to define the action to be taken when a referenced row is deleted or updated.

Option B) UNIQUE - This option is correct. UNIQUE is a valid Oracle constraint type that ensures that all values in a column or set of columns are unique.

Option C) NONUNIQUE - This option is incorrect because NONUNIQUE is not a valid Oracle constraint type. The opposite of UNIQUE constraint is actually the default behavior, where duplicate values are allowed.

Option D) CHECK - This option is correct. CHECK is a valid Oracle constraint type that allows you to specify a condition that must be satisfied for the data in a column.

Option E) PRIMARY KEY - This option is correct. PRIMARY KEY is a valid Oracle constraint type that uniquely identifies each row in a table.

Option F) NOT NULL - This option is correct. NOT NULL is a valid Oracle constraint type that ensures that a column cannot contain any NULL values.

The correct answer is B, D, E, F. These options are correct because they represent valid Oracle constraint types.

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

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

  1. 101

  2. 73

  3. 75

  4. 85

Show answer
Correct Option: C
  • + + * * * * + + + + * * * + + + + ? ? * Find ? ?
softskills communication
    • *
    • +
    • *
    • +
Show answer
Correct Option: A

E, ? , P, T, W, Y, Z Find ?
softskills communication

  1. g

  2. a

  3. k

  4. h

Show answer
Correct Option: C

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.
softskills communication

  1. True

  2. False

Show answer
Correct Option: A