Databases Interview Questions
Questions Answers Views Company eMail

Mention the IN Operator syntax in Neo4i?

5

what Neo4j CQL LIMIT clause is used for?

5

how you can create/delete databases in Neo4j?

5

For what Neo4j is widely used for?

5

Mention some of the important characteristics of neo4j?

5

which query language does Neo4j use and what is consist of?

5

what does the SET clause is used for in Neo4j?

5

Explain how Neo4j stores primitive array?

5

what Neo4j CQL command is used for?

5

Name some of the file extension for ms access?

554

Explain how you can build a relationship between the different databases in access?

520

What things to be taken in consideration for lookup fields?

488

Explain how you can import data from other sources into access database?

466

How you can export data in excel format?

479

What do you mean by queries?

507


Un-Answered Questions { Databases }

Explain the steps needed to create a scheduled job?

505


What do you mean by 'normalization'?

576


Can I work with several databases simultaneously? : sql server management studio

538


What is table scan and index scan?

595


Can you load data into multiple tables at once? : aql loader

571






What is the stored procedure to view current lock and processes respectively?

505


You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

269


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3201


What is CTE in SQL

521


Explain nested join?

543


Is ms access easy to learn?

440


How do I find mysql database?

461


How do I find the transaction log size in sql server?

499


How can you know that statistics should be updated?

576


What is a primary key constraint?

403