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?
No Answer is Posted For this Question
Be the First to Post Answer
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
How to determine the service pack currently installed on SQL Server?
What is the difference between Datapump & export/import?
What the different types of replication and why are they used? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Oracle (3259)
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)