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?
- 0 Answers
- 1987 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
You have just compiled a PL/SQL package but got errors, how would you view the errors?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Compare and contrast TRUNCATE and DELETE for a table.
How do you open a cluster administrator? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
