Explain materialized views and how they are used.
No Answer is Posted For this Question
Be the First to Post Answer
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
What view would you use to look at the size of a data file?
what are the types of connection load-balancing?
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
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 is the difference between catalog & nocatalog?
Give two examples of referential integrity constraints.
What is a correlated sub-query? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
How do you open a cluster administrator? : sql server DBA
You have just compiled a PL/SQL package but got errors, how would you view the errors?
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 (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)