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
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
How can you enable a trace for a session?
What is the difference between clustered and non-clustered index? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How do you switch from an init.ora file to a spfile?
How to start SQL Server in minimal configuration mode?
If we issue alter database begin backup. What happens to database?
what r the types of backup?
by issuing "alter tablespace begin backup;" what happens to tablespace?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
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)