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
what functionality does oracle provide to secure sensitive information?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How do you trace the traffic hitting a sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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.
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
How to start SQL Server in minimal configuration mode?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is the use of recording information about current session?