(Answer is in bold)
- The definition of Information System
- foreign key constraint
- odbc (c refers to connectivity)
- dbms is interface between database and program (From the book "The design of DBMS must take into account the interface between the DBMS and operating system")
- IBM's IMS uses hierarchical DBMS
- referential integrity rule applies to foreign keys
- QBE(query by example)
- Count(*)
- grouped query (GROUP BY)
- restricting groupings (HAVING clause)
- nested query
- BCNF: if and only if, every determinant is a candiate key
- create schema, domain, table, view (DDL)
- grant (revoke cascade|restrict )
- UML(multiplicity of relation)
- Armstrong’s axiom
- update anomaly
- UK’s 1998 Data Protection Act (people cannot erase the data)
- data types
- create database is normalised
- In MS access, input mask is used for data entry
- normalisation is a data validation technique
- UML notation, like natural join, selection, projection, etc.
- first develop DB model then process normalization (ch 17.2)
- (jdbc) executeQuery, what does rs.next() do? Moves the cursor froward one row from its current position
// answer source: http://docs.oracle.com/javase/6/docs/api/java/sql/ResultSet.html#next%28%29
ResultSet rs = stmt.executeQuery();
rs. next()Disclaimer: This post is copied from there