Django-quiz

Which of the following SQL clauses is used to DELETE tuples from a database table?

• DELETE

• REMOVE

• DROP

• CLEAR

The UPDATE SQL clause can _____________

• update only one row at a time

• update more than one row at a time

• delete more than one row at a time

• delete only one row at a time

How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

• UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

• MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

• MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’

• UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’

SQL query to find all the "cities" from the "weather" table whose humidity is 95.

• SELECT city WHERE humidity = 95

• SELECT city FROM weather WHERE humidity = 95

• SELECT humidity = 89 FROM weather

• SELECT city FROM weather

With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

• SELECT * FROM Persons WHERE FirstName=’a’

• SELECT * FROM Persons WHERE FirstName LIKE ‘a%’

• SELECT * FROM Persons WHERE FirstName LIKE ‘%a’

• SELECT * FROM Persons WHERE FirstName=’%a%’

What is a method in python?

• a way of doing something

• a special kind of function that is defined in a class definition

• the creation of an instance of a class

• orderliness of thought or behavior; systematic planning or action

Attributes of an object are also known as

• methods

• properties

• classes

• functions

An object is an instance of a:

• parameter
• method
• class
• application

Identify the term that describes the creation of a new object.

• instantiation

• declare

• iteration

• initialize

What does __init__ do?

• Constructs the instance

• Initialize the instance values

• Calls the Super class

• Creates a circle