Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What is user Account in Oracle database?
- Correct Answer
- An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges 95 When will the data in the snapshot log be used? - We must be able to create a after row trigger on table (ie, it should be not be already available) After giving table privileges We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log The master table name should be less than or equal to 23 characters (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name)
- 1. What are the responsibilities of a Database Administrator? Discuss
- 2. What are the database administrators utilities available? Discuss
- 3. What is the use of ANALYZE command? Discuss
- 4. What is database clusters? Discuss
- 5. What is Distributed database? Discuss
- 6. What is the difference between OLE Server & OLE Container? Discuss
- 7. What is relation between the window and canvas views? Discuss
- 8. What are the built-ins used for finding Object ID function? Discuss
- 9. What is WHEN-Database-record trigger? Discuss
- 10. In a database table, the category of information is called
Options- A. Record
- B. Field
- C. Tuple
- D. None of the above Discuss
Technology problems
Search Results
Correct Answer: - Installing and upgrading the Oracle Server and application tools - Allocating system storage and planning future storage requirements for the database system - Managing primary database structures (tablespaces) - Managing primary objects (table, views, indexes) - Enrolling users and maintaining system security - Ensuring compliance with Oracle license agreement - Controlling and monitoring user access to the database - Monitoring and optimizing the performance of the database - Planning for backup and recovery of database information - Maintain archived data on tape - Backing up and restoring the database - Contacting Oracle Corporation for technical support
Correct Answer: SQL * DBA - This allows DBA to monitor and control an ORACLE database SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database
Correct Answer: To perform one of these function on an index, table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary - To delete statistics about the object used by object from the data dictionary - To validate the structure of the object - To identify migrated and chained rows off the table or cluster
Correct Answer: Group of tables physically stored together because they share common columns and are often used together is called Cluster
Correct Answer: A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database The data of all databases in the distributed database can be simultaneously accessed and modified
Correct Answer: An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex OLE servers are ms_word & ms_excel OLE containers provide a place to store, display and manipulate objects that are created by ole server applications Ex oracle forms is an example of an OLE Container
Correct Answer: Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc,) and boilerplate objects (boxes, lines, images etc,) that operators interact with us they run your form Each canvas views displayed in a window
Correct Answer: FIND_GROUP(function) FIND_COLUMN(function)
Correct Answer: Fires when oracle forms first marks a record as an insert or an update The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item
Correct Answer: Field
Explanation:
In a database table, the category of information is called Field.
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.