Interested to Buy Any Domain ? << Click Here >> for more details...
Can you define a foreign key, with a key from the same
table?
- 2 Answers
- 6899 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhay
No, foreign key in a table is a reference from another
table, making a key foreign in the table itself will not be
useful for anything since the table will reference itself
during a query
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / samsudeen
Foreign key is a reference key of the Database.
if u set the foreing key refernece to the table, its make
the relation between two table.
| Is This Answer Correct ? | 0 Yes | 1 No |
When does the result for an sql statement return null?
What does connection pooling mean ?
Which type of driver is unique in jdbc?
What is the most common example type 1 driver?
Explain the two tier and three tier architecture of jdbc.
dear friends I have made connection with SQLSERVER where the following code is compiling properly but giving error at the runtime . I think error in this line where i am sending the value through string Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); import java.sql.*; //import mssqlserver.*; public class TestSQLCON { public TestSQLCON() throws Exception { // Get connection DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver()); System.out.println(); System.out.println("Successfully connected one"); System.out.println(); Connection connection = DriverManager.getConnection ( "jdbc:microsoft:sqlserver://localhost:1433","sa",""); if (connection != null) { System.out.println(); System.out.println("Successfully connected"); System.out.println(); // Meta data DatabaseMetaData meta = connection.getMetaData(); System.out.println("\nDriver Information"); System.out.println("Driver Name: " + meta.getDriverName()); System.out.println("Driver Version: " + meta.getDriverVersion()); System.out.println("\nDatabase Information "); System.out.println("Database Name: " + meta.getDatabaseProductName()); System.out.println("Database Version: "+ meta.getDatabaseProductVersion()); } } public static void main (String args[]) throws Exception { TestSQLCON test = new TestSQLCON(); } } so please help me
What are different types of ResultSet?
What are the jdbc drivers in java?
What happens if we don't close the connection in jdbc?
What are statements in JAVA ?
How can I create a custom RowSetMetaData object from scratch?
What is represented by the connection object?
Core Java 
