This class was created by Brainscape user Ally Thomas. Visit their profile to learn more about the creator.

Decks in this class (13)

Normalization
What is 1nf,
What is 2nf,
What is 3nf
20  cards
PL/SQL
What is the basic syntax for a block,
What are anonymous blocks,
What are named blocks
13  cards
Procedures, Functions, Triggers
What is the basic syntax for crea...,
What is the basic syntax for crea...,
Do these need declare statements ...
15  cards
Basic SQL
Name 6 aggregate functions,
Whats the syntax for creating a p...,
Whats the syntax for creating a f...
11  cards
PL/SQL Collections
Which collections allow holes,
Which collections do not allow holes,
Which collections are empty at de...
27  cards
Autonomous Transactions
A transaction starts when one of ...,
A transaction ends when one of th...,
A transaction is made permanent b...
13  cards
Packages
What are packages,
What are the two components of a ...,
What is the package specification
12  cards
CASE Statements and expressions
The oracle plsql case statement h...,
What types of datatypes can a cas...,
Can different cases in a case sta...
13  cards
Cursors
What are the two types of cursors,
What are implicit cursors,
What are explicit cursors
16  cards
Views
What is a view,
What is the syntax for creating a...,
What happens when you update the ...
6  cards
Triggers
What are triggers,
What events can be used to execut...,
What is the syntax for creating a...
9  cards
Indexes
What is indexing,
What is a index,
What is the first column in an index
11  cards
Logical Structures
What are the logical structures f...,
What are data blocks,
What are extents
11  cards

More about
COSC 404

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Ally Thomas's COSC 404 flashcards now!

How studying works.

Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.

Add your own flashcards.

Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!

What's Brainscape anyway?

Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.

We use an adaptive study algorithm that is proven to help you learn faster and remember longer....

Looking for something else?

COSC 360
  • 7 decks
  • 138 flashcards
  • 1 learners
Decks: Platform As A Service, App Engine, Heroku, And more!
COSC 326 - MEP II
  • 3 decks
  • 186 flashcards
  • 13 learners
Decks: Exam 1 Hvac, Exam 2, Exam 3, And more!
COSC 407
  • 3 decks
  • 50 flashcards
  • 5 learners
Decks: Chapter 3, Chapter 2, Chapter 1, And more!
COSC 2P13
  • 3 decks
  • 55 flashcards
  • 19 learners
Decks: Chapter 1, Chapter 2, Chapter 3, And more!
Make Flashcards