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) Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
1882An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
2051What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
2273Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
2159Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
2007Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
2324Provide 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.
2123
What are the different types of lock modes in sql server 2000?
What is triggers?
what is union, minus and interact commands? : Sql dba
What is difference between join and natural join?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');
what rules exist regarding format, content, flame wars, etc
What is for xml in sql server?
Can we use where clause in union?
How many redo logs should you have and how should they be configured for maximum recoverability?
What is a foreign key constraint?
What is a text delimiter?
What is a query?
What is the difference between functions, procedures, and packages in pl/sql?
What is postgresql?