Discussion
Home ‣ Interview ‣ Technology Comments
- Question
What are the Referential actions supported by FOREIGN KEY integrity constraint?
- Correct Answer
- UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted
- 1. What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode? Discuss
- 2. What is a DBA? Discuss
- 3. Which among the following are the capabilities of the Cursor?
Options- A. It reads every row one by one.
- B. It can be parameterised and hence are flexible
- C. It can be positioned to specific rows
- D. All the above Discuss
- 4. What is meant by a dedicated computer?
Options- A. Which is assigned one and only one task
- B. Which is meant for application software
- C. Which is used by one person only
- D. Which uses one kind of software Discuss
- 5. Which standard govern parallel communications?
Options- A. CAT 5
- B. RS232
- C. RS-232a
- D. IEEE 1284 Discuss
- 6. A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables? Discuss
- 7. How would you go about increasing the buffer cache hit ratio? Discuss
- 8. Explain an ORA-01555? Discuss
- 9. What does a Control file Contain? Discuss
- 10. Describe what redo logs are. Discuss
Technology problems
Search Results
Correct Answer: Complete database recovery from disk failure is possible only in ARCHIVELOG mode Online database backup is possible only in ARCHIVELOG mode
Correct Answer: A DBA is a Database Administrator, and this is the most common job that you find a database specialist doing There are Development DBAs and Production DBAs - A Development DBA usually works closely with a team of developers and gets more involved in design decisions, giving advice on performance and writing good SQL That can be satisfying at a human level because you are part of a team and you share the satisfaction of the teams accomplishments - A Production DBA (on the other hand) is responsible for maintaining Databases within an organization, so it is a very difficult and demanding job He or she, often gets involved when all the design decisions have been made, and has simply to keep things up and running Therefore, of course, it is also a rewarding job, both financially and in terms of job satisfaction But it is a more "lonely" job than being a Development DBA
Correct Answer: All the above
Explanation:
All the above listed actions are the functions of cursor
Correct Answer: Which is assigned one and only one task
Correct Answer: IEEE 1284
Correct Answer: Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint
Correct Answer: Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table If a change was necessary then I would use the alter system set db_cache_size command
Correct Answer: You get this error when you get a snapshot too old within rollback It can usually be solved by increasing the undo retention or increasing the size of rollbacks You should also look at the logic involved in the application getting the error message
Correct Answer: A Control file records the physical structure of the database It contains the following information Database Name ,Names and locations of a database?s files and redolog files Time stamp of database creation
Correct Answer: Redo logs are logical and physical structures that are designed to hold all the changes made to a database and are intended to aid in the recovery of a database
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.