HARYANA_LEET_SYLLABUS.pdf
1.8 MB
Document from Naveen Munjal
Join "GCC INSTITUTE- LEETCOACHING/JE/DIPLOMA" and get access to study material, live classes, mock tests, guidance and more.
Download Now: http://mbage.on-app.in/app/home/app/home?orgCode=mbage
Download Now: http://mbage.on-app.in/app/home/app/home?orgCode=mbage
CUET COMPUTER SCIENCE 20 MOST IMPORTANT QUESTION:🔥🔥
2. Which of the following SQL statements is used to select distinct subject names from a table "Student"?
Anonymous Quiz
39%
(1) mysql> SELECT distinct subject from Student;
29%
(2) mysql> SELECT subject from Student;
22%
(3) mysql> SELECT new subject from Student;
10%
(4) mysql> SELECT unique subject from Student;
3. Number of tuples in a relation is called:
Anonymous Quiz
31%
(1) Degree of the relation
40%
(2) Cardinality of the relation
17%
(3) Domain of the relation
12%
(4) Foreign Key
4. Which of the following functions are valid functions for string manipulation in SQL?
(A) Itrim() (B) Icase() (C) mid() (D) power()
(A) Itrim() (B) Icase() (C) mid() (D) power()
Anonymous Quiz
11%
(1) (A), (B) and (D) only
57%
(2) (A), (B) and (C) only
19%
(3) (A), (B), (C) and (D)
12%
(4) (B), (C) and (D) only
9. The overall design of the database is called:
Anonymous Quiz
13%
(1) Application Program
43%
(2) Data Manipulation Language (DML)
40%
(3) Schema
3%
(4) Relational Algebra
10. The result of which join is equivalent to the Cartesian product?
Anonymous Quiz
23%
(1) Natural Join
50%
(2) Cross Join
22%
(3) Inner Join
5%
(4) Outer Join
11. A network in which every computer is capable of playing the role of a client, or a server, or both, at the same time is called
Anonymous Quiz
56%
(1) Peer-to-Peer Network
18%
(2) Local Area Network
15%
(3) Dedicated Server Network
11%
(4) Wide Area Network
12. In ____ topology, each device is connected to every other device on the network through a dedicated point-to-point link.
Anonymous Quiz
36%
(1) Ring
17%
(2) Tree
16%
(3) Bus
31%
(4) Mesh
👍2