Database Errors Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Errors Interview Questions

Questions Answers Views Company eMail

TNS-01005: trace OFF | USER | ADMIN | SUPPORT [] : set tracing to the specified level

1 3252

TNS-01006: set password : set the password for subsequent calls

1 3327

TNS-01007: quit | exit : exit LSNRCTL

1 2979

TNS-01008: version [] : get the version information of the listener

1 3067

TNS-01009: service [] : get the service information of the listener

1 2965

TNS-01013: set|show trc_{ } []: set|show trace parameters of current listener

1 3313

TNS-01014: set|show log_{ } []: set|show log parameters of current listener

1 3936

TNS-01015: set|show parm_name []: sets|shows current listener parm values

1 4048

TNS-01016: change_password []: changes the password of the listener

1 3671

TNS-01017: set|show current_listener []: sets|shows current listener

1 3376

TNS-01018: save_config []: saves configuration changes to parameter file

1 3393

TNS-01019: set rawmode ON | OFF: set output mode for services and status commands

1 3063

TNS-01020: STATUS of the LISTENER

1 3103

TNS-01021: ------------------------

1 2879

TNS-01022: Alias string

1 3674

Un-Answered Questions { Database Errors }

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2868

RMAN-05017: no copy of datafile number found to recover

2471

ORA-16626: failed to enable specified object

2278

ORA-16627: No standby databases support the overall protection mode.

4042

mount: mount to NFS server failed: System Error: Connection timed out

3714

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

2259

ORA-26027: unique index string.string partition string initially in unusable state

6794

How will you Handle Error in SQL SERVER 2008?

2446

What is the meaning of lock escalation and why/how to stop this?

2716

IMP-00070: Lob definitions in dump file are inconsistent with database.

1801

What is the use of NOLOCK locking hint?

1837

What is live lock, deadlock and what is Lock escalation?

2502

What is Mutex error in Triggers?

3130

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2779

What severity level errors are managed in TRY-CATCH block?

2269

For More Un-Answered { Database Errors } Questions Click Here