1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

How would you best determine why your MVIEW couldnt FAST REFRESH?

 1430

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

 1823

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

 1477

How would you begin to troubleshoot an ORA-3113 error?

 1589

Which dictionary tables and/or views would you look at to diagnose a locking issue?

 1480

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

 1611

How would you extract DDL of a table without using a GUI tool?

 1 3639

Youre getting high busy buffer waits - how can you find whats causing it?

 1 1898

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

Infosys,

1793

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

 1664

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

 1525

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

 1799

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

 1460

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

 1567

Explain how you would restore a database using RMAN to Point in Time?

 1623

Un-Answered Questions { Databases }

Which software is used for pl sql programming?

514

Can you pass expressions to stored procedure parameters?

499

How many subqueries can be nested in a statement?

501

How to delete database objects with "drop" statements in ms sql server?

587

difference between Clustered index and non clustered index ?

568




First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1307

What are the types of keys?

508

What is database host?

515

What are date and time data types in mysql?

517

What is sql catalog?

555

What are the functions of database management system?

454

How to convert characters to times in oracle?

588

What do you mean by % and _ in the LIKE statement?

532

definition of cluster and non-clustered index?

2474

Define left outer join in sql server joins?

549

For More Un-Answered { Databases } Questions Click Here