Page 19 - IPP-12-2024

27. Create a DataFrame in Python from the given list: (3)

[["MOANA", 2016, "John Musker and Ron Clements"], ["MOWGLI", 2018, "Andy
Serkis"], ["Aladdin", 2019, "Guy Ritchie"]]
Also, give appropriate column headings as shown below:

MOVIE YEAR DIRECTOR
0 MOANA 2016 John Musker and Ron Clements
1 MOWGLI 2018 Andy Serkis
2 Aladdin 2019 Guy Ritchie
Ans. (i) import pandas as pd
df= [["MOANA", 2016, "John Musker and Ron Clements"],
["MOWGLI", 2018, "Andy Serkis"],
["Aladdin", 2019, "Guy Ritchie"]]
df=pd.DataFrame(df,columns=["MOVIE", "YEAR", "DIRECTOR"])
print(df)
28. Write MySQL statements for the following: (3)
(i) To create a database named ACCOMODATION.
(ii) To create a table named Hotels based on the following specification:
Column Name Data Type Constraints

Category Varchar(25) Not Null
Hotel_ID Integer(3) Primary Key
Hotel_Name Varchar(30) Not Null
Room_Type Varchar(20) Default ‘AC’
Charges Integer Should not be more than 15000

Ans. (i) CREATE DATABASE ACCOMODATION;
(ii) CREATE TABLE HOTELS

(CATEGORY VARCHAR(25) NOT NULL,
HOTEL_ID INTEGER(3) PRIMARY KEY,
HOTEL_NAME VARCHAR(30) NOT NULL,
ROOM_TYPE VARCHAR(20) DEFAULT "AC",
CHARGES INTEGER CHECK(CHARGES<15000));
29. Purvi recently applied for a driving licence by filling out an online form. A few days later, she received a
confirmation email along with a link to pay for it. She paid the fee and confirmed a date for the driving test.
However, when she arrived on the mentioned date, she couldn’t find her registered details in the centre. (3)
Based on the given information, answer the following questions.
(i) What could be the reason for not getting any details of herself at the driving test centre?
(ii) Identify the type of cybercrime she is a victim of.
(iii) Suggest any two precautionary measures which she should take in the future to avoid this cybercrime.
OR
Mention any three measures that need to be adopted to manage digital footprints.
Ans. (i) Purvi might not be able to find her registered details at the driving test centre due to a potential
cybercrime, such as data breach or unauthorized access.
(ii) Phishing
(iii) (a) Contact the driving licence authority immediately to report the issue. Share the details of the
situation along with any confirmation emails or receipts she would have.

6 MODEL TEST PAPER