Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
16 Cards in this Set
- Front
- Back
|
SELECT identifies...
|
which columns
|
|
|
FROM identifies...
|
which tables
|
|
|
What does DISTINCT do?
|
Suppresses duplicates
|
|
|
Are SQL statements case-sensitive?
|
No
|
|
|
Can keywords be split across lines?
|
Yes
|
|
|
Can tabs and spaces be used to make readible code?
|
Yes
|
|
|
What are four (4) ways to execute a SQL statement
|
1) ; at end
2) / on last line in buffer 3) / at SQL prompt 4) Issue SQL*Plus RUN command at SQL prompt |
|
|
Is date in result left or right justified?
|
Left
|
|
|
How can you change column header to lowercase
|
Select Field1 "Field1"...
|
|
|
What is a null?
|
A value that is unavailable, unassigned, unknown, or inapplicable
|
|
|
What is 12+(12*null)?
|
null
|
|
|
What is concatenation operator?
|
||
|
|
|
What is a literal?
|
A character, expression, or number included in the SELECT list
|
|
|
What is SQL buffer?
|
a part of memory that stores SQL statements
|
|
|
What command shows the strucutre of a table
|
DESC[RIBE]
|
|
|
How do you list contents of sql buffer?
|
L[IST]
|
