O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Flashcards

SQL

Andrew Dickinson Inglês 38 flashcards

Flashcards do conjunto (38)

  1. 1Relational DatabaseRelies on implementation of SQL. The applications that host multiple databases
  2. 2What is SQLStructured Query Language. Used to implement actions to a database, whether create, manipulate, or delete.
  3. 3How do we use SQL on a DatabaseWe use sql through the 5 sublanguages to create, modify, delete.
  4. 4What are the 5 sub-languages in SQLDDL, TCL, DCL, DML, DQL
    Data Definition Language
    Transaction Control Language
    Data Control Language
    Data Manipulation Language
    Data Query Language
  5. 5What are the Commands for DDLCreate Alter Drop Truncate
  6. 6What are the commands of the TCLCommit, Savepoint, Rollback
  7. 7What are the commands of the DQLSelect
  8. 8What are the commands of the DCLThe Data Control Language uses Grant or Revoke.
  9. 9Commands of the DMLInsert, Update, delete
  10. 10What are the Acid Properties of TransactionsA.Atomic
    C. Consistent
    I.Isolated
    D.Durable
  11. 11What does it mean for a transaction to be Atomic, Consistent, Isolated, DurableThe transaction has statements unable to be divisible/split up anymore.
    The statements are Consistent, meaning that always returns true if it runs true or false if it runs false.
    Isolated meaning that the work one person does on a database will not affect someone else's experience.
    Durable meaning the changes are committed forever
  12. 12What are the different types of joins?Inner Join, Self Join, Left Join, Right Join, Left (if Null) Join, Right (if Null) Join, Full Join, Cross Join
  13. 13What is a Inner JoinWhere two tables that share common information join off of that.
  14. 14What is Self JoinA way of one table joining itself to test the values
  15. 15What is Left JoinThe use of the common language from two tables and shows the first mentioned table as well as the shared information
  16. 16What is Right JoinThe use of the common information from the two tables, but shows the second mentioned table instead with the shared information
  17. 17Full JoinThis joins the two tables entirely
  18. 18Cross JoinTakes the column from table A and forces the combination with column b whether or not they are related
  19. 19Differences between Union and Union AllUnion returns Unique Data meaning no duplicates and no Null.
    Union All returns everything
  20. 20What is a trigger?Special type of stored procedures that auto executes when an event occurs
  21. 21What is a sequenceOrder list of numbers to count things
  22. 22What is a functionA common language runtime routine that uses parameters and performs actions
  23. 23How do you query a record?Request for information from a database using select
  24. 24How do you insert?Insert into (table name) values (column name values)
  25. 25How do you updateUpdate (table name) set (coulmn name = (new information)) where (criteria to be met)
  26. 26How do you deleteDelete from (table name) where (column name = title)
  27. 27What piece of information is returned from an insert update delete?The statistics shows how many rows are affected and then if you look at the table being affected you can see the changes
  28. 28What is a constraint violationWhen creating a table column and constraint for the column does not satisfy the values that can be implemented
  29. 29What is a cursorAn abstract ruleset temporary work area in the system memory
  30. 30How to create any one of the aboveTo create a cursor:
    Create or replace function funcname()
    returns reference as $$
    declare the cursor begin function end
    Then create a do implementation to use the cursor
  31. 31What is an idexDetermines the order of the information in the table
  32. 32What is referential integrityData linked between two or more tables using a foreign key that references a primary key that is in the parent table
  33. 33What are the constraints you can put on a table columnData types, Not Null, Primary and Foreign Key
  34. 34What are the interfaces of JDBCConnection Statement Prepared Statement, Callable Statment
  35. 35What is a JDBC DriverPostgre SQL
  36. 36Difference between Statement Prepared Statement and Callable StatementStatement is used for a general purpose of accessing data in the database.
    Prepared Statement is used when planning to use a statement multiple times
    Callable statements used to execute a call to a database stored procedure
  37. 37What is a RulesetSet of rows from a database as well as metadata about the query such as column names
  38. 38Explain the DAO patternThe design communicates from an object which communicates to the data access objects which communicates with the data source

Informações

Descrição
FlashCards sobre SQL, criado por Andrew Dickinson em 02-01-2019.
Visualizações
5
Avaliação

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?