Home / Engineering / Database Management System (DBMS) / Question

M

Mr. Dubey • 51.43K Points
Coach 

Q.) With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

(A) SELECT * FROM Persons SORT BY ‘FirstName’ DESC
(B) SELECT * FROM Persons ORDER FirstName DESC
(C) SELECT * FROM Persons SORT ‘FirstName’ DESC
(D) SELECT * FROM Persons ORDER BY FirstName DESC
Correct answer : Option (D) - SELECT * FROM Persons ORDER BY FirstName DESC

Share

Previous

Next

Discusssion

Login to discuss.

Related MCQs on Database Management System (DBMS)

Q. A relation is in if an attribute of a composite key is dependent on an attribute of other composite key.

Q. Docker can simplify both, and

Q. Which of the following database objects asks a question of information in a database and then displays the result?

Q. A semaphore is a shared integer variable .

Q. IMS stands for ___________

Q. The maximum number of nodes on level i of a binary tree is ___________.

Q. the truth table for exclusive disjunction will be

Q. ___________ classes are used to create the interface that the user sees and interacts with as the software is used.

Q. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

Q. Which of the following are decidable? I. Whether the intersection of two regular languages is infinite II. Whether a given context-free language is regular III. Whether two push-down automata accept the same language IV. Whether a given grammar is context-free