Explain 3 types of anomalies in tables?

              I.      Insertion anomaly: A new row cannot be inserted unless all primary key values are supplied.

           II.      Deletion anomaly: Deleting a row results in the loss of important information not stored elsewhere.

         III.      Modification anomaly: A simple update must be applied to multiple rows.

 

 

 

Name different types of DBMS Interfaces?

               I.      Menu-Based Interfaces for Web Clients or Browsing

             II.      Forms-Based Interfaces

           III.      Graphical User Interfaces

           IV.      Natural Language Interfaces

             V.      Interfaces for Parametric Users

           VI.      Interfaces for the DBA

 

What is the first steps in obtaining a Connection  under JDBC?

               I.      Set up the database URL

 

             II.      A database URL (or JDBC URL) is a platform independent way of adressing a database.

           III.      A database/JDBC URL is of the form

           IV.      jdbc:[subprotocol]:[node]/[databaseName]

 

 

 

 

What are the criteria you use for Selecting a DBMS

               I.      Data definition functionality

             II.      Physical criteria

           III.      Access criteria

           IV.      Transactions

             V.      Utilities

           VI.      Development tools

         VII.      Miscellaneous features

 

 

How to align partitiom? Performance benefits?

 

Diskpar.exe is used for aligning a partition at the storage level, to align at 64 KB ,can result in 20-30% performance improvement.

How to improve I/O performance?

 

Disabling inflow control allows the writing the I/O to cache

 

Explain I/O characteristics?

 

Random, Sequential, Reads, Writes

What types of application transactions you have worked with?

 

Apps with Higher % of I/O content

Email, DSS, and Rich Media

 

Apps with Higher % of CPU content

OLAP, CRM, and ERP

 

 

What  statements have you used?

I have used three types of statements:

 

               I.      Statement – Executes a standard query

             II.      PreparedStatement – Executes a precompiled SQL statement

           III.      CallableStatement – Executes non-SQL Statement

 

What is Metadata?

Metadata is data (or information) about data. JDBC allows the programmer to discover a large amount of information about a database and any given ResultSet via metadata classes.

 

Explain the use of ODBC?

ODBC (Open Database Connectivity), a C-based interface to SQL-based database engines, provides a consistent interface for communicating with a database and for accessing database metadata (information about the database system vendor, how the data is stored, and so on).

Individual vendors provide specific drivers or "bridges" to their particular database management system. Consequently, thanks to ODBC and SQL, I can connect to a database and manipulate it in a standard way. It is no surprise that, although ODBC began as a PC standard, it has become nearly an industry standard.

I have used it as a front-end accessing data from an Oracle back-end using the Oracle ODBC Driver.

 

 

What are the criteria you use for Selecting a DBMS

               I.      Data definition functionality

             II.      Physical criteria

           III.      Access criteria

           IV.      Transactions

             V.      Utilities

           VI.      Development tools

         VII.      Miscellaneous features

 

Explain Functional dependency

Constraints that are derived from the meaning and interrelationships of the data attributes

 

What considerations you take while selecting an application interface GUI

               I.      Descriptive page titles

             II.      Clear instructions

           III.      Consistent grouping of input fields

           IV.      Logically labeled fields

             V.      Consistent color use

           VI.      Properly sized data entry fields

         VII.      Logical cursor movement

       VIII.      Error messages

          IX.      Clearly indicated optional fields

            X.      Completion message

 

 

Explain conceptual database design process

               I.      Identifying entities

             II.      Identifying attributes and attribute domains for entities

           III.      Identifying relationships

           IV.      Identifying candidate and primary keys for entities

             V.      Creating an Entity-Relationship diagram

           VI.      Reviewing the ER model by the user and design team

 

 

Explain Numeric Data Types

 

               I.      SQL defines many different numeric types

             II.      Numeric types are classified as either exact or approximate

 

Explain SQL Data Types

 

1)       Numeric

2)       Temporal

3)       Character

4)       Locator-Based Data Types

a.        Arrays, CLOBS, and BLOBs

 

Explain the Cardinality of Relationship?

While creating relationship between two entities, it simply means that how many entities of the first set are related to how many entities of the second set.

 

What  statements have you used?

I have used three types of statements:

 

               I.      Statement – Executes a standard query

             II.      PreparedStatement – Executes a precompiled SQL statement

           III.      CallableStatement – Executes non-SQL Statement

 

What is Metadata?

Metadata is data (or information) about data. JDBC allows the programmer to discover a large amount of information about a database and any given ResultSet via metadata classes.

 

What is Normalization?

 

The process by which we efficiently organize data to achieve

These goals:

               I.      Eliminating redundancy

             II.      Ensuring data is stored in the correct table

           III.      Eliminating need for restructuring database when data is added.

 

Explain First Normal Form (1NF)

               I.      There are no repeating or duplicate fields.

             II.      Each cell contains only a single value.

           III.      Each record is unique.

 

 

What are the criteria you use for Selecting a DBMS

               I.      Data definition functionality

             II.      Physical criteria

           III.      Access criteria

           IV.      Transactions

             V.      Utilities

           VI.      Development tools

         VII.      Miscellaneous features

 

Explain Functional dependency

Constraints that are derived from the meaning and interrelationships of the data attributes

 

What considerations you take while selecting an application interface GUI

               I.      Descriptive page titles

             II.      Clear instructions

           III.      Consistent grouping of input fields

           IV.      Logically labeled fields

             V.      Consistent color use

           VI.      Properly sized data entry fields

         VII.      Logical cursor movement

       VIII.      Error messages

          IX.      Clearly indicated optional fields

            X.      Completion message

 

 

Explain conceptual database design process

               I.      Identifying entities

             II.      Identifying attributes and attribute domains for entities

           III.      Identifying relationships

           IV.      Identifying candidate and primary keys for entities

             V.      Creating an Entity-Relationship diagram

           VI.      Reviewing the ER model by the user and design team

 

Define Recursive foreign key 

 

A foreign key in a relation that references the primary key values of that same relation.

 

Define Normalization 

The process of decomposing relations with anomalies to produce smaller, well-structured relations.

 

Define Composite key 

A primary key that consists of more than one attribute.

 

 

Where should you check Cache utilization on SAN?

 

               I.      Disk Parity Group

             II.      DB Instance

           III.      Tablesapce

           IV.      Index