Related InterviewSolutions

• Which statement is true regarding external tables?(a) The default REJECT LIMIT for external tables is UNLIMITED(b) The data and metadata for an external table are stored outside the database(c) ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table(d) The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external tableThe question was posed to me in final exam.The query is from Implementation of Isolation Levels topic in section Transactions of Database Management
• How many types of recovery control techniques:(a) 2(b) 3(c) 4(d) 5This question was addressed to me in an international level competition.This interesting question is from Querying database part 5 in chapter Transactions of Database Management
• Who developed the normalization process:(a) E.F. codd(b) F.F. codd(c) E.E. codd(d) None of the mentionedThe question was asked in an international level competition.Query is from Querying Database in section Transactions of Database Management
• The storage structure which do not survive system crashes are ______(a) Volatile storage(b) Non-volatile storage(c) Stable storage(d) Dynamic storageI had been asked this question in an interview.This interesting question is from Storage Structure in section Transactions of Database Management
• Which of the following SQL command can be used to modify existing data in a database table?(a) MODIFY(b) UPDATE(c) CHANGE(d) NEWThe question was posed to me in unit test.My question is from A Simple Transaction Model topic in chapter Transactions of Database Management
• Which of the following is TRUE for the System Variable $date$?(a) Can be assigned to a global variable(b) Can be assigned to any field only during design time(c) Can be assigned to any variable or field during run time(d) Can be assigned to a local variableThis question was posed to me in examination.Question is taken from A Simple Transaction Model topic in portion Transactions of Database Management
• Which character function can be used to return a specified portion of a character string?(a) INSTR(b) SUBSTRING(c) SUBSTR(d) POSI had been asked this question during an interview for a job.Enquiry is from A Simple Transaction Model topic in chapter Transactions of Database Management
• In SQL, the CREATE TABLESPACE is used(a) To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace(b) To create a database trigger(c) To add/rename data files, to change storage(d) All of the mentionedThe question was asked in exam.Query is from A Simple Transaction Model in chapter Transactions of Database Management
• To delete a database ___________ command is used(a) Delete database database_name(b) Delete database_name(c) drop database database_name(d) drop database_nameI had been asked this question in an international level competition.Asked question is from Querying database part 3 topic in portion Transactions of Database Management
• SDL means _____________(a) Storage Discrete Language(b) Storage Definition Language(c) Storage Definition Localisation(d) Storage Discrete LocalisationThis question was addressed to me in an internship interview.I would like to ask this question from Storage Structure in section Transactions of Database Management