Class 12 Computer Science DBMS Concept Notes and Important Questions
Learn
Loading notes…
Notes for Class 12 DBMS Concept (Computer Science) are shown above.
Practice
Important Questions
Which one of the following given statement correct?
Select * from emp where copid = 103;
Select from emp where copid = 103;
Select copid where emp = 103 from emp;
Select copid where copid = 103 and table = emp;
A company needs to modify an existing table by adding a new column for employee email addresses. For this, which SQL command should be used?
CREATE
ALTER
SELECT
UPDATE
Which of the following is the purpose of using primary key in database?
To uniquely identify a record
To store duplicate record
To backup data
To enhance database size
Which database system normally offers better performance for geographically dispersed users?
Centralized database system
Distributed database system
NoSQL database system
Relational database system
Which SQL statement will show the names and heights of all basketball players taller than 6 feet?
SELECT name FROM Player WHERE height > 6;
SELECT name FROM Player WHERE height >= 6;
SELECT name, height FROM Player WHERE height > 6;
SELECT name, height FROM Player WHERE height < 6;
Write any three differences between DDL and DML. Give examples of each.
16 more questions locked
Upgrade to a paid plan to view all important questions
Exam
Past Question Analysis
Historical exam-pattern data from past NEB question papers — not a prediction of future questions.
13
Question Items
9
Total Marks
5
Papers Appeared In
| Year | Question Items | Marks |
|---|---|---|
| 2083 | 3 | 7 |
| 2082 | 3 | — |
| 2081 | 3 | — |
| 2080-supp | 2 | — |
| 2079 | 2 | 2 |
Also appears in 4 model questions (not counted above — model sets aren't actual NEB exam history).
DBMS Concept introduces the fundamentals of database management and how data is organized, stored and managed efficiently. Students learn about database models, DBMS advantages, relational databases, keys, relationships and normalization. The chapter also covers SQL commands, database security, backup and recovery, and different types of database systems.
This page covers DBMS Concept, chapter 1 of 7 in the Class 12 Computer Science syllabus set by the National Examination Board (NEB). 20 important questions for this chapter are available, each with a full solution.
For numerical and derivation-based chapters like this one, working through past NEB questions is usually more useful than re-reading notes alone — try solving each important question above before checking the solution, then compare your working step by step.