SQL Key Terms Fun Quiz!!!!

[Cr1TH1T]

IF you comment all the answers correctly you will get a........COOKIE FROM YOURS TRULY!!!
1.) What is an FK? Define the acronym and then define the what it does!
 2.) What is a Null?
3.) What is a Datatype?
4.) What does the acronym PK mean?
*****BONUS QUESTION*****
1.) Give an Example of a Entity Relationship!!!! [Equals additional Cookies!]

[HTH]

Cool idea but this is going to Newbie Programming.
Moved.

[Cr1TH1T]

Was just trying to accessible, it's something that I'm learning. Plus the way I figure, it can be fun to reach back and try to remember the basics. It helps to keep an edge. Don't be an asshole just because you already know this stuff. Have an open-mind towards students of the trade.

Cool idea but this is going to Newbie Programming.
Moved.

Forgot about that XD, Probably should have posted there in the first place.

Modified to Remove Double Post

[HTH]

No harm no foul. Just try to remember it in the future if you wish to share something you are learning but it's rather basic

[Cr1TH1T]

Appreciate the redirect there Captain!

[madf0x]

To start off, FUCK YOU STOP DOUBLE POSTING ANYWHERE


1.) What is an FK? Define the acronym and then define the what it does!
Foreign Key, basically a shitty pointer in one table to a value in another table. If the two tables aren't synced up you have problems.

 2.) What is a Null?
A null is exactly that: null void, nada, zip. Not to be confused with the integer 0, even if they are sometimes used interchangeably elsewhere. Basically an 'empty' value.

3.) What is a Datatype?
The type of data moron. Got yo strings. Got yo chars. Got yo integers. Etc. Data is stored in different memory sizes, and a datatype is basically a human convention to denote the memory size of a data value without explicit declaration while conveniently describing how a piece of data should be handled. Pretty universal concept here shawty.

4.) What does the acronym PK mean?

Primary Key, what a FK references.
*****BONUS QUESTION*****
1.) Give an Example of a Entity Relationship!!!! [Equals additional Cookies!]
Dogs have Nipples

[madf0x]

I wish I could have all my homework done for the price of a cookie or two...

Except I lied somewhere, DUN DUN DDUUUUUNNNN

[HTH]

Except I lied somewhere, DUN DUN DDUUUUUNNNN

dogs DONT have nipples?

[madf0x]

Hmm, I suppose I would say lie via inaccuracy? Really it would have been a bit easier to explain if he swapped two of his questions.

[Cr1TH1T]

To start off, FUCK YOU STOP DOUBLE POSTING ANYWHERE


1.) What is an FK? Define the acronym and then define the what it does!
Foreign Key, basically a shitty pointer in one table to a value in another table. If the two tables aren't synced up you have problems.

 2.) What is a Null?
A null is exactly that: null void, nada, zip. Not to be confused with the integer 0, even if they are sometimes used interchangeably elsewhere. Basically an 'empty' value.

3.) What is a Datatype?
The type of data moron. Got yo strings. Got yo chars. Got yo integers. Etc. Data is stored in different memory sizes, and a datatype is basically a human convention to denote the memory size of a data value without explicit declaration while conveniently describing how a piece of data should be handled. Pretty universal concept here shawty.

4.) What does the acronym PK mean?

Primary Key, what a FK references.
*****BONUS QUESTION*****
1.) Give an Example of a Entity Relationship!!!! [Equals additional Cookies!]
Dogs have Nipples

WINNER WINNER CHICKEN DINNER. Except for the Bonus. You get a COOKIE!!!

[Cr1TH1T]

rigggghhht... he either doesnt know the correct answers or didn't bother to read. at this point it could really be either or.

The main questions are correct. I have checked my reference and made sure. No worries. Btw the reference is Oracle.


ADDITION:
Also, Just wanted to clarify that while this is a public forum, I would like you guys to keep in mind that I have only been here for about a week and I am just trying to make something fun, albeit trivial, but fun nonetheless. Also, while the initial response was negative I will continue to post these if I find something a little challenging for beginners and experts alike. Just basically the stuff i learn myself as the class progresses over the length of the semester. I appreciate all the comments and the Cookies will be awarded to the person who answers all questions correctly FIRST. The bonus question is separate.

[madf0x]

Actually my bonus answer IS correct. I made it in joking manner, but was absolutely serious. You asked for an example of an entity relationship, not to explain entity relationships, to give context, draw an entity relationship model, etc. Just give an example.

You have two entities Dog and Nipples, dogs have a relationship to nipples as expressed through possession of them, ergo they have an entity relationship of Dogs have Nipples.

I did MY homework afterall

[madf0x]

This is inaccurate.

A FK can reference the PK, but a PK is not what the FK references. a foreign key can reference any CK (Candidate Key) including the PK...

Part of what I meant when I said one of my answers was off, although I was mainly just referencing my earlier answer, not an end all be all FKs reference a CK.

but +1 for fact checking

[Cr1TH1T]

 


Everyone gets le cookie.