- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
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]
|
