Technical InterviewsTechnical InterviewsA Interviews related website which offers technical students with latest information on learning the tweaks in programming languages, information on all the best corporate companies in India. Articles
Interview Questions on SAP
2007-11-01 16:05:00 1. What does the inclusion of D&B for SAP R/3 in mySAP Edition mean for customers? Basically all mySAP Edition contract holders will automatically receive the D&B for SAP software as part of their regular Edition upgrade shipments. They will be able to install both A/R and A/P versions of the software as many times as ... More About: Questions , Interview
SAP Interview Questions
2007-11-01 15:59:00 1. Can you create a table with fields not referring to data elements? YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element. What are the different types of data dictionary objects? tables, structures, views, domains, data elements, lock objects, Match code objects. 2. What should be the approach for writing a ... More About: Questions , Interview
30 best Oracle Interview Questions
2007-10-14 16:22:00 1. How would you determine the time zone under which a database was operating? 2. Explain the use of setting GLOBAL_NAMES equal to TRUE. 3. What command would you use to encrypt a PL/SQL application? 4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. 5. Explain the use of table functions. 6. Name three advisory statistics you can collect. 7. ... More About: Questions , Oracle , Interview
Oracle Interview Questions Part 7
2007-10-14 16:19:00 What is an UTL_FILE.What are different procedures and functions associated with it? UTL_FILE is a package that adds the ability to read and write to operating system files Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ... More About: Questions , Oracle , Interview , Part
Oracle Interview Questions Part 6
2007-10-14 16:15:00 What is use of a cursor variable? How it is defined. A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type(like a pointer in C). Declaring a cursor variable: TYPE ... More About: Questions , Oracle , Interview , Part
Real time Oracle Interview Questions
2007-10-04 21:10:00 You have installed Oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem. Check to make sure that the archiver isn?t stuck. If archive logging is turned on during install a large ... More About: Questions , Time , Interview , Real
Oracle DBA Interview Questions Part 1
2007-10-04 21:04:00 If a table space shows excessive fragmentation what are some methods to defragment the table space? (7.1,7.2 and 7.3 only) In Oracle 7.0 to 7.2 The use of the ‘alter session set events ‘immediate trace name coalesce level ts# command is the easiest way to defragment contiguous free space fragmentation. The ts# parameter corresponds to the ... More About: Questions , Interview , Part
Database interview questions
2007-09-30 21:41:00 When should you increase copy latches? What parameters control copy latches When you get excessive contention for the copy latches as shown by the “redo copy” latch hit ratio. You can increase copy latches via the initialization parameter LOG_SIMULTANEOUS_COPIES to twice the number of CPUs on your system. Where can you get a list of all initialization ... More About: Questions , Interview , Database , Base
Oracle DBA interview questions
2007-09-30 21:37:00 A tablespace has a table with 30 extents in it. Is this bad? Why or why not. Multiple extents in and of themselves aren?t bad. However if you also have chained rows this can hurt performance. How do you set up tablespaces during an Oracle installation? You should always attempt to use the Oracle Flexible Architecture standard or ... More About: Questions , Interview
Oracle Interview Questions Part 1
2007-09-30 21:31:00 What special Oracle feature allows you to specify how the cost based system treats a SQL statement The COST based system allows the use of HINTs to control the optimizer path selection. If they can give some example hints such as FIRST ROWS, ALL ROWS, USING INDEX, STAR, even better. You want to determine the location of ... More About: Questions , Interview , Part
Oracle Interview Questions & Answers - 2
2007-09-26 15:37:00 A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check You need to check that the user has specified the full name of the object (select empid from scott.emp; instead of select empid from emp;) or has a synonym that balls to the ... More About: Questions , Oracle , Interview , Answers
Oracle Interview Questions & Answers - 1
2007-09-26 15:33:00 What are SQLCODE and SQLERRM and why are they important for PL/SQL developers? SQLCODE returns the value of the error number for the last error encountered. The SQLERRM returns the actual error message for the last error encountered. They can be used in exception handling to report, or, store in an error log table, the error ... More About: Questions , Oracle , Interview , Answers
Oracle Interview Questions & Answers
2007-09-21 13:55:00 What command would you use to create a backup control file? Alter database backup control file to trace. Give the stages of instance startup to a usable state where normal users may access it. STARTUP NOMOUNT - Instance startup STARTUP MOUNT - The database is mounted STARTUP OPEN - The database is opened What column differentiates the V$ views to the ... More About: Questions , Oracle , Interview , Answers
Oracle Interview Questions-V
2007-09-17 21:43:00 7. Compare and contrast TRUNCATE and DELETE for a table. Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just moves the high water mark and produces a now rollback. ... More About: Questions , Oracle , Interview
Oracle Interview Questions-IV
2007-09-17 21:41:00 1. Explain the difference between a hot backup and a cold backup and the benefits associated with each. A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it ... More About: Questions , Oracle , Interview
Oracle Interview Questions-III
2007-09-17 21:40:00 12.To view installed Oracle version information SQL> select banner from v$version; 13. Display the number value in Words SQL> select sal, (to_char(to_date(sal,’j'), ‘jsp’)) from emp; the output like, SAL (TO_CHAR(TO_DATE(SAL,’J'),’JS P’)) ——— —————— ;—————̵ 2;—————R 11; 800 eight hundred 1600 one thousand six hundred 1250 one thousand two hundred fifty If you want to add some text like, Rs. Three Thousand only. SQL> select sal “Salary “, (’ Rs. ‘|| (to_char(to_date(sal,’j'), ‘Jsp’))|| ‘ ... More About: Questions , Interview
Oracle Interview Questions-II
2007-09-13 09:21:00 Display the records between two range select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum< &Start); Enter value for upto: 10 Enter value for Start: 7 ROWNUM EMPNO ENAME ——— ——— ———- 1 7782 CLARK 2 ... More About: Questions , Oracle , Interview
Oracle Interview Questions-1
2007-09-07 17:21:00 1.To see current user name Sql> show user; 2.Change SQL prompt name SQL> set sqlprompt ?Manimara > ? Manimara > Manimara > 3.Switch to DOS prompt SQL> host 4.How do I eliminate the duplicate rows ? SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or SQL> delete from table_name ta where rowid >(select min(rowid) from table_name tb where ta.dv=tb.dv ... More About: Questions , Oracle , Interview
Oracle Interview Questions
2007-09-07 17:19:00 1. What are the components of physical database structure of Oracle database? Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files. 2. What are the components of logical database structure of Oracle database? There are tablespaces and database’s schema objects. 3. What is ... More About: Questions , Interview
How does the browser know to go to a certain IP address when you enter a do
2007-09-04 06:00:00 It searches through local DNS cache, if nothing is there, it queries the ISP?s DNS server. Share This More About: Browser , Enter , Address , Browse , Cert
How many logical drives is it possible to fit onto a physical disk?
2007-09-04 05:58:00 Maximum of 24 logical drives. The extended partition can only have 23 logical drives. Share This More About: Disk , Physical , Ossi , Logical , Logi
What are * and ? when using them for wildcards in Windows?* any characters,
2007-09-04 05:58:00 single character Share This More About: Windows , Characters , Char , Hara
What?s the maximum hard drive size for FAT16-based Windows system?
2007-09-04 05:51:00 2 GB Share This More About: Windows , System , Drive , Hard , Size
Where?s MBR located on the disk?
2007-09-04 05:44:00 Main Boot Record is located in sector 0, track 0, head 0, cylinder 0 of the primary active partition. Share This More About: Disk , The D , Loca
What?s the difference between L1 and L2 cache?
2007-09-04 05:43:00 Level 1 cache is internal to the chip, L2 is external. Share This More About: Difference , Cache , The D , Ween , Diff
What?s the speed and device maximum specs for Firewire?
2007-09-04 05:43:00 IEEE 1394 (Firewire ) supports the maximum of 63 connected devices with speeds up to 400 Mbps. Share This More About: Speed , Device , Maxi , Specs
Name the processor lines of two major manufacturers?
2007-09-04 05:42:00 High-end: Intel - Pentium (II, III, 4), AMD - Athlon. Low-end: Intel - Celeron, AMD - Duron. 64-bit: Intel - Itanium 2, AMD - Opteron. Share This More About: Manufacturers , Processor , Lines , Major , Manufacturer
Where does CPU Enhanced mode originate from?
2007-09-04 05:40:00 Intel?s 80386 was the first 32-bit processor, and since the company had to backward-support the 8086. All the modern Intel-based processors run in the Enhanced mode, capable of switching between Real mode (just like the real 8086) and Protected mode, which is the current mode of operation. Share This More About: Mode , Nate , Origin
Where does the Real mode on the CPU come from?
2007-09-04 04:58:00 The original 8086, which only had 1 MB of memory. This megabyte is split into low memory for IRQ tables, application memory and high memory. Share This More About: Mode , Real
What are the basic expansion card types?
More articles from this author:2007-09-04 04:57:00 ISA and PCI, ISA can be used only on XT, AT and ATX boards. The industry now considers ISA obsolete. Share This More About: Card , Basic , Types , Expansion 1, 2, 3, 4 |
|
 |
|
 |
