Interested to Buy Any Domain ? << Click Here >> for more details...
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
How would you go about increasing the buffer cache hit ratio? 0. Explain the difference between a hot backup and a cold backup and the benefits associated with each 1. You have just had to restore from backup and do not have any control files. How would you go about bringing up this database? 2. How do you switch from an init.ora file to a spfile? 3. Explain the difference between a data block, an extent and a segment. 4. Give two examples of how you might determine the structure of the table DEPT. 5. Where would you look for errors from the database engine? 6. Compare and contrast TRUNCATE and DELETE for a table. 7. Give the reasoning behind using an index. 8. Give the two types of tables involved in producing a star schema and the type of data they hold. 9. What type of index should you use on a fact table? 10. Give two examples of referential integrity constraints. 11. 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? 12. Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each. 13. What command would you use to create a backup control file? 14. Give the stages of instance startup to a usable state where normal users may access it. 15. What column differentiates the V$ views to the GV$ views and how? 16. How would you go about generating an EXPLAIN plan?
2 6065mazimum size of a database in mysql? when we create a table then how many tables actually created? write there name?
1 4163I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
1 2021what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
9 18041
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
If a cursor is open, how can we find in a pl/sql block?
Are you familiar with user exits in reports?
Where can you add custom error messages to sql server?
in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what is sql server agent? : Sql dba
Is inner join faster than left join?
What are the steps in creating a database?
what is bcp? When does it used? : Sql dba
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How to export data from database and import into another?
How do I find the sql server version?
Is microsoft getting rid of access?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
