What is JDBC? Describe the steps needed to execute a SQL query using JDBC.

What is JDBC? Describe the steps needed to execute a SQL query using JDBC.
by

1 Answer

Answer :

Ans. The JDBC is a pure Java API used to execute SQL statements. It
provides a set of classes and interfaces that can be used by developers to write database applications.
The steps needed to execute a SQL query using JDBC:
1. Open a connection to the database. 2. Execute a SQL statement.
3. Process th results.
4. Close the connection to the database.
by

Related questions

For execution of DELETE SQL query in JDBC, ............. method must be used. A) executeQuery() B) executeDeleteQuery() C) executeUpdate() D) executeDelete()

Description : For execution of DELETE SQL query in JDBC, ............. method must be used. A) executeQuery() B) executeDeleteQuery() C) executeUpdate() D) executeDelete()

Last Answer : C) executeUpdate()

Preparedstatement Object in JDBC is used to execute ........................... queries. A) executable B) simple C) high level D) parameterized

Description : Preparedstatement Object in JDBC is used to execute ........................... queries. A) executable B) simple C) high level D) parameterized

Last Answer : D) parameterized

Prepared Statement object in JDBC used to execute........... queries. A) Executable B) Simple C) High level D) Parameterized

Description : Prepared Statement object in JDBC used to execute........... queries. A) Executable B) Simple C) High level D) Parameterized

Last Answer : D) Parameterized

Python has a SQL-like querylanguage called ________- a) GQL b) PL SQL c) NOSQL d) JDBC

Description : Python has a SQL-like querylanguage called ________- a) GQLb) PL SQL c) NOSQL d) JDBC

Last Answer : GQL

In JDBC ........................ imports all Java classes concerned with database connectivity. A) javax.sql.* B) java.mysql.* C) java.sql.* D) com.*

Description : In JDBC ........................ imports all Java classes concerned with database connectivity. A) javax.sql.* B) java.mysql.* C) java.sql.* D) com.*

Last Answer : C) java.sql.*

Describe, in general, how java's garbage collector works ?

Description : Describe, in general, how java's garbage collector works ?

Last Answer : Ans. The Java runtime environment deletes objects when it determines that they are no longer being used. This process is known as garbage collection. The Java runtime environment supports a garbage collector that ... not marked (i.e. are not referenced) are known to be garbage and are collected.

Describe what happens when an object is created in Java ?

Description : Describe what happens when an object is created in Java ?

Last Answer : Ans. 1. Memory is allocated from heap to hold all instance variables and implementation-specific data of the object and its superclasses. Implemenation-specific data includes pointers to class and ... for the base class completes first and constructor for the most derived class completes last.

What is constructor ?Describe its special properties?

Description : What is constructor ?Describe its special properties?

Last Answer : A constructor is a special method of class. which is invoked automatically , whenever an object of a class is created. It has the same name as its class and resides similar to a method. A constructor ... .  It can be overloaded.  It is automatically used to initialize the member of the object.

Describe the java garbage collection mechanism?

Description : Describe the java garbage collection mechanism?

Last Answer : Since objects are dynamically allocated by using the new operator, you might be wondering how such objects are destroyed and their memory released for later reallocation. The technique that accomplishes this is ... to be no longer needed, and the memory occupied by the object can be reclaimed.

How can I use the reverse method of the string buffer using Java?

Description : How can I use the reverse method of the string buffer using Java?

Last Answer : Show your attempt at using reverse() yourself, and one of us might help you fix/improve it. No one is going to write your homework for you.

How do I program a neural network from scratch using Java?

Description : How do I program a neural network from scratch using Java?

Last Answer : There are many implementations of neural networks... What will you be using it for? I wrote a fairly simple one in college in Java just using basic data types. Can you give me some more info?

Which interface provides the capability to store objects using a key-value pair?

Description : Which interface provides the capability to store objects using a key-value pair?

Last Answer : Ans. java.util.map

. Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Description : . Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Last Answer : d. SQL Injection attack

What is better: One big SQL query or several?

Description : What is better: One big SQL query or several?

Last Answer : It’s difficult without examples. But what you describe seems like a simple join.

Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Description : Help him in writing SQL query for the following purpose: (i) To count how many female candidates will be attending the training. -Technology

Last Answer : (i)Select count(name) from training where name like ‘Ms.%’;(ii) Select * from training where fee is NULL;(iii) Select city, fee from training where topic = ‘Cyber Security’;(iv) Alter table training add feedback varchar(20);

Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Description : Write SQL query to create a table “BOOKS” with the following structure: Table: BOOKS -Technology

Last Answer : Create table Books(BOOK_ID Integer (2) Primary Key,BOOK_NAME Varchar (20),CATEGORY Varchar (20),ISSUE_DATE Date);

Write SQL query to create a table “Registration” with the following structure: -Technology

Description : Write SQL query to create a table “Registration” with the following structure: -Technology

Last Answer : Create table Registration(Reg_Id Integer(2) Primary Key,Name varchar(20),Course varchar(10),Join_Dt date);

Write SQL query to create a table Inventory with the following structure : -Technology

Description : Write SQL query to create a table Inventory with the following structure : -Technology

Last Answer : CREATE TABLE Inventory(Material Id Integer Primary Key,Material Varchar (50) NOT NULL,Category Char,DatePurchase Date) :

Write SQL query to create a table Player with the following structure : -Technology

Description : Write SQL query to create a table Player with the following structure : -Technology

Last Answer : CREATE TABLE Player(};

Write SQL Query commands based on the following table: -Technology

Description : Write SQL Query commands based on the following table: -Technology

Last Answer : This answer was deleted by our moderators...

What is SQL Query ?

Description : What is SQL Query ?

Last Answer : SQL Query is a query that uses SQL 's DDL and DML languages to find , display , print , and perform certain conditions in one or more tables in a database .

In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed?

Description : In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed? 

Last Answer : ADO.NET handles most of the database communication for you behind-thescenes. You would only use SQL statements when generating ad-hoc queries for the database. You execute SQL statements by ... returning statements, such as DELETE, INSERT INTO, or UPDATE statements, use the ExecuteNonQuery method.

SQL stands for  Structured Query Language  Statistical Query Language  Superior Questions Lot  Superior Questions Lo

Description : SQL stands for   Structured Query Language   Statistical Query Language   Superior Questions Lot   Superior Questions Lo

Last Answer :  Structured Query Language

………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Description : ………………… is a full form of SQL. A) Standard query language B) Sequential query language C) Structured query language D) Server side query language

Last Answer : A) Standard query language

Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height>180); If the SQL queries (a) and (b) above, return 10 rows and 7 rows in the result set respectively, then what is one possible number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Description : Consider the following three SQL queries (Assume the data in the people table) : (a) Select Name from people where Age>21; (b) Select Name from people where Height>180; (c) Select Name from people where (Age>21) or (Height ... number of rows returned by the SQL query (c) ? (A) 3 (B) 7 (C) 10 (D) 21

Last Answer : (C) 10

Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 : SQ1 : Select * From R Full Join S On R.B=S.B; SQ2 : Select * From R Inner Join S On R.B=S.B; The numbers of tuples in the result of the SQL query SQ1 and the SQL query SQ2 are given by : (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Description : Suppose ORACLE relation R(A, B) currently has tuples {(1, 2), (1, 3), (3, 4)} and relation S(B, C) currently has {(2, 5), (4, 6), (7, 8)}. Consider the following two SQL queries SQ1 and SQ2 ... (A) 2 and 6 respectively (B) 6 and 2 respectively (C) 2 and 4 respectively (D) 4 and 2 respectively

Last Answer : (D) 4 and 2 respectively

In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats

Description : In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats 

Last Answer : (B) Fragments

What to you think of taking an eight week online Java cerfitcate from Robertson College?

Description : What to you think of taking an eight week online Java cerfitcate from Robertson College?

Last Answer : Eight week online Java cerfitcate from Robertson College not offered this year. Please just find me a good free online Java YouTube videos that worked for you? Also how do I purchase a Java and all its parts ... ? I just bought a Chromebook last month and will have to save money to buy a new laptop.

How do you say "java" in Spanish?

Description : How do you say "java" in Spanish?

Last Answer : answer:Cafe. Or, you can pronounce it haba.

How do I install Leximancer?

Description : How do I install Leximancer?

Last Answer : Double click it, jar files just run. You may have to start it through the command prompt.

What is your go-to cup of coffee - and what is your preferred brew?

Description : What is your go-to cup of coffee - and what is your preferred brew?

Last Answer : answer::) That’d be a one-shot soya latte, in a medium sized cup, from Costa… If I have to go to a Starbucks, it’s the same drink but in a large sized cup – their coffee is stronger. Note – soya milk in the UK is nowhere near as sweet as soy milk in the US. It’s more nutty in flavour.

Why abstraction in java is called as a mathematical entity?

Description : Why abstraction in java is called as a mathematical entity?

Last Answer : answer:Abstract data classes are analogous to mathematical constructions. In Euclidean geometry, for example, the axioms would be like the methods in an abstract Java class. Since the terms in the axioms ... allow you to work with types that really are undefined and that have to be instantiated.

How can I easily save a java game for offline use?

Description : How can I easily save a java game for offline use?

Last Answer : Can you maybe try this?

How do I autofill an adobe flash login popup?

Description : How do I autofill an adobe flash login popup?

Last Answer : answer:Set up your Firefox options- Make sure remember search & form history : is checked under Firefox Privacy settings. You could choose remember passwords from sites under Security if you want. And ... I start typing. All of the above might work better than roboform and work in Flash too.

Java Embedded Database for Global File System?

Description : Java Embedded Database for Global File System?

Last Answer : answer:Perhaps something like SQLite? I believe if shared on a GFS the application will lock the database during writing. And of course SQLite an embedded database, and can be used by Java as well as C++.

A coffee lover's question - or rather, the debunking of a java myth. Proceed with caution.

Description : A coffee lover's question - or rather, the debunking of a java myth. Proceed with caution.

Last Answer : Thankfully,no.I am a potter and throw stoneware mugs to sell to people who feel exactly as you do.there are alot of you out there :))

Why do Rails developers hate Java so much?

Description : Why do Rails developers hate Java so much?

Last Answer : Hating any tool makes no sense. You can’t hate tools, you can hate users or abusers thereof. But even that is not useful. Every tool has its use, and it may be ‘superior’ for a particular solution than another. That’s all there is.

Django in the enterprise?

Description : Django in the enterprise?

Last Answer : I think Glassfish + JRuby + Rails is pretty common. Perhaps Glassfish + Jython + Django?

How to format text (like bold, italic) in jabber/gtalk?

Description : How to format text (like bold, italic) in jabber/gtalk?

Last Answer : Not sure for jabber. But for Google Talk it's actually the same as for Fluther. Surround your text with the modifiers to style the string. Asterisks will make it bold, underscores will make it italicized, and dashes ... use it, but I don't know if a robot script will act the same. I hope that helps.

Why can't I get java to download?

Description : Why can't I get java to download?

Last Answer : Look at the help files. that is a known error with a known workaround. You have to kill a process, or uninstall your previous iteration.

Can an iPod touch run .jar games?

Description : Can an iPod touch run .jar games?

Last Answer : Nope, iPod touch doesn’t run Java, or Adobe :(

Can I set a 'limit' on an integer value in a java applet?

Description : Can I set a 'limit' on an integer value in a java applet?

Last Answer : At the beginning of the function, always check to see if ‘nowplaying’ is > 9. If it is, set it to 0 and then have the function run normally. I’m familiar with C++, so I can’t really help you with the syntax, but this should be pretty easy.

ajc gone blind?

Description : ajc gone blind?

Last Answer : answer:These folks are having the same problem. I don’t know much about this type of stuff, but they do. http://forum.springsource.org/archive/index.php/t-25945.html

Can you play runescape on an iPhone?

Description : Can you play runescape on an iPhone?

Last Answer : Oh dear.

Which Jabber server software has the smallest memory footprint?

Description : Which Jabber server software has the smallest memory footprint?

Last Answer : answer:Andrew, I not sure what version of Wildfire (now called OpenFire) you are using?We are running Wildfire at my work on WinTel boxes and its memory footprint is small. I've also used ... this document that compares the various Jabber servers with an extensive list of features. Good Luck! R

Can I get MobiTV or Java on my iPhone?

Description : Can I get MobiTV or Java on my iPhone?

Last Answer : you can’t get Java because you can’t change the iPhone it’s self. But just try a Slingbox for mobile tv after the SDK.

How to open Textmate for a .java document since the begining?

Description : How to open Textmate for a .java document since the begining?

Last Answer : answer:You can’t do that with TextMate as far as I know. You could, however make a shell script that does something like: touch $1.java mate $1.java Where $1 is the path and file name passed as an argument (eg: `./script.sh Class`)