What is the difference between the SQL Loader and IMPORT
utilities?
Answer Posted / kunal sain
Sql loader can import data from any flat files
where as import command import data from exported file.
Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
which background process invoke at the time of upgradation tell me???
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
how can you create a user-defined lock?
when does an alert gets signaled?
Why would you call update statistics? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can you record information about current session?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Query processing is slow(eg select query)how will u solve that
What authentication modes does sql server support? : sql server DBA
what do you understand by fine-grained auditing?
What is the difference between dropping a database and taking a database offline? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?