Home » MCQs » Oracle MCQs

Oracle Change Password, Check Constraints, Comments, and Primary Key MCQs

Oracle Change Password, Check Constraints, Comments, and Primary Key MCQs: This section contains multiple-choice questions and answers on Change Password, Check Constraints, Comments, and Primary Key in Oracle.
Submitted by Anushree Goswami, on June 29, 2022

1. Using Oracle's ____ command, we can change our passwords.

1. Alter
2. Change
3. New
4. Remove

Answer: A) Alter

Explanation:

Using Oracle's alter command, we can change our passwords.

Discuss this Question

---

2. What is the syntax to Change Password?

1. ALTER USER user_name IDENTIFIED BY old_password;
2. ALTER user_name IDENTIFIED BY new_password;
3. ALTER USER user_name new_password;
4. ALTER USER user_name IDENTIFIED BY new_password;

Answer: D) ALTER USER user_name IDENTIFIED BY new_password;

Explanation:

The syntax to Change Password is:

ALTER USER user_name IDENTIFIED BY new_password;

Discuss this Question

---

3. What are the parameters in Change Password?

1. User_name
2. New_password
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The parameters in Change Password are, "user_name" and "new_password".

Discuss this Question

---

4. Each ____ of a table has a specific condition for Check Constraints in Oracle.

1. Column
2. Row
3. Field
4. Record

Answer: B) Row

Explanation:

Each row of a table has a specific condition for Check Constraints in Oracle.

Discuss this Question

---

5. What are the parameters in the syntax to check the constraints using CREATE TABLE statement?

1. Table_name
2. Constraint_name
3. Column_name
4. All of the above

Answer: D) All of the above

Explanation:

The parameters in the syntax to check the constraints using CREATE TABLE statement are table_name, constraint_name and column_name.

Discuss this Question

---

6. It is possible to post ____ comments.

1. Single-line
2. Multi-line
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

It is possible to post single-line comments as well as multi-line comments.

Discuss this Question

---

7. What is the syntax to comment on a single line?

1. -- comment
2. /* comment */
3. /* comment
4. comment */

Answer: A) -- comment

Explanation:

The syntax to comment on a single line is "-- comment".

Discuss this Question

---

8. What is the syntax to comment on multi lines?

1. /* comment */
2. /* comment
3. comment */
4. */ comment /*

Answer: A) /* comment */

Explanation:

The syntax to comment on multi lines is "/* comment */".

Discuss this Question

---

9. ____ keys in Oracle are columns with unique values, and they cannot contain nulls.

1. Primary
2. Foreign
3. Alternate
4. Composite

Answer: A) Primary

Explanation:

Primary keys in Oracle are columns with unique values, and they cannot contain nulls.

Discuss this Question

---

10. ____ primary key is allowed in a table.

1. One
2. Two
3. Three
4. Four

Answer: A) One

Explanation:

One primary key is allowed in a table.

Discuss this Question

---

11. What is/are the parameter(s) in the syntax of using primary key in CREATE TABLE statement?

1. Table_name
2. Constraint_name
3. Column_1, column_2,...,column_n
4. All of the above

Answer: D) All of the above

Explanation:

The parameter in the syntax of using primary key in CREATE TABLE statement is -

1. Table_name
2. Constraint_name
3. Column_1, column_2,...,column_n

Discuss this Question

---

12. What is/are the clause(s) in the syntax of using primary key in ALTER TABLE statement?

1. ALTER TABLE
2. ADD CONSTRAINT
3. PRIMARY KEY
4. All of the above

Answer: D) All of the above

Explanation:

The clauses in the syntax of using primary key in ALTER TABLE statement are -

1. ALTER TABLE
2. ADD CONSTRAINT
3. PRIMARY KEY

Discuss this Question

---

13. Syntax to Drop Primary Key is -

1. ALTER TABLE DROP CONSTRAINT constraint_name;
2. ALTER TABLE table_name DROP CONSTRAINT;
3. ALTER TABLE table_name DROP CONSTRAINT constraint_name;
4. ALTER TABLE DROP CONSTRAINT;

Answer: C) ALTER TABLE table_name DROP CONSTRAINT constraint_name;

Explanation:

Syntax to Drop Primary Key is:

ALTER TABLE table_name DROP CONSTRAINT constraint_name;

Discuss this Question

---

14. Syntax to Disable Primary Key is -

1. ALTER TABLE DISABLE CONSTRAINT constraint_name;
2. ALTER TABLE table_name DISABLE CONSTRAINT;
3. ALTER TABLE DISABLE CONSTRAINT;
4. ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

Answer: D) ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

Explanation:

Syntax to Disable Primary Key is

ALTER TABLE table_name DISABLE CONSTRAINT constraint_name;

Discuss this Question

---

15. Syntax to Enable Primary Key is -

1. ALTER TABLE ENABLE CONSTRAINT constraint_name;
2. ALTER TABLE table_name ENABLE CONSTRAINT;
3. ALTER TABLE table_name constraint_name;
4. ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

Answer: D) ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

Explanation:

Syntax to Enable Primary Key is:

ALTER TABLE table_name ENABLE CONSTRAINT constraint_name;

Discuss this Question

---

---