School & Entrance Prep
Board Exams, NEET, and JEE Question Bank • 817 questions
Advanced Filters
______ is the attempt to acquire sensitive information such as usernames, passwords and credit card details by concealed as a trustworthy entity in an electronic communication.
Prof. Sarita Gupta
Options:
Pharming
Phishing
Give two examples of e-waste.
Prof. Sarita Gupta
Which of the following query will remove a column from a table?
Prof. Sarita Gupta
Options:
DELETE COLUMN column_name;
DROP COLUMN column_name;
Legal term to describe the rights of a creator of original creative or artistic work is:
Prof. Sarita Gupta
Options:
Copyright
Copyleft
Predict the output:
SELECT POW(5, 3);
Prof. Sarita Gupta
Give the difference between drop and delete command.
Prof. Sarita Gupta
In SQL, which of the following types of table constraints will prevent the entry of duplicate rows?
Prof. Sarita Gupta
Options:
Unique
Distinct
Which operator can take wild card characters for query condition?
Prof. Sarita Gupta
Options:
BETWEEN
LIKE
Which of the following attribute returns index, column labels of dataframe?
Prof. Sarita Gupta
Options:
labels
axis
Identify the most appropiate INSERT query from the following:
Prof. Sarita Gupta
Options:
INSERT INTO Persons('xxx1', 'yyy1');
INSERT INTO Persons (LastName, FirstName) Values ('xxx', 'yyy');
Explain copyright infringement.
Prof. Sarita Gupta
Write the SQL query to display the month from the date '2024-10-23'.
Prof. Sarita Gupta
Define MAC address.
Prof. Sarita Gupta
A dataframe is created using dictionary as given below. Write the code to create the same.
d={'Name':['Ram','Shyam','Sita'],'Marks':[90,80,70]}
Prof. Sarita Gupta
Which of the following is not a type of cyber crime?
Prof. Sarita Gupta
Options:
Data theft
Installing antivirus for protection
An organization purchases new computers every year and dumps the old ones into the local dumping yard. Write the name of the most appropriate category of waste that the organization is creating every year, out of the following options:
Prof. Sarita Gupta
Options:
Solid Waste
Commercial Waste
Consider the table with structure as: Student(ID, name, dept_name, tot_cred). In the above table, which attribute will form the primary key?
Prof. Sarita Gupta
Options:
name
dept_name
A software that can be freely accessed and modified is called
Prof. Sarita Gupta
Options:
Package Software
Open Source Software
Logical operator used in SQL are:
Prof. Sarita Gupta
Options:
AND, OR, NOT
in, not in
What is the purpose of using ndim attribute in Series?
Prof. Sarita Gupta
Options:
It returns the number of elements in the given data structure.
It returns the Series object in the form of an ndarray.
To display the 3rd, 4th and 5th columns from the 6th to 9th rows of a dataframe DF, you can write-
Prof. Sarita Gupta
Options:
DF.loc[6:9,3:5]
DF.loc[6:10,3:6]
Which amongst the following is not an example of a browser?
Prof. Sarita Gupta
Options:
Chrome
Firefox
Assertion (A): The rename() requires copy argument to make changes in the original dataframe.
Reason (R): To access values using positional index we can use DF.iloc
Prof. Sarita Gupta
Options:
Both A and R are true and R is the correct explanation for A
Both A and R are true and R is not the correct explanation for A
Assertion (A): Star topology is a network topology in which each network component is physically connected to a central device such as a router, hub or switch. Reason (R): Failure of one node will affect whole network in star topology.
Prof. Sarita Gupta
Options:
Both A and R are true and R is the correct explanation for A
Both A and R are true and R is not the correct explanation for A
Which of the following is not a correct method to create a DataFrame?
Prof. Sarita Gupta
Options:
pd.DataFrame({'Name': ['A','B']})
pd.DataFrame([('A', 10), ('B',20)], columns=['Name','Marks'])
Google Chrome, Mozilla Firefox, and Microsoft Edge are examples of which type of software?
Prof. Sarita Gupta
Options:
Web Browser
Search Engine
What will be the result of the following SQL query?
SELECT ROUND(418678.6010, -2);
Prof. Sarita Gupta
Options:
A ______ is a networking device that connects two or more networks and forwards data packets between them, based on their IP addresses.
Prof. Sarita Gupta
Options:
Gateway
Router
While applying for a job, Sohan's employer searches his name online and finds old posts with offensive language. He is rejected. This shows the impact of:
Prof. Sarita Gupta
Options:
Cyber Crime
Digital Footprint
Expand the following: (i) FOSS (ii) URL
Prof. Sarita Gupta