Search:

Type: Posts; User: parthokonar1; Keyword(s):

Search: Search took 0.01 seconds.

  1. Answers
    2
    Views
    1,536

    Oracle Re: Oracle 9i database get stoped

    But it should not stop the database. have you checked in the alert log file what message is coming there?
  2. Oracle Re: hot backup recovery of database is a temporyay tablespace needed

    i think i have replied it
  3. Oracle Re: hot backup recovery of database is a temporary tablespace needed

    No it is not needed you can create a temporary tablespace no issues.
  4. Answers
    1
    Views
    4,788

    Oracle Re: Can exp just export a tablespace

    Yes we can export a tablespace make the concerned tablespace read only so that no write operation is taking place an then export it.
  5. Oracle Re: Is the “spfile” is considered to be an Oracle segment?

    No it is just a configuration file which oracle reads to configure the instance
  6. Answers
    5
    Views
    5,520

    Oracle Re: Books to learn Oracle

    Yes if you search the google a lot many books comes. but i am giving some name of the books that may be helpful to you. if you wants certification in oracle 9i then you should read oracle press books...
  7. Answers
    3
    Views
    2,467

    SQL Re: Query to See Functions

    I dont think it can be done through sql query, but it can be done through java jdbc programming which can extract all the predefined functions and display them
  8. Answers
    2
    Views
    2,519

    Oracle Re: Transaction in Oracle Server

    When you update the Oracle Server in some way, that update should initially be regarded as tentative only - tentative in the sense that, if something subsequently goes wrong, the update may be...
  9. Answers
    3
    Views
    6,029

    Oracle Re: Memory Layers In Shared Pool

    Actually there are three layers in the shared pool, these are
    Library cache, Data dictionary cache, and control structures
    as you are well aware with Library & data dictionary cache,
    the control...
  10. Answers
    2
    Views
    2,652

    Oracle Re: Usage of Unique Index

    See creation of indexes are fine in some situation i.e when the data retrival from the table is less than 5%, otherwise a FTS is occuring there is no need of index.

    unique index and index is...
  11. Answers
    5
    Views
    5,520

    Oracle Re: Books to learn Oracle

    Try to search in google
  12. Answers
    1
    Views
    5,513

    Oracle Re: Reasons for Database Crash

    Crash can be media crash or instance crash in media crash the hard disk containing the files is crashed or due to some error in the read write head. And instance crash means crash due to power...
  13. Answers
    3
    Views
    2,609

    Oracle Re: Backup of Database

    Backup of database can be taken in hot mode or cold mode in cold backup the database is shutdown properly and then backup of datafiles and controlfile is taken, but in hot bakup the database has to...
  14. Answers
    1
    Views
    2,358

    Oracle Re: Partitioning a table

    Decompose a table or index into smaller, more manageable pieces, called partitions. Each partition of a table or index must have the same logical attributes, such as column names, datatypes, and...
  15. Answers
    2
    Views
    7,318

    Oracle Re: How to find Table Size

    First go for..

    analyze table tabe_name compute statistics;
    and then give
    select num_rows,blocks ,empty_blocks as
    empty,avg_space,chain_cnt,avg_row_len from dba_tables
    where...
  16. Answers
    1
    Views
    6,353

    SQL Re: Query with a command in DBMS

    The SLEEP procedure suspends the session for the number of seconds specified in the seconds parameter. Sleep periods can be specified with accuracy down to the hundredth of a second (e.g., 1.35 and...
  17. Answers
    2
    Views
    2,179

    Oracle Re: Dynamic Query

    Most database applications do a specific job. For example, a simple program might prompt the user for an employee number, then update rows in the EMP and DEPT tables. In this case, you know the...
  18. Answers
    2
    Views
    2,516

    SQL Re: What is the Default Value

    The datatype in a declaration can either be constrained or unconstrained. A datatype is constrained when you specify a number which constrains or restricts the magnitude of the value which can be...
  19. Answers
    5
    Views
    4,010

    Oracle Re: Temporary Tables

    The data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific rows in a global temporary table can be preserved for...
Results 1 to 19 of 24
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact