SQL Test

SMTPMart - Buy Inbox SMTP | Leads | Shell | cPanel 100% Bonus on 1st deposit | Instant Refunds

ProxyByte $2/GB | Residential IPv4 - No Logs - 26M+ IPs - All unblocked

REFUNDING.GG | #1 REFUND SERVICE | SAME DAY REFUNDS | WORLDWIDE ORDERS | GET ITEMS 85% OFF

New Ownership - Policies and Changes Going Forward

Thread Rating:

1 Vote(s) - 4 Average

SQL Test
Author Message

phyrrus9 Offline

1996-2021, Rest in Peace

Twelve Years of Service

Posts: 2,376

Threads: 227

Reputation: 284

Currency: 277 NSP

RE: SQL Test 04-05-2018, 09:35 PM #16

(04-05-2018, 11:44 AM)Sikom Wrote: I got 21 out of 25 => 84%

I have used MySQL quite a bit lately, which I think is the reason for that score. I did however have problems with some specific cases.
What I got wrong:

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"?

Which SQL statement is used to return only different values?

What is the most common type of join?

Which operator is used to search for a specified pattern in a column?

I have never done anything related to it, so I understand why I didn't get them.

Those were all trick questions.... SQL uses old school terminology.

==phyrrus9's tutorial list==

Website

Messages In This Thread

SQL Test - by mothered - 02-09-2018, 02:20 PM

RE: SQL Test - by MrSecurity - 02-09-2018, 06:57 PM

RE: SQL Test - by Synthx - 02-09-2018, 07:10 PM

RE: SQL Test - by mothered - 02-10-2018, 03:30 AM

RE: SQL Test - by krMM - 04-04-2018, 07:06 PM

RE: SQL Test - by mothered - 04-04-2018, 09:25 PM

RE: SQL Test - by krMM - 04-05-2018, 05:03 AM

RE: SQL Test - by phyrrus9 - 04-05-2018, 07:15 AM

RE: SQL Test - by mothered - 04-05-2018, 09:31 AM

RE: SQL Test - by phyrrus9 - 04-05-2018, 09:37 AM

RE: SQL Test - by mothered - 04-05-2018, 09:50 AM

RE: SQL Test - by phyrrus9 - 04-05-2018, 09:52 AM

RE: SQL Test - by mothered - 04-05-2018, 10:31 AM

RE: SQL Test - by Sikom - 04-05-2018, 11:44 AM

RE: SQL Test - by mothered - 04-06-2018, 04:17 AM

SQL Test - by Bish0pQ - 04-05-2018, 12:19 PM

RE: SQL Test - by phyrrus9 - 04-05-2018, 09:35 PM

RE: SQL Test - by drxddock - 04-09-2018, 03:32 PM

RE: SQL Test - by Pikami - 04-09-2018, 03:39 PM

RE: SQL Test - by mothered - 04-10-2018, 11:35 AM

RE: SQL Test - by Pikami - 04-10-2018, 03:30 PM

RE: SQL Test - by mothered - 04-10-2018, 03:43 PM

RE: SQL Test - by d4ggm4sk - 02-26-2021, 11:11 AM

RE: SQL Test - by Dismas - 02-26-2021, 11:23 AM

Users browsing this thread: 1 Guest(s)