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) Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
1940An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
2112What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
2347Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
2218Database 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.
2064Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
2378Provide 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.
2184
Can we use rowid as primary key?
difference between global n context sensitive segments?
How to create percentile function?
Is it possible to call a stored procedure within a stored procedure?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are the differences between char and varchar in ms sql server?
What is ase database?
What are the constraints available in sql?
How would you go about verifying the network name that the local_listener is currently using?
Explain indexed views?
Does table partitioning require user-defined segments in sybase?
What are window functions in sql server?
What is sql catalog?
Can you get microsoft access for free?
Is database a hardware or software?