ENCOR Exam - Question 688

Question

Refer to the exhibit. What does this Python script do?

Examice · Accepted Answer

This Python script reads the username for a specific IP address from a light (SQLite) database. It connects to the SQLite database, creates a cursor object to execute SQL commands, constructs and executes a query to select the user from the monitor_branch table where the loopback IP matches a specified IP address, fetches the result, and processes the retrieved username. The script only reads the data and does not perform any write operations on the database.

jackr76 · Answer

WTF is this a Cisco or SQL exam

Badger_27 · Answer

WTF are they serious?

Sammy3637 · Answer

no clue ...
didn't see this coming , not in OCG

slacker_at_work · Answer

Here's a breakdown of what each part does:

-1 Importing sqlite3: This line imports the SQLite3 module in Python, allowing the script to interact with SQLite databases.
-2 Connecting to the database: The script connects to a SQLite3 database located at /home/sdwan-lab/user.sqlite3. This is done using the connect() method of the sqlite3 module, which returns a connection object (a in this case).
-3 Creating a cursor object: Cursors are used to execute SQL queries on the connected database. The cursor() method creates a cursor object (b in this case) associated with the connection

slacker_at_work · Answer

- 4 SQL Query: The variable c contains an SQL query. It appears to be selecting the user column from a table named monitor_branch where the loopbackip matches a specific pattern. However, there seems to be a syntax error in the query. The string concatenation is not done properly.
- 5 Executing the query: The execute() method of the cursor b executes the SQL query stored in the variable c.
- 6 Fetching the results: The fetchall() method retrieves all the rows returned by the query execution and stores them in the variable e.
- 7 Processing the result: The script then appears to be manipulating the fetched result. It converts the first element of the result (e[0]) to a string, removes any occurrences of ( and ,) from the string, and assigns the modified string back to the variable usr.

HungarianDish_111 · Answer

B seems to be correct, because data only needs to be read from the DB, and not altered.

https://www.google.com/amp/s/www.geeksforgeeks.org/how-to-list-tables-using-sqlite3-in-python/amp/

djedeen · Answer

B: good link here for similar queries from sqlite3 DB. 
https://pyneng.readthedocs.io/en/latest/book/25_db/sqlite3_fetch.html

mgiuseppe86 · Answer

doesn the usr.replace string write the username back to the DB once it selects it from the table monitor_Branch?

RickAO76 · Answer

I'm 50/50 with it being B or C.
The two lines for ....
usr = usr.replace()
...functions, are for writing.
- I honestly just hope I don't see this question :-/

[Removed] · Answer

B is correct

The keyword is:
c = "select user from monitor branch where loopbackip='" + str(ip[i]) + "'"

CiscoTerminator · Answer

I wonder what is being asked in devops then, if these are encor questions?

AbdullahMohammad251 · Answer

Connect to the SQLite database (user.sqlite)
Execute the SQL query (find the username for a given IP address: the IP address stored in the list item with index 'i')
Fetch the entire result set and parse it into a Python list (list 'e')
Modify the result list - in our example, curly brackets were replaced with double quotes

[Removed] · Answer

i'm going with B, no idea why :D

Steve122 · Answer

Definitely 'B'.
After getting the username from e[0] it removes the ( and ) chars from string. (nothing written back to DB)

johndoen · Answer

I this sql exam or cisco one , I dont see get it just like I wasn't able to roam my globe sim before knowing https://theglobesimregistration.ph

chmacnp · Answer

nice one slacker_at_work !

ENCOR Exam - Question 688

Discussion