Font size
WorksheetsICT (test) — Final
Total questions: 69
Worksheet time: 35mins
Which SQL statement is used to delete a table from a database?
REMOVE TABLE
DELETE TABLE
DROP TABLE
CLEAR TABLE
What is the primary purpose of a foreign key in a database?
To uniquely identify a record in a table.
To enforce referential integrity between tables.
To sort data within a table.
To store large amounts of text.
What keyword is used to filter records based on a specified condition in SQL?
WHERE
HAVING
FILTER
SELECT
What does the COUNT() function do in SQL?
Counts the number of columns in a table.
Counts the number of rows in a table.
Counts distinct values in a specified column.
Counts the total number of tables in a database.
Which of the following are valid SQL aggregate functions? (Select all that apply)
SUM()
AVG()
COUNT()
LIST()
Which SQL command is used to remove all records from a table without deleting the table itself?
DELETE TABLE
REMOVE ALL
TRUNCATE TABLE
DROP TABLE
What is the default sorting order when using the ORDER BY clause?
DESCENDING
ASCENDING
RANDOM
ALPHABETICAL
What does the SQL clause GROUP BY do?
It groups rows that have the same values in specified columns into summary rows.
It orders the rows in a result set.
It filters rows based on a condition.
It combines rows from two or more tables.
Which SQL command can be used to create a relationship between two tables? (Select all that apply)
CREATE TABLE
ALTER TABLE
ADD FOREIGN KEY
JOIN
Which of the following are valid SQL data types? (Select all that apply)
INT
VARCHAR
DECIMAL
DATE
What SQL statement is used to select all entries from the locations table?
SELECT ALL FROM locations
SELECT * FROM locations
GET * FROM locations
SELECT locations
Which keyword is used in SQL to combine the results of two or more SELECT statements?
JOIN
UNION
INTERSECT
COMBINE
Which SQL clause is used to sort the results of a query?
ORDER BY
GROUP BY
SORT
FILTER
What is the purpose of a LEFT JOIN in SQL?
To combine rows from two tables, returning only matching rows.
To combine rows from two tables, returning all rows from the left table.
To create a new table.
To delete rows from a table.
What SQL query would you use to get a list of all companies whose names start with the letter 'A'? (Select all that apply)
SELECT * FROM companies WHERE company_name LIKE 'A%'
SELECT company_name FROM companies WHERE company_name STARTS WITH 'A'
SELECT company_name FROM companies WHERE company_name LIKE '%A%'
SELECT company_name FROM companies WHERE company_name = 'A%'
What does the MONTH function do in Excel?
Returns the current month.
Extracts the month from a date.
Calculates the number of months between two dates.
Formats the date to show only the month.
Which action would you take to sort data in Excel?
Use the Format Cells option.
Use the Data tab and select Sort.
Use the Home tab and select Filter.
Use the View tab and select Sort.
Which of the following statements are true about SmartArt in PowerPoint? (Select all that apply)
It can be used to visualize information.
It cannot be customized.
It allows for easy rearrangement of elements.
It can include text and images.
Which of the following actions can help protect your PowerPoint presentation? (Select all that apply)
Set a password for editing.
Save as a PDF.
Use a watermark.
Disable editing features.
In Excel, how can you quickly apply a currency format to a cell?
Right-click and select Format Cells > Currency
Press Ctrl + C
Use the Home tab and select Currency from the Number format dropdown
Type "$" before the number
Which Excel feature allows you to summarize data based on specific criteria?
PivotTable
Chart
Table
Filter
What function would you use to combine text from multiple cells into one cell in Excel?
CONCATENATE
JOIN
MERGE
COMBINE
How can you adjust the timing of animations in PowerPoint?
Use the Animations tab to set duration and delay.
Right-click on the slide and select "Timing".
Use the Design tab for timing adjustments.
Animations cannot be timed.
Which of the following can be included in an Excel chart? (Select all that apply)
Data labels
Trend lines
Legends
Footnotes
Which feature allows you to add interactivity to a PowerPoint presentation?
Animations
Transitions
Hyperlinks
Slide Layouts
What can you do with the Filter feature in Excel? (Select all that apply)
Display only rows that meet certain criteria.
Sort data in ascending or descending order.
Hide rows that do not meet certain criteria.
Format cells based on conditions.
What will be the output of print("Programming"[3:7])?
Gra
gram
pro
pr
Which of the following correctly demonstrates variable reassignment in Python?
x = 10; x = 20
x := 10; x = 20
int x = 10; x = 20
const x = 10; x = 20
How many iterations will the following code execute? The code shown is: for i in range(2, 10, 2): print(i)
4
5
3
8
What is the primary function of Power BI?
Data storage
Data visualization and analysis
Data modeling
Programming application
Which of the following file types can Power BI NOT import directly?
Excel files
JSON files
XML files
Java files
What is the purpose of a slicer in Power BI?
To create reports
To visualize geographic data
To filter data
To combine multiple visuals
How can you customize the appearance of a chart in Power BI?
Changing the data source settings
Through the Formatting pane
By altering the data model
By manually editing visual code
How do you establish a connection to a SQL database in Power BI?
Using ODBC or SqlClient
Via FTP
With a direct HTTP request
Only through CSV files
In the context of Power BI, which operation combines tables based on matching columns?
Inner Join
Cross Join
Outer Join
Natural Join
What is the effect of the statement print("Hello"[::-1])?
Hello
olleH
Error
H
Which of the following is a correct way to create a multi-line string in Python?
"""Hello World"""
'Hello\nWorld'
<
"Hello World"
What will print(2**3**2) output?
512
64
12
16
Which of the following types can be used as keys in a dictionary?
List
Set
Tuple
All of the above
What will print("10" + str(10)) yield?
20
1010
"1010"
"20"
What is the output of the following code? for i in range(3): for j in range(2): print(i, j)
000011112222
000110112021
012
Error
What does the following code output? for i in range(1, 6, 2): if i == 3: continue print(i)
1 2 3 4 5
1 3 5
1 5
1 2 4
What will be the result of len([[1, 2], (3, 4, 5), [6]])?
3
6
5
4
If list1 = [1, 2, [3, 4]], what will list1[2][1] return?
3
4
[3, 4]
Error
Which of the following can NOT be a data source for Power BI?
Microsoft Excel
SQL Server
MongoDB
Only CSV Files
What is Power Query used for in Power BI?
Creating visualizations
Data cleaning and transformation
Writing DAX formulas
None of the above
What must be done to use a Calculated Column in Power BI?
Input data manually
Write a DAX formula
Change the visual type
Load the data model
What is the purpose of the "Modeling" tab in Power BI?
To create reports
To modify visual elements
To manage relationships and calculated columns
To import data
What kind of connection does DirectQuery allow between Power BI and SQL databases?
Live connection
Scheduled refresh
Manual refresh
None of the above
How can you improve performance when querying a large SQL table in Power BI?
Limit the columns returned with SELECT
Use a more complex query
Avoid indexes
None of the above
What kind of connection does DirectQuery allow between Power BI and SQL databases?
Live connection
Scheduled refresh
Manual refresh
None of the above
How can you improve performance when querying a large SQL table in Power BI?
Limit the columns returned with SELECT
Use a more complex query
Avoid indexes
None of the above
To analyze trends effectively in Power BI, data is typically grouped by:
Categories
Time intervals
Both A and B
Direct data references
Which of the following is a correct use of DAX in Power BI?
Creating a data connection
Defining calculated columns and measures
Formatting visual elements
Connecting to APIs
What is the correct way to declare a variable in Python?
var x = 5
x = 5
int x = 5
x := 5
Which of the following data types is immutable in Python?
List
Dictionary
Set
Tuple
Which keyword is used to define a function in Python?
function
def
define
func
What does the strip() method do when called on a string?
convert it to uppercase
removes whitespace from both ends
splits the string into a list
brings cr7
How do you create a dictionary in Python?
my_dict = []
my_dict = {}
my_dict = ()
my_dict = <>
What is the output o f the following code? print("Python" * 3)
Python
PythonPython
PythonPythonPython
PythonPythonPythonPython
What function do you use to read a line of input from the user?
input_line
input
read_input
read_line
Which of the following will generate a random integer between 1 and 10 in Python?
random.randint(1, 10)
random.range(1, 10)
random.integer(1, 10)
random.int(1, 10)
How do you handle exceptions in Python?
try-except block
if-else block
Catch - finally
handle-except
How are elements in a dictionary accessed?
Using square brackets
Using parentheses
Using curly braces
Using parents
Which method is used to remove an item from a list at a specific index?
remove
pop
delete
discard
What is the purpose of the return statement in a function?
To return a value to the caller
To print a value to the console
to exit the program
To define a function
What is the result of this expression: 5== "5"?
error
none
true
false
What will this value print? print("Hello" + "World")
Hello world
Helloworld
'Hello world'
"Hello world"
What will len("Hello, World!") return?
12
13
14
11
