-
Database Design Questions
I have a database with 5 millions records, i have Person table having 5 million records and its have 13 columns. Forename and surname column is heavily populated as compared to other columns. My question is it appropriate to separate forename and surname column and make separate tables for it and reference it with id in person_detail table. What are the advantages and disadvantages in separating these...
-
Collections get nth Record from Index by Table
How to get nth record from index by table?
-
-
MS SQL Server and SQL Server
What is the difference between MS SQL Server and SQL Server? Are both same are not?
-
Mutating Trigger Timing
At what trigger timing does mutating trigger error occur?
Is it before/after or both? And is it for row level/statement level OR both? -
Physical and Logical Loss in Database
Can Physical and Logical loss in Database can recovered from Full backup?
-
Queries for Truck Booking
Consider the following tables which give details of customers, trucks and packets booked by
customers, which are carried by trucks and write SQL commands to do the following:
Tables:
CUSTOMER(c_no, c_name, c_address)
TRUCK(t_no, driver_name)
PACKET(p_no, c_no, t_no, date_of_booking, weight, destination)
Queries:
i) Destinations which have received more... -
-
Clone MySQL Database
How to Clone MySQL Database?
-
-
-
Diplay Records using ROWNUM, MINUS & UNION
Display 6th & 9th records only from the table using ROWNUM & MINUS & UNION ?
-
Redis Server Database Data Storage
1. How can I store data in Redis server database, with key as dynamic changing value and values as list of structure?
2. Where the data store in the system? -
-
RowSet Vs ResultSet
Why is RowSet implementation is beneficial over ResultSet?
-
-
-
Organization problems
Consider an organization by which you are familiar. If the organization is using file processing system then what are the problems organization will face?Explain with suitable examples.
-
Better Performance Collection
Which of following collection (nested tables, associative arrays, varrays) is better performance wise?
-
Database Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans