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 2978

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

1 3064

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

1 2962

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

1 3310

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 4044

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

1 3669

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

1 3373

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 3100

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

1 2875

TNS-01022: Alias string

1 3673

Un-Answered Questions { Database Errors }

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2854

ORA-26076: cannot set or reset value after direct path structure is allocated

2035

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

2470

java.sql.SQLException:Invalid state, the statement object is closed Hai all i got this error when i am multiple times referesh web page

6721

ORA-16516: The current state is invalid for the attempted operation.

8882

How will you Handle Error in SQL SERVER 2008?

2446

IMP-00063: Warning: Skipping table "string"."string" because object type "string"."string" cannot be created or has different identifier

2786

When do you get "getwmicomexception"?

2735

ORA-26029: index string.string partition string initially in unusable state

2235

write a database figure to implement the master detained relationship.

3016

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

2864

ORA-26095: unprocessed stream data exists

3642

ORA-16626: failed to enable specified object

2278

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

3229

What is SCD (Slowly Changing Dimensions)? What are its types?

2720

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