top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Interview question: Which of the following is not a schema object Oracle?

+2 votes

Which of the following is not a schema object: Indexes, tables, public synonyms, triggers and packages?

posted Jan 30, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Public synonyms

answer Apr 10, 2015 by Shivaranjini
Similar Questions
+2 votes

1) Is this for loop allowed :For x in &Start..&End Loop

2) Which symbol preceeds the path to the table in the remote database?

3) Are views automatically updated when base tables are updated?

4) Can a trigger written for a view?

5) If all the values from a cursor have been fetched and another fetch is issued, the output will be : error, last record or first record ?

Please have a look at and find the answers.

+1 vote

which of the following is better to find the number of rows in a table?
1. count(1)
2. count(*)
3. count(rowid)

0 votes

If I have an execute privilege on a procedure in another users schema, can I execute his procedure even though I do not have privileges on the tables within the procedure?