SQL Quiz
SQL and AWS Quiz Challenge
Test your knowledge with our engaging SQL and AWS quiz! Designed for tech enthusiasts, this quiz will challenge your understanding of SQL queries and AWS CloudFormation templates.
Highlights:
- 8 thought-provoking questions
- Multiple-choice format
- Immediate feedback on answers
Which SQL statement selects all data in the table cars
SELECT * FROM Cars
SELECT all FROM Cars
SELECT _all_ FROM Cars
What is NOT an element of an AWS Cloudformation template
AWS resources list and Values
Template version number
AWS MFA
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
Select * from person firstname = 'Peter'
Select * from person firstname != 'Peter'
Select * from person where firstname = 'Peter'
Select from person where firstname = 'Peter'
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?
Select * from person where firstname like '%a%'
Select * from person where firstname like '%a'
Select * from person where firstname like '%%a%'
Select * from person where firstname like 'a%'
Which SQL keyword is used to sort the result-set?
Order
Sort by
Order by
Sort
With SQL, how can you return the number of records in the "Persons" table?
Select count() person
Select count(*)
Select count(*) from person
Select columns(count *) from person
How do you create a dataframe in python?
Pandas as pd data = pd.read_csv(r'Path where the CSV file is stored\File name.csv') df = pd.DataFrame(data) print(df)
Import pandas as pd data = pd.read_df(r'Path where the CSV file is stored\File name.csv') df = pd.DataFrame(data) print(df)
Import pandas as pd data = read_csv(r'Path where the CSV file is stored\File name.csv') df = pd.DataFrame(data) print(df)
Import pandas as pd data = pd.read_csv(r'Path where the CSV file is stored\File name.csv') df = pd.DataFrame(data) print(df)
{"name":"SQL Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge with our engaging SQL and AWS quiz! Designed for tech enthusiasts, this quiz will challenge your understanding of SQL queries and AWS CloudFormation templates.Highlights:8 thought-provoking questionsMultiple-choice formatImmediate feedback on answers","img":"https:/images/course1.png"}