Programming Questions

Question 1

What is required for a queue?

Answer 1

Start pointer, rear pointer, current size, maximum size and an array

Question 2

Create a new database called ‘rent’

Answer 2

$sql = "CREATE DATABASE 'rent'"
$result = $connection ->query($sql)

Question 3

Write SQL code to check if there has been a connection error

Answer 3

if(mysqli_connect_errno()){
echo “error message”
exit();
}

Question 4

Close a database connection

Answer 4

mysqli_close($connection)

Question 5

Write SQL code to connect to a database called school with the password ‘12345’ and the username teacher

Answer 5

$connection = new mysqli(“localhost”,”teacher”,”12345”,”school”);

Question 6

Write a SQL statement that inserts ‘Charles Boyle’ ‘Detective’ into the table cops to the attributes name and job respectively

Answer 6

INSERT INTO cops(name,job)

VALUES(‘Charles Boyle’,’Detective’);

Question 7

Write an Update SQL statement to update the table pupil and change the pupil second name to ‘Davis’ where pupil ID is 34

Answer 7

UPDATE pupil
SET pupil.secondname = ‘Davis’
WHERE pupil.id = 34;

Question 8

Write SQL code to delete all from the table school

Answer 8

DELETE * FROM school;

Question 9

Write SQL code to select all the records where the year of the pupil is greater than 4th year and order by DESC in pupil age from pupil table

Answer 9

SELECT * FROM pupil WHERE pupil.year > 4 ORDER BY pupil.age DESC;

Question 10

Write a delete track function on a Playlist where index in passed in and the instance variables in the class are self.maxLength, self.tracks, self.nextTrack

Answer 10

def deleteTrack(self,index):
if index > self.maxLength or index < 0:
print("Invalid index")
else:
for item in range(index, self.nextTrack-1):
self.tracks[item] = self.tracks[item+1]
end for
self.nextTrack = self.nextTrack - 1

Question 11

Write a class AlbumnTrack and init subroutine that inherits all it's instance variables from the Track class and then has another instance variable called albumnname 
Title, artist and length are passed into track initiation

Answer 11

class AlbumnTrack(Track):
def \_\_init\_\_(self,title,artist,length,albumnname):
Track.\_\_init\_\_(self,title,artist,length)
self.albumnname = albumnname

Question 12

Write code to define a class Athlete which has instance values age, name, event and has a method to display all the information 
Event should be default competitor if no event is given during instantiation

Answer 12

class Athlete:
def \_\_init\_\_(self,age,name,event="Competitor"):
self.age = age
self.name = name
self.event = event 
def display(self):
print("Age:" , self.age)
print("Name:", self.name)
print("Event:", self.event)

Question 13

Write PHP code to sanitize username which has come in by the get method

Answer 13

$username = filter_var($_GET[‘username’], FILTER_SANITIZE_STRING);

Question 14

Write PHP to receive the value from the radio box of the 2018 tony best musical nominations which were sent under the name ‘Best Musical’ and using post

Answer 14

$result = $_POST[‘Best Musical’]

echo $result

Question 15

Write the start of the stack class without the push or pop

Answer 15

class Stack:
def \_\_init\_\_(self,size):
self.stack = [] * size
self.stackPointer = 0
self.size = 0

Question 16

Write a push action for a stack class

Answer 16

def push(self,value):
if self.stackPointer == self.size

else:

self. stack[self.StackPointer] = value
self. stackPointer = self.stackPointer + 1

Question 17

Write a pop action for a stack class

Answer 17

def Pop(self):
if self.stackPointer == 0:

else:
self.stackPointer = self.stackPointer - 1
return self.stack[self.stackPointer]

Question 18

Write the start of the Queue class without the join and the leave functions

Answer 18

class Queue
def \_\_Init\_\_(self,size):
self.start = 0
self.rear = 0 
self.currentSize = 0
self.maxSize = size
self.queue = [] * self.maxSize

Question 19

Write the join procedure for queue

Answer 19

def Join(self,data):
if self.currentSize = self.maxSize:

else:

self. queue[self.rear] = data
self. rear = self.rear + 1
self. currentSize = self.currentSize + 1

if self.rear > self.maxSize:
self.rear = 1

Question 20

Write the leave function for a queue

Answer 20

def Leave(self):
if self.currentSize = 0:

return 0 
else:
return self.queue[self.start]
self.queue[self.start] = 0
self.currentSize = self.currentSize - 1
self.start = self.start + 1
if self.start > self.maxSize:
self.start = 1

Question 21

Write a procedure to set up a linked list

Answer 21

PROCEDURE setuplist()
DECLARE data INTEGER INITIALLY 0
DECLARE head POINTER INITIALLY NULL
END PROCEDURE

Question 22

Write a procedure to add a new node to a linked list

Answer 22

PROCEDURE newNode(data, next):
IF head = NULL THEN

next = NULL
ELSE

next = NULL
END IF
END PROCEDURE