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 12 hours ago

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

    Posted By: Benny 12 hours ago

  • What is normalization in DBMS?
    Dbms

    Posted By: Murray 12 hours ago

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

    Posted By: Michael 12 hours ago

  • What is data abstraction in DBMS?
    Dbms

    Posted By: Joel 12 hours ago

  • Explain what is Relational Algebra?
    Dbms

    Posted By: Srinivas 12 hours ago

  • What is atomicity and aggregation?
    Dbms

    Posted By: HatlodWed 12 hours ago

  • What is functional Dependency?
    Dbms

    Posted By: Chalmers 12 hours ago

  • What is E-R model?
    Dbms

    Posted By: Anonymous 12 hours ago

  • What is Object Oriented model?
    Dbms

    Posted By: RichardExeda 12 hours ago

  • What is BCNF?
    Dbms

    Posted By: Cleve 12 hours ago

  • What is extension and intension?
    Dbms

    Posted By: Barton 12 hours ago

  • What is the difference between DBMS and RDBMS?
    Dbms

    Posted By: Frederic 12 hours ago

  • What is a transaction?
    Dbms

    Posted By: Primus 12 hours ago

  • Explain the difference between attributes and identifiers.
    Dbms

    Posted By: Philip 12 hours ago

  • List few the advantages of DBMS?
    Dbms

    Posted By: Bertha 12 hours ago

  • What is data dictionary?
    Dbms

    Posted By: Waverly 12 hours ago

  • What is a query and sub query?
    Dbms

    Posted By: Godfrey 12 hours ago

  • List few basic DDL and DML commands?
    Dbms

    Posted By: Waldo 12 hours ago

  • What is join? Mention its types.
    Dbms

    Posted By: asype 12 hours ago

  • Enlist various phases of transaction.
    Dbms

    Posted By: bculsv 12 hours ago

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

    Posted By: Clovis 12 hours ago

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

    Posted By: Bennie 12 hours ago

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

    Posted By: Coca Porn 12 hours ago

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

    Posted By: Abc 12 hours ago

  • What is a SUBPROGRAM?
    Stored Procedures

    Posted By: Wheeler 12 hours ago

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

    Posted By: Burl 12 hours ago

  • What are Temporary Stored Procedure?
    Stored Procedures

    Posted By: Joseph 12 hours ago

  • What are recursive Stored Procedure?
    Stored Procedures

    Posted By: NIKHIL 12 hours ago

  • What are cursors?
    Stored Procedures

    Posted By: Pooja 12 hours ago

  • Enlist few advantages of a cursor?
    Stored Procedures

    Posted By: Hershel 12 hours ago

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

    Posted By: Weston 12 hours ago

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

    Posted By: Shailesh Kumar 12 hours ago

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

    Posted By: Kyle 12 hours ago

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

    Posted By: Francis 12 hours ago

  • What is SQL SECURITY DEFINER?
    Stored Procedures

    Posted By: Ed 12 hours ago

  • What is the order for Declares?
    Stored Procedures

    Posted By: Juluis 12 hours ago

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

    Posted By: Krishna Kushwaha 12 hours ago

  • How do you invoke a stored procedure?
    Stored Procedures

    Posted By: Orval 12 hours ago

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

    Posted By: Thornton 12 hours ago

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

    Posted By: Augusta 12 hours ago

  • What is mysqlcheck do?
    Mysql

    Posted By: Hermon 12 hours ago

  • What does tee command do in MySQL?
    Mysql

    Posted By: OliverSam 12 hours ago

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

    Posted By: Austin 12 hours ago

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

    Posted By: Eric 12 hours ago

  • What is use of IGNORE keyword in MySQL?
    Mysql

    Posted By: Francis 12 hours ago

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

    Posted By: Anonymous 12 hours ago

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

    Posted By: bharadwaja 12 hours ago

  • What is difference between denormalization and normalization?
    Mysql

    Posted By: oliverusselldev 12 hours ago

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

    Posted By: Horace 12 hours ago

  • How many rows will return from dual table?
    Mysql

    Posted By: Erastus 12 hours ago

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

    Posted By: Prashant 12 hours ago

  • What are Scrollable cursor?
    Mysql

    Posted By: Camille 12 hours ago

  • What are HEAP Tables?
    Mysql

    Posted By: shankar 12 hours ago

  • What is difference between SUBSTR and INSTR?
    Mysql

    Posted By: Jack 12 hours ago

  • What is Pragma EXECPTION_INIT ? Explain is usage?
    Mysql

    Posted By: Ishmael 12 hours ago

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

    Posted By: Mathias 12 hours ago

  • What is "i_am_a_dump" flag in MySql?
    Mysql

    Posted By: Pearl 12 hours ago

  • Explain advantages of InnoDB over MyISAM?
    Mysql

    Posted By: Clinton 12 hours ago

  • What is the default port for MySQL Server?
    Mysql

    Posted By: AliSalari 12 hours ago

  • What is the difference between CHAR and VARCHAR?
    Mysql

    Posted By: Himanshi 12 hours ago

  • Enlist the storage engine available in MySQL?
    Mysql

    Posted By: Guilherme Couto 12 hours ago

  • How to use the MySQL slow query log?
    Mysql

    Posted By: Claudiuslest 12 hours ago

  • What is the difference between BLOB and TEXT?
    Mysql

    Posted By: Nandha Kumar 12 hours ago

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

    Posted By: Neal 12 hours ago

  • What is the difference between FLOAT and DOUBLE?
    Mysql

    Posted By: Handy 12 hours ago

  • How to get the current date in MySQL?
    Mysql

    Posted By: Fisher 12 hours ago

  • What is MySQL data directory?
    Mysql

    Posted By: Vk 12 hours ago

  • What are federated tables?
    Mysql

    Posted By: Clay 12 hours ago

  • Enlist the drivers available in MySQL?
    Mysql

    Posted By: mohanjothi 12 hours ago

  • What is MSSQL?
    Mssql

    Posted By: Arnold 12 hours ago

  • Explain Trigger and its types?
    Mssql

    Posted By: EvgeniaAnd 12 hours ago

  • How will you handle blocking and deadlocks
    Mssql

    Posted By: Rowland 12 hours ago

  • what is DML?
    Mssql

    Posted By: Curtis 12 hours ago

  • Define join and name different type of joins?
    Mssql

    Posted By: Rakhi 12 hours ago

  • What is DCL?
    Mssql

    Posted By: Ankit 12 hours ago

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

    Posted By: Hamilton 12 hours ago

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

    Posted By: Aurthur 12 hours ago

  • What is Triggers in PL/SQL
    Mssql

    Posted By: Dayton 12 hours ago

  • What is Normalization and types of Normalization?
    Mssql

    Posted By: Anna 12 hours ago

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

    Posted By: Mills 12 hours ago

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

    Posted By: Gustavus 12 hours ago

  • What is sql profiler?
    Mssql

    Posted By: Anthony 12 hours ago

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

    Posted By: Howell 12 hours ago

  • What is Primary Key and Foreign Key?
    Mssql

    Posted By: Dayton 12 hours ago

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

    Posted By: Michael 12 hours ago

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

    Posted By: Caleb 12 hours ago

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

    Posted By: Bennie 12 hours ago

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

    Posted By: Harland 12 hours ago

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

    Posted By: Bharathi 12 hours ago

  • Define MongoDB.
    Mongodb

    Posted By: Ali Hyder 12 hours ago

  • What is the role of profiler in MongoDB?
    Mongodb

    Posted By: Lawrence 12 hours ago

  • What's a Master or Primary?
    Mongodb

    Posted By: Aubrey 12 hours ago

  • What makes MongoDB the best?
    Mongodb

    Posted By: Ezra 12 hours ago

  • When do we use Namespace in MongoDB?
    Mongodb

    Posted By: Clyde 12 hours ago

  • How does MongoDB provide consistency?
    Mongodb

    Posted By: Hershel 12 hours ago

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

    Posted By: Ruffus 12 hours ago

  • What are the key features of mongodb?
    Mongodb

    Posted By: Murphy 12 hours ago

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

    Posted By: Eliga 12 hours ago

  • List the important features of MongoDB.
    Mongodb

    Posted By: Reed 12 hours ago

  • ;