WithoutBook LIVE Mock Interviews

Interview Questions and Answers

The Best LIVE Mock Interview - You should go through before interview

Test your skills through the online practice test: DBMS Quiz Online Practice Test

Freshers / Beginner level questions & answers

Ques 1. What is database or database management systems (DBMS)?

Database provides a systematic and organized way of storing, managing and retrieving from

collection of logically related information.

Secondly the information has to be persistent, that means even after the application is closed

the information should be persisted.

Finally it should provide an independent way of accessing data and should not be dependent on the application to access the information.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 2. What's the difference between file and database? Can files qualify as a database?

Main difference between a simple file and database that database has independent way (SQL) of accessing information while simple files do not File meets the storing, managing and retrieving part of a database but not the independent way of accessing data. Many experienced programmers think that the main difference is that file can not provide multi-user capabilities which a DBMS provides. But if we look at some old COBOL and C programs where file where the only means of storing data, we can see functionalities like locking, multi-user etc provided very efficiently. So it�s a matter of debate if some interviewers think this as a main difference between files and database accept it� going in to debate is probably loosing a job.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 3. What is SQL?

SQL stands for Structured Query Language.SQL is an ANSI (American National Standards

Institute) standard computer language for accessing and manipulating database systems. SQL

statements are used to retrieve and update data in a database.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 4. What�s difference between DBMS and RDBMS?

DBMS provides a systematic and organized way of storing, managing and retrieving from

collection of logically related information. RDBMS also provides what DBMS provides but above that it provides relationship integrity. So in short we can say

RDBMS = DBMS + REFERENTIAL INTEGRITY

These relations are defined by using �Foreign Keys� in any RDBMS.Many DBMS companies claimed there DBMS product was a RDBMS compliant, but according to industry rules and regulations if the DBMS fulfills the twelve CODD rules it�s truly a RDBMS. Almost all DBMS (SQL SERVER, ORACLE etc) fulfills all the twelve CODD rules and are considered as truly RDBMS.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 5. What are E-R diagrams?

E-R diagram also termed as Entity-Relationship diagram shows relationship between various

tables in the database.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 6. How many types of relationship exist in database designing?

There are three major relationship models:-

One-to-one

One-to-many

Many-to-many

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 7. What are DML and DDL statements?

DML stands for Data Manipulation Statements. They update data values in table. Below are the most important DDL statements:-

=>SELECT - gets data from a database table

=> UPDATE - updates data in a table

=> DELETE - deletes data from a database table

=> INSERT INTO - inserts new data into a database table

DDL stands for Data definition Language. They change structure of the database objects like table, index etc. Most important DDL statements are as shown below:-

=>CREATE TABLE - creates a new table in the database.

=>ALTER TABLE � changes table structure in database.

=>DROP TABLE - deletes a table from database

=> CREATE INDEX - creates an index

=> DROP INDEX - deletes an index

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 8. How do we select distinct values from a table?

DISTINCT keyword is used to return only distinct values. Below is syntax:- Column age and

Table wbEmp

SELECT DISTINCT age FROM wbEmp

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 9. What is Like operator for and what are wild cards in DMBS?

LIKE operator is used to match patterns. A "%" sign is used to define the pattern.

Below SQL statement will return all words with letter "S"

SELECT * FROM pcdsEmployee WHERE EmpName LIKE 'S%'

Below SQL statement will return all words which end with letter "S"

SELECT * FROM pcdsEmployee WHERE EmpName LIKE '%S'

Below SQL statement will return all words having letter "S" in between

SELECT * FROM pcdsEmployee WHERE EmpName LIKE '%S%'

"_" operator (we can read as �Underscore Operator�). �_� operator is the character defined at that point. In the below sample fired a query Select name from pcdsEmployee where name like

'_s%' So all name where second letter is �s� is returned.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 10. Can you explain Insert, Update and Delete query in DBMS?

Insert statement is used to insert new rows in to table. Update to update existing data in the

table. Delete statement to delete a record from the table. Below code snippet for Insert, Update and Delete :-

INSERT INTO wbEmployee SET name='maxwell',age='22';

UPDATE wbEmployee SET age='22' where name='maxwell';

DELETE FROM wbEmployee WHERE name = 'david';

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 11. What is order by clause in DMBS?

ORDER BY clause helps to sort the data in either ascending order to descending order.

Ascending order sort query

SELECT name,age FROM pcdsEmployee ORDER BY age ASC

Descending order sort query

SELECT name FROM pcdsEmployee ORDER BY age DESC

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 12. What is the SQL " IN " clause?

SQL IN operator is used to see if the value exists in a group of values. For instance the below

SQL checks if the Name is either 'David' or 'Craig' SELECT * FROM wbEmployee WHERE name IN ('David','Craig') Also you can specify a not clause with the same. SELECT * FROM wbEmployee WHERE age NOT IN (30,25)

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 13. Can you explain the between clause in DBMS?

Below SQL selects employees born between '01/01/1995' AND '01/01/1978' as per mysql

SELECT * FROM wbEmployee WHERE DOB BETWEEN '1995-01-01' AND '2011-09-28'

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 14. How to select the first record in a given set of rows?

Select top 1 * from wb.wbEmployees;

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 15. What is the default �-SORT � order for a SQL?

ASCENDING

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 16. What is a self-join?

If we want to join two instances of the same table we can use self-join.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 17. What�s the difference between �UNION� and �UNION ALL�?

UNION SQL syntax is used to select information from two tables. But it selects only distinct

records from both the table, while UNION ALL selects all records from both the tables.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 18. What are cursors and what are the situations you will use them?

SQL statements are good for set at a time operation. So it is good at handling set of data. But

there are scenarios where we want to update row depending on certain criteria. we will loop

through all rows and update data accordingly. There�s where cursors come in to picture.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 19. What is " Group by " clause?

�Group by� clause group similar data so that aggregate values can be derived.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 20. What is a Sub-Query?

A query nested inside a SELECT statement is known as a subquery and is an alternative to

complex join statements. A subquery combines data from multiple tables and returns results

that are inserted into the WHERE condition of the main query. A subquery is always enclosed within parentheses and returns a column. A subquery can also be referred to as an inner query and the main query as an outer query. JOIN gives better performance than a subquery when you have to check for the existence of records.

For example, to retrieve all EmployeeID and CustomerID records from the ORDERS table that have the EmployeeID greater than the average of the EmployeeID field, you can create a nested query, as shown:

SELECT DISTINCT EmployeeID, CustomerID FROM ORDERS WHERE EmployeeID > (SELECT AVG(EmployeeID) FROM ORDERS)

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 21. What is Data Model?

A collection of conceptual tools for describing data, data relationships data semantics and constraints.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 22. What is Weak Entity set?

An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 23. What is an Entity?

It is a 'thing' in the real world with an independent existence.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 24. What is an attribute?

It is a particular property, which describes the entity.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 25. What is degree of a Relation?

It is the number of attribute of its relation schema.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 26. What is Relationship?

It is an association among two or more entities.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 27. What is 1 NF (Normal Form)?

The domain of attribute must include only atomic (simple, indivisible) values.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 28. What is 2NF?

A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 29. What is a foreign key, and what is it used for?

A foreign key is used to establish relationships among relations in the relational model. Technically, a foreign key is a column (or columns) appearing in one relation that is (are) the primary key of another table. Although there may be exceptions, the values in the foreign key columns usually must correspond to values existing in the set of primary key values. This correspondence requirement is created in a database using a referential integrity constraint on the foreign key.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Intermediate / 1 to 5 years experienced level questions & answers

Ques 30. What are CODD rules in DBMS?

In 1969 Dr. E. F. Codd laid down some 12 rules which a DBMS should adhere in order to get the logo of a true RDBMS.

Rule 1: Information Rule.

"All information in a relational data base is represented explicitly at the logical level and in

exactly one way - by values in tables."

Rule 2: Guaranteed access Rule.

"Each and every datum (atomic value) in a relational data base is guaranteed to be logically

accessible by resorting to a combination of table name, primary key value and column name."

In flat files we have to parse and know exact location of field values. But if a DBMS is truly

RDBMS you can access the value by specifying the table name, field name, for instance

Customers.Fields [�Customer Name�].

Rule 3: Systematic treatment of null values.

"Null values (distinct from the empty character string or a string of blank characters and distinct from zero or any other number) are supported in fully relational DBMS for representing missing information and inapplicable information in a systematic way, independent of data type.".

Rule 4: Dynamic on-line catalog based on the relational model.

"The data base description is represented at the logical level in the same way as ordinary data, so that authorized users can apply the same relational language to its interrogation as they apply to the regular data."The Data Dictionary is held within the RDBMS, thus there is no-need for off-line volumes to tell you the structure of the database.

Rule 5: Comprehensive data sub-language Rule.

"A relational system may support several languages and various modes of terminal use (for

example, the fill-in-the-blanks mode). However, there must be at least one language whose

statements are expressible, per some well-defined syntax, as character strings and that is

comprehensive in supporting all the following items.

Data Definition

View Definition

Data Manipulation (Interactive and by program).

Integrity Constraints

Authorization.

Transaction boundaries ( Begin , commit and rollback)

Rule 6: .View updating Rule

"All views that are theoretically updatable are also updatable by the system."

Rule 7: High-level insert, update and delete.

"The capability of handling a base relation or a derived relation as a single operand applies not only to the retrieval of data but also to the insertion, update and deletion of data."

Rule 8: Physical data independence.

"Application programs and terminal activities remain logically unimpaired whenever any changes are made in either storage representations or access methods."

Rule 9: Logical Data Independence

"Application programs and terminal activities remain logically unimpaired when informatino-preserving changes of any kind that theoritically permit un-impairement are made to the base-tables."

Rule 10: Integrity independence.

"Integrity constraints specific to a particular relational data base must be definable in the

relational data sub-language and storable in the catalog, not in the application programs."

Rule 11: Distribution independence.

"A relational DBMS has distribution independence."

Rule 12: Non-subversion Rule.

"If a relational system has a low-level (single-record-at-a-time) language, that low level cannot be used to subvert or bypass the integrity Rules and constraints expressed in the higher level relational language (multiple-records-at-a-time)."

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 31. What are different types of joins in SQL?

INNER JOIN

Inner join shows matches only when they exist in both tables. Example in the below SQL there are two tables Customers and Orders and the inner join in made on Customers. Customerid and Orders.Customerid. So this SQL will only give you result with customers who have orders. If the customer does not have order it will not display that record.

SELECT Customers.*, Orders.* FROM Customers INNER JOIN Orders ON Customers.CustomerID=Orders.CustomerID

LEFT OUTER JOIN

Left join will display all records in left table of the SQL statement. In SQL below customers with or without orders will be displayed. Order data for customers without orders appears as NULL values. For example, you want to determine the amount ordered by each customer and you need to see who has not ordered anything as well. You can also see the LEFT OUTER JOIN as a mirror image of the RIGHT OUTER JOIN (Is covered in the next section) if you switch the side of each table.

SELECT Customers.*, Orders.* FROM Customers LEFT OUTER JOIN Orders ON

Customers.CustomerID =Orders.CustomerID

RIGHT OUTER JOIN

Right join will display all records in right table of the SQL statement. In SQL below all orders with or without matching customer records will be displayed. Customer data for orders without customers appears as NULL values. For example, you want to determine if there are any orders in the data with undefined CustomerID values (say, after a conversion or something like it). You can also see the RIGHT OUTER JOIN as a mirror image of the LEFT OUTER JOIN if you switch the side of each table.

SELECT Customers.*, Orders.* FROM Customers RIGHT OUTER JOIN Orders ON

Customers.CustomerID =Orders.CustomerID

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 32. What�s the difference between DELETE and TRUNCATE?

Following are difference between them:

DELETE TABLE syntax logs the deletes thus making the delete operations low. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table. So TRUNCATE table is faster as compared to delete table.
DELETE table can have criteria while TRUNCATE can not.
TRUNCATE table can not have triggers.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 33. What is the difference between �HAVING� and �WHERE� clause?

�HAVING� clause is used to specify filtering criteria for �GROUP BY�, while �WHERE� clause applies on normal SQL.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 34. What are Aggregate and Scalar Functions?

Aggregate and Scalar functions are in built function for counting and calculations.

Aggregate functions operate against a group of values but returns only one value.

AVG(column) :- Returns the average value of a column

COUNT(column) :- Returns the number of rows (without a NULL value) of a column

COUNT(*) :- Returns the number of selected rows

MAX(column) :- Returns the highest value of a column

MIN(column) :- Returns the lowest value of a column

Scalar functions operate against a single value and return value on basis of the single value.

UCASE(c) :- Converts a field to upper case

LCASE(c) :- Converts a field to lower case

MID(c,start[,end]) :- Extract characters from a text field

LEN(c) :- Returns the length of a text

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 35. What is a View?

View is a virtual table which is created on the basis of the result set returned by the select

statement.

CREATE VIEW [MyView] AS SELECT * from pcdsEmployee where LastName = 'singh'

In order to query the view.

SELECT * FROM [MyView]

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 36. What is Object Oriented model?

This model is based on collection of objects. An object contains values stored in instance variables with in the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 37. What is Fully Functional dependency?

It is based on concept of full functional dependency. A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 38. What is 3NF?

A relation schema R is in 3NF if it is in 2NF and for every FD X A either of the following is true

1. X is a Super-key of R.

2. A is a prime attribute of R.

In other words, if every non prime attribute is non-transitively dependent on primary key.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 39. What is meant by query optimization?

The phase that identifies an efficient execution plan for evaluating a query that has the least estimated cost is referred to as query optimization.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 40. What do you mean by atomicity and aggregation?

1. Atomicity: Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete transactions. DBMS ensures this by undoing the actions of incomplete transactions.

2. Aggregation: A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 41. Are the resulting relations of PRODUCT and JOIN operation the same?

No.

PRODUCT: Concatenation of every row in one relation with every row in another.

JOIN: Concatenation of rows from one relation and related rows from another.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 42. What is Buffer Manager?

It is a program module, which is responsible for fetching data from disk storage into main memory and deciding what data to be cache in memory.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 43. What is Transaction Manager?

It is a program module, which ensures that database, remains in a consistent state despite system failures and concurrent transaction execution proceeds without conflicting.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 44. What is File Manager?

It is a program module, which manages the allocation of space on disk storage and data structure used to represent information stored on a disk.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Experienced / Expert level questions & answers

Ques 45. What is normalization? What are different type of normalization?

There is set of rules that has been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is known as Normalization.

Benefits of Normalizing your database include:

=>Avoiding repetitive entries

=>Reducing required storage space

=>Preventing the need to restructure existing tables to accommodate new data.

=>Increased speed and flexibility of queries, sorts, and summaries.

Following are the three normal forms :-

First Normal Form:

For a table to be in first normal form, data must be broken up into the smallest un possible.In addition to breaking data up into the smallest meaningful values, tables first normal form should not contain repetitions groups of fields.

Second Normal form:

The second normal form states that each field in a multiple field primary keytable must be directly related to the entire primary key. Or in other words,each non-key field should be a fact about all the fields in the primary key.

Third normal form:

A non-key field should not depend on other Non-key field.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 46. What is denormalization?

Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 47. Can you explain Fourth Normal Form and Fifth Normal Form?

In fourth normal form it should not contain two or more independent multi-v about an entity and it should satisfy �Third Normal form�.

Fifth normal form deals with reconstructing information from smaller pieces of information.

These smaller pieces of information can be maintained with less redundancy.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 48. Have you heard about sixth normal form?

If we want relational system in conjunction with time we use sixth normal form. At this moment

SQL Server does not supports it directly.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 49. We have an employee salary table how do we find the second highest from it?

Below Sql Query find the second highest salary:

SELECT * FROM wbEmployeeSalary a WHERE (2=(SELECT COUNT(DISTINCT(b.salary)) FROM wbEmployeeSalary b WHERE b.salary>=a.salary))

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 50. What is �CROSS JOIN�? or What is Cartesian product?

�CROSS JOIN� or �CARTESIAN PRODUCT� combines all rows from both tables. Number of rows will be product of the number of rows in each table. In real life scenario I can not imagine where we will want to use a Cartesian product. But there are scenarios where we would like permutation and combination probably Cartesian would be the easiest way to achieve it.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 51. Can you explain the SELECT INTO Statement?

SELECT INTO statement is used mostly to create backups. The below SQL backsup the

Employee table in to the EmployeeBackUp table. One point to be noted is that the structure of

wbEmployeeBackup and wbEmployee table should be same. SELECT * INTO

wbEmployeeBackup FROM wbEmployee

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 52. What is SQL injection?

It is a Form of attack on a database-driven Web site in which the attacker executes

unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a database from which the data would normally not be available and/or to gain access to an organization�s host computers through the computer that is hosting the database.

SQL injection attacks typically are easy to avoid by ensuring that a system has strong input

validation.

As name suggest we inject SQL which can be relatively dangerous for the database. Example this is a simple SQL

SELECT email, passwd, login_id, full_name FROM members WHERE email = 'x'

Now somebody does not put �x� as the input but puts �x ; DROP TABLE members;�.

So the actual SQL which will execute is :-

SELECT email, passwd, login_id, full_name FROM members WHERE email = 'x' ; DROP TABLE

members;

Think what will happen to your database.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 53. What is Data Independence?

Data independence means that "the application is independent of the storage structure and access strategy of data". In other words, The ability to modify the schema definition in one level should not affect the schema definition in the next higher level.

Two types of Data Independence:

1. Physical Data Independence: Modification in physical level should not affect the logical level.

2. Logical Data Independence: Modification in logical level should affect the view level.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 54. What is Functional Dependency?

A Functional dependency is denoted by X Y between two sets of attributes X and Y that are subsets of R specifies a constraint on the possible tuple that can form a relation state r of R. The constraint is for any two tuples t1 and t2 in r if t1[X] = t2[X] then they have t1[Y] = t2[Y]. This means the value of X component of a tuple uniquely determines the value of component Y.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 55. What is BCNF (Boyce-Codd Normal Form)?

A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 56. What is 4NF?

A relation schema R is said to be in 4NF if for every Multivalued dependency X Y that holds over R, one of following is true.

1.) X is subset or equal to (or) XY = R.

2.) X is a super key.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 57. What is 5NF?

A Relation schema R is said to be 5NF if for every join dependency {R1, R2, ..., Rn} that holds R, one the following is true

1) Ri = R for some i.

2) The join dependency is implied by the set of FD, over R in which the left side is key of R.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 58. What is Domain-Key Normal Form?

A relation is said to be in DKNF if all constraints and dependencies that should hold on the the constraint can be enforced by simply enforcing the domain constraint and key constraint on the relation.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 59. What are partial, alternate, artificial, compound and natural key?

1. Partial Key: It is a set of attributes that can uniquely identify weak entities and that are related to same owner entity. It is sometime called as Discriminator.

2. Alternate Key: All Candidate Keys excluding the Primary Key are known as Alternate Keys.

3. Artificial Key: If no obvious key, either stand alone or compound is available, then the last resort is to simply create a key, by assigning a unique number to each record or occurrence. Then this is known as developing an artificial key.

4. Compound Key: If no single data element uniquely identifies occurrences within a construct, then combining multiple elements to create a unique identifier for the construct is known as creating a compound key.

5. Natural Key: When one of the data elements stored within a construct is utilized as the primary key, then it is called the natural key.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 60. What is indexing and what are the different kinds of indexing?

Indexing is a technique for determining how quickly specific data can be found.

Types:

1. Binary search style indexing

2. B-Tree indexing

3. Inverted list indexing

4. Memory resident table

5. Table indexing

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 61. What is system catalog or catalog relation? How is better known as?

A RDBMS maintains a description of all the data that it contains, information about every relation and index that it contains. This information is stored in a collection of relations maintained by the system called metadata. It is also called data dictionary.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 62. What is durability in DBMS?

Once the DBMS informs the user that a transaction has successfully completed, its effects should persist even if the system crashes before all its changes are reflected on disk. This property is called durability.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 63. What is a Phantom Deadlock?

In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to identify deadlocks that do not really exist. Such situations are called phantom deadlocks and they lead to unnecessary aborts.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 64. What is a checkpoint and When does it occur?

A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during restart in the event of subsequent crashes.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 65. What is RDBMS KERNEL?

Two important pieces of RDBMS architecture are the kernel, which is the software, and the data dictionary, which consists of the system-level data structures used by the kernel to manage the database You might think of an RDBMS as an operating system (or set of subsystems), designed specifically for controlling data access; its primary functions are storing, retrieving, and securing data. An RDBMS maintains its own list of authorized users and their associated privileges; manages memory caches and paging; controls locking for concurrentresource usage; dispatches and schedules user requests; and manages space usage within its table-spacestructures.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 66. Name the sub-systems of a RDBMS.

I/O, Security, Language Processing, Process Control, Storage Management, Logging and Recovery, Distribution Control, Transaction Control, Memory Management, Lock Management.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 67. Which part of the RDBMS takes care of the data dictionary? How?

Data dictionary is a set of tables and database objects that is stored in a special area of the database and maintained exclusively by the kernel.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 68. What is the job of the information stored in data-dictionary?

The information in the data dictionary validates the existence of the objects, provides access to them, and maps the actual physical storage location.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 69. What is database Trigger?

A database trigger is a PL/SQL block that can defined to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the entire statement or once for every row that is inserted, updated, or deleted. For any one table, there are twelve events for which you can define database triggers. A database trigger can call database procedures that are also written in PL/SQL.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 70. What is Storage Manager?

It is a program module that provides the interface between the low-level data stored in database, application programs and queries submitted to the system.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 71. What is Authorization and Integrity manager?

It is the program module, which tests for the satisfaction of integrity constraint and checks the authority of user to access data.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 72. What are stand-alone procedures?

Procedures that are not part of a package are known as stand-alone because they independently defined. A good example of a stand-alone procedure is one written in a SQL*Forms application. These types of procedures are not available for reference from other Oracle tools. Another limitation of stand-alone procedures is that they are compiled at run time, which slows execution.

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Ques 73. What are cursors give different types of cursors?

PL/SQL uses cursors for all database information accesses statements. The language supports the use two types

of cursors

1.) Implicit

2.) Explicit

Save For Revision

Bookmark this item, mark it difficult, or place it in a revision set.

Open My Learning Library

Is it helpful? はいいいえ Add Comment View Comments

Most helpful rated by users:

Related interview subjects

MariaDB 面接の質問と回答 - Total 40 questions
DBMS 面接の質問と回答 - Total 73 questions
Apache Hive 面接の質問と回答 - Total 30 questions
SSIS 面接の質問と回答 - Total 30 questions
PostgreSQL 面接の質問と回答 - Total 30 questions
Teradata 面接の質問と回答 - Total 20 questions
SQL Query 面接の質問と回答 - Total 70 questions
SQLite 面接の質問と回答 - Total 53 questions
Cassandra 面接の質問と回答 - Total 25 questions
Neo4j 面接の質問と回答 - Total 44 questions
MSSQL 面接の質問と回答 - Total 50 questions
OrientDB 面接の質問と回答 - Total 46 questions
SQL 面接の質問と回答 - Total 152 questions
Data Warehouse 面接の質問と回答 - Total 20 questions
IBM DB2 面接の質問と回答 - Total 40 questions
Data Mining 面接の質問と回答 - Total 30 questions
Elasticsearch 面接の質問と回答 - Total 61 questions
Oracle 面接の質問と回答 - Total 34 questions
MongoDB 面接の質問と回答 - Total 27 questions
AWS DynamoDB 面接の質問と回答 - Total 46 questions
Entity Framework 面接の質問と回答 - Total 46 questions
MySQL 面接の質問と回答 - Total 108 questions
Data Modeling 面接の質問と回答 - Total 30 questions
Redis Cache 面接の質問と回答 - Total 20 questions

All interview subjects

C# 面接の質問と回答 - Total 41 questions
LINQ 面接の質問と回答 - Total 20 questions
ASP .NET 面接の質問と回答 - Total 31 questions
Microsoft .NET 面接の質問と回答 - Total 60 questions
ASP 面接の質問と回答 - Total 82 questions
IBM Watson 面接の質問と回答 - Total 30 questions
Perplexity AI 面接の質問と回答 - Total 40 questions
ChatGPT 面接の質問と回答 - Total 20 questions
NLP 面接の質問と回答 - Total 30 questions
AI Agents (Agentic AI) 面接の質問と回答 - Total 50 questions
OpenCV 面接の質問と回答 - Total 36 questions
Amazon SageMaker 面接の質問と回答 - Total 30 questions
TensorFlow 面接の質問と回答 - Total 30 questions
Hugging Face 面接の質問と回答 - Total 30 questions
Gemini AI 面接の質問と回答 - Total 50 questions
Artificial Intelligence (AI) 面接の質問と回答 - Total 47 questions
Oracle AI Agents 面接の質問と回答 - Total 50 questions
Machine Learning 面接の質問と回答 - Total 30 questions
Google Cloud AI 面接の質問と回答 - Total 30 questions
Scala 面接の質問と回答 - Total 48 questions
Swift 面接の質問と回答 - Total 49 questions
Golang 面接の質問と回答 - Total 30 questions
Embedded C 面接の質問と回答 - Total 30 questions
VBA 面接の質問と回答 - Total 30 questions
C++ 面接の質問と回答 - Total 142 questions
COBOL 面接の質問と回答 - Total 50 questions
R Language 面接の質問と回答 - Total 30 questions
Python Coding 面接の質問と回答 - Total 20 questions
CCNA 面接の質問と回答 - Total 40 questions
Oracle Cloud Infrastructure (OCI) 面接の質問と回答 - Total 100 questions
AWS 面接の質問と回答 - Total 87 questions
Azure Data Factory 面接の質問と回答 - Total 30 questions
Microsoft Azure 面接の質問と回答 - Total 35 questions
OpenStack 面接の質問と回答 - Total 30 questions
ServiceNow 面接の質問と回答 - Total 30 questions
Snowflake 面接の質問と回答 - Total 30 questions
Oracle APEX 面接の質問と回答 - Total 23 questions
PDPA 面接の質問と回答 - Total 20 questions
OSHA 面接の質問と回答 - Total 20 questions
HIPPA 面接の質問と回答 - Total 20 questions
PHIPA 面接の質問と回答 - Total 20 questions
FERPA 面接の質問と回答 - Total 20 questions
DPDP 面接の質問と回答 - Total 30 questions
PIPEDA 面接の質問と回答 - Total 20 questions
CCPA 面接の質問と回答 - Total 20 questions
GDPR 面接の質問と回答 - Total 30 questions
HITRUST 面接の質問と回答 - Total 20 questions
LGPD 面接の質問と回答 - Total 20 questions
Data Structures 面接の質問と回答 - Total 49 questions
Computer Networking 面接の質問と回答 - Total 65 questions
Microsoft Excel 面接の質問と回答 - Total 37 questions
Computer Basics 面接の質問と回答 - Total 62 questions
Computer Science 面接の質問と回答 - Total 50 questions
MS Word 面接の質問と回答 - Total 50 questions
Operating System 面接の質問と回答 - Total 22 questions
Tips and Tricks 面接の質問と回答 - Total 30 questions
PoowerPoint 面接の質問と回答 - Total 50 questions
Pandas 面接の質問と回答 - Total 30 questions
Deep Learning 面接の質問と回答 - Total 29 questions
PySpark 面接の質問と回答 - Total 30 questions
Flask 面接の質問と回答 - Total 40 questions
PyTorch 面接の質問と回答 - Total 25 questions
Data Science 面接の質問と回答 - Total 23 questions
SciPy 面接の質問と回答 - Total 30 questions
Generative AI 面接の質問と回答 - Total 30 questions
NumPy 面接の質問と回答 - Total 30 questions
Python 面接の質問と回答 - Total 106 questions
Python Pandas 面接の質問と回答 - Total 48 questions
Python Matplotlib 面接の質問と回答 - Total 30 questions
Django 面接の質問と回答 - Total 50 questions
MariaDB 面接の質問と回答 - Total 40 questions
DBMS 面接の質問と回答 - Total 73 questions
Apache Hive 面接の質問と回答 - Total 30 questions
SSIS 面接の質問と回答 - Total 30 questions
PostgreSQL 面接の質問と回答 - Total 30 questions
Teradata 面接の質問と回答 - Total 20 questions
SQL Query 面接の質問と回答 - Total 70 questions
SQLite 面接の質問と回答 - Total 53 questions
Cassandra 面接の質問と回答 - Total 25 questions
Neo4j 面接の質問と回答 - Total 44 questions
MSSQL 面接の質問と回答 - Total 50 questions
OrientDB 面接の質問と回答 - Total 46 questions
SQL 面接の質問と回答 - Total 152 questions
Data Warehouse 面接の質問と回答 - Total 20 questions
IBM DB2 面接の質問と回答 - Total 40 questions
Data Mining 面接の質問と回答 - Total 30 questions
Elasticsearch 面接の質問と回答 - Total 61 questions
Oracle 面接の質問と回答 - Total 34 questions
MongoDB 面接の質問と回答 - Total 27 questions
AWS DynamoDB 面接の質問と回答 - Total 46 questions
Entity Framework 面接の質問と回答 - Total 46 questions
MySQL 面接の質問と回答 - Total 108 questions
Data Modeling 面接の質問と回答 - Total 30 questions
Redis Cache 面接の質問と回答 - Total 20 questions
Data Engineer 面接の質問と回答 - Total 30 questions
Robotics 面接の質問と回答 - Total 28 questions
AutoCAD 面接の質問と回答 - Total 30 questions
Power System 面接の質問と回答 - Total 28 questions
Electrical Engineering 面接の質問と回答 - Total 30 questions
Verilog 面接の質問と回答 - Total 30 questions
Digital Electronics 面接の質問と回答 - Total 38 questions
VLSI 面接の質問と回答 - Total 30 questions
Software Engineering 面接の質問と回答 - Total 27 questions
MATLAB 面接の質問と回答 - Total 25 questions
Civil Engineering 面接の質問と回答 - Total 30 questions
Electrical Machines 面接の質問と回答 - Total 29 questions
Oracle CXUnity 面接の質問と回答 - Total 29 questions
Web Services 面接の質問と回答 - Total 10 questions
Salesforce Lightning 面接の質問と回答 - Total 30 questions
IBM Integration Bus 面接の質問と回答 - Total 30 questions
Power BI 面接の質問と回答 - Total 24 questions
OIC 面接の質問と回答 - Total 30 questions
Web API 面接の質問と回答 - Total 31 questions
Dell Boomi 面接の質問と回答 - Total 30 questions
Salesforce 面接の質問と回答 - Total 57 questions
IBM DataStage 面接の質問と回答 - Total 20 questions
Talend 面接の質問と回答 - Total 34 questions
TIBCO 面接の質問と回答 - Total 30 questions
Informatica 面接の質問と回答 - Total 48 questions
Java Applet 面接の質問と回答 - Total 29 questions
Java Mail 面接の質問と回答 - Total 27 questions
Google Gson 面接の質問と回答 - Total 8 questions
Java 21 面接の質問と回答 - Total 21 questions
RMI 面接の質問と回答 - Total 31 questions
Java Support 面接の質問と回答 - Total 30 questions
Apache Camel 面接の質問と回答 - Total 20 questions
Struts 面接の質問と回答 - Total 84 questions
JAXB 面接の質問と回答 - Total 18 questions
J2EE 面接の質問と回答 - Total 25 questions
JUnit 面接の質問と回答 - Total 24 questions
Java OOPs 面接の質問と回答 - Total 30 questions
Apache Tapestry 面接の質問と回答 - Total 9 questions
JSP 面接の質問と回答 - Total 49 questions
Java Concurrency 面接の質問と回答 - Total 30 questions
JDBC 面接の質問と回答 - Total 27 questions
Java 11 面接の質問と回答 - Total 24 questions
Java Garbage Collection 面接の質問と回答 - Total 30 questions
Java Swing 面接の質問と回答 - Total 27 questions
Java Design Patterns 面接の質問と回答 - Total 15 questions
Spring Framework 面接の質問と回答 - Total 53 questions
JPA 面接の質問と回答 - Total 41 questions
JSF 面接の質問と回答 - Total 24 questions
Java 8 面接の質問と回答 - Total 30 questions
Hibernate 面接の質問と回答 - Total 52 questions
JMS 面接の質問と回答 - Total 64 questions
Java 17 面接の質問と回答 - Total 20 questions
Java Beans 面接の質問と回答 - Total 57 questions
Java Exception Handling 面接の質問と回答 - Total 30 questions
Spring Boot 面接の質問と回答 - Total 50 questions
Servlets 面接の質問と回答 - Total 34 questions
Kotlin 面接の質問と回答 - Total 30 questions
EJB 面接の質問と回答 - Total 80 questions
Java 15 面接の質問と回答 - Total 16 questions
Java Multithreading 面接の質問と回答 - Total 30 questions
Apache Wicket 面接の質問と回答 - Total 26 questions
Core Java 面接の質問と回答 - Total 306 questions
JBoss 面接の質問と回答 - Total 14 questions
Log4j 面接の質問と回答 - Total 35 questions
ITIL 面接の質問と回答 - Total 25 questions
Finance 面接の質問と回答 - Total 30 questions
JIRA 面接の質問と回答 - Total 30 questions
SAP MM 面接の質問と回答 - Total 30 questions
SAP ABAP 面接の質問と回答 - Total 24 questions
SCCM 面接の質問と回答 - Total 30 questions
Tally 面接の質問と回答 - Total 30 questions
Pega 面接の質問と回答 - Total 30 questions
Android 面接の質問と回答 - Total 14 questions
Mobile Computing 面接の質問と回答 - Total 20 questions
Xamarin 面接の質問と回答 - Total 31 questions
iOS 面接の質問と回答 - Total 52 questions
Ionic 面接の質問と回答 - Total 32 questions
Kubernetes 面接の質問と回答 - Total 30 questions
Microservices 面接の質問と回答 - Total 30 questions
Apache Kafka 面接の質問と回答 - Total 38 questions
Tableau 面接の質問と回答 - Total 20 questions
Adobe AEM 面接の質問と回答 - Total 50 questions
IAS 面接の質問と回答 - Total 56 questions
PHP OOPs 面接の質問と回答 - Total 30 questions
OOPs 面接の質問と回答 - Total 30 questions
Fashion Designer 面接の質問と回答 - Total 20 questions
Desktop Support 面接の質問と回答 - Total 30 questions
CICS 面接の質問と回答 - Total 30 questions
Yoga Teachers Training 面接の質問と回答 - Total 30 questions
Nursing 面接の質問と回答 - Total 40 questions
Linked List 面接の質問と回答 - Total 15 questions
Dynamic Programming 面接の質問と回答 - Total 30 questions
SharePoint 面接の質問と回答 - Total 28 questions
Behavioral 面接の質問と回答 - Total 29 questions
School Teachers 面接の質問と回答 - Total 25 questions
Language in C 面接の質問と回答 - Total 80 questions
Statistics 面接の質問と回答 - Total 30 questions
Digital Marketing 面接の質問と回答 - Total 40 questions
Apache Spark 面接の質問と回答 - Total 24 questions
Full-Stack Developer 面接の質問と回答 - Total 60 questions
IIS 面接の質問と回答 - Total 30 questions
System Design 面接の質問と回答 - Total 30 questions
VISA 面接の質問と回答 - Total 30 questions
Google Analytics 面接の質問と回答 - Total 30 questions
Cloud Computing 面接の質問と回答 - Total 42 questions
BPO 面接の質問と回答 - Total 48 questions
ANT 面接の質問と回答 - Total 10 questions
SEO 面接の質問と回答 - Total 51 questions
SAS 面接の質問と回答 - Total 24 questions
Control System 面接の質問と回答 - Total 28 questions
Agile Methodology 面接の質問と回答 - Total 30 questions
HR Questions 面接の質問と回答 - Total 49 questions
REST API 面接の質問と回答 - Total 52 questions
Content Writer 面接の質問と回答 - Total 30 questions
Banking 面接の質問と回答 - Total 20 questions
Checkpoint 面接の質問と回答 - Total 20 questions
Blockchain 面接の質問と回答 - Total 29 questions
Technical Support 面接の質問と回答 - Total 30 questions
Mainframe 面接の質問と回答 - Total 20 questions
Hadoop 面接の質問と回答 - Total 40 questions
Chemistry 面接の質問と回答 - Total 50 questions
Docker 面接の質問と回答 - Total 30 questions
Sales 面接の質問と回答 - Total 30 questions
Nature 面接の質問と回答 - Total 20 questions
Interview Tips 面接の質問と回答 - Total 30 questions
College Teachers 面接の質問と回答 - Total 30 questions
SDLC 面接の質問と回答 - Total 75 questions
Cryptography 面接の質問と回答 - Total 40 questions
RPA 面接の質問と回答 - Total 26 questions
Blue Prism 面接の質問と回答 - Total 20 questions
Memcached 面接の質問と回答 - Total 28 questions
GIT 面接の質問と回答 - Total 30 questions
DevOps 面接の質問と回答 - Total 45 questions
Accounting 面接の質問と回答 - Total 30 questions
SSB 面接の質問と回答 - Total 30 questions
Algorithm 面接の質問と回答 - Total 50 questions
Business Analyst 面接の質問と回答 - Total 40 questions
Splunk 面接の質問と回答 - Total 30 questions
Sqoop 面接の質問と回答 - Total 30 questions
JSON 面接の質問と回答 - Total 16 questions
OSPF 面接の質問と回答 - Total 30 questions
Insurance 面接の質問と回答 - Total 30 questions
Scrum Master 面接の質問と回答 - Total 30 questions
Accounts Payable 面接の質問と回答 - Total 30 questions
Computer Graphics 面接の質問と回答 - Total 25 questions
IoT 面接の質問と回答 - Total 30 questions
Bitcoin 面接の質問と回答 - Total 30 questions
Active Directory 面接の質問と回答 - Total 30 questions
Laravel 面接の質問と回答 - Total 30 questions
XML 面接の質問と回答 - Total 25 questions
GraphQL 面接の質問と回答 - Total 32 questions
Ansible 面接の質問と回答 - Total 30 questions
Electron.js 面接の質問と回答 - Total 24 questions
ES6 面接の質問と回答 - Total 30 questions
RxJS 面接の質問と回答 - Total 29 questions
NodeJS 面接の質問と回答 - Total 30 questions
Vue.js 面接の質問と回答 - Total 30 questions
ExtJS 面接の質問と回答 - Total 50 questions
jQuery 面接の質問と回答 - Total 22 questions
Svelte.js 面接の質問と回答 - Total 30 questions
Shell Scripting 面接の質問と回答 - Total 50 questions
Next.js 面接の質問と回答 - Total 30 questions
Knockout JS 面接の質問と回答 - Total 25 questions
TypeScript 面接の質問と回答 - Total 38 questions
PowerShell 面接の質問と回答 - Total 27 questions
Terraform 面接の質問と回答 - Total 30 questions
JCL 面接の質問と回答 - Total 20 questions
JavaScript 面接の質問と回答 - Total 59 questions
Ajax 面接の質問と回答 - Total 58 questions
Express.js 面接の質問と回答 - Total 30 questions
Ethical Hacking 面接の質問と回答 - Total 40 questions
Cyber Security 面接の質問と回答 - Total 50 questions
PII 面接の質問と回答 - Total 30 questions
Data Protection Act 面接の質問と回答 - Total 20 questions
BGP 面接の質問と回答 - Total 30 questions
Ubuntu 面接の質問と回答 - Total 30 questions
Linux 面接の質問と回答 - Total 43 questions
Unix 面接の質問と回答 - Total 105 questions
Weblogic 面接の質問と回答 - Total 30 questions
Tomcat 面接の質問と回答 - Total 16 questions
Glassfish 面接の質問と回答 - Total 8 questions
TestNG 面接の質問と回答 - Total 38 questions
Postman 面接の質問と回答 - Total 30 questions
SDET 面接の質問と回答 - Total 30 questions
UiPath 面接の質問と回答 - Total 38 questions
Quality Assurance 面接の質問と回答 - Total 56 questions
Selenium 面接の質問と回答 - Total 40 questions
Kali Linux 面接の質問と回答 - Total 29 questions
Mobile Testing 面接の質問と回答 - Total 30 questions
API Testing 面接の質問と回答 - Total 30 questions
Appium 面接の質問と回答 - Total 30 questions
ETL Testing 面接の質問と回答 - Total 20 questions
QTP 面接の質問と回答 - Total 44 questions
Cucumber 面接の質問と回答 - Total 30 questions
PHP 面接の質問と回答 - Total 27 questions
Oracle JET(OJET) 面接の質問と回答 - Total 54 questions
Frontend Developer 面接の質問と回答 - Total 30 questions
Zend Framework 面接の質問と回答 - Total 24 questions
RichFaces 面接の質問と回答 - Total 26 questions
HTML 面接の質問と回答 - Total 27 questions
Flutter 面接の質問と回答 - Total 25 questions
CakePHP 面接の質問と回答 - Total 30 questions
React 面接の質問と回答 - Total 40 questions
React Native 面接の質問と回答 - Total 26 questions
Angular JS 面接の質問と回答 - Total 21 questions
Web Developer 面接の質問と回答 - Total 50 questions
Angular 8 面接の質問と回答 - Total 32 questions
Dojo 面接の質問と回答 - Total 23 questions
GWT 面接の質問と回答 - Total 27 questions
Symfony 面接の質問と回答 - Total 30 questions
Ruby On Rails 面接の質問と回答 - Total 74 questions
CSS 面接の質問と回答 - Total 74 questions
Yii 面接の質問と回答 - Total 30 questions
Angular 面接の質問と回答 - Total 50 questions

集中型学習パス、模擬テスト、面接向けコンテンツでスキルを伸ばしましょう。

Interview Questions and Answers

Freshers / Beginner level questions & answers

Ques 1. What is database or database management systems (DBMS)?

Save For Revision

Ques 2. What's the difference between file and database? Can files qualify as a database?

Save For Revision

Ques 3. What is SQL?

Save For Revision

Ques 4. What�s difference between DBMS and RDBMS?

Save For Revision

Ques 5. What are E-R diagrams?

Save For Revision

Ques 6. How many types of relationship exist in database designing?

Save For Revision

Ques 7. What are DML and DDL statements?

Save For Revision

Ques 8. How do we select distinct values from a table?

Save For Revision

Ques 9. What is Like operator for and what are wild cards in DMBS?

Save For Revision

Ques 10. Can you explain Insert, Update and Delete query in DBMS?

Save For Revision

Ques 11. What is order by clause in DMBS?

Save For Revision

Ques 12. What is the SQL " IN " clause?

Save For Revision

Ques 13. Can you explain the between clause in DBMS?

Save For Revision

Ques 14. How to select the first record in a given set of rows?

Save For Revision

Ques 15. What is the default �-SORT � order for a SQL?

Save For Revision

Ques 16. What is a self-join?

Save For Revision

