Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
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

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/16

Click to flip

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]