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) What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
1 3680What would you use to improve performance on an insert statement that places millions of rows into that table?
1 3814If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
1 2218How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 1989You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
1 9091I 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?
1 4149
How to rebuild the master database?
What kind of problems occurs if we do not implement proper locking strategy?
what is schema? : Sql dba
Explain “row_number()” in sql server with an example?
what is the command syntax for inserting a document?
Who proposed the relational model?
What is the best sql course?
How to remove duplicate rows from table except one?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can one drop a column from a table?
what is sql server agent? : Sql dba
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
how many tables will create when we create table, what are they? : Sql dba
What is the difference between upgrade and migration in sql server?
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com