What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
1 2931What would you use to improve performance on an insert statement that places millions of rows into that table?
1 3042If 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?
1661How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1473You 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 8035I 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 3174
What do you mean by normalisation?
Which database is used by google?
what is the difference between blob and text? : Sql dba
What do you mean by sga and how is it different from pga?
You see a wait on lms process in statspack, what does that mean?
How do I run multiple versions of sybase on the same server?
What is mongodb query language?
What is the difference between clustered index and primary key?
How to order siblings in oracle hierarchy queries?
What is snowflake sql?
How to represent ENUMs and SETs internally?
Which is the most used database?
What is materialized view. What are different methods of refresh?
What are the different data types in mysql?
How sql server executes a statement with nested subqueries?