Can Physical and Logical loss in Database can recovered from Full backup?

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...

How to Clone MySQL Database?

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?

Which of following collection (nested tables, associative arrays, varrays) is better performance wise?

Suppose we have two database in one database there are 10 block ? then we want only eight block import in second dba how????

Why excessive redo generation in hot backups ?How to resolve it ?

Hi, I am starting oracle services on redhat linux ,
but unable to start " sql * plus service" from console as well as from em(oracle enterprise manager)
Error : "The connection was refused when attempting to contact localhost : 5560"

You have been asked to design the following database diagram:“We would like to store a list of user’s in the database with their corresponding network of friends, groups, as well as any messages which are swapped between them. A user consists of a username, password, first name, last name and profile picture. A message is a string. User’s can have many friends but usually start off with none or...

Explain the lifecycle regarding validating data from start to finish?

IRLM is a module of DB2 which doesA. LoggingB. Thread creationsC. Concurrency controlD. Both logging and thread creation.

Show the basic architecture of Data Warehouse and briefly describe its components.

Differentiate between Microsoft and Oracle's XML technology support for database.

What are the reasons of developing Object Oriented Database management system? Describe the various features of Object Oriented programming languages that are being supported by SQL with the help of an example each.

Provide VBScript code that that outputs the contents of a SQL table into a CSV formatted file called Output.csv. Your code must include the connection string and must use the following SQL criteria: SQL Server Name: DBServerDatabase Name: DBNameSQL User Login: SQLUserSQL User Password: SQLPasswordSQL Table: dbo.Exam (2 fields: FirstName, LastName)

You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen. For example, consider a system for a gift wishlist....

There is a new project to acquire a new data feed from a vendor and add it to a database to enhance coverage for a neglected market. The data feed consists of a daily set of 6 files, one primary file with one row per main object, 4 other files which relate to the main file, and a secondary object file which is loosely related to the first. The data is in plain text. What sort of information would...