Related InterviewSolutions

• Which of the following is the right syntax for the assertion?(a) Create assertion ‘assertion-name’ check ‘predicate’;(b) Create assertion check ‘predicate’ ‘assertion-name’;(c) Create assertions ‘predicates’;(d) All of the mentionedThe question was asked in an international level competition.My question is from Integrity Constraints in chapter SQL : Queries, Constraints and Triggers of Database Management
• In order to maintain the consistency during transactions, database provides(a) Commit(b) Atomic(c) Flashback(d) RetainI have been asked this question in a job interview.This is a very interesting question from Transactions in chapter SQL : Queries, Constraints and Triggers of Database Management
• In case of any shut down during transaction before commit which of the following statement is done automatically?(a) View(b) Commit(c) Rollback(d) FlashbackThe question was asked by my college director while I was bunking the class.This is a very interesting question from Transactions in portion SQL : Queries, Constraints and Triggers of Database Management
• In SQL the cross-tabs are created using(a) Slice(b) Dice(c) Pivot(d) All of the mentionedThe question was posed to me in an online interview.This question is from OLAP topic in division SQL : Queries, Constraints and Triggers of Database Management
• In authorization graph, if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct?(a) If DBA revokes authorization from u1 then u2 authorization is also revoked(b) If u1 revokes authorization from u2 then u2 authorization is revoked(c) If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked(d) If u2 revokes authorization then u1 authorization is revokedThe question was asked in an online quiz.The above asked question is from Authorizations topic in division SQL : Queries, Constraints and Triggers of Database Management
• The user defined data type can be created using(a) Create datatype(b) Create data(c) Create definetype(d) Create typeThe question was asked in my homework.I'd like to ask this question from SQL Data Types and Schemas topic in portion SQL : Queries, Constraints and Triggers of Database Management
• Which of the following is used to store movie and image files?(a) Clob(b) Blob(c) Binary(d) ImageI have been asked this question in unit test.This intriguing question originated from SQL Data Types and Schemas in portion SQL : Queries, Constraints and Triggers of Database Management
• Data integrity constraints are used to:(a) Control who is allowed access to the data(b) Ensure that duplicate records are not entered into the table(c) Improve the quality of data entered for a specific property (i.e., table column)(d) Prevent users from changing the values stored in the tableThis question was posed to me during an interview for a job.This question is from Integrity Constraints topic in portion SQL : Queries, Constraints and Triggers of Database Management
• The number of attributes in relation is called as its(a) Cardinality(b) Degree(c) Tuples(d) EntityThe question was asked by my school principal while I was bunking the class.This interesting question is from Set Operations topic in portion SQL : Queries, Constraints and Triggers of Database Management
• If we want to retain all duplicates, we must write ________ in place of union.(a) Union all(b) Union some(c) Intersect all(d) Intersect someThe question was posed to me during an internship interview.This interesting question is from Set Operations topic in portion SQL : Queries, Constraints and Triggers of Database Management