Give the stages of instance startup to a usable state where
normal users may access it.
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
who owns the operating system files created by the utl_file package?
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.
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
orra 1555 what is this error,why it is occur?
In oracle 10g export, import if we declare rows=y/n what would be the output?
what is the differnce between process and thread ?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
What is the difference between clustered and non-clustered index? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How would you go about verifying the network name that the local_listener is currently using?
When creating a user, what permissions must you grant to allow them to connect to the database?
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)