Ques 17. What�s the difference between �UNION� and �UNION ALL�?

Save For Revision

Ques 18. What are cursors and what are the situations you will use them?

Save For Revision

Ques 19. What is " Group by " clause?

Save For Revision

Ques 20. What is a Sub-Query?

Save For Revision

Ques 21. What is Data Model?

Save For Revision

Ques 22. What is Weak Entity set?

Save For Revision

Ques 23. What is an Entity?

Save For Revision

Ques 24. What is an attribute?

Save For Revision

Ques 25. What is degree of a Relation?

Save For Revision

Ques 26. What is Relationship?

Save For Revision

Ques 27. What is 1 NF (Normal Form)?

Save For Revision

Ques 28. What is 2NF?

Save For Revision

Ques 29. What is a foreign key, and what is it used for?

Save For Revision

Intermediate / 1 to 5 years experienced level questions & answers

Ques 30. What are CODD rules in DBMS?

Save For Revision

Ques 31. What are different types of joins in SQL?

Save For Revision

Ques 32. What�s the difference between DELETE and TRUNCATE?

Save For Revision

Ques 33. What is the difference between �HAVING� and �WHERE� clause?

Save For Revision

Ques 34. What are Aggregate and Scalar Functions?

Save For Revision

Ques 35. What is a View?

Save For Revision

Ques 36. What is Object Oriented model?

Save For Revision

Ques 37. What is Fully Functional dependency?

Save For Revision

Ques 38. What is 3NF?

Save For Revision