Home

Designed for school students & undergraduate entrance aspirants preparing for board exams, NEET, JEE and more.

JEE (Mains & Adv)NEET (UG)CBSE BoardISC BoardUP BoardCUET

Built for graduates & professionals targeting competitive exams — UPSC, CAT, GMAT, GRE, IELTS, banking & more.

GREGMATCATUPSCIBPSIELTSTOEFLSATACT

Core school & undergraduate subjects aligned with CBSE, ISC, UP Board, NEET and JEE syllabi.

PhysicsChemistryMathematicsBiologyAccountancyBusiness StudiesEconomicsEnglish CoreEnglish (ISC)Computer ScienceInformatics Practices

Subjects tailored for UPSC, CAT, GRE, GMAT, IELTS and banking competitive exams.

EnglishQuantitative AptitudeGeneral StudiesCurrent AffairsLogical ReasoningVerbal ReasoningData InterpretationIntegrated ReasoningComputer KnowledgeEssay Writing
PracticeMock TestsResources
Log InSign Up
Back to Categories
Question 1 of 50

Informatics Practices > Database Query using SQL > Querying And Grouping

Progress: 0%
Success Rate: 0%
Question 1

(i) Write the SQL statement to create a table,

Customer
with the following specifications: Table: Customer Column Name:
CID
, Data Type:
Int
, Key:
Primary Key
Column Name:
FName
, Data Type:
Varchar (20)
Column Name:
LName
, Data Type:
Varchar (20)
Column Name:
Age
, Data Type:
Int

(ii) Write the SQL query to display all records in descending order of

LName
from the Table
Customer
.

0 of 50 answered

Current Session

Questions Answered0
Correct Answers0
Session Success Rate0%
Ready to Start! 🚀

Community Stats

Active Learners30
Questions Attempted601
Community Success Rate70%

Track Your Progress

Sign up to save your practice progress and get personalized insights across all topics.

Sign Up FreeSign In

Quick Actions

More Informatics-practices QuestionsBrowse All Subjects

We Value Your Privacy

Edvaya uses cookies to enhance your learning experience, analyze platform usage, and provide personalized content. You can customize your preferences or accept all cookies to continue.

By continuing, you agree to our Cookie Policy and Privacy Policy