InterviewUp – Job Interview Questions and Answers – What should we do to copy the tables, schema and...

What should we do to copy the tables, schema and views from one SQL Server to another?

Comments (0) |

Inappropriate

Asked By: tom77

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

We have to write some DTS packages for it.

Tags

Edit

ORACLE DATA ACCESS

Asked At

Edit

None

Job Titles

Edit

Comments (0) :

Your Name:

Add your comment text

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

What are Schema Objects ?

Add or view comments about this interview question

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: spebby |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Schema objects are the logical structures that directly refer to the database's data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages anddatabase links.

Create Date

Saturday, May 10, 2008

Tags

ORACLE DATA ACCESS

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

What is a Data Dictionary ?

Inappropriate

Asked By: tom77 |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

The data dictionary of an ORACLE database is a set of tables and views that are used as a read-only reference about the database. It stores information about both the logical and physical structure of the database, the valid users of an ORACLE database, integrity constraints defined for tables in the database and space allocated for a schema object and how much of it is being used.

Create Date

Saturday, May 10, 2008

Tags

ORACLE DATA ACCESS

Asked At

None

Job Positions

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

What's the difference between COPY OF A FILE & MOVE_UPLOAD_FILE in file uploading?

Inappropriate

Asked By: kiran |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Move : This function checks to ensure that the file designated by filename is a valid upload file (meaning that it was uploaded via PHP's HTTP POST upload mechanism). If the file is valid, it will be moved to the filename given by destination.
If filename is not a valid upload file, then no action will occur, and move_uploaded_file() will return FALSE.
Copy :Makes a copy of a file. Returns TRUE if the copy succeeded, FALSE otherwise

Create Date

Saturday, March 15, 2008

Tags

file, copy, upload, move, php

Asked At

None

Job Positions

php

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

104

what is copy pending and check pending ?