Which clause is used to assign a temporary alias name to a column or table in an SQL statement for better readability? MCQ with Answer and Explanation

Question

Share Report Error

Which clause is used to assign a temporary alias name to a column or table in an SQL statement for better readability?

A. WITH

B. LIKE

C. USING

D. AS

Answer: Option D

Solution (By JKSSB Mock Tests)

The AS keyword is used to assign a temporary alias name to an expression, column, or table within an SQL statement query execution context.

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

Share Report

Which SQL component is used to specify a fallback default value for a column when no value is provided during an insert operation?

A. UNIQUE

B. NOT NULL

C. DEFAULT

D. CHECK

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The DEFAULT constraint assigns a predefined default value to a column when an INSERT statement does not explicitly provide a value for that column.

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

Question #2

Share Report

Which of the following is not a type of database model?

A. Hierarchical

B. Object-oriented

C. Flat-file

D. Network

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.

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