Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Intro to Database

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

By: Cassie Wilson
Start Studying

Decks in this class (17)

Chapter 6 Study Questions
______ functions operate on a sin...,
_________ functions operate on a ...,
An _________ function is sometime...
17  cards
Chapter 6 Application
Prepare a summary query that uses...,
Code a summary query that works o...,
Write a summary query on employee...
6  cards
Chapter 7 Study Questions
A ________ is a select statement ...,
A subquery coded within another s...,
An ____________ subquery is execu...
10  cards
Chapter 7 Application
Code a query with subquery to pro...,
Prepare a nested query that proje...,
Use the in operator in a query wi...
8  cards
Chapter 8 Study Questions
A columns ____ ____ specifies the...,
_________ ____ _____ are intended...,
The _______ ____ _____ are intend...
27  cards
Chapter 8 Application
Use format number decimal in a se...,
Use cast expression as casttype i...,
Use convert expression casttype i...
3  cards
Chapter 9 Application
Sort by the car column,
Sort by the car column explicitly...,
Sort by the car column implicitly...
11  cards
Chapter 10 Study Questions
A table in a relational database ...,
Within each table each column sto...,
Each table row stores one occurre...
20  cards
Chapter 11 Study Questions
The ____________ statement consis...,
___________ are used to enforce i...,
A n ___________________ is coded ...
18  cards
Chapter 11 Application
Issue a command to create a datab...,
Provide code to create a table na...,
Add a column named id data type i...
8  cards
Chapter 12 Study Questions
A n ____ consists of a select sta...,
Table s referenced in the select ...,
A view can also be referred to as...
14  cards
Chapter 17 Study Questions
The __________________________ ha...,
_________________ involves settin...,
The type of database file that co...
8  cards
Chapter 18 Study Questions
The _________ statement is used t...,
The __________ a user has to work...,
Use the ______ statement to set u...
14  cards
Chapter 19 Study Questions
A n ___________ includes the stru...,
A n __________________ only conta...,
A n ______________________ allows...
12  cards
Chapter 19 Application
Change to a directory with the my...,
Restore to copy a file of sql com...
2  cards
Chapter 18 Application
Login as user root to create a da...,
Have root grant privileges to dev...,
Show the privileges granted to th...
14  cards
Chapter 12 Application
Use the show create table tablena...,
Create a restrict view named numb...,
Materialize query the view number...
10  cards

More about
Intro to Database

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Cassie Wilson's Intro to Database 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.

Learn more about spaced repetition

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?

Intro to Software, Programming, and D...
  • 1 decks
  • 23 flashcards
  • 1 learners
Decks: 1 Computing Platforms And Software Apps, And more!
DATABASE SYSTEMS
  • 14 decks
  • 231 flashcards
  • 4 learners
Decks: Introduction To Databases, Introduction To Databases Ansi Sparc, Introduction To The Relational Model, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions