Useful tips for everyday
How can I tell when a MySQL database was last updated? In MySQL’s latest version you can use the information_schema database if another table is…
Which one is an example of database designing? Explanation: Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database…
How to fix error 2003 in SQLyog? SQLyog needs to connect using TCP-IP. Some networking issue prevents connection. It could be a network malconfiguration or…
How does hints work in Oracle? Hints let you make decisions usually made by the optimizer. As an application designer, you might know information about…
What is the use of Rowlock in SQL Server? ROWLOCK means that SQL will lock only the affected row, and not the entire table or…
How do I create a dynamic PivotTable? Create a dynamic Pivot Table by using the OFFSET function Enter a name for the range in the…
How to create users on secondary standby database in log shipping? 1. Create login on production server 2. Create user in database mapped to login…
What are the properties of functional dependency? A functional dependency FD: X → Y is called trivial if Y is a subset of X. In…
How do I create a synonym in Oracle SQL? Introduction to Oracle CREATE SYNONYM statement First, specify the name of the synonym and its schema.…
How do I manually create a database in Oracle? Manually Creating an Oracle Database Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish…