Answer / sa123

Dont create any public synonym, then that is available only
for its owner

Answer / ankush

dont give any grant permission for the table except the
schema where the table is actually crearted.U can also use
a private synonym.. with in the schema to recognizing the
table with a dirrerent name.

Answer / swapna

Once table is created in your own schema that is only
visible to that schema. For others it is not visible.

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

How do I run sql?

0 Answers  

---

What is a delimiter in sas?

0 Answers  

---

what are all different types of collation sensitivity? : Sql dba

0 Answers  

---

Are sql views compiled?

1 Answers  

---

What is sql profiling in oracle?

0 Answers  

---

How do you declare a constant?

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

How do I view a sql database?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

What is nested table in pl sql?

0 Answers  

---