- What is relational database
- What are indexes? What are the advantages
- What is the difference between filters and conditions
- What is the difference between DBMS and RDBMS
- Explain about the critical recovery scenario you had experienced
- What do you mean by implementation
- Write a query to Find the Maximum second value in table
- What are the differences you find when working with oracle 91 and sql server 2005
- What file is read by ODBC to load drivers
- Can we assign Explicitly transaction to a rollback segment
- How the status of the Rollback segment can be viewed
- Are Constraints exported through Export command
- What is the use of NOARCHIEVELOG parameter in Database
- Which parameters are optional in init.ora parameter file
- Can the User set Archive file name formats
- Can the SNAPSHOTS be refreshed automatically
- What is the use of EXP command
- How the SMON process is used to write into LOG files
- When the SYSTEM TABLESPACE can be made off-line
- What are the different Sequence of events takes place while starting a Database
- What are the types of Calculated columns available
- What are the SQL clauses supported in the link property sheet
- What is TERM
- What are the different file extensions that are created by Oracle
- What Kind of COMMENT statements placed within SQL statements
- For a field in a repeating frame, can the source come from a column
- How many number of columns can a RECORD GROUP have
- Can we create a List of Values without any RECORD GROUP
- Oracle precompiler translates the EMBEDDED SQL statements into
- Can an Alert message be changed at runtime
- What is an ALERT
- What is a RADIO GROUP
- What is a Built_in subprogram
- When is a .FMB file extension is created in Forms 4.5
- Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5
- Can you copy the PROGRAM UNIT into an Object group
- How do you pass values from one form to another form
- Can we attach the same List of Values to different fields in Design time
- When a form is invoked with CALL_FORM does Oracle forms issues
- Is it possible to Disable the Parameter form while running the report
- Which command ENQUEUE_RESOURCES parameter information is derived from
- What is Library in Forms 4.0
- What is the List of Values (LOV) supports
- What do you mean by Checkbox
- Can A CONTROL BLOCK can sometimes refer to a Base table
- What is GET_BLOCK property
- What is built-in Subprogram
- When do you get a .PLL extension
- How can you CALL Reports from Forms4.0
- What is the use of SYSTEM.EFFECTIVE.DATE variable
- What SYSTEM VARIABLE is used to refer DATABASE TIME
- Can we use a restricted packaged procedure in WHEN_TEXT_ITEM trigger
- Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger
- What type of file is used for porting Forms 4.5 applications to various platforms
- What built-in procedure is used to get IMAGES in Forms 4.5
- What will the SHOW_ALERT function returns
- Can we pass RECORD GROUP between FORMS
- What built in subprogram is used to manipulate images in image items
- What are the different events in Triggers
- What are the the different Data Manipulation Language statements are
- What is Data Definition Language
- Explain different types of Views? Inbound-Solutions
- What the REPLACE ('JACK AND JUE','J', and ?BL?) will return
- What is the Result of the following 'VIK'||NULL||?RAM?
- Is it possible to Enable or Disable a Database trigger
- What is "TABLE" data type
- PL/SQL supports which data types
- What is dedicated server configuration
- Which factors does not affect the size of the SGA
- How the size of the table space can be increased
- When A set of Dictionary tables are created
- What is a DATABLOCK
- What does a COMMIT statement do to a CURSOR
- Where a Database Procedure is stored
- Explain what is an Exception
- Explain about User Defined Exceptions
- Does the Database trigger will fire when the table is TRUNCATED
- Is it possible to use Transactional control statements in Database
- Is it possible to open a cursor which is in a Package in another database
- What the SUBSTR will return
- What the TRANSLATE will return
- Is it possible to modify a Data type of a column when column contains values
- If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate value
- Can A column defined as PRIMARY KEY can have NULL values
- When All data files related to a Table space are removed
- Explain ERASE packaged procedure
- What is a trigger?
- Name the two files that are created when you generate a form
- What is SQL FORMS
- Which of the packaged procedure is UNRESTRICTED
- What is the maximum size of the page
- What is post back trigger
- What does DLL stands for
- What are the advantages of a client or server model
- Why is it better to use an Integrity Constraint to validate data
- What is the difference between a LIST BOX and a COMBO BOX
- What are the advantages of GUI systems
- Can a DIALOG WINDOW have scroll bar attached to it
- What is the difference between a MESSAGEBOX and an ALERT
- What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW
- Can Constraints cannot be exported through EXPORT command
- Where the Databases overall structure is maintained
- What is the use of SET TRANSACTION USE ROLLBACK SEGMENT
- Where does the LGWR process write information
- What is the use of Snapshot
- What are the factors causing the reparsing of SQL statements in SGA
- What are the basic elements of Base configuration of an oracle Database
- What is a SQL * NET
- What is the mechanism provided by ORACLE for table replication
- Describe two phases of Two-phase commit
- What is Two-Phase Commit
- What is Distributed database
- What is cursor and where do you use them
- What is the use of ROWS option in IMP command
- What is the use of INDEXES option in IMP command
- What is the use of GRANT option in IMP command
- What is the use of IGNORE option in IMP command
- What is the use of SHOW option in IMP command
- What is the use of FILE option in IMP command
- What is use of LOG (Ver 7) option in EXP command
- What is the use of CONSISTENT (Ver 7) option in EXP command
- What is the use of ANALYSE ( Ver 7) option in EXP command
- What is the use of PARFILE option in EXP command
- What is the use of INCTYPE option in EXP command
- What is the use of RECORD LENGTH option in EXP command
- What is the use of TABLES option in EXP command
- What is the use of OWNER option in EXP command
- What is the use of FULL option in EXP command
- What is the use of CONSTRAINTS option in EXP command
- What is the use of ROWS option in EXP command
- What is the use of COMPRESS option in EXP command
- What is the use of FILE option in EXP command
- What is hot backup and how it can be taken
- What is the different kind of export backups
- What is cold backup? What are the elements of it
- What is a logical backup
- What are the different methods of backing up oracle database
- What are the steps involved in Instance Recovery
- What is Log Switch
- What is Archived Redo Log
- What is Mirrored on-line Redo Log
- What is On-line Redo Log
- What is Partial Backup
- Can Full Backup be performed when the database is open
- What is Full Backup
- What are the different modes of mounting a Database with the Parallel Server
- What is Restricted Mode of Instance Startup
- What are the steps involved in Database Shutdown
- What is the use of RECORD option in EXP command
- What are the advantages of operating a database in ARCHIVELOG mode over operating
- Where the Transactions per rollback segment are derived
- Where ENQUEUE resources parameter information is derived