Database - Interview Questions and Answers for 'Ddl' | Search Interview Question - javasearch.buggybread.com
Javasearch.buggybread.com

Search Interview Questions


 More than 3000 questions in repository.
 There are more than 900 unanswered questions.
Click here and help us by providing the answer.
 Have a video suggestion.
Click Correct / Improve and please let us know.
Label / Company      Label / Company / Text

   



Database - Interview Questions and Answers for 'Ddl' - 3 question(s) found - Order By Newest

 Q1. What is the use of hbm2ddl Configuration in Hibernate ?Hibernate
Ans. This configuration specifies if hibernate should creates the Schema / Table on its own if the respective table is not found.

"update" doesn't create the table if it's not found whereas configuration set as "create" creates the schema automatically.

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     hibernate   hibernate configuration   hibernate.cfg.xml   hbm2ddl


Related Questions

  What are the contents of Hibernate configuration file ( hibernate.cfg.xml ) ?


 Q2. Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?Database
Ans. NOT NULL

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     sql   oracle   database   ddl   constraint   table creation


Related Questions

  What's the benefit for specifying constraints like Not Null , Primary Key explicitly instead of specifying it against the column ?
  How can we disable a constraint ?
  How to know the constraints on a Table in Oracle ?
 When do we generally get this database error - integrity constraint violated - parent key not found ?
 When do we generally get the database error - Unique Constraint Violated ?
 Write an SQL Statement to add a foreign key constraint in oracle ?
 What do you make out of this error

org.hibernate.exception.ConstraintViolationException: could not insert: [<Entity>]
Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<Constraint Name>) violated

and how would you go about debugging it ?
 What is ConstraintViolationException in Hibernate ?
 What are the different database constraint types ?


 Q3. Create a Table with 2 Columns and Insert a row into itDatabase
Ans. CREATE TABLE TABLE_NAME (
ID NUMBER PRIMARY KEY,
NAME VARCHAR(50) NOT NULL,
);

INSERT INTO TABLE_NAME(ID, NAME) VALUES(1, "Abc");

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     ddl  dml  create table  insert records into table     Asked in 1 Companies


Related Questions




Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked: