top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Question posted by antony

+3 votes
1 answer
oracle: What does coalescing a tablespace do?
posted Apr 1, 2015
  • oracle
  • sql
+2 votes
1 answer
Oracle: What background process refreshes materialized views?
posted Mar 27, 2015
  • oracle
  • sql
+2 votes
1 answer
Oracle: When a user process fails, what background process cleans up after it?
posted Mar 27, 2015
  • oracle
  • sql
+2 votes
1 answer
Oracle: Name three advisory statistics you can collect.
posted Mar 25, 2015
  • oracle
  • sql
+1 vote
1 answer
Oracle: Explain the use of table functions.
posted Mar 25, 2015
  • sql
  • oracle
+1 vote
1 answer
oracle: Explain the use of setting GLOBAL_NAMES equal to TRUE.
posted Mar 23, 2015
  • sql
  • oracle
+1 vote
1 answer
Oracle: What is the maximum number of triggers, can apply to a single table?
posted Mar 23, 2015
  • oracle
  • sql
+2 votes
1 answer
Orcale: How to view installed Oracle version information?
posted Mar 13, 2015
  • oracle
  • sql
+1 vote
1 answer
Oracle: how to find out 9th highest salary from emp table?
posted Mar 13, 2015
  • sql
  • oracle
+2 votes
1 answer
Oracle: what is the command switch to DOS prompt from sql ?
posted Mar 12, 2015
  • sql
  • oracle
+2 votes
1 answer
Oracle: explain NVL function?
posted Mar 12, 2015
  • oracle
  • sql
+1 vote
2 answers
Oracle: What is a Cartesian product?
posted Mar 9, 2015
  • oracle
  • sql
+1 vote
2 answers
Oracle: which of the following is better to find the number of rows in a table?
posted Mar 9, 2015
  • oracle
  • sql
+1 vote
1 answer
Oracle: What is a ROWID and Why do we need that?
posted Mar 6, 2015
  • oracle
  • sql
+1 vote
1 answer
How does Oracle store the DATE datatype internally?
posted Feb 11, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What is a ROWID and Why do we need that?
posted Feb 11, 2015
  • oracle
+1 vote
1 answer
What is ROWNUM in Oracle?
posted Feb 9, 2015
  • oracle
  • sql
+1 vote
2 answers
Oracle: I want to use a view to update a table. Is it possible?
posted Feb 9, 2015
  • oracle
  • sql
0 votes
2 answers
Oracle: Why should I not commit after every record when updating a large table?
posted Feb 6, 2015
  • oracle
  • sql
0 votes
1 answer
How long will a variable remain defined in SQL Plus?
posted Feb 6, 2015
  • sql
  • oracle
+1 vote
1 answer
Is there a limit on the size of a PL/SQL block?
posted Feb 3, 2015
  • sql
  • oracle
  • plsql
+1 vote
1 answer
Is there a PL/SQL Engine in SQL*Plus?
posted Feb 3, 2015
  • sql
  • oracle
  • plsql
+1 vote
1 answer
What is implicit cursor and how is it used by Oracle?
posted Jan 29, 2015
  • sql
  • oracle
+1 vote
1 answer
What are the various types of queries in SQL?
posted Jan 29, 2015
  • sql
  • oracle
+1 vote
1 answer
Oracle: insert a row & create another table.
posted Jan 28, 2015
  • oracle
  • sql
+1 vote
1 answer
What is a package cursor in oracle?
posted Jan 28, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What all important parameters of the init.ora ,....., increase the SGA size?
posted Jan 23, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What are the types of Notation?
posted Jan 23, 2015
  • sql
  • oracle
0 votes
1 answer
Oracle: For which relational operators in where clause, index is not used?
posted Jan 20, 2015
  • sql
  • oracle
0 votes
1 answer
Oracle: If any other tables same as dual were created would it act similar to dual?
posted Jan 20, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What is the difference between foreign key and reference key?
posted Jan 16, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: What's the length of SQL integer?
posted Jan 16, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: Can you create index on view?
posted Jan 13, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle: can you alter synonym of view or view?
posted Jan 12, 2015
  • oracle
  • sql
0 votes
1 answer
Oracle:Can database trigger written on synonym of a table?
posted Jan 12, 2015
  • oracle
  • sql
+1 vote
1 answer
What is the result of the following SQL?
posted Jan 12, 2015
  • sql
  • oracle
0 votes
1 answer
Oracle: What is Auditing?
posted Jan 7, 2015
  • oracle
  • sql
0 votes
1 answer
Which are initial RDBMS, Hierarchical & N/w database?
posted Jan 7, 2015
  • oracle
  • rdbms
+1 vote
1 answer
Oracle: A table has the following data : [5, Null, 10]. What will the average function return?
posted Jan 2, 2015
  • oracle
  • sql
+2 votes
1 answer
Oracle: Below were the interview questions which was held by IBM.
posted Jan 2, 2015
  • oracle
  • sql
+1 vote
1 answer
oracle: Is the assignment given below allowed ?
posted Dec 30, 2014
  • oracle
  • sql
+1 vote
1 answer
Oracle: Is the query below allowed?
posted Dec 30, 2014
  • oracle
  • sql
+1 vote
2 answers
What is the maximum no. of columns a table can have in Oracle ?
posted Dec 23, 2014
  • oracle
  • sql
+1 vote
1 answer
Can we define multiple save points and Rollback to any save points? in Oracle
posted Dec 23, 2014
  • oracle
  • sql
+1 vote
1 answer
What are the min. extents allocated to a rollback extent in Oracle?
posted Dec 19, 2014
  • sql
  • oracle
0 votes
1 answer
Can Check constraint be used for self referential integrity? if Yes, How? In Oracle
posted Dec 19, 2014
  • oracle
  • sql
0 votes
1 answer
Can you increase the size of a table space in Oracle? If yes then How?
posted Dec 15, 2014
  • oracle
  • sql
0 votes
1 answer
Describe Oracle database's physical and logical structure In Oracle?
posted Dec 15, 2014
  • oracle
  • sql
0 votes
1 answer
Oracle: Can views be specified in a trigger statement?
posted Dec 10, 2014
  • oracle
  • sql
+1 vote
1 answer
Oracle: What is the maximum no. of statements that can be specified in a trigger statement?
posted Dec 10, 2014
  • oracle
  • sql
Page:
...