Get data from any page you want to get data from.
Need to talk to someone? Contact us—we’d love to help.
Get data from any page you want to get data from.
Need to talk to someone? Contact us—we’d love to help.
We are still busy preparing this batch of data. Please come back in a few minutes.
Seems like this data source was never ran before...
Changes are only available only when you have ran at least a second time.
Nope... guess no Martians around... Maybe set the webhook URL before pressing this button again...
Question | option_1 | option_2 | option_3 | option_4 | answer | origin_pattern | origin_url | createdAt | updatedAt | pingedAt |
---|---|---|---|---|---|---|---|---|---|---|
Q10. What is the purpose of the SQL AS clause? | The AS SQL clause is used to change the name of a column in the result set or to ... | The AS clause is used with the JOIN clause only | The AS clause defines a search condition | All of the mentioned | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q11. Which of the following is a legal expression in SQL? | SELECT NULL FROM SALES; | SELECT NAME FROM SALES; | SELECT * FROM SALES WHEN PRICE = NULL; | SELECT # FROM SALES; | B | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q12. DCL provides commands to perform actions like | Change the structure of Tables | Insert, Update or Delete Records and Values | Authorizing Access and other control over Database | None of Above | C | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q13. The COUNT function in SQL returns the number of _____ | Values | Distinct values | Group By | Columns | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q14. Which data type can store unstructured data in a column? | RAW | CHAR | NUMERIC | VARCHAR | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q15. A SQL query will not work if there are no indexes on the relations - Is it t... | NO | YES | B | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | ||
Q16. Table Employee has 10 records. It has a non-NULL SALARY column which is also... | 10 | 9 | 5 | 0 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | |
Q18. The SQL statement - SELECT ROUND(45.926, -1) FROM DUAL; | is illegal | prints garbage | prints 045.926 | prints 50 | B | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q19. Which of the following must be enclosed in double-quotes? | Dates | Column Alias | Strings | All of the above | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q2. Which SQL keyword is used to retrieve a maximum value? | MOST | TOP | MAX | UPPER | C | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q21. A subquery in an SQL SELECT statement is enclosed in: | parenthesis -- (...). | brackets -- [...]. | CAPITAL LETTERS. | braces -- {...}. | B | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q22. The result of a SQL SELECT statement is a ______. | file | report | table | form | B | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q23. In an SQL SELECT statement querying a single table, according to the SQL-92 ... | all columns of the table are to be returned. | all records meeting the full criteria are to be returned. | all records with even partial criteria met are to be returned. | None of the above is correct. | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q24. The HAVING clause does which of the following? | Acts EXACTLY like a WHERE clause. | Acts like a WHERE clause but is used for columns rather than groups. | Acts like a WHERE clause but is used for groups rather than rows. | Acts like a WHERE clause but is used for rows rather than columns. | C | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q25. Which of the following do you need to consider when you make a table in SQL?... | Data types | Primary keys | Default values | All of the above. | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q3. Which of the following SQL clauses is used to DELETE tuples from a database t... | DELETE | REMOVE | DROP | CLEAR | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
D | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | |||||
Q1. Which SQL function is used to count the number of rows in a SQL query? | COUNT() | NUMBER() | SUM() | COUNT(*) | D | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q17. The SQL statement - SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2... | gh | 23 | bc | ab | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | |
Q20. Which of the following command makes the updates performed by the transactio... | ROLLBACK | COMMIT | TRUNCATE | DELETE | D | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q4. _____removes all rows from a table without logging the individual row deletio... | DELETE | REMOVE | DROP | TRUNCATE | D | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q5. Which of the following is not a DDL command? | UPDATE | TRUNCATE | ALTER | None of the Mentioned | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q6. Which of the following are TCL commands? | UPDATE and TRUNCATE | SELECT and INSERT | GRANT and REVOKE | ROLLBACK and SAVEPOINT | D | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q7. ___ is not a category of SQL command. | TCL | SCL | DCL | DDL | B | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q8. If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following i... | ASC | DESC | There is no default value | None of the mentioned | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Q9. Which of the following statement is true? | DELETE does not free the space containing the table and TRUNCATE free the space c... | Both DELETE and TRUNCATE free the space containing the table | Both DELETE and TRUNCATE does not free the space containing the table | DELETE free the space containing the table and TRUNCATE does not free the space c... | A | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
C | https://tutorialslink.com/Articles/SQL-MCQs/1834 | https://tutorialslink.com/Articles/SQL-MCQs/1834 | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC | 2021-09-13 07:19:52 UTC |
Sample code snippets to quickly import data set into your application
For more information on how to automatically trigger an import please reference our WebHook API guide
Integrating with Java
import java.io.BufferedReader; import java.io.InputStreamReader; import java.net.URL; import java.net.URLConnection; import java.util.Arrays; public class HelloWorld { public static void main(String[] args) { try { URL urlCSV = new URL( "https://cache.getdata.io/n96541_2c4bf174fd19d21c6de798acd4ba1befeses/latest_all.csv" ); URLConnection urlConn = urlCSV.openConnection(); InputStreamReader inputCSV = new InputStreamReader( ((URLConnection) urlConn).getInputStream() ); BufferedReader br = new BufferedReader(inputCSV); String line; String[] fields; while ((line = br.readLine()) != null) { // Each row fields = line.split(","); System.out.println(Arrays.toString(fields)); } // clean up buffered reader br.close(); } catch (Exception e) { System.out.println(e.getMessage()); } } }
Integrating with NodeJs
const csv = require('csv-parser'); const https = require('https'); const fs = require('fs'); const file = fs.createWriteStream("temp_download.csv"); const request = https.get( "https://cache.getdata.io/n96541_2c4bf174fd19d21c6de798acd4ba1befeses/latest_all.csv", function(response) { response.pipe(file); } ); file.on('finish', function() { file.close(); fs.createReadStream('temp_download.csv').pipe(csv()).on('data', (row) => { // Each row console.log(row); }).on('end', () => { console.log('CSV file successfully processed'); }); });
Integrating with PHP
$data = file_get_contents("https://cache.getdata.io/n96541_2c4bf174fd19d21c6de798acd4ba1befeses/latest_all.csv"); $rows = explode("\n",$data); $s = array(); foreach($rows as $row) { # Each row var_dump( $row); }
Integrating with Python
import csv import urllib2 url = 'https://cache.getdata.io/n96541_2c4bf174fd19d21c6de798acd4ba1befeses/latest_all.csv' response = urllib2.urlopen(url) cr = csv.reader(response) for row in cr: # Each row print row
Integrating with Ruby
require 'open-uri' require 'tempfile' require 'csv' temp_file = Tempfile.new( "getdata", :encoding => 'ascii-8bit') temp_file << open("https://cache.getdata.io/n96541_2c4bf174fd19d21c6de798acd4ba1befeses/latest_all.csv").read temp_file.rewind CSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts row end
created on 2025-06-03
created on 2025-06-03