You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

How would you force a log switch?

4 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---

when does an alert gets signaled?

0 Answers   Oracle,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

0 Answers  

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---