Database Client & servers

Databases: Prepare Databases Interview Questions, Answers, Tips, news, tutorials. Find Mainframe Questions asked in various companies, Get Career advice & Interview Procedures from Databases experts.

  • What is NoSQL?
    Nosql

    Posted By: rangoli

  • What is the difference between primary key and unique key?
    Dbms

    Posted By: Benny

  • What is normalization in DBMS?
    Dbms

    Posted By: Murray

  • How many types of database languages are available in DBMS?
    Dbms

    Posted By: Michael

  • What is data abstraction in DBMS?
    Dbms

    Posted By: Joel

  • Explain what is Relational Algebra?
    Dbms

    Posted By: Srinivas

  • What is atomicity and aggregation?
    Dbms

    Posted By: HatlodWed

  • What is functional Dependency?
    Dbms

    Posted By: Chalmers

  • What is E-R model?
    Dbms

    Posted By: Anonymous

  • What is Object Oriented model?
    Dbms

    Posted By: RichardExeda

  • What is BCNF?
    Dbms

    Posted By: Cleve

  • What is extension and intension?
    Dbms

    Posted By: Barton

  • What is the difference between DBMS and RDBMS?
    Dbms

    Posted By: Frederic

  • What is a transaction?
    Dbms

    Posted By: Primus

  • Explain the difference between attributes and identifiers.
    Dbms

    Posted By: Philip

  • List few the advantages of DBMS?
    Dbms

    Posted By: Bertha

  • What is data dictionary?
    Dbms

    Posted By: Waverly

  • What is a query and sub query?
    Dbms

    Posted By: Godfrey

  • List few basic DDL and DML commands?
    Dbms

    Posted By: Waldo

  • What is join? Mention its types.
    Dbms

    Posted By: asype

  • Enlist various phases of transaction.
    Dbms

    Posted By: bculsv

  • What is difference between candidate key and foreign key?
    Dbms

    Posted By: Clovis

  • What is stored procedures? List few uses of it?
    Stored Procedures

    Posted By: Bennie

  • Enlist the types of stored procedures in an SQL server?
    Stored Procedures

    Posted By: Coca Porn

  • What is difference between View and Stored Procedure?
    Stored Procedures

    Posted By: Abc

  • What is a SUBPROGRAM?
    Stored Procedures

    Posted By: Wheeler

  • What are the advantages and disadvantages of using a stored procedure?
    Stored Procedures

    Posted By: Burl

  • What are Temporary Stored Procedure?
    Stored Procedures

    Posted By: Joseph

  • What are recursive Stored Procedure?
    Stored Procedures

    Posted By: NIKHIL

  • What are cursors?
    Stored Procedures

    Posted By: Pooja

  • Enlist few advantages of a cursor?
    Stored Procedures

    Posted By: Hershel

  • How to create a Stored Procedure in Mysql?
    Stored Procedures

    Posted By: Weston

  • What is difference between stored procedure and function?
    Stored Procedures

    Posted By: Shailesh Kumar

  • Write the syntax to create a stored procedure?
    Stored Procedures

    Posted By: Kyle

  • What is the syntax to create a function?
    Stored Procedures

    Posted By: Francis

  • What is SQL SECURITY DEFINER?
    Stored Procedures

    Posted By: Ed

  • What is the order for Declares?
    Stored Procedures

    Posted By: Juluis

  • What is the syntax for the declare statement?
    Stored Procedures

    Posted By: Krishna Kushwaha

  • How do you invoke a stored procedure?
    Stored Procedures

    Posted By: Orval

  • What privilege do you need to alter a function or procedure?
    Stored Procedures

    Posted By: Thornton

  • What privilege do you need to grant privileges for a routine?
    Stored Procedures

    Posted By: Augusta

  • What is mysqlcheck do?
    Mysql

    Posted By: Hermon

  • What does tee command do in MySQL?
    Mysql

    Posted By: OliverSam

  • Write an sql statement to count number of rows in table?
    Mysql

    Posted By: Austin

  • What is maximum number of columns allowed in a table?
    Mysql

    Posted By: Eric

  • What is use of IGNORE keyword in MySQL?
    Mysql

    Posted By: Francis

  • What is difference between MyISAM Static and MyISAM Dynamic?
    Mysql

    Posted By: Anonymous

  • What are different type of Joins available in MySQL?
    Mysql

    Posted By: bharadwaja

  • What is difference between denormalization and normalization?
    Mysql

    Posted By: oliverusselldev

  • Write a query to find second highest salary of an employee?
    Mysql

    Posted By: Horace

  • How many rows will return from dual table?
    Mysql

    Posted By: Erastus

  • What is the difference between TRUNCATE and DELETE commands?
    Mysql

    Posted By: Prashant

  • What are Scrollable cursor?
    Mysql

    Posted By: Camille

  • What are HEAP Tables?
    Mysql

    Posted By: shankar

  • What is difference between SUBSTR and INSTR?
    Mysql

    Posted By: Jack

  • What is Pragma EXECPTION_INIT ? Explain is usage?
    Mysql

    Posted By: Ishmael

  • How to use mysqldump to create a copy of the database?
    Mysql

    Posted By: Mathias

  • What is "i_am_a_dump" flag in MySql?
    Mysql

    Posted By: Pearl

  • Explain advantages of InnoDB over MyISAM?
    Mysql

    Posted By: Clinton

  • What is the default port for MySQL Server?
    Mysql

    Posted By: AliSalari

  • What is the difference between CHAR and VARCHAR?
    Mysql

    Posted By: Himanshi

  • Enlist the storage engine available in MySQL?
    Mysql

    Posted By: Guilherme Couto

  • How to use the MySQL slow query log?
    Mysql

    Posted By: Claudiuslest

  • What is the difference between BLOB and TEXT?
    Mysql

    Posted By: Nandha Kumar

  • How many types of triggers are available in MySQL?
    Mysql

    Posted By: Neal

  • What is the difference between FLOAT and DOUBLE?
    Mysql

    Posted By: Handy

  • How to get the current date in MySQL?
    Mysql

    Posted By: Fisher

  • What is MySQL data directory?
    Mysql

    Posted By: Vk

  • What are federated tables?
    Mysql

    Posted By: Clay

  • Enlist the drivers available in MySQL?
    Mysql

    Posted By: mohanjothi

  • What is MSSQL?
    Mssql

    Posted By: Arnold

  • Explain Trigger and its types?
    Mssql

    Posted By: EvgeniaAnd

  • How will you handle blocking and deadlocks
    Mssql

    Posted By: Rowland

  • what is DML?
    Mssql

    Posted By: Curtis

  • Define join and name different type of joins?
    Mssql

    Posted By: Rakhi

  • What is DCL?
    Mssql

    Posted By: Ankit

  • what are the types of normalization in relational database? Describe each.
    Mssql

    Posted By: Hamilton

  • Write the Insert, Update, Delete Query in SQL ?
    Mssql

    Posted By: Aurthur

  • What is Triggers in PL/SQL
    Mssql

    Posted By: Dayton

  • What is Normalization and types of Normalization?
    Mssql

    Posted By: Anna

  • What is the difference between a having clause and a where clause?
    Mssql

    Posted By: Mills

  • What are the properties and different types of sub-queries?
    Mssql

    Posted By: Gustavus

  • What is sql profiler?
    Mssql

    Posted By: Anthony

  • Difference between drop, truncate and delete a table?
    Mssql

    Posted By: Howell

  • What is Primary Key and Foreign Key?
    Mssql

    Posted By: Dayton

  • What different are the Constraints used on Table Columns in SQL?
    Mssql

    Posted By: Michael

  • They asked about oops concept and basic sql concepts?
    Mssql

    Posted By: Caleb

  • What's the difference between a primary key and a clustered index?
    Mssql

    Posted By: Bennie

  • What are the two authentication modes in SQL Server?
    Mssql

    Posted By: Harland

  • What is the difference between Clustered and Non-Clustered Index?
    Mssql

    Posted By: Bharathi

  • Define MongoDB.
    Mongodb

    Posted By: Ali Hyder

  • What is the role of profiler in MongoDB?
    Mongodb

    Posted By: Lawrence

  • What's a Master or Primary?
    Mongodb

    Posted By: Aubrey

  • What makes MongoDB the best?
    Mongodb

    Posted By: Ezra

  • When do we use Namespace in MongoDB?
    Mongodb

    Posted By: Clyde

  • How does MongoDB provide consistency?
    Mongodb

    Posted By: Hershel

  • Why is MongoDB not chosen for a 32-bit system?
    Mongodb

    Posted By: Ruffus

  • What are the key features of mongodb?
    Mongodb

    Posted By: Murphy

  • Which syntax is used to create collection in mongodb?
    Mongodb

    Posted By: Eliga

  • List the important features of MongoDB.
    Mongodb

    Posted By: Reed