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;
11 Cards in this Set
- Front
- Back
How would you find out the total number of rows in a table?
|
Use SELECT COUNT(*) ... in query
|
|
How do you eliminate duplicate values in SELECT ?
|
Use SELECT DISTINCT ... in SQL query
|
|
How you insert records into a table ?
|
Using SQL INSERT statement
|
|
How do you delete record from a table ?
|
Using DELETE statement
|
|
What's the difference between a primary key and a unique key?
|
Primary key wont allow nulls, unique key allow nulls.
|
|
What is a join and explain different types of joins?
|
INNER JOIN
OUTER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN INNER JOIN |
|
What is a transaction ?
|
transaction is a logicl unint of work. All steps must be commited or rolled back.
|
|
What is ACID ?
|
Atomicity, Consistency, Isolation and Durability, these are properties of a transaction.
|
|
What is Normalisation ?
|
In relational database design, the process of organizing data to minimize redundancy. Results in a series of distinct yet related tables.
|
|
What is Stored Procedure?
|
A stored procedure is a named group of SQL statements that have been previously created and stored in the server database
|
|
What is Trigger?
|
A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.
|