Question 1

As a Cloud Developer you need to work with relational databases like SQLite. You need to create a table named employees with columns as follows:

-> id: INTEGER, NOT NULL

-> name: TEXT, NOT NULL

-> age: INTEGER, NOT NULL

And the primary key constraint set to the id column.

Which of the following statements will correctly create the employees table? (select 2)

Options :

A :

CREATE TABLE employees (

id INTEGER NOT NULL PRIMARY KEY,

name TEXT NOT NULL,

age INTEGER NOT NULL

);

B :

CREATE TABLE employees (

id INTEGER NOT NULL,

name TEXT NOT NULL,

age INTEGER NOT NULL,

FOREIGN KEY (id)

);

C :

CREATE TABLE employees (

id INTEGER NOT NULL,

name TEXT NOT NULL,

age INTEGER NOT NULL

);

D :

CREATE TABLE employees (

id INTEGER NOT NULL,

name TEXT NOT NULL,

age INTEGER NOT NULL,

PRIMARY KEY (id)

);

Answer: A,D

Question 2

Options :

A : This code will output [2, 3, '4'] to the console.

B : This code will raise the SyntaxError exception.

C : This code will output [2, 3, 4] to the console.

D : This code will raise the ValueError exception.

Answer: C

Question 3

You’ve created the following label using Tkinter:

label = tk.Label(

text='Hello, World!',

fg='white',

bg='black',

width=10,

height=10

)

What are the characteristics of the above label? (select 2)

Options :

A : The label will be a square.

B : The background will be black.

C : The text will be white.

D : Hello, World! will not appear on the button.

Answer: B,C

Question 4

The json.loads() method... (select 2)

Options :

A : takes Python data as its argument.

B : takes a JSON string as its argument.

C : returns a string.

D : returns a JSON object.

Answer: B,D

Question 5

The following code snippet attempts to call a method with multiple arguments in Python. Identify the correct syntax for calling the method and provide the correct code snippet.

class Calculator:

def add_numbers(self, num1, num2):

return num1 + num2

# Attempt to call the add_numbers method

calculator = Calculator()

Options :

A : result = Calculator.add_numbers(3, 4, 5)

B : result = add_numbers(3, 4, 5)

C : result = calculator.add_numbers([3, 4, 5])

D : result = calculator.add_numbers(3, 4, 5)

Answer: D