In SQL, which statement is used to change a user's password? MCQ with Answer and Explanation

Question

Share Report Error

In SQL, which statement is used to change a user's password?

A. MODIFY USER

B. CHANGE USER

C. UPDATE USER

D. ALTER USER

Answer: Option D

Solution (By JKSSB Mock Tests)

ALTER USER is used in many DBMS to change user attributes, including password. The exact syntax varies by DBMS.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

In SQL, what does the wildcard '%' match when used with LIKE?

A. Only digits

B. Any single character

C. A specific character

D. Any string of zero or more characters

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
'%' matches any sequence of zero or more characters, while '_' matches a single character.

This question belongs to: Computer Database Management System (DBMS)

Question #2

What is a synonym in database terms?

A. An alias for a table or view

B. A foreign key

C. A data type

D. A type of index

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A synonym is an alternative name for a database object, allowing simpler references.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which level of database architecture defines the entire logical structure of the database, including entities, relationships, and constraints, independent of physical storage?

A. View Level

B. Physical Level

C. Conceptual Level

D. Internal Level

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The Conceptual (or Logical) level describes what data is stored in the entire database and what relationships exist among those data points.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs