2 - Class 12 CS and IP Objective Type Revision Class - 2

 DBMS – CLASS 12 CS and IP

1.      The _______ allows you to perform tasks related to data definition.

A).   DDL

B).   DML

C).   TCL

D).   None of These

 

2.      The ________ allows you to perform tasks related to data manipulation.

A).   DDL

B).   DML

C).   TCL

D).   None of These

 

3.      A ________is a text that is not executed.

A).   Statement

B).   Query

C).   Comment

D).   Clause

 

4.      _________ are words that have a special meaning in SQL.

A).   Keywords

B).   Literal

C).   Variable

D).   Table

 

5.      _________command helps to open the database for use.

A).   Use

B).   Open

C).   Distinct

D).   Select

 

6.      ___________command helps to fetch data from relation.

A).   Use

B).   Show

C).   Fetch

D).   Select

 

7.      The ___________ keyword eliminates duplicate rows from the results of a Select statement.

A).   OR

B).   Distinct

C).   Any

D).   All

 

8.      __________command helps to see the structure of a table/relation.

A).   Show

B).   Select

C).   Describe

D).   Order By

 

9.      A relational database consists of a collection of

A).   Tables

B).   Fields

C).   Records

D).   Keys

 

10.   A relational database consists of a collection of

A).   Tuples

B).   Attributes

C).   Relations

D).   Keys

 

11.   A (n) ____ in a table represents a logical relationship among a set of values.

A).   Attribute

B).   Key

C).   Tuple

D).   Entry

 

12.   The term ________ is used to refer to a field in a table.

A).   Attribute

B).   Tuple

C).   Row

D).   Instance

 

13.   A _________ is a property of the entire relation, which ensures through its value that each tuple is unique in a relation.

A).   Rows

B).   Key

C).   Attribute

D).   Fields

 

14.   Which of the following attributes cannot be considered as a choice for primary key?

A).   Id

B).   License Number

C).   Dept_id

D).   Street

 

15.   An attribute in a relation is a foreign key if it is the _________ key in any other relation.

A).   Candidate

B).   Primary

C).   Super

D).   Sub

    CLICK HERE FOR VIDEO EXPLANATION OF THESE QUESTIONS

Answer:

1.      A

2.      B

3.      C

4.      A

5.      A

6.      D

7.      B

8.      C

9.      A

10.   C

11.   C

12.   A

13.   B

14.   D

15.   B

Computer Science Objective Type Quick Revision Classes

 

1. CS Objective Type Quick Revision Classes - 1

2. CS Objective Type Quick Revision Classes - 2

3. CS Objective Type Quick Revision Classes - 3

4. CS Objective Type Quick Revision Classes - 4

5. CS Objective Type Quick Revision Classes - 5

6. CS Objective Type Quick Revision Classes - 6

7. CS Objective Type Quick Revision Classes - 7

8. CS Objective Type Quick Revision Classes - 8

9 CS Objective Type Quick Revision Classes - 9

10. CS Objective Type Quick Revision Classes - 10

1 - Class 12 CS and IP Objective Type Revision Class - 1

 

DBMS – CLASS 12 CS and IP

MCQ:

1.      What will be the order of the data being sorted after the execution of given SQL query?

SELECT * FROM STUDENT ORDER BY ROLL_NO;

A).   Custom Sort

B).   Descending

C).   Ascending

D).   None of These

 

2.      Which values will not be considered by SQL while executing the following statements?

SELECT COUNT () FROM DEPARTMENT;

A).   Numeric Value

B).   Text Value

C).   Null Value

D).   Date Value

NOTE: Query should be

SELECT COUNT (Column_Name) FROM DEPARTMENT;

3.      Which of the following clauses is used to sort the result set?

A).   SORT BY

B).   GROUP BY

C).   ARRANGE BY

D).   ORDER BY

4.      Which clause is used in query to place the condition on groups in MYSQL?

A).   Where

B).   Having

C).   Group By

D).   Both A and B

 

5.      If column “Marks” contains the data set {25, 35, 25, 35, 38}, what will be the output after the execution of the given query?

SELECT MARKS (DISTINCT) FROM STUDENTS;

A).   25, 35, 25, 35, 38

B).   25, 25, 35, 35, 38

C).   25, 35, 38

D).   25, 25, 35, 35

NOTE: Query should be

SELECT DISTINCT MARKS FROM STUDENTS;

6.      If column “Salary” contains the data set {10000, 15000, 25000, 10000, 15000}, what will be the output after the execution of the given query?

SELECT SUM (DISTINCT SALARY) FROM EMPLOYEE;

A).   75000

B).   25000

C).   10000

D).   50000

7.      What SQL statement do we use to display the record of all students whose last name contains 5 letters ending with “A”?

A).   SELECT * FROM STUDENTS WHERE LNAME LIKE ‘_ _ _ _ A’;

B).   SELECT * FROM STUDENTS WHERE LNAME LIKE ‘_ _ _ _ _’;

C).   SELECT * FROM STUDENTS WHERE LNAME LIKE ‘????A’;

D).   SELECT * FROM STUDENTS WHERE LNAME LIKE ‘*A’;

 

8.      What SQL statement do we use to find the total number of records present in the table Product?

