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;
4 Cards in this Set
- Front
- Back
LEFT JOIN keyword? |
It returns all rows from the left table with the matching rows in the right. |
|
A view? |
View is a virtual table based on the result-set of an sql statement. It contains rows and columns just like a real table. |
|
MongoDB? |
It is document-oriented database. Like NoSQL database, MongoDB avoids the traditional table-based relational database structure, but it is JSON-LIKE document with dynamic schemas to be easier and faster. |
|
Parallel querying in database? |
Parallel query works by creating several parallel query processes that divide the workload of a sql statement. These processes operate on objects in parallel and can therefore greatly reduce overall execution time. |