Which of the following is not a valid SQL command?
SELECT
INSERT
CREATE
FORM
Fill in the blank to pick/ display all contents of the Frontline table. SELECT __ FROM Frontline.
*
^
all
%
Which command allows you to control the number of output rows?
STOP
LIMIT
CHECK
END
The Employee table, hosted in AWS, stores Name, EmpId, Team, Location information. You need to export all information of employees based in Brisbane. Choose the correct statement(s).
select * from Employee where Location='Brisbane'
select Employee from Brisbane
select * from employees where location == Brisbane
select Name where Location="Brisbane" from Employee
select * from Employee where Location like 'Brisbane'
select * where Location like "Brisbane" from Employee
Consider 2 tables A & B. Which operator(s) allows you to pick only the matching rows between the tables?
intersect
and
inner join
or
Which of these is not a database service offered by popular public CSPs - Amazon/Microsoft/Google ?
Azure CosmosDB
Amazon Redshift
Google Cloud Spanner
Amazon Firehose
Which of these libraries allows you to interact with databases using python? Select all that apply.
sqlite
pyodbc
boto3
sqlalchemy
Any words of encouragement/ advise for Rithvik who's leaving us next week?
0
{"name":"SQL", "url":"https://www.quiz-maker.com/QB7JKH5K7","txt":"What does SQL stand for?, Who developed SEQUEL?, What type of data is SQL intended to operate on?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}