A).   SELECT * FROM PRODUCT;

B).   SELECT COUNT (*) FROM PRODUCT;

C).   SELECT FIND (*) FROM PRODUCT;

D).   SELECT SUM () FROM PRODUCT;

 

9.      Which of the following functions is not an aggregate function?

A).   Round()

B).   Sum()

C).   Count()

D).   AVG()

 

10.   Which of the following function is used to find the largest value from the given data in MYSQL?

A).   MAX()

B).   MAXIMUM()

C).   LARGEST()

D).   BIG()

 

        CLICK HERE FOR VIDEO EXPLANATION OF THESE QUESTIONS

Answer:

1.      C

2.      C

3.      D

4.      B

5.      C

6.      D

7.      A

8.      B

9.      A

10.   A

23 May 2021 Computer Science Weekly Test Result

 

S.No.	Name	Marks
1	Karan Kumar	39
2	Ankur Bhardwaj	38
3	Poonam Goyal	37
4	Suruchi Sethi	37
5	Meera Yadav	36
6	Pooja Chaudhary	36
7	Priyanka Arora	36
8	Pritam Kumari	35
9	Salvi Vatsa	35
10	Poonam Yadav782	34
11	Sushmita Singh	34
12	Varsha Choudhary	34
13	Poonam Kashyap	33
14	Priyanka Yadav	33
15	Shweta Sharma	33
16	Ankur Gahlawat	32
17	Deepali Dhankar	32
18	Prabin Pandey	32
19	Ravina Dahiya	32
20	Amrik Goswami	31
21	Monty Sharma	31
22	Neety Yadav	31
23	Amarjeet Singh	30
24	Ankul Singh	30
25	Lalit Gupta	30
26	Niharika Khurana	30
27	Minakshi .	29
28	Rohit Sharma	29
29	Vikas Patel	29
30	Divya ...	28
31	Piyush Kumar	28
32	Preeti Patel	28
33	Priyanka Soni	28
34	Sandeep Kumar SKM	28
35	Shahib	28
36	Suhail Malik	28
37	Sunanda Yadav	28
38	Vijay Kushawah	28
39	Aarti Choudhary	27
40	Gaurav Gahlot	27
41	Kavita Chahar	27
42	Rakesh Dhankhar	27
43	Rohit Singh	27
44	Shivani Singh	27
45	Yamini Choudhary	27
46	Yash Kumar	27
47	Gaurav Mudgal	26
48	Nitin Kumar	26
49	Pinki Rani	26
50	Priya Chaurasia	26
51	Ritu Meena	26
52	Ashish Swami	25
53	Divya Mishra	25
54	Hemnat Kumar Singh	25
55	Poonam Yadav	25
56	Raj Kumar	25
57	Seema Dagar	25
58	Ajay Gupta	24
59	Jeet Meena	24
60	Md Tehran	24
61	Mohd. Junaid	24
62	Nisha Duhan	24
63	Pragya Sharma	24
64	Sachin Kumar	24
65	Sanjeev	24
66	Shehbaz	24
67	Anuradha Bhardwaj	23
68	Ekta Saini	23
69	Hemant Kr Singh	23
70	Monika Yadav.	23
71	Pragati Jakhar	23
72	Chirag Kashyap	22
73	Jyoti Lamba	22
74	Anil Yadav	21
75	Jitender	21
76	Monika Bhabla	21
77	Rajesh Kumar	21
78	Sandeep Bhadu Bhadu	21
79	Sumit Chopra	21
80	Amita Mor Gill	20
81	Jyoti Malik	20
82	Lokesh Kumar	20
83	Manish Kumar Garg	20
84	Mukesh Roy	20
85	Rajiv Ranjan	20
86	Ravi Kumar	20
87	Sanjay	20
88	Chandan	19
89	Manoj Kumar	19
90	Rahul Singhal	19
91	Ranjeet Yadav	19
92	Akshay Sharma	18
93	Ankit Pandey	18
94	Divya Sharma	18
95	Preeti Kataria	18
96	Rohit Kumar	18
97	Sandeep Kumar	18
98	Shailja Yadav	18
99	Yash Sharma	18
100	Annu Maan	17
101	Chanchal Pawar	17
102	Manu Raghav	17
103	Ranjeet Singh	17
104	Sachin Kumar Tehlan	17
105	Shalu Pal	17
106	Vipin Kumar	17
107	Ajay Kumar	16
108	Mohd. Asif	16
109	Sandhya Sharma	16
110	Dilip Gupta	15
111	Himanshu	15
112	Anuj Kashyap	14
113	Gopal Sharma	14
114	Naveen Dhanda	14
115	Nitish Kumar	14
116	Raj Yaduvanshi	14
117	Satyam	14
118	Ajeet Singh	13
119	Anuroop Singh	13
120	Artee Sikarwar	13
121	Sandeep Kumar Cool Sandy	13
122	Vaibhav Chaudhary	13
123	Abhishek Singh	12
124	Arvind Yadav	11
125	Renu Yadav	11
126	Sonam Singh	10
127	Anupama Jena	9
128	Ujjwal Rohit	8
129	Coaching Solution	7
130	Rajendra Prasad Sharma	7
131	Om Meena	6
132	Rashmika Kataria	5