3. Which function is used to count the number of values in the specified column ignoring null values?
Anonymous Quiz
41%
1. count(*)
34%
2. count(column)
18%
3. count(column)
7%
4. sum(column)
4. ____ is a unique address that can be used to uniquely identify each node in a network.
Anonymous Quiz
26%
1. MAC address
69%
2. IP address
4%
3. TCP
1%
4. NIC
5. Write the Python statement to open a text file "notes.txt" in both read and write mode.
Anonymous Quiz
18%
1. f = open ("notes.txt", "r")
54%
2. f = open ("notes.txt", "r+")
9%
3. f = open ("notes", "r")
19%
4. f = open ("notes.txt")
10. Which of the following functions returns an integer that specifies the current position of the file object in the file?
Anonymous Quiz
18%
1. tell()
40%
2. seek()
33%
3. find()
9%
4. read()
11. The number of tuples in a relation is called:
Anonymous Quiz
17%
Degree
38%
Cardinality
23%
Domain
23%
4. Attribute
12. ____ is a useful technique that helps in capturing runtime errors and handling them so as to avoid the program getting terminated abruptly.
Anonymous Quiz
25%
1. Error Handling
24%
2. Try Catch
46%
3. Exception Handling
5%
4. Error exception
13. How to remove the primary key constraint from the table? Syntax: ALTER table table_name ____ primary key:
Anonymous Quiz
30%
Delete
32%
Drop
25%
Modify
13%
Alter
14. In DBMS, the file system suffers from:
* A. Data Dependence
* B. Data Redundancy * C. Data Isolation * D. Data Inconsistency Choose the most appropriate answer:
* A. Data Dependence
* B. Data Redundancy * C. Data Isolation * D. Data Inconsistency Choose the most appropriate answer:
Anonymous Quiz
22%
1. B, C, and D only
30%
2. A and D only
31%
3. A, B, C, and D
18%
4. A, B, and C only
15. In SQL, to increase the salary by 10% of employees from the Employee Table, select the correct query.
Anonymous Quiz
16%
1. alter table Employee add salary = 10/100 * salary;
32%
2. update salary set salary = salary * 10/100;
24%
3. update salary set salary = salary + 10/100 salary;
29%
4. update Employee set salary = salary + 10/100 * salary;
Which of the following sorting algorithms is known for its efficiency in average and worst-case scenarios with a time complexity of O(n log n)?
Anonymous Quiz
31%
1. Bubble Sort
41%
2. Insertion Sort
19%
3. Merge Sort
9%
4. Selection Sort
22. In object-oriented programming, the mechanism of deriving a new class from an old one is called:
Anonymous Quiz
13%
1. Polymorphism
66%
2. Inheritance
16%
3. Abstraction
5%
Encapsulation
👍1
23. Which SQL statement is used to retrieve data from a database?
Anonymous Quiz
20%
1. INSERT
27%
2. UPDATE
51%
3. SELECT
3%
4. DELETE
24. What does HTML stand for?
Anonymous Quiz
81%
1. Hyper Text Markup Language
10%
2. Hyperlink Text Manipulation Language
5%
3. Home Tool Markup Language
4%
4. Highly Technical Machine Language
25. Which of the following is a type of network topology in which each device is connected to a central hub?
Anonymous Quiz
19%
1. Bus Topology
15%
2. Ring Topology
51%
3. Star Topology
15%
4. Mesh Topology
👍1
26. Which protocol is commonly used for sending emails over the internet?
Anonymous Quiz
15%
1. FTP
37%
2. HTTP
42%
3. SMTP
5%
4. TCP
28. Which data structure follows the Last-In, First-Out (LIFO) principle?
Anonymous Quiz
23%
1. Queue
14%
2. Array
55%
3. Stack
8%
4. Linked List
HARYANA_LEET_SYLLABUS.pdf
1.8 MB
Document from Naveen Munjal