CBSE Class-12 Exam 2020 : Question Paper (Database Management Applications)

• Subject :- Database Management Applications
• Class : XII
• Year : 2020

SECTION A

1. How can you insert a new row into the ‘‘Student’’ table ? 1
(A) INSERT (1,‘Gulshan’) INTO Student;
(B) INSERT VALUES (1,‘Gulshan’) INTO Student;
(C) INSERT INTO Student VALUES (1,‘Gulshan’);
(D) ADD ROW Student VALUES (1,‘Gulshan’);

2. Which of the following statements is true about JAVA ? 1
(A) Relational Database Management System
(B) Machine Level Language
(C) Platform Dependent
(D) Supports Objects and Classes

3. Which one of the following is used as a comparison operator in SQL ? 1
(A) Double equal sign (= =)
(B) Like
(C) Between
(D) Single equal sign (=)

4. DML provides commands to 1
(A) Change the structure of Tables.
(B) Insert, Update or Delete records and values.
(C) Deal with the rights, permissions and other controls of the database system.
(D) All of the above

5. The most common protocol that is used to access any web application on the Internet is 1
(A) Gopher
(B) FTP
(C) HTTP
(D) WAIS

6. Which of the following is/are the advantage(s) associated with the B2B e-commerce ? 1
(A) Shorter cycle time
(B) Reduction in cost
(C) Reaches wider audiences
(D) All of the above

7. Which operator is used in SQL to compare a value with a specific list of values ? 1
(A) BETWEEN
(B) ANY
(C) ALL
(D) IN

8. Which of the following expressions in SQL should Mr. X write to display all records from table STUDENT where marks column is empty ? 1
(A) SELECT * FROM STUDENT WHERE MARKS EMPTY;
(B) SELECT * FROM STUDENT WHERE MARKS IS NULL;
(C) SELECT * FROM STUDENT WHERE NULL (MARKS);
(D) SELECT * FROM STUDENT WHERE MARKS = NULL;

9. Consider x = 1, which of the following are valid Java statements for changing the value of x to 0 ? 1
I. x--;
II. x = x - 1;
III. x - = 1;
IV. x = -1;
(A) I, II & III
(B) I & IV
(C) II & IV
(D) All of the above 

Click Here To Download Full Paper

<< Go Back To Main Page

Courtesy: CBSE