Novell Certifications Interview Questions

 
1.
What is LDAP?
2.
What is the Difference between Windows 2003 standard Enterprise, Premium, Data center and Web Edition?
3.
How do you recover an object in Active Directory, which is accidentally deleted by you, with no backup?
4.
What is the Logical / Physical Structures of the AD Environment?
5.
How to change the windows xp product key if wrongly installed with other product key but you have original
product key? What you will do to Make your os as Genuine?
6.
If 512mb Ram is there what will be the minimum and maximum Virtual memory for the system?
7.
Ntfldr.exe is missing in win xp os what will you do?
8.
What is LDAP?
9.
What is the SYSVOL folder?
10.
What are application partitions? When do we use them?
11.
What is the KCC?
12.
What is tombstone lifetime attribute?
13.
How do we Backup Active Directory?
14.
How do we restore AD?
15.
What are GPOs?
16.
What is the order in which GPOs are applied?
17.
Name a few benefits of using GPMC?
18.
What are the GPC and the GPT? Where can I find them?
19.
What are GPO links? What special things can I do to them?
20.
What are administrative templates?
21.
Name the AD NCs and replication issues for each NC?
22.
What is MUTEX?
23.
What is the difference between a computer process and thread?
24.
What is INODE?
25.
Explain the working of Virtual Memory?
26.
How does Windows NT supports Multitasking?
27.
What is Semaphore?
28.
Recovery from Deadlock?
29.
What is multi tasking, multi programming, multi threading?
30.
Differentiate between RAM and ROM?
31.
Binding of Instructions and Data to Memory?
32.
Why paging is used?
33.
What is a Safe State and its use in deadlock avoidance?
34.
Explain the difference between microkernel and macro kernel?
35.
Differentiate between Compiler and Interpreter?
36.
What is the relation between process system time, process waiting time , and process CPU time?
37.
Condition for deadlock occurrence?
38.
Compare Linux credit based algorithm with other scheduling algorithms?
39.
Why thread is called as a lightweight process?
40.
What is the cause of thrashing? How does the system detect thrashing? Once it detects thrashing, what can the system do to eliminate this problem?
41.
Define Demand Paging, Page fault interrupt, and Trashing?
42.
Give a non-computer example of preemptive and non-preemptive scheduling?
43.
What is starvation and aging?
44.
If a system has 128 MB RAM and 1 GB hard Disk, and a process decides to use its fully allotted Virtual Memory 2^32 - 2GB = 2 GB, how is it practically possible?. But this works in all machines. How?
45.
Difference between Logical and Physical Address Space?
46.
Describe the actions taken by thread library to context switch between user level threads?
47.
Explain briefly about, processor, assembler, compiler, loader, linker and the functions executed by them?
48.
Explain Segmentation with paging?
49.
What are the major differences between windows XP and Windows 2000 operating systems?
50.
What is the difference between Hard and Soft real-time systems?
51.
Why are page sizes always powers of 2?
52.
On a system with paging, a process cannot access memory that it does not own why? How could the operating system allow access to other memory? Why should it or should it not?
53.
What is active directory? How it works?
What is dns? How it works?
What is dhcp? How it works?
What is ias? How it works?
54.
What is the main component of operating system?
55.
What are Dynamic Loading, Dynamic Linking and Overlays?
56.
What is Dispatcher?
57.
What is the difference between unix and windows?
58.
What is Context Switch?
59.
What are different tasks of Lexical Analysis?
60.
Deadlock Detection-Algorithm Usage?
61.
Common Functions of Interrupts?
62.
Distributed Systems?
63.
While running DOS on a PC, which command would be used to duplicate the entire diskette?
64.
What is CPU Scheduler?
65.
What do you mean by deadlock?
66.
Give an example of microkernel?
67.
What is the difference between a process and a task?
68.
Describe different job scheduling in operating systems?
69.
Difference between Primary storage and secondary storage?
70.
Explain the difference between microkernel and macro kernel?
71.
I have deleted a file from recycle bin but i want to use that file how can i restore that file? I have already used system restore for the same but the file could not be restore?
72.
What is a Real-Time System?
73.
What is the important aspect of a real-time system or Mission Critical Systems?
74.
What are the difference phases of software development or software life cycle?
75.
What are the main difference between Micro-Controller and Micro- Processor?
76.
What is the state of the processor, when a process is waiting for some event to occur?
77.
What is LDAP?
78.
How to switch between virtual terminals on your computer?
A. Fx
B. SHFT-Fx
C. CTRL-Fx
D. CTRL-ALT-Fx
E. The TAB key
79.
You have made the following entries on your da10 server:
da10:- #umask 033
da10:- # mkdir training
Which correctly reflect the permissions on the training directory?
A. drwx------
B. drwxr--r--
C. drw---x--x
D. drw--w--w-
E. drwx-rw-rwF. drwx--wx-wx
80.
Explain When booting up a Linux computer, which loads the kernel and the initrd to memory?
A. init
B. BIOS
C. Kernel
D. initramfs
E. Boot manager
81.
Previously user temps account was locked, but you cannot remember if it is still locked. As the
root user, when entering the command grep geeko /etc/shadow, what is displayed to help you
identify if the account is still locked?
A. If it is still locked, nothing will display.
B. If it is still locked, a # will appear before the password hash.
C. If it is still locked, an ! will appear before the password hash.
D. If it is still locked, the # symbol will appear for every value of the password hash.
E. if it is still locked, the * symbol will appear for every value of the password hash.
82.
Explain Which is the configuration file for init?
A. /etc/inittab
B. /sys/inittab
C. /root/inittab
D. /sbin/inittab
E. /boot/inittab
83.
From a terminal window, which command will allow you to change system wide defaults?
(Choose 2.)
A. gconfd-2
B. gconftool-2
C. gconf-editor
D. config-source
E. gconf-defaults
84.
What is the command to rename a file on your SLED 10 computer?
A. rn
B. mv
C. ren
D. move
E. rename
85.
When a user submits a print job, which directory contains the actual data to print?
A. /etc/cups/
B. /proc/cups/
C. /home/cups/
D. /var/spool/cups/
E. /srv/spool/cups/
86.
Which command sets the sticky bit to the /tmp directory?
A. chmod +s /tmp
B. chmod 0777 /tmp
C. chmod 1777 /tmp
D. chmod 7770 /tmp
E. chmod +s 777 /tmp
87.
Which keystroke switches the vi editor from insert mode back to command mode?
A. $
B. #
C. :
D. >
E. ~
F. Esc
88.
Shown below is results from the ls -l progress command:
-rw-rw-r-- 1 rtracy users 0 2007-02-07 15:30 progress
Which statement is true?
A. The group has read only rights to this file.
B. User rtracy has read only rights to this file.
C. User rtracy has read and write rights to this file.
D. All other users have read and write rights to this file.
E. All other users have read only rights to this directory
F. The group has read and write rights to this directory.
89.
With CUPS, each print queue is registered with its name in which file?
A. /etc/cups/printers.conf
B. /proc/cups/printers.conf
C. /home/cups/printers.conf
D. /var/spools/cups/printers.conf
E. /srv/spools/cups/printers.conf
90.
Which directory allows you see which services are loaded in runlevel 5?
A. /var/init/rc5/
B. /sys/init/rc5/
C. /etc/init.d/rc5.d/
D. /boot/inittab/rc5/
E. /root/init.d/rc5.d/
91.
You are logged is as user wparker and want to change the priority of process 1824. It is currently
at a nice value of 5. Being logged in as wparker, which command will change the priority?
A. renice -10 1824
B. renice -1 1824
C. renice 0 1824
D. renice 3 1824
E. renice 7 1824
F. Only root can change the nice value of a process.
92.
Which command shows who is currently on the system and their processes?
A. w
B. who
C. last
D. finger
E. lastlog
93.
Bash stores commands in a history file so you can have easy access to them gain later when
needed. In SUSE Linux Enterprise 10 Desktop, what is default maximum number of entries that
this file is set to?
A. 100
B. 250
C. 500
D. 1,000
E. 10,000
94.
There are several versions of grep in your system. You would like to find out which grep
command is being used when you run that command without specifying a path. Which command
will provide you this information?
A. grep
B. man grep
C. list grep
D. find grep
E. which grep
95.
What is the yast command to enter the software installation module from the command line?
A. yast sw_single
B. yast /sw_single
C. yast -l sw_single
D. yast -i sw_single
E. yast --i sw_single
96.
What GID number is assigned to system groups?
A. GID 0
B. GID 1 to 99
C. GID 100 to 199
D. GID 200 to 299
E. GID 300 and above
97.
Which will restart the Novell Client tray application from the command line?
A. /opt/novell//ncl/bin/tray
B. /opt/novell/ncl/bin/n_tray
C. /opt/novell/ncl/bin/ncl_tray
D. /opt/novell/ncl/bin/novell_tray
E. /opt/novell/ncl/bin/nclient_tray
98.
Explain The primary configuration of the automount program is contained in which file?
A. /etc/fstab
B. /etc/auto.misc
C. /etc/auto.home
D. /etc/auto.master
E. /root/automount.ldif
99.
Sample Novell CLE 9 Certification Exam Questions!
100.
How to install SLES 9?
101.
Explain function keys?
102.
Explain authentication method?
103.
What is Initial requirements for Novell Certification?
104.
How to take my NCLP exam. Can give me some pointers?
105.
How does someone become a novell certified linux professional?
106.
How to prepare for novell CLP certification?
107.
Explain Which ZENworks for Desktop 3 policy is a General category policy that can be applied to any Windows
95, 98, NT, or 2000 workstation that a user logs into?
A. Help Desk
B. User Extensible
C. NT User System
D. Dynamic Local User
E. Windows Terminal Server?
108.
Explain What is the console command to load the print server manager?
A. LOAD NDPS MANAGER
B. LOAD PSM
C. LOAD NDPS
D. LOAD NDPSM
E. LOAD BROKER
109.
Tell me Which eDirectory property right is only available on container objects?
A. Read
B. Write
C. Compare
D. Inheritable
E. Supervisor
F. Add/Remove self
110.
Suppose You have an alias object in your eDirectory tree with the name of Alias referring to a printer object with
the name of Certking 1.
What is a valid attribute type and value of the alias object?
A. A= Certking 1
B. P= Certking 1
C. CN= Certking 1
D. A=Alias
E. P=Alias
F. CN=Alias
111.
Tell me Which objects with eDirectory are leaf objects? (Choose two)
A. Tree
B. Group
C. Security
D. NDPS Broker
E. License container
112.
Tell me To set up iPrint, which objects must exist in your eDirectory tree? (Choose three)
A. Print queue
B. Print server
C. NDPS printer
D. NDPS broker
E. NDPS gateway
F. NDPS manager
113.
Explain The object class definitions within the schema define what?
A. Object placement within the tree.
B. The syntax structure of an attribute
C. The synchronization rules between replicas.
D. The types of objects that can exist in the tree.
E. The types of replicas that can exist in the tree.
114.
Explain Which firewall technology allows 2 or more hosts to exchange data over a public network using a secure
channel?
A. NAT
B. VPN
C. Packet filtering
D. IPX/IP gateway
E. Internet object caching
115.
Suppose You have deleted a file in the USERSCOMMON directory and have not changed any Netware defaults.
From which directory can you salvage this file?
A. DELETED.SAV
B. USERSCOMMON
C. SYSTEMDELETED
D. From the root of the volume.
E. It cannot be salvaged because it was immediately purged.
116.
Explain When assigning file system rights, which order is recommended?
A. Public, users, security equivalence, containers, groups
B. Public, containers, groups, users, security equivalence
C. Containers, groups, users, Public, security equivalence
D. Containers, groups, users, security equivalence, Public
E. Users, security equivalence, groups, containers, Public
117.
Tell me Which is a feature of the GroupWise 6 server?
A. Client caching mode
B. AutoComplete addressing
C. Multiple account signatures
D. Public Key Infrastructure support
118.
Tell me Which objects can you assign as object trustees that grant access to multiple users at once? (Choose three)
A. Tree
B. Group
C. Server
D. Volume
E. Security Container
F. Organizational role
119.
Explain Which objects are container objects? (Choose three)
A. Group
B. Server
C. Volume
D. Domain
E. Country
F. Organization
120.
Explain Which NetWare directory is available to users before logging into a NetWare server?A. ETC
B. LOGIN
C. PUBLIC
D. README
E. NETBASIC
121.
Explain Which Internet delivery components purpose is to create a system that prevents unauthorized users from
accessing proprietary information?
A. Router
B. Firewall
C. Proxy server
D. Cache server
122.
Explain Which is a workstation requirement for iFolder?
A. Internet Explorer 5 or 5.5.
B. At least 4 MB of free space.
C. At least 256 MB of memoery.
D. Windows 95, 98, 2000, NT, Me, or UNIX.
123.
Explain Which security feature of NetWare is a primary defense against password
hackers?
A. DSTRACE
B. Intruder lookout
C. SECURE CONSOLE
D. Console screensaver
124.
Explain Which allows users to send and receive email with international character
sets?
A. MTA
B. POA
C. MIME
D. POP3
E. IMAP4
125.
Tell me What can you assign to a GroupWise user object to identify this user with
a role, such as Travel?
A. Rule
B. Resource
C. Nickname
D. External entity
126.
Explain Which can you configure by selecting the Custom option when installing the Novell client? (Choose two)
A. DHCP
B. The default users login name.
C. The IP address that the client will use.
D. The network protocol for the client to use.
E. The type of connection the client should establish: NDS or bindery.
127.
Tell me Which statement is true of a user objects being moved?
A. All trustees assignments will have to be re-created.
B. If the user is a member of a group, that membership will be retained.
C. The context on the client workstation will automatically be changed to reflect the move.
D. If the user is an occupant of an organizational role, that occupancy will be lost.
E. If a user is security equivalent to another object, the security equivalence will need to be re-established.
128.
Tell me Which NetWare directory contains NetWare installation files?
A. NI
B. ETC
C. NSN
D. LOGIN
E. SYSTEM
129.
What is a function of the MTA?
A. To monitor disk space.
B. To store email messages.
C. To execute GroupWise client rules.
D. To transfer email messages between post offices and other domains.
130.
Suppose You are using the default configuration on your server. To access Web Manager from your workstation, you
open a browser, enter the servers IP address, and then enter which port number?
A. 443
B. 636
C. 2200
D. 8008
E. 8009
131.
Tell me When leaf objects can be configured to contain other leaf objects as members or occupants? (Choose two)
A. Alias
B. Group
C. Organizational Unit
D. Security Container
E. Organizational role
132.
Explain When setting up NDPS, which objects must be created?
A. Manager only
B. Manager and printer only
C. Broker and manager only
D. Broker, manager, and printer only
E. Broker, manager, gateway, and printer
133.
Explain Which NSS volume attribute maintains an inventory of all files on the
volume that have had their contents changed at some point since the last backup operation?
A. Backup
B. Salvage
C. Migration
D. Compression
E. Directory Quotas
F. Modified File List
G. User Space Restrictions
H. Flush Files Immediately on Close
134.
Suppose You need to access your NetWare 6.5 servers console. However, youre
currently in a different building. You decide to use Remote Manager to access the server from a
Windows XP workstation. Your servers DNS name is da5.da.com. What URL should use to access
Remote Manager? (Choose 2.)
A. http://da5.da.com:81
B. http://da5.da.com:8008
C. https://da5.da.com:444
D. https://da5.da.com:8009
E. http://da5.da.com/nps/RemoteManager.html
F. https://da5.da.com:443/nps/RemoteManager.html
135.
Tell me Where is the ConsoleOne utility located, by default, on a NetWare 6.5
server?
A. SYS:PUBLICMGMT
B. SYS:PUBLICCONSOLEONE
C. SYS:PUBLICMGMTCONSOLEONE
D. SYS:PUBLICCONSOLEONE1.2BIN
E. SYS:PUBLICMGMTCONSOLEONEBIN
F. SYS:PUBLICMGMTCONSOLEONE1.2
G. SYS:PUBLICMGMTCONSOLEONE1.2BIN
136.
Suppose You have a Novell Distributed Print Services (NDPS) Broker object in your
tree named Broker.SLC.DA. Which command would you use to load the Broker on a NetWare 6.5
server?
A. BROKER SLC.DA
B. BROKER BROKER.SLC.DA
C. BROKER CONTEXT=SLC.DA
D. BROKER -N BROKER.SLC.DA
E. NDPSBROKER BROKER.SLC.DA
F. NDPSBROKER CONTEXT=SLC.DA
G. NDPSBROKER -N BROKER.SLC.DA
137.
Tell me Which NetWare loadable module provides the iPrint service on a NetWare
6.5 server?
A. IPP.NLM
B. IPRINT.NLM
C. NPRINT.NLM
D. IPPSRVR.NLM
E. PSERVER.NLM
F. IPRINTSRVR.NLM
138.
Tell me Which product can be used to track eDirectory security issues? (Choose 2.)
A. Rsync
B. OpenSSH
C. BindView
D. NMAP.EXE
E. BURGLAR.NLM
F. SETPASS.NLM
G. CRACKER.NLM
H. Novell Branch Office Server
I. Novell Advanced Audit Service
139.
Tell me In NetWare 6.5, which file extension is used for network board drivers?
A. .NCF
B. .LAN
C. .HAM
D. .CDM
E. .NLM
140.
Explain Which web-based services does Virtual Office provide? (Choose 3.)
A. Chat
B. Calendar
C. Bookmarks
D. Spreadsheet
E. Word processor
F. Project management charts
141.
Suppose Drive G: is currently mapped to DA1DATA:. You need to remove this
drive mapping. To do this you would enter __________ at your workstations DOS prompt.
142.
Suppose During the installation of NetWare 6.5, the server files are installed on the
__________ volume.
143.
Explain Which utilities can you use to manage directory and file attributes on a
NetWare 6.5 server? (Choose 2.)
A. ICE
B. FLAG
C. iManager
D. iMonitor
E. NDS Manager
F. Remote Manager
144.
The __________ feature of NSS allows the sum of the sizes of each volume in
a partition to exceed the size of the partition itself.
145.
Explain Which describes the role of the Novell Distributed Print Services (NDPS)
printer agent?
A. It downloads the correct print driver to the workstation.
B. It responds to queries from clients about the status of a print job.
C. It provides a platform for printer objects that reside on the server.
D. It allows NDPS clients to sent print jobs to printers that are not NDPS-aware.
E. It redirects print jobs to directory on the server while waiting for the printer to become available.
F. It takes application-specific data from the application creating the print job and reformats it to work with the
printer it is being sent to.
146.
Tell me Which utility can be used to create NSS volumes in NetWare 6.5? (Choose
2.)
A. NSSMU
B. iMonitor
C. NWCONFIG
D. ConsoleOne
E. NDS Manager
F. NetWare Administrator
147.
Suppose Youve just installed a new content management application on your
NetWare 6.5 server. You installed it on the APPS volume in the KNOWLEDGE directory. To manage
the application, you must remember the full path to this directory. You want to create a search drive so
you dont have to remember the full path. Which command would you enter at the server console to do
this?
A. SEARCH APPS:KNOWLEDGE
B. MAP S1:=APPS:KNOWLEDGE
C. SEARCH ADD APPS:KNOLWEDGE
D. ADD SEARCH APPS:KNOWLEDGE
E. SEARCH APPS:KNOWLEDGE ADD
F. ADD APPS:KNOWLEDGE SEARCH
G. MAP INS S16:=APPS:KNOWLEDGE
148.
Tell me Which of the following are system files used by DR-DOS? (Choose 3.)
A. NTLDR
B. IO.SYS
C. MSDOS.SYS
D. IBMBIO.COM
E. IBMDOS.COM
F. COMMAND.COM
G. NTDETECT.COM
H. PAGEFILE.SYS
149.
Tell me By default, where does the STARTUP.NCF file reside?
A. C:
B. SYS:
C. SYS:ETC
D. C:NWSERVER
E. SYS:SYSTEM
F. SYS:PUBLIC
G. SYS:STARTUP
H. C:NWSERVERSTARTUP
I. C:NWSERVERDRIVERS
150.
Tell me Which tasks can be performed with ConsoleOne? (Choose 2.)
A. Manage licensing.
B. Assign rights to objects.
C. Browse very large trees.
D. Configure NDPS Brokers.
E. Change the servers IP address.
151.
Suppose Youre implementing a network for your company from scratch. Youve
just completed installing the CAT-5 wiring, RJ-45 jacks, and Fast Ethernet switches that will service
your network. During the installation of NetWare 6.5, the only system connected to the network is the
server you are performing the installation on. As you have decided to use the IPX protocol on your
network, what frame type will be bound, by default, to your servers network board by the installation
program?
A. 802.2
B. 802.3
C. 802.5
D. 802.11b
E. Ethernet_II
F. Ethernet_SNAP
152.
Suppose Youve just created an NSS volume on your NetWare 6.5 server named
SHARED. Your server name is WIDGET1. What will the volume object in eDirectory be named?
A. SHARED
B. WIDGET1_SHARED
C. WIDGET1~SHARED
D. WIDGET1#SHARED
E. WIDGET1&SHARED
F. NSS volumes dont have accompanying eDirectory objects.
153.
Explain Which of the following technologies is used by NetWare 6.5 to prevent data
from being written to bad blocks on the hard disk drive by redirecting it to a reserved area of the
partition?
A. HPFS
B. iSCSI
C. Rsync
D. Hot Fix
E. Hot-Plug
F. Overbooking
G. Storage Pools
H. Block Suballocation
154.
Which products does Virtual Office provide web-based access to? (Choose
3.)
A. eGuide
B. iFolder
C. NetStorage
D. WAN Manager
E. Remote Manager
F. Web Search Server
155.
Explain Novell mcne certification?
156.
What are benefits of mcne certification?
157.
Explain Types of questions asked in Novell MCNE certification exam?
158.
How to prepare for Novell MCNE certification?
159.
What is Android?
160.
What is BSD?
161.
Who maintains OpenBSD?
162.
What is new in OpenBSD 4.3?
163.
Is OpenBSD really free?
164.
Why is/is not ProductX included?
165.
What is in the file /etc/ttys?
166.
Who maintains the OpenBSD?
167.
How do you change your shell to bash?
168.
Explain the difference between SIGTERM and SIGKILL?
169.
Explain the difference between SIGHUP, SIGUSR1 and SIGUSR2?
170.
You are told that the permissions of a file are 645. Quick, how do you calculate what it means?
171.
How did you find initial support for a new distro?
172.
Explain difference between nfs soft and hard mouniting points?
173.
If we transfer 100 files by ftp to remote server, how to know the files are successfully transfer or some file are not transferred?
174.
Explain any one service which are working on UDP only?
175.
How many interfaces(ethernet cards) are working using single command?
176.
What is the status code 403,404 represented in apache server?
177.
How to monitor ports in a linux machine, with single command?
178.
Explain Difference between swap partition and swap file?
179.
How to recover /etc/passwd file and /etc/shadow file?
180.
How to know linux os is 32 bit or 64 bit?
181.
Suppose I lost a root password and i need to give it, I treid to change it through single usermode even though i am not get a password, then what is the other procedure to give a root password?
182.
What are different command to check ram, process and hdd of linux machine?
183.
What is lilo? How it is useful in linux?
184.
What is the command to change from /etc/passwd file to /etc/shadow file?
185.
What is the command to find the hardware configuration in Linux?
186.
How to root mirror in Linux? How to replace mirrored hdd in case of failure?
187.
What is the command to check wwn # in linux?
188.
How to give acl permission in numerical mode on linux?
189.
How to restart apache server with out shatdown?
190.
What is chainloading?
191.
How to hide the partition in GRUB booting?
192.
How to shuffle the GRUB booting from one Disk to other?
193.
What is the Difference between su and su- ?
194.
What is vnc?
195.
What is Linux?
196.
You need to see the last fifteen lines of the files dog, cat and horse. What command should you use?
197.
Who owns the data dictionary in Linux?
198.
You routinely compress old log files. You now need to examine a log from two months ago. In order to view its contents without first having to decompress it, use the _________ utility in Linux
199.
You suspect that you have two commands with the same name as the command is not producing the expected results. What command can you use to determine the location of the command being run?
200.
You locate a command in the /bin directory but do not know what it does. What command can you use to determine its purpose
201.
You wish to create a link to the /data directory in bob's home directory so you issue the command ln /data /home/bob/datalink but the command fails. What option should you use in this command line to be successful.
202.
Why is the new Microsoft operating system called Windows 7?
203.
Are there beta or release candidate versions that can be downloaded for testing purposes?
204.
Which editions of Windows 7 will be released?
205.
Where can I get this special pre-order deal?
206.
What are the minimum hardware requirements for Windows 7?
207.
What if I own a netbook?
208.
What if I buy a computer with Vista between now and October 22?
209.
What is better Windows 7 upgrade or full retail version? Does the upgrade contain all the features of full version?
210.
How can I install Windows 7 to a netbook with no DVD drive?
211.
What is the difference between the Upgrade and Custom installation options?
212.
How do I get my files and folders after upgrading from Windows XP or Windows Vista?
213.
How can we find programs and devices that work with the 64-bit version of Windows 7?
214.
Will the Windows 32-bit applications run if I switch to 64-bit variant of Windows 7
215.
How do I qualify for the students price of Windows 7? What about the OEM pricing?
216.
Is it possible to upgrade from one Vista Edition, like Home Premium to Window 7 Ultimate?
217.
If I run a 64-bit version of Windows, does that require a 64-bit driver for my devices?
218.
What do I do if I insert a CD or DVD and Windows 7 doesn�t recognize it?
219.
What can I do with a system with the minimum hardware recommendations?
220.
What features are available with each Windows 7 edition?
221.
What are some new features and hotkeys of Windows 7?
222.
What is the OPERATING SYSTEM?
223.
What are the OPERATING SYSTEM TYPES?
224.
What are the basic functions of an operating system?
225.
Why paging is used in OS?
226.
While running DOS on a PC, which command would be used to duplicate the entire diskette?
227.
What resources are used when a thread created? How do they differ from those when a process is created?
228.
What is the virtual memory?
229.
What is Throughput, Turnaround time, waiting time and Response time?
230.
What is the state of the processor, when a process is waiting for some event to occur?
231.
What is the important aspect of a real-time system or Mission Critical Systems?
232.
What is the difference between Hard and Soft real-time systems?
233.
What is the cause of thrashing? How does the system detect thrashing?
234.
What is multi tasking, multi programming and multi threading?
235.
What is hard disk and what is its purpose?
236.
What is fragmentation? Different types of fragmentation?
237.
What is DRAM? In which form does it store data?
238.
What is the Dispatcher?
239.
What is the CPU Scheduler?
240.
What is the Context Switch?
241.
What is the cache memory?
242.
What is a Safe State and what is its use in deadlock avoidance?
243.
What is the Real-Time System?
244.
What is Shell Script?
245.
What are PIDs?
246.
How do you send a mail message to somebody?
247.
How do you remove a file?
248.
How do you remove recursively?
249.
How do you find out your own username?
250.
How do you count words, lines and characters in a file?
251.
How do you search for a string inside a given file?
252.
How do you search for a string inside a directory?
253.
How do you search for a string in a directory with the subdirectories recursed?
254.
How do you list currently running process?
255.
How do you find out what�s your shell?
256.
How do you fire a process in the background?
257.
How do you refer to the arguments passed to a shell script?
258.
What�s the conditional statement in shell scripting?
259.
How do you do number comparison in shell scripts?
260.
How do you test for file properties in shell scripts?
261.
How do you do Boolean logic operators in shell scripting?
262.
How do you find out the number of arguments passed to the shell script?
263.
What�s a way to do multilevel if-else�s in shell scripting?
264.
How do you write a for loop in shell?
265.
How do you find out the current directory you�re in?
266.
What�s the command to find out users on the system?
267.
What�s the command to find out today�s date?
268.
How do you stop a process?
269.
How do you find out about all running processes?
270.
How do you stop all the processes, except the shell window?
271.
How do you define a function in a shell script?
272.
How do you read keyboard input in shell scripts?
273.
How does a case statement look in shell scripts?
274.
How do you write a while loop in shell?
275.
Explain about kadmin command?
276.
Explain about the command prof_attr?
277.
Explain the differences between setting files using octal codes and symbolic codes?
278.
What is the best solution to avoid large number of groups?
279.
What is umask?
280.
How can you determine whether a file is setUID?
281.
Explain about sticky bit permissions?
282.
Explain about the command ls?
283.
Explain about the limitations present in sudo?
284.
What is sudo?
285.
What are the different ways to execute profiles?
286.
What are the three different system management roles?
287.
What is Solaris Roles?
288.
What is RBAC?
289.
Describe about Logical Domains and its functions?
290.
Explain the interoperability features of Solaris?
291.
Explain about Solaris?
292.
Display the all files recursively with path under current directory ?
293.
Set the Display automatically for the current new user ?
294.
Display the processes, which are running under your username ?
295.
List some Hot Keys for bash shell ?
296.
Display the files in the directory by file size ?
297.
How to save man pages to a file ?
298.
How to know the date and time for . when script is executed ?
299.
How do you find out drive statistics?
300.
Display disk usage in Kilobytes?
301.
Display top ten largest files/directories?
302.
How much space is used for users in kilobytes?
303.
How to create null file?
304.
Access common commands quicker?
305.
Display the page size of memory?
306.
Display Ethernet Address arp table?
307.
Display the no.of active established connections to localhost?
308.
Display the state of interfaces used for TCP/IP traffic?
309.
Display the parent/child tree of a process?
310.
Show the working directory of a process?
311.
Display the processes current open files?
312.
Display the inter-process communication facility status?
313.
Display the top most process utilizing most CPU?
314.
Alternative for top command?
315.
What is Sun Solaris?
316.
What is the command to do an interactive boot from the ok prompt?
317.
Consider the following crontab entry: ?59 23 13 * 5 /wipe.disk? What time will this cronjob run?
318.
How can i disable STOP+A utility on SUN machines, which brings system into OK> prompt?
319.
How do we know how many LAN cards we have in server?
320.
What is "Piping" solaris?
321.
Where are the templates stored that are copied into the users home directories for their personal customizations?
322.
Which NFS daemons are found on the NFS server?
323.
What SPARC emergency keyboard sequence will take the system to the ok prompt (forth monitor) but will send output to TTYA?
324.
What file controls system wide password aging?
325.
Which of the following can be an appropriate name for a cluster?
326.
What flag used with patchadd will prevent a later back out by preventing patchadd from backing up files? If this flag is used, the patch cannot be removed.
327.
What file do you put the umask setting in?
328.
When using the admintool, the membership list for groups is separated by what?
329.
Among the applications below, which one is not a client/server application?
330.
What command will display the VTOC for disk c0t0d0s0?
331.
In order to save a template in /etc/format.dat, what two steps must occur?
332.
What command enables a printer?
333.
Which of the following commands can tell you whether packets are being delayed or dropped on your network?
334.
What file contains the location of the namespace configuration textfiles such as hosts.rev, named.local, etc..?
335.
What file controls global variables for system wide values for the Bourne Shell?
336.
Partition sizes can be set manually or from what configuration?
337.
The hardware-level user interface that you see before the operating system has been started is called:
338.
Give the command that will display your default boot device.
339.
How many different kill signals are there?
340.
What software install group do you need to select in order to load the compilers?
341.
The NVRAM is also soldered to the main logic board or motherboard.
342.
What command will install the patches: 123456-01 and 123457-01 if both are located in the /just.patches directory?
343.
What command can you use to display all of your groups?
344.
What field will cause the message Your password has expired to be displayed to the user?
345.
What is the command for seeing a long listing of all the processes running on your unix box?
346.
What is sticky bit in Solaris?
347.
How do you check the cron jobs of other users, (as a super user)
348.
What does this file /etc/path_to_inst contain and what is the importance of this file
349.
What is the command can reconfigure devices with out reboot?
350.
How to restore a corrupted file system or trouble shoot bad super blocks for a FS c0t2d0s5
351.
How will you add a virtual IP address to a server in Solaris. Given the interface qe0 and IP 10.10.1.150
352.
What are the different phases in boot process
353.
How do you determin which Run Level the sytem is running
354.
How would you find out what version of Solaris is currently running?
355.
What does reboot ?r do?
356.
What is the difference between a probe-scsi and a probe-scsi-all?
357.
What would a XIR signal do to a server and why would it be used?
358.
How would you find out what kernel parameter SHMMAX is set to by one command?
359.
What is after the VTOC on the root filesystem?
360.
What is difference between Process and Daemon in Solaris?
361.
How to install win xp after installing solaris for dual booting.
362.
You logged into the system using telnet.
As a system administrator, how would you figure out the system transaction is slow between the system you logged into and from the system you did telnet login?
363.
Why we use / for mount any filesystem?
364.
What is the big difference between /dev/dsk and /dev/rdsk
365.
How many cpus we can connect to a spark machine in Solaris?
366.
How can we find RAM size in solaris server?
367.
How to configure mail server in sun solaris?
368.
How to find 32 or 64 bit system instances of OS?
369.
What could be the reason and what files has to be checked to fix this and which log file we have to refer to know more details about the problem.
370.
Which obp command has a permanent allies?
371.
List the files in current directory sorted by size?
372.
List the hidden files in current directory?
373.
Delete blank lines in a file?
374.
Search for a sample string in particular files?
375.
Display the last newly appending lines of a file during appendingdata to the same file by some processes ?
376.
Display the Disk Usage of file sizes under each directory in current Directory ?
377.
Change to a directory, which is having very long name ?
378.
Display the all files recursively with path under current directory ?
379.
What is Symbians significance in the wireless market?
380.
In what areas do you think wireless Java on Symbian OS will be applied?
381.
What are your plans for Java on Symbian OS?
382.
Why should developers target Symbian OS, rather than any other phone running a Java VM?
383.
Can I install my paid copy of SlingPlayer Mobile for Symbian OS on multiple devices?
384.
What is the advantage of Symbian devices compared to J2ME and Brew devices?
385.
What is Cleanup mechanism in symbian?
386.
What is the difference between thread and activex objects?
387.
What is two phase construction?
388.
What is activex objects?why we need that?
389.
What is EPOC?
390.
Explain Symbian OS 9?
391.
State and explain about features of UNIX?
392.
Explain about sh?
393.
Explain about system and user utilities?
394.
Explain about document formatting?
395.
Explain about communication features in UNIX?
396.
Explain about chmod options filename?
397.
Explain about gzip filename?
398.
Explain about refer?
399.
Explain about lpr filename?
400.
Explain about lprm job number?
401.
Brief about the command ff?
402.
Brief about finger username?
403.
Explain about the command elm?
404.
Brief about the command kill PID?
405.
Explain about the command lynx?
406.
Brief about the command nn?
407.
Brief about ftp hostname?
408.
What is Unix?
409.
How are devices represented in UNIX OS?
410.
What is inode in UNIX OS?
411.
Brief about the directory representation in UNIX OS?
412.
What are the Unix system calls for I/O?
413.
How do you change File Access Permissions in UNIX OS?
414.
What are links and symbolic links in UNIX OS file system?
415.
What is a FIFO in UNIX OS?
416.
How do you create special files like named pipes and device files in UNIX OS?
417.
Discuss the mount and unmount system calls in UNIX OS?
418.
How does the inode map to data block of a file in UNIX OS?
419.
What is a UNIX OS shell?
420.
Brief about the initial process sequence while the UNIX system boots up.
421.
What are various IDs associated with a process in UNIX OS?
422.
Explain UNIX fork() system call.
423.
Predict the output of the following program code in UNIX?
424.
Predict the output of the following program code?
425.
List the system calls used for process management in UNIX?
426.
How can you get/set an environment variable from a program in UNIX?
427.
How can a parent and child process communicate?
428.
What is a zombie?
429.
What are the process states in Unix?
430.
What Happens when you execute a program?
431.
What Happens when you execute a command in UNIX OS?
432.
What is the major advantage of a hash table?
433.
What are the techniques that you use to handle the collisions in hash tables?
434.
In Unix OS, what is the file server?
435.
What is NFS? What is its job?
436.
What is CVS? List some useful CVS commands?
437.
How do you debug a core dump?
438.
How would you create shared and dynamic libraries?
439.
What are the differences between Shared and Dynamic libraries?
440.
Give examples of how memory leaks can occur with c programs?
441.
Explain the Unix file system?
442.
How would you remove a semaphore / shared memory whose owner processes have died?
443.
What is stty used for?
444.
What type of scheduling is used in Unix?
445.
Explain difference between IPC mechanisms?
446.
Construct pipes to execute the following jobs?
447.
How do Sockets Work?
448.
What is with the second parameter in bind()?
449.
If bind() fails, what should I do with the socket descriptor?
450.
When should I use shutdown()?
451.
Code Sample: a very simple client process.
452.
What are Sockets?
453.
How can I tell when a socket is closed on the other end?
454.
How do I get the port number for a given service?
455.
How do I properly close a socket?
456.
What is the difference between close() and shutdown()?
457.
Explain the TIME_WAIT state.
458.
How can I put a timeout on connect()?
459.
Why does the sockets buffer fill up sooner than expected?
460.
How often should I re-transmit un-acknowleged messages?
461.
How can I be sure that a UDP message is received?
462.
of the socket? Does doing a connect() call affect the receive behaviour?
463.
When should I use UDP instead of TCP?
464.
How can I read only one character at a time?
465.
What is the difference between SO_REUSEADDR and SO_REUSEPORT?
466.
How do I get my server to find out the clients address / host- name?
467.
What exactly does SO_KEEPALIVE do?
468.
What exactly does SO_REUSEADDR do?
469.
How can I make my server a daemon?
470.
How come I get address already in use from bind()?
471.
Why do I get connection refused when the server is not running?
472.
How can I set the timeout for the connect() system call?
473.
Why does connect() succeed even before my server did an accept()?
474.
How do I convert a string into an internet address?
475.
What are socket exceptions? What is out-of-band data?
476.
Why do I keep getting EINTR from the socket calls?
477.
Is there any advantage to handling the signal, rather than just ignoring it and checking for the EPIPE error? Are there any useful parameters passed to the signal catching function?
478.
How do I send [this] over a socket?
479.
How come select says there is data, but read returns zero?
480.
How can I force a socket to send the data in its buffer?
481.
What are the pros/cons of select(), non-blocking I/O and SIGIO?
482.
Why does it take so long to detect that the peer died?
483.
Why do I get EPROTO from read()?
484.
Where can a get a library for programming sockets?
485.
Whats the difference between select() and poll()?
486.
How do I use TCP_NODELAY?
487.
What is the difference between read() and recv()?
488.
After the chroot(), calls to socket() are failing. Why?
489.
When will my application receive SIGPIPE?
490.
How can I find the full hostname (FQDN) of the system I am running on?
491.
How can my client work through a firewall/proxy server?
492.
Why do I sometimes lose a servers address when using more than one server?
493.
system choose one for me on the connect() call? Should I bind() a port number in my client program, or let the?
494.
over the socket? Is there a way to have a dynamic buffer? What does one do when one does not know how much information is coming?
495.
Why do not my sockets close?
496.
How can I listen on more than one port at a time?
497.
What exactly does SO_LINGER do?
498.
How can I bind() to a port number < 1024?
499.
How should I choose a port number for my server?
500.
How can I write a multi-homed server?
501.
What is the difference between connected and unconnected sockets?
502.
How can I read ICMP errors from connected UDP sockets?
503.
How can I be sure that UDP messages are received in order?
504.
How come only the first part of my datagram is getting through?
505.
How would I put my socket in non-blocking mode?
506.
What are types of kernel objects?
507.
If we cannot alter these Kernel Object structures directly, how do our applications manipulate these kernel objects?
508.
User can access these kernel objects structures?
509.
How the handle helps in manipulating the kernel objects?
510.
You forget to call CloseHandle - will there be a memory leak?
511.
What is a kernel object?
512.
Name few functions that create Kernel Objects?
513.
How to identify the difference between the kernel object and user object?
514.
How does the kernel object outlive the process that created it?
515.
What is signaled and non signaled state?
516.
What is Synchronization Objects?
517.
What is DuplicateHandle (API)?
518.
What are Named Objects?
519.
Why the entries in the parent process table and child table are same?
520.
What is the need of process relative handles?
521.
What happens when the CloseHandle(handle) is called?
522.
What is handle?
523.
What is the purpose of Process Handle Table?
524.
Which is the data member common to all the kernel object and what is the use of it?
525.
How owns the Kernel Object?
526.
How do other threads own the mutex?
527.
How do I create a Mutex?
528.
APIs for creating event and set and reset the events?
529.
What is Event Object and why it is used?
530.
What is the limit on per process for creating a thread?
531.
What do you mean by unnamed object?
532.
What about the usage count in the parent child process tables?
533.
How the handles are handled in the child process?
534.
What is Mutex Object and why it is used?
535.
What is a thread?
536.
How is the balance of an invoice derived?
537.
What is MRC and what is its use?
538.
Describe the main tables involved in AR, and what is the data stored in them?
539.
What is the importance of Batch Source set up in AR?
540.
What do you mean by HZ_ in customer tables?
541.
What is the difference between _all, _tl, _vl, _v tables in Oracle Apps?
542.
How many Flex fields are there in AR and what are they?
543.
What is FSG and what is its use?
544.
What is the difference between conversions and interfaces?
545.
How many reporting currencies can be attached to Primary Set of Books?
546.
What are Different types of transactions in AR?
547.
What are value sets?
548.
What is the use of Transaction Flexfield in Autoinvoice?
549.
Explain Accounting for invoice in Advance and Arrears?
550.
What is an Oracle database Partial Backup?
551.
What is an Oracle database Full Backup?
552.
What is the difference between oracle media recovery and crash recovery?
553.
What is db_recovery_file_dest in oracle? When do you need to set this value?
Give me the steps to perform the point in time recovery with a backup which is taken before the reset logs of the db?
Tell me about the steps required to enable the RMAN backup for a target database?
554.
What is Restricted Mode of Instance Startup in Oracle?
555.
What is the difference between recovery and restoring of the oracle database?
556.
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
557.
What do you mean by Oracle MEDIA RECOVERY?
558.
What is the disk migration? what is the steps involved in oracle disk migration?
559.
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
560.
Why more redos are generated when the oracle database is in begin backup mode?
561.
What is PTO and ATO? Their functionality. How can we differentiate between them?
562.
Explain What is ORDER_TO_CASH cycle?
563.
Explain shipping process along with some screen shots?
564.
Explain What should be done when sales order lines are closed but header is still in Booked status?
565.
Explain What is the difference between a Purchase Order (PO) and Sales Order?
566.
Explain What are the interface programs done in Order Management?
567.
Explain the conversion of holds done using API? What are the tables affected? what are the fields to be passed and to which base tables?
568.
Explain What are the APIs used in Order Management?
569.
What is ONT stands for, as OE stands for Order Entry?
570.
Explain Order Management Flow in detail?
571.
Explain what are the setups involved in Drop Shipment Process?
572.
What is oracle d2k? why we use it?
573.
Were you involved in any data conversion, which one?
574.
Which Oracle Apps version you are very confident in?
575.
Total months of effort in Oracle Apps technical work?
576.
Are you familiar with User exits in reports?
577.
Do you know what are User Profiles in Apps. Any examples you can give?
578.
How many concurrent programs you have customized, can you name some of them?
579.
How to make the project as .exe file in oracle forms & reports(d2k)?
580.
How do you run ms_batch file in forms?
what could be the value :system.mode?
581.
How to get / select the nth row from the table?
how to select first n rows ,last n rows from a table?
582.
Do you know what is APPLYSYS in Oracle application database schema, what is APPS?
583.
Any work done in Oracle Workflow builder. Did you customize or build a new workflow?
584.
Do you know table based value sets?
585.
Which Flexfields you have customized?
586.
Have you good knowledge on Java?
587.
Have you used lexical parameters in reports?
588.
Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?
589.
Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?
590.
In oracle application how do you debug or trace errors?
591.
Are you familiar with internet architecture of Oracle Apps 11i?
592.
Which Oracle applications PL/SQL standard APIs you are familiar, have you used most of them?
593.
What are the new features in Release 11I?
594.
How I can use SRW.RUN_REPORT in Reports6i?
595.
How many different layouts are available in Reports6i? What are they?
in which sequence , form level trigger will fire? in which sequence, report trigger will fire?
how many types of canvas are there in form? what r they?
what are bind variables and lexical reference in oracle reports?
how many types of colums are there in Reports6i? what are they?
what is the purpose of placeHolder column in Report?
can u have a form with out a canvas?
what is confine mode and flex mode in reports?
how do u register report in oracleApps?
596.
What is the Placeholder Column?
What is the Format Trigger?
597.
I need to run a report at Scheduled timings only. I don?t want to run the report on Sundays. How to do this?
598.
What is the Anchoring in Reports?
What is the difference between Frame and Repeating Frame?
599.
What is the Page Protect in Reports?
600.
Explain Can we delete tuples in a table based on date column? And how?
601.
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
602.
Explain What is Read-Only Transaction?
603.
Explain What is Execution Plan?
604.
Explain What is SAVE POINT?
605.
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
606.
What is RULE-based approach to optimization?
607.
Explain Transaction?
608.
Explain What does COMMIT do?
609.
Explain What is the function of Optimizer?
610.
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
611.
Explain There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers. How?
612.
Explain When does a Transaction end?
613.
Explain What does ROLLBACK do?
614.
What is COST-based approach to optimization?
615.
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
616.
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
617.
Explain What are the values that can be specified for OPTIMIZER MODE Parameter?
618.
Explain database clusters?
619.
Explain What is a lookup table in database? where can we use these type of table?
620.
Explain Different types of table join?
621.
Explain When can hash cluster used?
622.
Explain What is an Oracle sequence?
623.
Explain What is an extent?
624.
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
625.
Explain What is hash cluster?
626.
Explain What is a tablespace?
627.
Explain What is index cluster?
628.
Tell us Do you need a commit after DDL statements?
629.
What is the difference between indexes,views,synonyms?
630.
Explain What are the basic element of base configuration of an Oracle database?
631.
Explain What is ORA-1555?
632.
Explain How do we handle exceptions / errors in stored procedures?
633.
Explain Do a view contain data?
634.
Explain What are the different types of segments?
635.
Explain What does a control file contains?
636.
Explain What is a deadlock?
637.
What is uses of rollback segment?
638.
Explain some built-in functions that can be used in SQL queries?
639.
What is Parallel Server in Oracle?
640.
What are the types of synonyms in Oracle?
641.
Explain What is a database instance?
642.
Explain Can we decrease the Datafile size?
643.
What is an Oracle Rollback Segment?
644.
What are the uses of Oracle Rollback Segment?
645.
What are Oracle Schema Objects?
646.
What is an Oracle Data Block?
647.
Can objects of the same Schema reside in different tablespaces?
648.
What is the use of Oracle Control File?
649.
Can a View based on another View in Oracle?
650.
What is the function of Redo Log in Oracle?
651.
Describe the different type of Integrity Constraints supported by ORACLE?
652.
What is an Oracle Data Dictionary?
653.
What is an Oracle SYSTEM tablespace and when is it Created?
654.
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
655.
How to define Data Block size in Oracle?
656.
What is an Integrity Constrains in Oracle?
657.
Can a Tablespace hold objects from different Schemes in Oracle?
658.
What is an oracle database schema?
659.
What is an Oracle Data Segment?
660.
Explain What is user Account in Oracle database?
661.
Explain What is Privilege Auditing?
662.
What is a database security profile?
663.
Explain What is Auditing? What are the different Levels of Auditing?
664.
Explain What is a trace file and how is it created?
665.
Explain What are Roles?
666.
Explain What is Statement Auditing?
667.
Explain What are the system resources that can be controlled through Profile?
668.
Explain What is an Auditing?
669.
Explain What is an Object Auditing?
670.
Explain What are the responsibilities of a Database Administrator?
671.
Explain What is default tablespace?
672.
Explain What is a user Account in Oracle database?
673.
Explain What are the roles and user accounts created automatically with the database?
674.
Explain What are the steps to creating a password authentication file?
675.
Explain What are the database administrators utilities avaliable?
676.
Explain if you have database,then how can you tell the data in the "database is secured". And what is ment by "data validation"?
677.
Explain What is Tablespace Quota?
678.
What are the security features in Oracle?
679.
Explain How you can secure our data in local area Network?
680.
Explain What are roles? How can you implement roles?
681.
Explain How can you specify the Archived log file name format and destination?
682.
Explain How can we enable automatic archiving?
683.
When using Oracle export/import what character set concerns might come up? How do you handle them?
684.
How do you use automatic PGA memory management with Oracle 9i and above?
685.
Explain two easy SQL optimizations.
686.
Name three SQL operations that perform a SORT.
687.
What is your favorite tool for day-to-day Oracle operation?
688.
What is the difference between Truncate and Delete? Why is one faster?
Can we ROLLBACK both? How would a full table scan behave after?
689.
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
690.
What does the NO LOGGING option do? Why would we use it? Why would we be careful of using it?
691.
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
692.
What is the difference between RMAN and a traditional hotbackup?
693.
What are bind variables and why are they important?
694.
In PL/SQL, what is bulk binding, and when/how would it help performance?
695.
Why is SQL*Loader direct path so fast?
696.
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
697.
What is the difference between RAID 5 and RAID 10? Which is better for Oracle?
698.
what is difference between Co-related sub query and nested sub query?
699.
How do I write a cron which will run a SQL query and mail the results to a group?
700.
What operator performs pattern matching
701.
What is the use of the DROP option in the ALTER TABLE command?
702.
Which date function is used to find the difference between two dates?
703.
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
704.
Which function is used to find the largest integer less than or equal to a specific value?
705.
What operator tests column for the absence of data?
706.
What are the steps involved in Database Start up?
707.
What are the different modes of mounting a Database with the Parallel
Server?
708.
What is Oracle Full Backup?
709.
What is Oracle Partial Backup?
710.
What is Oracle Archived Redo Log?
711.
What are the advantages of operating a database in ARCHIVELOG mode
over operating it in NO ARCHIVELOG mode?
712.
What is Oracle Log Switch?
713.
What are the steps involved in Instance Recovery in Oracle?
714.
Do you need a commit after DDL statements?
715.
How would you pass hints to the SQL processor?
716.
what is the difference between group by and order by?
717.
A DBA had to remove some Archivelogs to free up space in filesystem. Now when the RMAN job starts to backup Archivelogs, it complains about missing Archivelogs that were deleted by DBA. To resolve the issue and continue backing up remainder of Archivelogs, which RMAN command can be used so it wo not complain about missing Archivelogs.
718.
Which RMAN command is used to create an exact replica of a database in new host?
719.
How do you install Statspack?
720.
Process you follow to start looking into Performance issue at database level (If the application is running very slow, at what points do you need to go about the database in
order to improve the performance?)
721.
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?
722.
List five most important parameter in 9i affecting performance?
723.
What is PGA_AGGREGATE_TARGET?
724.
How do you analyze table partition using Oracle provided package?
725.
You see a wait on LMS process in statspack, what does that mean?
726.
Explain procedure to Change CHARACTERSET of a database.
727.
If you had a tablespace, TEST_TABLESPACE, which consists of three files: TEST01.dbf, TEST02.dbf, and TEST03.dbf, and someone accidentally used the Unix command "rm" to delete the file TEST02.dbf, what else would you need in order to recover all the data that was present in TEST_TABLESPACE at the time that TEST02.dbf was deleted?
728.
How do you put database is ARCHIVELOG mode, explain procedure?
729.
How can you tell if an index on particular table is USED or NOT USED in 9i?
730.
Explain FORCE LOGGING feature in 9i.
731.
What is LDAP?
732.
When can Hash Cluster used?
733.
Explain Database Link?
734.
What are the types of Database Links?
735.
What is Private Database Link?
736.
What is Public Database Link?
737.
What is Network Database link?
738.
What is Data Block?
739.
How to define Data Block size?
740.
What are the components of Physical database structure of Oracle Database?
741.
What are the components of Logical database structure of ORACLE database?
742.
What is Tablespace?
743.
What is SYSTEM tablespace and When is it Created?
744.
Explain the relationship among Database, Tablespace and Data file?
745.
What is schema?
746.
What are Schema Objects?
747.
Can a Tablespace hold objects from different Schemes?
748.
Explain Table?
749.
Explain View?
750.
Explain Can a View based on another View?
751.
Explain Do View contain Data?
752.
Explain What are the advantages of Views?
753.
What is Sequence?
754.
Explain a Synonym?
755.
Explain What are the type of Synonyms?
756.
Explain a Private Synonyms?
757.
What is a Public Synonyms?
758.
Explain What are synonyms used for?
759.
Explain an Index?
760.
Explain How are Indexes Update?
761.
Explain What are Clusters?
762.
What is cluster Key?
763.
What is Index Cluster?
764.
What is Hash Cluster?
765.
What is the maximum number of CHECK constraints that can be defined on a column?
766.
What are the Limitations of a CHECK Constraint?
767.
What is self-referential integrity constraint?
768.
What is Row Chaining?
769.
Explain an Extent?
770.
Explain a Segment?
771.
Explain What are the different type of Segments?
772.
Explain a Data Segment?
773.
Explain an Index Segment?
774.
What is Rollback Segment?
775.
Explain What are the uses of Rollback Segment?
776.
What is a Temporary Segment?
777.
What is Data File?
778.
Explain What are the Characteristics of Data Files?
779.
What is Redo Log?
780.
What is the function of Redo Log?
781.
What is the use of Redo Log Information?
782.
Explain What does a Control file Contain?
783.
Explain the use of Control File?
784.
What is a Data Dictionary?
785.
Explain an Integrity Constrains?
786.
What constitute an ORACLE Instance?
787.
What is SGA?
788.
What are the components of SGA?
789.
What do Database Buffers contain?
790.
Describe two phases of Oracle Two-phase commit?
791.
What is an oracle SNAPSHOT?
792.
What is an Oracle SQL * NET?
793.
Differentiate simple and complex, oracle snapshots?
794.
How can you Enforce Referential Integrity in oracle snapshots?
795.
What is an oracle snapshot log?
796.
What is Oracle Two-Phase Commit?
797.
How can we reduce the network traffic in Distributed Processing?
798.
What are the various type of snapshots in Oracle?
799.
What are the options available to refresh Oracle snapshots?
800.
When will the data in the oracle snapshot log be used?
801.
What is Oracle Distributed database?
802.
What are the various tools? Name a few?
803.
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
804.
What is fact less fact table? where you have used it in your project?
805.
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
806.
Where do we use connected and un connected lookups?
807.
What are the various tools? - Name a few?
808.
What is the difference between Power Center & Power Mart?
809.
What are the various transformation available?
810.
What is ODS (operation data source)?
811.
What is the difference between etl tool and olap tools?
812.
What is the metadata extension?
813.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
814.
I am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done?
815.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
816.
What is Full load & Incremental or Refresh load?
817.
How to determine what records to extract?
818.
Do we need an ETL tool? When do we go for the tools in the market?
819.
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
820.
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
821.
What are parameter files? Where do we use them?
822.
How can we use mapping variables in Informatica? Where do we use them?
823.
What is a mapping, session, worklet, workflow, mapplet?
824.
What is Informatica Metadata and where is it stored?
825.
How do we call shell scripts from informatica?
826.
Can Informatica load heterogeneous targets from heterogeneous sources?
827.
What are the different Lookup methods used in Informatica?
828.
What are active transformation / Passive transformations?
829.
What are the modules in Power Mart?
830.
Compare ETL & Manual development?
831.
When do we Analyze the tables? How do we do it?
832.
What is partitioning? What are the types of partitioning?
833.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
834.
What is the significance of structure id in key flexfields?
835.
What is the maximum number of segments that can be defined for KFF?
836.
Do we need to register Standard DFF?s?
837.
Are the value sets mandatory for DFF segments?
838.
How do I enable a database column to use it in a DFF segment?
839.
What is the use of Group Flex field and where exactly we use?
840.
How many flexfields are there in total modules?
841.
Is it possible to enable/disable only few fields of any DFF?
842.
What is the purpose of a flexfield qualifier? Why is it needed when you can have a unique name for a segment?
843.
Can we disable/enable a whole DFF not few Attributes?
844.
Give the complete process cycle for OE / AR?
845.
What is the difference between flexfield qualifier and segment qualifier?
846.
How do I enter the default value of Key flexfield or DFF segment?
847.
What is concurrent prg?
848.
What is the significance of reference field in a DFF?
849.
What is the significance of cross validate segments in the Key flexfield structure screen?
850.
Which procedure should be used to make the DFF read only at run time?
851.
Can we use other columns (beside attributes) as segments for DFF?
852.
What is the difference between key flexfield and Descriptive flexfield?
853.
What are context sensitive segments in descriptive flexfields?
854.
Explain What is the significance of PAGE 0 in forms 3.0?
855.
Explain What is an Alert?
856.
Explain What SYNCHRONIZE procedure does?
857.
Explain How do we trap the error in forms 3.0 ?
858.
Explain What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS?
859.
How to execute the user defined triggers in forms 3.0?
860.
Explain What are the types of Pop-up window?
861.
Explain What Enter package procedure does?
862.
Explain What package procedure used for invoke sql *plus from sql *forms?
863.
Explain What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger?
864.
Explain What is an User Exits?
865.
Explain What is an SQL *FORMS?
866.
Explain What package procedure is used for calling another form?
867.
Explain What are the types of TRIGGERS?
868.
Explain Committed block sometimes refer to a BASE TABLE?
869.
Explain What are the main types of TRIGGERS?
870.
Explain What is a Package Procedure?
871.
Explain What ERASE package procedure does?
872.
Explain EXIT_FORM is a restricted package procedure?
a. True
b. False?
873.
Explain What is the maximum size of a form?
874.
Explain When does an on-lock trigger fire?
875.
Explain What is the difference between NAME_IN and COPY?
876.
Explain What does an on-clear-block Trigger fire?
877.
Explain When is PRE-QUERY trigger executed?
878.
Explain built-in routines for the controlling canvas views during run-time?
879.
Explain How do you pass the parameters from one form to another form?
880.
Explain the built-in routine used to count the no of rows in a group?
881.
Explain How image_items can be populate to field in forms 4.0?
882.
Explain What are the menu items that oracle forms 4.0 supports?
883.
Can we change the default value of the radio button group at run time?
884.
Explain What is a predefined exception available in forms 4.0?
885.
How to Give built-in routine related to a record groups?
886.
Explain What is a window?
887.
Explain What are the types of canvas-views?
888.
Explain some built-in routines used to manipulate images in image_item?
889.
Can we attach an alert to a field?
890.
Explain System.effective_date system variable is read only True/False?
891.
Explain What are the triggers associated with a check box?
892.
Explain What is the built-in function used for finding the alert?
893.
Explain What is a Navigable item?
894.
Can we change the color of the push button in design time?
895.
Explain What is a Check Box?
896.
Explain the Abbreviation for the following File Extension:
1. FMB
2. MMB
3. PLL
897.
Explain what is a display item?
898.
Explain What is a Layout Editor?
899.
Explain What is the content view and stacked view?
900.
What is the difference between discounts and adjustments?
901.
What are cycles of GL, AP, and AR?
902.
What are Summary Accounts and Rollup groups?
903.
Get the following message on Drilldown - Function not available to this responsibility. Change responsibility or contact your system administrator?
904.
Differences between VB.Net and C#, related to OOPS concepts?
905.
What is Set of Books? What are the four conditions when you change your SOBs?
906.
What are different period types?
907.
Explain types of invoices are there in AP and AR?
908.
What is the difference between cross-validation rules and security-rules?
909.
In how many ways can you enter a journal in GL?
910.
What are different types of invoices and what is a recurring invoice?
911.
What id recurring invoices?What are AP setup steps?
912.
What Subledgers does Oracle General Ledger 11i Drilldown support?
913.
What are different types of Journal entries?
914.
What is an Invoice? How man?
915.
What is FSG and its use?
916.
In GL there is no org id. So how can we differentiate the data different operating units when no other modules are given?
917.
What is the difference between GL date and GL posted date in GL?
918.
How do we integrate AP or AR to GL?
919.
What are the setup steps for AP, AR, and GL?
920.
I am confused about inter company journal balancing.
As far as I can tell, it does one or both of:
1) If you enable it you can post incorrect (i.e. imbalanced) journals. And if you disable it you ca not (i.e. all journals must balance - A GOOD THING, RIGHT)?
921.
Can anyone tell me about MRC and Multi-Org?
922.
Can I delete a budget?
923.
Can I update/adjust an existing account range in my budget organization?
924.
What is a funding budget?
925.
Why do not my budget amounts appear on FSGs?
926.
How many Current budgets can you have?
927.
I was able to post a budget journal to a closed period, why?
928.
Is there a limit to the number of periods in a budget year or how many years a budget can span?
929.
Can you disable budgetary control for a set of books?
930.
How can we integrate AR or AP to GL?
931.
What is the difference between gl_date, gl_posted?
932.
What are the journal entries in Procure to Pay Cycle?
933.
How to import data to General Ledger by Feeder System?
934.
What is Consolidation in GL?
935.
What is planing budget in GL?
936.
Can anyone please say me what is EDI and its functions?
937.
What is meant by ADI?
938.
Expain ADI and its features?
939.
Why cant interest rates be set uniqely supplierwise in payables module. whereas interest rate is applied to all suppliers the same rate?
940.
What is the MD form 50?
941.
Can we change the profile value? How?
942.
What is the difference between GL date and GL posted date?
943.
At what stage is the subledger data posted to GL?
944.
In GL there is no org id. So how do we differentiate the data from different operating units?
945.
What is the significance of having storage clause?
946.
What is the functionality of SYSTEM table space?
947.
How does Space allocation table place within a block?
948.
What is the role of PCTFREE parameter is storage clause?
949.
What is the OPTIMAL parameter?
950.
What is a shared pool?
951.
What is mean by Program Global Area (PGA)?
952.
What is a data segment?
953.
What are the factors causing the reparsing of SQL statements in SGA?
954.
What is Database Buffers?
955.
What is dictionary cache?
956.
Which parameter in Storage clause will reduce number of rows per block?
957.
What is meant by free extent?
958.
How will you force database to use particular rollback segment?
959.
How can we organize the tablespaces in Oracle database to have maximum performance?
960.
How will you swap objects into a different table space for an existing database?
961.
What is redo log buffer?
962.
What is meant by recursive hints?
963.
How can we plan storage for very large tables?
964.
How will you estimate the space required by a non-clustered tables?
965.
It is possible to use raw devices as data files and what are the advantages over file system files?
966.
What is a Control file?
967.
How will you monitor rollback segment status?
968.
How will you monitor the space allocation?
969.
Why query fails sometimes?
970.
How the space utilization takes place within rollback segments?
971.
How will you create multiple rollback segments in a database?
972.
What is a rollback segment entry?
973.
What is hit ratio?
974.
What are disadvantages of having raw devices?
975.
What is use of rollback segments in Oracle database?
976.
What is advantage of having disk shadowing / mirroring?
977.
How redo logs can be achieved?
978.
What is redo log file mirroring?
979.
How to implement the multiple control files for an existing database?
980.
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
981.
What is a Shared SQL pool?
982.
What is mean by Program Global Area (PGA)?
983.
List the factors that can affect the accuracy of the estimations?
984.
What are the different kind of export backups?
985.
What is cold backup? What are the elements of it?
986.
What is a logical backup?
987.
What is hot backup and how it can be taken?
988.
What is the use of FILE option in EXP command?
989.
What is the use of GRANT option in EXP command?
990.
What is the use of INDEXES option in EXP command?
991.
What is the use of ROWS option in EXP command?
992.
What is the use of PARFILE option in EXP command?
993.
What is the use of ANALYSE ( Ver 7) option in EXP command?
994.
What is the use of FULL option in EXP command?
995.
What is the use of OWNER option in EXP command?
996.
What is the use of TABLES option in EXP command?
997.
What is the use of RECORD LENGTH option in EXP command?
998.
What is the use of INCTYPE option in EXP command?
999.
What is the use of RECORD option in EXP command?
1000.
What is the use of ROWS option in IMP command?
1001.
What is the use of INDEXES option in IMP command?
1002.
What is the use of GRANT option in IMP command?
1003.
What is the use of SHOW option in IMP command?
1004.
What is the use of FILE option in IMP command?
1005.
What is use of LOG (Ver 7) option in EXP command?
1006.
What is difference b/w stored procedures and application procedures, stored function and application function?
1007.
Explian rowid, rownum?what are the psoducolumns we have?
1008.
what is the starting oracle error number?
what is meant by forward declaration in functions?
1009.
In a Distributed Database System Can we execute two queries simultaneously? Justify?
1010.
How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
1011.
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
1012.
State the difference between implict and explict cursors?
1013.
How to know the last executed procedure?
1014.
How can a function retun more than one value in oracle with proper example?
1015.
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
1016.
What is the basic structure of PL/SQL?
1017.
What are the components of a PL/SQL block?
1018.
What are the datatypes a available in PL/SQL?
1019.
What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
1020.
What is difference between % ROWTYPE and TYPE RECORD?
1021.
What will the Output for this Coding>
Declare
Cursor c1 is select * from emp FORUPDATE;
Z c1%rowtype;
Begin
Open C1;
Fetch c1 into Z;
Commit;
Fetch c1 in to Z;
end;
1022.
What are the Restrictions on Cursor Variables?
1023.
Can we declare a column having number data type and its scale is larger than pricesion
ex: column_name NUMBER(10,100),
column_name NUMBAER(10,-84)
1024.
What will happen after commit statement?
1025.
Explain the usage of WHERE CURRENT OF clause in cursors?
1026.
What is a database trigger? Name some usages of database trigger?
1027.
How many types of database triggers can be specified on a table? What are they?
1028.
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
1029.
What are two virtual tables available during database trigger execution?
1030.
What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
1031.
Write the order of precedence for validation of a column in a table?
i. done using Database triggers.
ii. done using Integarity Constraints
1032.
What is an Exception? What are types of Exception?
1033.
What is Pragma EXECPTION_INIT? Explain the usage?
1034.
What is Raise_application_error?
1035.
What are the return values of functions SQLCODE and SQLERRM?
1036.
Where the Pre_defined_exceptions are stored?
1037.
What is an oracle stored procedure?
1038.
What is a cursor for loop?
1039.
What are the cursor attributes used in PL/SQL?
1040.
What are the PL/SQL Statements used in cursor processing?
1041.
Explain the two type of Cursors?
1042.
What is a cursor ? Why Cursor is required?
1043.
What is PL/SQL table?
1044.
What is difference between a PROCEDURE & FUNCTION?
1045.
What are advantages fo Stored Procedures?
1046.
What are the modes of parameters that can be passed to a procedure?
1047.
What are the two parts of a procedure?
1048.
Give the structure of the procedure?
1049.
Give the structure of the function?
1050.
Explain how procedures and functions are called in a PL/SQL block?
1051.
What is Overloading of procedures?
1052.
What are two parts of package?
1053.
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?
1054.
How packaged procedures and functions are called from the following?
a. Stored procedure or anonymous block
b. an application program such a PRC *C, PRO* COBOL
c. SQL *PLUS
1055.
Name the tables where characteristics of Package, procedure and functions are stored?
1056.
Give the Types of modules in a form?
1057.
Explain What are the advantages of having a Package?
1058.
Explain What is difference between Procedures and Functions?
1059.
Explain What are Oracle Schema Objects?
1060.
Explain the uses of Database Trigger?
1061.
Explain What is a Package?
1062.
Explain What is Database Trigger?
1063.
Explain What are the uses of Oracle Rollback Segment?
1064.
Explain What is a Procedure?
1065.
Explain What is an Oracle Data Block?
1066.
Explain What are the differences between Database Trigger and Integrity constraints?
1067.
Explain What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?
1068.
Explain If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
1069.
We are regularly changing the package body part. How will we create or what will we do before creating that package?
1070.
Explain What is spooling?
1071.
Can we create procedures to fetch more than one record?
1072.
Schema A has some objects and created one procedure and granted to Schema B.
Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?
1073.
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
1074.
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
1075.
Explain the total process of eim?
1076.
Explain How do we increase the performance of %LIKE operator?
1077.
Explain If the SQL * Plus hangs for a long time, what is the reason?
1078.
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
1079.
Explain What is bulk SQL?
1080.
Explain What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it?
1081.
Explain How to do the scheduled task/jobs in Unix platform?
1082.
Explain the Dual table. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get and Why?
1083.
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
1084.
Explain What are the differences between database designing and database modeling?
1085.
Explain In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
1086.
Explain How can we see the source code of the package?
1087.
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
1088.
Explain about the oracle disaster recovery scenarios?
1089.
Explain What is difference between SQL and SQL*PLUS?
1090.
What is is a cursor?
1091.
Explain What are various joins used while writing SUBQUERIES?
1092.
Explain Difference between database triggers and form triggers?
1093.
Explain me can the default values be assigned to actual parameters?
1094.
How to pass cursor variables in PL/SQL 2.2?
1095.
Explain What is difference between SUBSTR and INSTR?
1096.
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
1097.
Explain Which is more faster - IN or EXISTS?
1098.
How to find out nth highest salary from emp table?
1099.
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
1100.
Select the Nth lowest value from a table?
1101.
Explain What is the purpose of a cluster?
1102.
Explain Difference between procedure and function.?
1103.
Explain Which datatype is used for storing graphics and images?
1104.
Explain Difference between an implicit and an explicit cursor?
1105.
Please Explain Connect by Prior?
1106.
Explain ROWID?
1107.
Explain Explicit Cursor attributes?
1108.
Explain What is a database link?
1109.
Explain What is a corelated subquery?
1110.
Explain How to drop the index?
1111.
What is a join in Oracle? Explain the different types of joins?
1112.
Explain What are the data types allowed in a table?
1113.
Explain How do we replace a comma (,) with a blank in a select statement?
1114.
Explain Can a view be updated/inserted/deleted?
1115.
Explain What are the different types of SQL?
1116.
Explain some PL/SQL Exceptions?
1117.
Explain What is a Cartesian product?
1118.
Explain What is an Integrity Constraint?
1119.
Explain How do we eliminate the duplicate rows?
1120.
Explain What is meant by SORTING and GROUPING?
1121.
Explain What is the maximum number of triggers, can apply to a single table?
1122.
How to use SQL to build SQL, what is this called and give an example?
1123.
Explain What is the output of SIGN function?
1124.
Explain What is meant by Scrollable cursor?
1125.
What is the format of oracle table?
1126.
How to Use Delegated Administration Services (DAS), which task can you accomplish?
A. manage OracleAS Single Sign-On server
B. manage Oracle Internet Directory processes
C. register applications that are created using OracleAS Portal
D. manage user and group entries in Oracle Internet Directory (OID)
E. monitor system components in an Oracle Application Server 10g installation
1127.
Suppose You require a certificate for your Web server. Which tool would you use to create a
certificate request?
A. OCA User pages
B. Oracle Wallet Manager
C. Application Server Control
D. Oracle Enterprise Security Manager
1128.
What is oracle application certification?
1129.
Suppose You execute the following command in your Oracle Application Server 10g installation
to start the Oracle Internet Directory (OID) Server Instance with a new instance ID:
$ oidctl connect=infra server=oidldapd instance=1 host=edtdr5p1.us.oracle.com start
The command does not error out. But while trying to locate the server instance using the
Process Status (ps) operating system utility, you realize that the instance has not started.
What could be the reason?
A. The OID Listener process has not started.
B. The OID server processes have not started.
C. The Oracle HTTP Server process has not started.
D. The Oracle Internet Directory (OID) Monitor process has not started.
E. The Oracle Enterprise Manager 10g Application Server Control page has not started.
1130.
Suppose You need to save a certificate request in a file system directory by using Oracle Wallet
Manager. What would you do?
A. export the certificate request
B. use the File > Save As option
C. import the certificate request and save it
D. upload the certificate request to the Directory Service
1131.
Explain Can we give DML statements inside a function?
1132.
How to switch between virtual terminals on your computer?
A. Fx
B. SHFT-Fx
C. CTRL-Fx
D. CTRL-ALT-Fx
E. The TAB key
1133.
You have made the following entries on your da10 server:
da10:- #umask 033
da10:- # mkdir training
Which correctly reflect the permissions on the training directory?
A. drwx------
B. drwxr--r--
C. drw---x--x
D. drw--w--w-
E. drwx-rw-rwF. drwx--wx-wx
1134.
Explain When booting up a Linux computer, which loads the kernel and the initrd to memory?
A. init
B. BIOS
C. Kernel
D. initramfs
E. Boot manager
1135.
Previously user temps account was locked, but you cannot remember if it is still locked. As the
root user, when entering the command grep geeko /etc/shadow, what is displayed to help you
identify if the account is still locked?
A. If it is still locked, nothing will display.
B. If it is still locked, a # will appear before the password hash.
C. If it is still locked, an ! will appear before the password hash.
D. If it is still locked, the # symbol will appear for every value of the password hash.
E. if it is still locked, the * symbol will appear for every value of the password hash.
1136.
Explain Which is the configuration file for init?
A. /etc/inittab
B. /sys/inittab
C. /root/inittab
D. /sbin/inittab
E. /boot/inittab
1137.
From a terminal window, which command will allow you to change system wide defaults?
(Choose 2.)
A. gconfd-2
B. gconftool-2
C. gconf-editor
D. config-source
E. gconf-defaults
1138.
What is the command to rename a file on your SLED 10 computer?
A. rn
B. mv
C. ren
D. move
E. rename
1139.
When a user submits a print job, which directory contains the actual data to print?
A. /etc/cups/
B. /proc/cups/
C. /home/cups/
D. /var/spool/cups/
E. /srv/spool/cups/
1140.
Which command sets the sticky bit to the /tmp directory?
A. chmod +s /tmp
B. chmod 0777 /tmp
C. chmod 1777 /tmp
D. chmod 7770 /tmp
E. chmod +s 777 /tmp
1141.
Which keystroke switches the vi editor from insert mode back to command mode?
A. $
B. #
C. :
D. >
E. ~
F. Esc
1142.
Shown below is results from the ls -l progress command:
-rw-rw-r-- 1 rtracy users 0 2007-02-07 15:30 progress
Which statement is true?
A. The group has read only rights to this file.
B. User rtracy has read only rights to this file.
C. User rtracy has read and write rights to this file.
D. All other users have read and write rights to this file.
E. All other users have read only rights to this directory
F. The group has read and write rights to this directory.
1143.
With CUPS, each print queue is registered with its name in which file?
A. /etc/cups/printers.conf
B. /proc/cups/printers.conf
C. /home/cups/printers.conf
D. /var/spools/cups/printers.conf
E. /srv/spools/cups/printers.conf
1144.
Which directory allows you see which services are loaded in runlevel 5?
A. /var/init/rc5/
B. /sys/init/rc5/
C. /etc/init.d/rc5.d/
D. /boot/inittab/rc5/
E. /root/init.d/rc5.d/
1145.
You are logged is as user wparker and want to change the priority of process 1824. It is currently
at a nice value of 5. Being logged in as wparker, which command will change the priority?
A. renice -10 1824
B. renice -1 1824
C. renice 0 1824
D. renice 3 1824
E. renice 7 1824
F. Only root can change the nice value of a process.
1146.
Which command shows who is currently on the system and their processes?
A. w
B. who
C. last
D. finger
E. lastlog
1147.
Bash stores commands in a history file so you can have easy access to them gain later when
needed. In SUSE Linux Enterprise 10 Desktop, what is default maximum number of entries that
this file is set to?
A. 100
B. 250
C. 500
D. 1,000
E. 10,000
1148.
There are several versions of grep in your system. You would like to find out which grep
command is being used when you run that command without specifying a path. Which command
will provide you this information?
A. grep
B. man grep
C. list grep
D. find grep
E. which grep
1149.
What is the yast command to enter the software installation module from the command line?
A. yast sw_single
B. yast /sw_single
C. yast -l sw_single
D. yast -i sw_single
E. yast --i sw_single
1150.
What GID number is assigned to system groups?
A. GID 0
B. GID 1 to 99
C. GID 100 to 199
D. GID 200 to 299
E. GID 300 and above
1151.
Which will restart the Novell Client tray application from the command line?
A. /opt/novell//ncl/bin/tray
B. /opt/novell/ncl/bin/n_tray
C. /opt/novell/ncl/bin/ncl_tray
D. /opt/novell/ncl/bin/novell_tray
E. /opt/novell/ncl/bin/nclient_tray
1152.
Explain The primary configuration of the automount program is contained in which file?
A. /etc/fstab
B. /etc/auto.misc
C. /etc/auto.home
D. /etc/auto.master
E. /root/automount.ldif
1153.
Sample Novell CLE 9 Certification Exam Questions!
1154.
How to install SLES 9?
1155.
Explain function keys?
1156.
Explain authentication method?
1157.
What is Initial requirements for Novell Certification?
1158.
How to take my NCLP exam. Can give me some pointers?
1159.
How does someone become a novell certified linux professional?
1160.
How to prepare for novell CLP certification?
1161.
Explain Which ZENworks for Desktop 3 policy is a General category policy that can be applied to any Windows
95, 98, NT, or 2000 workstation that a user logs into?
A. Help Desk
B. User Extensible
C. NT User System
D. Dynamic Local User
E. Windows Terminal Server?
1162.
Explain What is the console command to load the print server manager?
A. LOAD NDPS MANAGER
B. LOAD PSM
C. LOAD NDPS
D. LOAD NDPSM
E. LOAD BROKER
1163.
Tell me Which eDirectory property right is only available on container objects?
A. Read
B. Write
C. Compare
D. Inheritable
E. Supervisor
F. Add/Remove self
1164.
Suppose You have an alias object in your eDirectory tree with the name of Alias referring to a printer object with
the name of Certking 1.
What is a valid attribute type and value of the alias object?
A. A= Certking 1
B. P= Certking 1
C. CN= Certking 1
D. A=Alias
E. P=Alias
F. CN=Alias
1165.
Tell me Which objects with eDirectory are leaf objects? (Choose two)
A. Tree
B. Group
C. Security
D. NDPS Broker
E. License container
1166.
Tell me To set up iPrint, which objects must exist in your eDirectory tree? (Choose three)
A. Print queue
B. Print server
C. NDPS printer
D. NDPS broker
E. NDPS gateway
F. NDPS manager
1167.
Explain The object class definitions within the schema define what?
A. Object placement within the tree.
B. The syntax structure of an attribute
C. The synchronization rules between replicas.
D. The types of objects that can exist in the tree.
E. The types of replicas that can exist in the tree.
1168.
Explain Which firewall technology allows 2 or more hosts to exchange data over a public network using a secure
channel?
A. NAT
B. VPN
C. Packet filtering
D. IPX/IP gateway
E. Internet object caching
1169.
Suppose You have deleted a file in the USERSCOMMON directory and have not changed any Netware defaults.
From which directory can you salvage this file?
A. DELETED.SAV
B. USERSCOMMON
C. SYSTEMDELETED
D. From the root of the volume.
E. It cannot be salvaged because it was immediately purged.
1170.
Explain When assigning file system rights, which order is recommended?
A. Public, users, security equivalence, containers, groups
B. Public, containers, groups, users, security equivalence
C. Containers, groups, users, Public, security equivalence
D. Containers, groups, users, security equivalence, Public
E. Users, security equivalence, groups, containers, Public
1171.
Tell me Which is a feature of the GroupWise 6 server?
A. Client caching mode
B. AutoComplete addressing
C. Multiple account signatures
D. Public Key Infrastructure support
1172.
Tell me Which objects can you assign as object trustees that grant access to multiple users at once? (Choose three)
A. Tree
B. Group
C. Server
D. Volume
E. Security Container
F. Organizational role
1173.
Explain Which objects are container objects? (Choose three)
A. Group
B. Server
C. Volume
D. Domain
E. Country
F. Organization
1174.
Explain Which NetWare directory is available to users before logging into a NetWare server?A. ETC
B. LOGIN
C. PUBLIC
D. README
E. NETBASIC
1175.
Explain Which Internet delivery components purpose is to create a system that prevents unauthorized users from
accessing proprietary information?
A. Router
B. Firewall
C. Proxy server
D. Cache server
1176.
Explain Which is a workstation requirement for iFolder?
A. Internet Explorer 5 or 5.5.
B. At least 4 MB of free space.
C. At least 256 MB of memoery.
D. Windows 95, 98, 2000, NT, Me, or UNIX.
1177.
Explain Which security feature of NetWare is a primary defense against password
hackers?
A. DSTRACE
B. Intruder lookout
C. SECURE CONSOLE
D. Console screensaver
1178.
Explain Which allows users to send and receive email with international character
sets?
A. MTA
B. POA
C. MIME
D. POP3
E. IMAP4
1179.
Tell me What can you assign to a GroupWise user object to identify this user with
a role, such as Travel?
A. Rule
B. Resource
C. Nickname
D. External entity
1180.
Explain Which can you configure by selecting the Custom option when installing the Novell client? (Choose two)
A. DHCP
B. The default users login name.
C. The IP address that the client will use.
D. The network protocol for the client to use.
E. The type of connection the client should establish: NDS or bindery.
1181.
Tell me Which statement is true of a user objects being moved?
A. All trustees assignments will have to be re-created.
B. If the user is a member of a group, that membership will be retained.
C. The context on the client workstation will automatically be changed to reflect the move.
D. If the user is an occupant of an organizational role, that occupancy will be lost.
E. If a user is security equivalent to another object, the security equivalence will need to be re-established.
1182.
Tell me Which NetWare directory contains NetWare installation files?
A. NI
B. ETC
C. NSN
D. LOGIN
E. SYSTEM
1183.
What is a function of the MTA?
A. To monitor disk space.
B. To store email messages.
C. To execute GroupWise client rules.
D. To transfer email messages between post offices and other domains.
1184.
Suppose You are using the default configuration on your server. To access Web Manager from your workstation, you
open a browser, enter the servers IP address, and then enter which port number?
A. 443
B. 636
C. 2200
D. 8008
E. 8009
1185.
Tell me When leaf objects can be configured to contain other leaf objects as members or occupants? (Choose two)
A. Alias
B. Group
C. Organizational Unit
D. Security Container
E. Organizational role
1186.
Explain When setting up NDPS, which objects must be created?
A. Manager only
B. Manager and printer only
C. Broker and manager only
D. Broker, manager, and printer only
E. Broker, manager, gateway, and printer
1187.
Explain Which NSS volume attribute maintains an inventory of all files on the
volume that have had their contents changed at some point since the last backup operation?
A. Backup
B. Salvage
C. Migration
D. Compression
E. Directory Quotas
F. Modified File List
G. User Space Restrictions
H. Flush Files Immediately on Close
1188.
Suppose You need to access your NetWare 6.5 servers console. However, youre
currently in a different building. You decide to use Remote Manager to access the server from a
Windows XP workstation. Your servers DNS name is da5.da.com. What URL should use to access
Remote Manager? (Choose 2.)
A. http://da5.da.com:81
B. http://da5.da.com:8008
C. https://da5.da.com:444
D. https://da5.da.com:8009
E. http://da5.da.com/nps/RemoteManager.html
F. https://da5.da.com:443/nps/RemoteManager.html
1189.
Tell me Where is the ConsoleOne utility located, by default, on a NetWare 6.5
server?
A. SYS:PUBLICMGMT
B. SYS:PUBLICCONSOLEONE
C. SYS:PUBLICMGMTCONSOLEONE
D. SYS:PUBLICCONSOLEONE1.2BIN
E. SYS:PUBLICMGMTCONSOLEONEBIN
F. SYS:PUBLICMGMTCONSOLEONE1.2
G. SYS:PUBLICMGMTCONSOLEONE1.2BIN
1190.
Suppose You have a Novell Distributed Print Services (NDPS) Broker object in your
tree named Broker.SLC.DA. Which command would you use to load the Broker on a NetWare 6.5
server?
A. BROKER SLC.DA
B. BROKER BROKER.SLC.DA
C. BROKER CONTEXT=SLC.DA
D. BROKER -N BROKER.SLC.DA
E. NDPSBROKER BROKER.SLC.DA
F. NDPSBROKER CONTEXT=SLC.DA
G. NDPSBROKER -N BROKER.SLC.DA
1191.
Tell me Which NetWare loadable module provides the iPrint service on a NetWare
6.5 server?
A. IPP.NLM
B. IPRINT.NLM
C. NPRINT.NLM
D. IPPSRVR.NLM
E. PSERVER.NLM
F. IPRINTSRVR.NLM
1192.
Tell me Which product can be used to track eDirectory security issues? (Choose 2.)
A. Rsync
B. OpenSSH
C. BindView
D. NMAP.EXE
E. BURGLAR.NLM
F. SETPASS.NLM
G. CRACKER.NLM
H. Novell Branch Office Server
I. Novell Advanced Audit Service
1193.
Tell me In NetWare 6.5, which file extension is used for network board drivers?
A. .NCF
B. .LAN
C. .HAM
D. .CDM
E. .NLM
1194.
Explain Which web-based services does Virtual Office provide? (Choose 3.)
A. Chat
B. Calendar
C. Bookmarks
D. Spreadsheet
E. Word processor
F. Project management charts
1195.
Suppose Drive G: is currently mapped to DA1DATA:. You need to remove this
drive mapping. To do this you would enter __________ at your workstations DOS prompt.
1196.
Suppose During the installation of NetWare 6.5, the server files are installed on the
__________ volume.
1197.
Explain Which utilities can you use to manage directory and file attributes on a
NetWare 6.5 server? (Choose 2.)
A. ICE
B. FLAG
C. iManager
D. iMonitor
E. NDS Manager
F. Remote Manager
1198.
The __________ feature of NSS allows the sum of the sizes of each volume in
a partition to exceed the size of the partition itself.
1199.
Explain Which describes the role of the Novell Distributed Print Services (NDPS)
printer agent?
A. It downloads the correct print driver to the workstation.
B. It responds to queries from clients about the status of a print job.
C. It provides a platform for printer objects that reside on the server.
D. It allows NDPS clients to sent print jobs to printers that are not NDPS-aware.
E. It redirects print jobs to directory on the server while waiting for the printer to become available.
F. It takes application-specific data from the application creating the print job and reformats it to work with the
printer it is being sent to.
1200.
Tell me Which utility can be used to create NSS volumes in NetWare 6.5? (Choose
2.)
A. NSSMU
B. iMonitor
C. NWCONFIG
D. ConsoleOne
E. NDS Manager
F. NetWare Administrator
1201.
Suppose Youve just installed a new content management application on your
NetWare 6.5 server. You installed it on the APPS volume in the KNOWLEDGE directory. To manage
the application, you must remember the full path to this directory. You want to create a search drive so
you dont have to remember the full path. Which command would you enter at the server console to do
this?
A. SEARCH APPS:KNOWLEDGE
B. MAP S1:=APPS:KNOWLEDGE
C. SEARCH ADD APPS:KNOLWEDGE
D. ADD SEARCH APPS:KNOWLEDGE
E. SEARCH APPS:KNOWLEDGE ADD
F. ADD APPS:KNOWLEDGE SEARCH
G. MAP INS S16:=APPS:KNOWLEDGE
1202.
Tell me Which of the following are system files used by DR-DOS? (Choose 3.)
A. NTLDR
B. IO.SYS
C. MSDOS.SYS
D. IBMBIO.COM
E. IBMDOS.COM
F. COMMAND.COM
G. NTDETECT.COM
H. PAGEFILE.SYS
1203.
Tell me By default, where does the STARTUP.NCF file reside?
A. C:
B. SYS:
C. SYS:ETC
D. C:NWSERVER
E. SYS:SYSTEM
F. SYS:PUBLIC
G. SYS:STARTUP
H. C:NWSERVERSTARTUP
I. C:NWSERVERDRIVERS
1204.
Tell me Which tasks can be performed with ConsoleOne? (Choose 2.)
A. Manage licensing.
B. Assign rights to objects.
C. Browse very large trees.
D. Configure NDPS Brokers.
E. Change the servers IP address.
1205.
Suppose Youre implementing a network for your company from scratch. Youve
just completed installing the CAT-5 wiring, RJ-45 jacks, and Fast Ethernet switches that will service
your network. During the installation of NetWare 6.5, the only system connected to the network is the
server you are performing the installation on. As you have decided to use the IPX protocol on your
network, what frame type will be bound, by default, to your servers network board by the installation
program?
A. 802.2
B. 802.3
C. 802.5
D. 802.11b
E. Ethernet_II
F. Ethernet_SNAP
1206.
Suppose Youve just created an NSS volume on your NetWare 6.5 server named
SHARED. Your server name is WIDGET1. What will the volume object in eDirectory be named?
A. SHARED
B. WIDGET1_SHARED
C. WIDGET1~SHARED
D. WIDGET1#SHARED
E. WIDGET1&SHARED
F. NSS volumes dont have accompanying eDirectory objects.
1207.
Explain Which of the following technologies is used by NetWare 6.5 to prevent data
from being written to bad blocks on the hard disk drive by redirecting it to a reserved area of the
partition?
A. HPFS
B. iSCSI
C. Rsync
D. Hot Fix
E. Hot-Plug
F. Overbooking
G. Storage Pools
H. Block Suballocation
1208.
Which products does Virtual Office provide web-based access to? (Choose
3.)
A. eGuide
B. iFolder
C. NetStorage
D. WAN Manager
E. Remote Manager
F. Web Search Server
1209.
Explain Novell mcne certification?
1210.
What are benefits of mcne certification?
1211.
Explain Types of questions asked in Novell MCNE certification exam?
1212.
How to prepare for Novell MCNE certification?
1213.
What is Android?
1214.
What is BSD?
1215.
Who maintains OpenBSD?
1216.
What is new in OpenBSD 4.3?
1217.
Is OpenBSD really free?
1218.
Why is/is not ProductX included?
1219.
What is in the file /etc/ttys?
1220.
Who maintains the OpenBSD?
1221.
How do you change your shell to bash?
1222.
Explain the difference between SIGTERM and SIGKILL?
1223.
Explain the difference between SIGHUP, SIGUSR1 and SIGUSR2?
1224.
You are told that the permissions of a file are 645. Quick, how do you calculate what it means?
1225.
How did you find initial support for a new distro?
1226.
Explain difference between nfs soft and hard mouniting points?
1227.
If we transfer 100 files by ftp to remote server, how to know the files are successfully transfer or some file are not transferred?
1228.
Explain any one service which are working on UDP only?
1229.
How many interfaces(ethernet cards) are working using single command?
1230.
What is the status code 403,404 represented in apache server?
1231.
How to monitor ports in a linux machine, with single command?
1232.
Explain Difference between swap partition and swap file?
1233.
How to recover /etc/passwd file and /etc/shadow file?
1234.
How to know linux os is 32 bit or 64 bit?
1235.
Suppose I lost a root password and i need to give it, I treid to change it through single usermode even though i am not get a password, then what is the other procedure to give a root password?
1236.
What are different command to check ram, process and hdd of linux machine?
1237.
What is lilo? How it is useful in linux?
1238.
What is the command to change from /etc/passwd file to /etc/shadow file?
1239.
What is the command to find the hardware configuration in Linux?
1240.
How to root mirror in Linux? How to replace mirrored hdd in case of failure?
1241.
What is the command to check wwn # in linux?
1242.
How to give acl permission in numerical mode on linux?
1243.
How to restart apache server with out shatdown?
1244.
What is chainloading?
1245.
How to hide the partition in GRUB booting?
1246.
How to shuffle the GRUB booting from one Disk to other?
1247.
What is the Difference between su and su- ?
1248.
What is vnc?
1249.
What is Linux?
1250.
You need to see the last fifteen lines of the files dog, cat and horse. What command should you use?
1251.
Who owns the data dictionary in Linux?
1252.
You routinely compress old log files. You now need to examine a log from two months ago. In order to view its contents without first having to decompress it, use the _________ utility in Linux
1253.
You suspect that you have two commands with the same name as the command is not producing the expected results. What command can you use to determine the location of the command being run?
1254.
You locate a command in the /bin directory but do not know what it does. What command can you use to determine its purpose
1255.
You wish to create a link to the /data directory in bob's home directory so you issue the command ln /data /home/bob/datalink but the command fails. What option should you use in this command line to be successful.
1256.
Why is the new Microsoft operating system called Windows 7?
1257.
Are there beta or release candidate versions that can be downloaded for testing purposes?
1258.
Which editions of Windows 7 will be released?
1259.
Where can I get this special pre-order deal?
1260.
What are the minimum hardware requirements for Windows 7?
1261.
What if I own a netbook?
1262.
What if I buy a computer with Vista between now and October 22?
1263.
What is better Windows 7 upgrade or full retail version? Does the upgrade contain all the features of full version?
1264.
How can I install Windows 7 to a netbook with no DVD drive?
1265.
What is the difference between the Upgrade and Custom installation options?
1266.
How do I get my files and folders after upgrading from Windows XP or Windows Vista?
1267.
How can we find programs and devices that work with the 64-bit version of Windows 7?
1268.
Will the Windows 32-bit applications run if I switch to 64-bit variant of Windows 7
1269.
How do I qualify for the students price of Windows 7? What about the OEM pricing?
1270.
Is it possible to upgrade from one Vista Edition, like Home Premium to Window 7 Ultimate?
1271.
If I run a 64-bit version of Windows, does that require a 64-bit driver for my devices?
1272.
What do I do if I insert a CD or DVD and Windows 7 doesn�t recognize it?
1273.
What can I do with a system with the minimum hardware recommendations?
1274.
What features are available with each Windows 7 edition?
1275.
What are some new features and hotkeys of Windows 7?
1276.
What is the OPERATING SYSTEM?
1277.
What are the OPERATING SYSTEM TYPES?
1278.
What are the basic functions of an operating system?
1279.
Why paging is used in OS?
1280.
While running DOS on a PC, which command would be used to duplicate the entire diskette?
1281.
What resources are used when a thread created? How do they differ from those when a process is created?
1282.
What is the virtual memory?
1283.
What is Throughput, Turnaround time, waiting time and Response time?
1284.
What is the state of the processor, when a process is waiting for some event to occur?
1285.
What is the important aspect of a real-time system or Mission Critical Systems?
1286.
What is the difference between Hard and Soft real-time systems?
1287.
What is the cause of thrashing? How does the system detect thrashing?
1288.
What is multi tasking, multi programming and multi threading?
1289.
What is hard disk and what is its purpose?
1290.
What is fragmentation? Different types of fragmentation?
1291.
What is DRAM? In which form does it store data?
1292.
What is the Dispatcher?
1293.
What is the CPU Scheduler?
1294.
What is the Context Switch?
1295.
What is the cache memory?
1296.
What is a Safe State and what is its use in deadlock avoidance?
1297.
What is the Real-Time System?
1298.
What is Shell Script?
1299.
What are PIDs?
1300.
How do you send a mail message to somebody?
1301.
How do you remove a file?
1302.
How do you remove recursively?
1303.
How do you find out your own username?
1304.
How do you count words, lines and characters in a file?
1305.
How do you search for a string inside a given file?
1306.
How do you search for a string inside a directory?
1307.
How do you search for a string in a directory with the subdirectories recursed?
1308.
How do you list currently running process?
1309.
How do you find out what�s your shell?
1310.
How do you fire a process in the background?
1311.
How do you refer to the arguments passed to a shell script?
1312.
What�s the conditional statement in shell scripting?
1313.
How do you do number comparison in shell scripts?
1314.
How do you test for file properties in shell scripts?
1315.
How do you do Boolean logic operators in shell scripting?
1316.
How do you find out the number of arguments passed to the shell script?
1317.
What�s a way to do multilevel if-else�s in shell scripting?
1318.
How do you write a for loop in shell?
1319.
How do you find out the current directory you�re in?
1320.
What�s the command to find out users on the system?
1321.
What�s the command to find out today�s date?
1322.
How do you stop a process?
1323.
How do you find out about all running processes?
1324.
How do you stop all the processes, except the shell window?
1325.
How do you define a function in a shell script?
1326.
How do you read keyboard input in shell scripts?
1327.
How does a case statement look in shell scripts?
1328.
How do you write a while loop in shell?
1329.
Explain about kadmin command?
1330.
Explain about the command prof_attr?
1331.
Explain the differences between setting files using octal codes and symbolic codes?
1332.
What is the best solution to avoid large number of groups?
1333.
What is umask?
1334.
How can you determine whether a file is setUID?
1335.
Explain about sticky bit permissions?
1336.
Explain about the command ls?
1337.
Explain about the limitations present in sudo?
1338.
What is sudo?
1339.
What are the different ways to execute profiles?
1340.
What are the three different system management roles?
1341.
What is Solaris Roles?
1342.
What is RBAC?
1343.
Describe about Logical Domains and its functions?
1344.
Explain the interoperability features of Solaris?
1345.
Explain about Solaris?
1346.
Display the all files recursively with path under current directory ?
1347.
Set the Display automatically for the current new user ?
1348.
Display the processes, which are running under your username ?
1349.
List some Hot Keys for bash shell ?
1350.
Display the files in the directory by file size ?
1351.
How to save man pages to a file ?
1352.
How to know the date and time for . when script is executed ?
1353.
How do you find out drive statistics?
1354.
Display disk usage in Kilobytes?
1355.
Display top ten largest files/directories?
1356.
How much space is used for users in kilobytes?
1357.
How to create null file?
1358.
Access common commands quicker?
1359.
Display the page size of memory?
1360.
Display Ethernet Address arp table?
1361.
Display the no.of active established connections to localhost?
1362.
Display the state of interfaces used for TCP/IP traffic?
1363.
Display the parent/child tree of a process?
1364.
Show the working directory of a process?
1365.
Display the processes current open files?
1366.
Display the inter-process communication facility status?
1367.
Display the top most process utilizing most CPU?
1368.
Alternative for top command?
1369.
What is Sun Solaris?
1370.
What is the command to do an interactive boot from the ok prompt?
1371.
Consider the following crontab entry: ?59 23 13 * 5 /wipe.disk? What time will this cronjob run?
1372.
How can i disable STOP+A utility on SUN machines, which brings system into OK> prompt?
1373.
How do we know how many LAN cards we have in server?
1374.
What is "Piping" solaris?
1375.
Where are the templates stored that are copied into the users home directories for their personal customizations?
1376.
Which NFS daemons are found on the NFS server?
1377.
What SPARC emergency keyboard sequence will take the system to the ok prompt (forth monitor) but will send output to TTYA?
1378.
What file controls system wide password aging?
1379.
Which of the following can be an appropriate name for a cluster?
1380.
What flag used with patchadd will prevent a later back out by preventing patchadd from backing up files? If this flag is used, the patch cannot be removed.
1381.
What file do you put the umask setting in?
1382.
When using the admintool, the membership list for groups is separated by what?
1383.
Among the applications below, which one is not a client/server application?
1384.
What command will display the VTOC for disk c0t0d0s0?
1385.
In order to save a template in /etc/format.dat, what two steps must occur?
1386.
What command enables a printer?
1387.
Which of the following commands can tell you whether packets are being delayed or dropped on your network?
1388.
What file contains the location of the namespace configuration textfiles such as hosts.rev, named.local, etc..?
1389.
What file controls global variables for system wide values for the Bourne Shell?
1390.
Partition sizes can be set manually or from what configuration?
1391.
The hardware-level user interface that you see before the operating system has been started is called:
1392.
Give the command that will display your default boot device.
1393.
How many different kill signals are there?
1394.
What software install group do you need to select in order to load the compilers?
1395.
The NVRAM is also soldered to the main logic board or motherboard.
1396.
What command will install the patches: 123456-01 and 123457-01 if both are located in the /just.patches directory?
1397.
What command can you use to display all of your groups?
1398.
What field will cause the message Your password has expired to be displayed to the user?
1399.
What is the command for seeing a long listing of all the processes running on your unix box?
1400.
What is sticky bit in Solaris?
1401.
How do you check the cron jobs of other users, (as a super user)
1402.
What does this file /etc/path_to_inst contain and what is the importance of this file
1403.
What is the command can reconfigure devices with out reboot?
1404.
How to restore a corrupted file system or trouble shoot bad super blocks for a FS c0t2d0s5
1405.
How will you add a virtual IP address to a server in Solaris. Given the interface qe0 and IP 10.10.1.150
1406.
What are the different phases in boot process
1407.
How do you determin which Run Level the sytem is running
1408.
How would you find out what version of Solaris is currently running?
1409.
What does reboot ?r do?
1410.
What is the difference between a probe-scsi and a probe-scsi-all?
1411.
What would a XIR signal do to a server and why would it be used?
1412.
How would you find out what kernel parameter SHMMAX is set to by one command?
1413.
What is after the VTOC on the root filesystem?
1414.
What is difference between Process and Daemon in Solaris?
1415.
How to install win xp after installing solaris for dual booting.
1416.
You logged into the system using telnet.
As a system administrator, how would you figure out the system transaction is slow between the system you logged into and from the system you did telnet login?
1417.
Why we use / for mount any filesystem?
1418.
What is the big difference between /dev/dsk and /dev/rdsk
1419.
How many cpus we can connect to a spark machine in Solaris?
1420.
How can we find RAM size in solaris server?
1421.
How to configure mail server in sun solaris?
1422.
How to find 32 or 64 bit system instances of OS?
1423.
What could be the reason and what files has to be checked to fix this and which log file we have to refer to know more details about the problem.
1424.
Which obp command has a permanent allies?
1425.
List the files in current directory sorted by size?
1426.
List the hidden files in current directory?
1427.
Delete blank lines in a file?
1428.
Search for a sample string in particular files?
1429.
Display the last newly appending lines of a file during appendingdata to the same file by some processes ?
1430.
Display the Disk Usage of file sizes under each directory in current Directory ?
1431.
Change to a directory, which is having very long name ?
1432.
Display the all files recursively with path under current directory ?
1433.
What is Symbians significance in the wireless market?
1434.
In what areas do you think wireless Java on Symbian OS will be applied?
1435.
What are your plans for Java on Symbian OS?
1436.
Why should developers target Symbian OS, rather than any other phone running a Java VM?
1437.
Can I install my paid copy of SlingPlayer Mobile for Symbian OS on multiple devices?
1438.
What is the advantage of Symbian devices compared to J2ME and Brew devices?
1439.
What is Cleanup mechanism in symbian?
1440.
What is the difference between thread and activex objects?
1441.
What is two phase construction?
1442.
What is activex objects?why we need that?
1443.
What is EPOC?
1444.
Explain Symbian OS 9?
1445.
State and explain about features of UNIX?
1446.
Explain about sh?
1447.
Explain about system and user utilities?
1448.
Explain about document formatting?
1449.
Explain about communication features in UNIX?
1450.
Explain about chmod options filename?
1451.
Explain about gzip filename?
1452.
Explain about refer?
1453.
Explain about lpr filename?
1454.
Explain about lprm job number?
1455.
Brief about the command ff?
1456.
Brief about finger username?
1457.
Explain about the command elm?
1458.
Brief about the command kill PID?
1459.
Explain about the command lynx?
1460.
Brief about the command nn?
1461.
Brief about ftp hostname?
1462.
What is Unix?
1463.
How are devices represented in UNIX OS?
1464.
What is inode in UNIX OS?
1465.
Brief about the directory representation in UNIX OS?
1466.
What are the Unix system calls for I/O?
1467.
How do you change File Access Permissions in UNIX OS?
1468.
What are links and symbolic links in UNIX OS file system?
1469.
What is a FIFO in UNIX OS?
1470.
How do you create special files like named pipes and device files in UNIX OS?
1471.
Discuss the mount and unmount system calls in UNIX OS?
1472.
How does the inode map to data block of a file in UNIX OS?
1473.
What is a UNIX OS shell?
1474.
Brief about the initial process sequence while the UNIX system boots up.
1475.
What are various IDs associated with a process in UNIX OS?
1476.
Explain UNIX fork() system call.
1477.
Predict the output of the following program code in UNIX?
1478.
Predict the output of the following program code?
1479.
List the system calls used for process management in UNIX?
1480.
How can you get/set an environment variable from a program in UNIX?
1481.
How can a parent and child process communicate?
1482.
What is a zombie?
1483.
What are the process states in Unix?
1484.
What Happens when you execute a program?
1485.
What Happens when you execute a command in UNIX OS?
1486.
What is the major advantage of a hash table?
1487.
What are the techniques that you use to handle the collisions in hash tables?
1488.
In Unix OS, what is the file server?
1489.
What is NFS? What is its job?
1490.
What is CVS? List some useful CVS commands?
1491.
How do you debug a core dump?
1492.
How would you create shared and dynamic libraries?
1493.
What are the differences between Shared and Dynamic libraries?
1494.
Give examples of how memory leaks can occur with c programs?
1495.
Explain the Unix file system?
1496.
How would you remove a semaphore / shared memory whose owner processes have died?
1497.
What is stty used for?
1498.
What type of scheduling is used in Unix?
1499.
Explain difference between IPC mechanisms?
1500.
Construct pipes to execute the following jobs?
1501.
How do Sockets Work?
1502.
What is with the second parameter in bind()?
1503.
If bind() fails, what should I do with the socket descriptor?
1504.
When should I use shutdown()?
1505.
Code Sample: a very simple client process.
1506.
What are Sockets?
1507.
How can I tell when a socket is closed on the other end?
1508.
How do I get the port number for a given service?
1509.
How do I properly close a socket?
1510.
What is the difference between close() and shutdown()?
1511.
Explain the TIME_WAIT state.
1512.
How can I put a timeout on connect()?
1513.
Why does the sockets buffer fill up sooner than expected?
1514.
How often should I re-transmit un-acknowleged messages?
1515.
How can I be sure that a UDP message is received?
1516.
of the socket? Does doing a connect() call affect the receive behaviour?
1517.
When should I use UDP instead of TCP?
1518.
How can I read only one character at a time?
1519.
What is the difference between SO_REUSEADDR and SO_REUSEPORT?
1520.
How do I get my server to find out the clients address / host- name?
1521.
What exactly does SO_KEEPALIVE do?
1522.
What exactly does SO_REUSEADDR do?
1523.
How can I make my server a daemon?
1524.
How come I get address already in use from bind()?
1525.
Why do I get connection refused when the server is not running?
1526.
How can I set the timeout for the connect() system call?
1527.
Why does connect() succeed even before my server did an accept()?
1528.
How do I convert a string into an internet address?
1529.
What are socket exceptions? What is out-of-band data?
1530.
Why do I keep getting EINTR from the socket calls?
1531.
Is there any advantage to handling the signal, rather than just ignoring it and checking for the EPIPE error? Are there any useful parameters passed to the signal catching function?
1532.
How do I send [this] over a socket?
1533.
How come select says there is data, but read returns zero?
1534.
How can I force a socket to send the data in its buffer?
1535.
What are the pros/cons of select(), non-blocking I/O and SIGIO?
1536.
Why does it take so long to detect that the peer died?
1537.
Why do I get EPROTO from read()?
1538.
Where can a get a library for programming sockets?
1539.
Whats the difference between select() and poll()?
1540.
How do I use TCP_NODELAY?
1541.
What is the difference between read() and recv()?
1542.
After the chroot(), calls to socket() are failing. Why?
1543.
When will my application receive SIGPIPE?
1544.
How can I find the full hostname (FQDN) of the system I am running on?
1545.
How can my client work through a firewall/proxy server?
1546.
Why do I sometimes lose a servers address when using more than one server?
1547.
system choose one for me on the connect() call? Should I bind() a port number in my client program, or let the?
1548.
over the socket? Is there a way to have a dynamic buffer? What does one do when one does not know how much information is coming?
1549.
Why do not my sockets close?
1550.
How can I listen on more than one port at a time?
1551.
What exactly does SO_LINGER do?
1552.
How can I bind() to a port number < 1024?
1553.
How should I choose a port number for my server?
1554.
How can I write a multi-homed server?
1555.
What is the difference between connected and unconnected sockets?
1556.
How can I read ICMP errors from connected UDP sockets?
1557.
How can I be sure that UDP messages are received in order?
1558.
How come only the first part of my datagram is getting through?
1559.
How would I put my socket in non-blocking mode?
1560.
What are types of kernel objects?
1561.
If we cannot alter these Kernel Object structures directly, how do our applications manipulate these kernel objects?
1562.
User can access these kernel objects structures?
1563.
How the handle helps in manipulating the kernel objects?
1564.
You forget to call CloseHandle - will there be a memory leak?
1565.
What is a kernel object?
1566.
Name few functions that create Kernel Objects?
1567.
How to identify the difference between the kernel object and user object?
1568.
How does the kernel object outlive the process that created it?
1569.
What is signaled and non signaled state?
1570.
What is Synchronization Objects?
1571.
What is DuplicateHandle (API)?
1572.
What are Named Objects?
1573.
Why the entries in the parent process table and child table are same?
1574.
What is the need of process relative handles?
1575.
What happens when the CloseHandle(handle) is called?
1576.
What is handle?
1577.
What is the purpose of Process Handle Table?
1578.
Which is the data member common to all the kernel object and what is the use of it?
1579.
How owns the Kernel Object?
1580.
How do other threads own the mutex?
1581.
How do I create a Mutex?
1582.
APIs for creating event and set and reset the events?
1583.
What is Event Object and why it is used?
1584.
What is the limit on per process for creating a thread?
1585.
What do you mean by unnamed object?
1586.
What about the usage count in the parent child process tables?
1587.
How the handles are handled in the child process?
1588.
What is Mutex Object and why it is used?
1589.
What is a thread?
1590.
How is the balance of an invoice derived?
1591.
What is MRC and what is its use?
1592.
Describe the main tables involved in AR, and what is the data stored in them?
1593.
What is the importance of Batch Source set up in AR?
1594.
What do you mean by HZ_ in customer tables?
1595.
What is the difference between _all, _tl, _vl, _v tables in Oracle Apps?
1596.
How many Flex fields are there in AR and what are they?
1597.
What is FSG and what is its use?
1598.
What is the difference between conversions and interfaces?
1599.
How many reporting currencies can be attached to Primary Set of Books?
1600.
What are Different types of transactions in AR?
1601.
What are value sets?
1602.
What is the use of Transaction Flexfield in Autoinvoice?
1603.
Explain Accounting for invoice in Advance and Arrears?
1604.
What is an Oracle database Partial Backup?
1605.
What is an Oracle database Full Backup?
1606.
What is the difference between oracle media recovery and crash recovery?
1607.
What is db_recovery_file_dest in oracle? When do you need to set this value?
Give me the steps to perform the point in time recovery with a backup which is taken before the reset logs of the db?
Tell me about the steps required to enable the RMAN backup for a target database?
1608.
What is Restricted Mode of Instance Startup in Oracle?
1609.
What is the difference between recovery and restoring of the oracle database?
1610.
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
1611.
What do you mean by Oracle MEDIA RECOVERY?
1612.
What is the disk migration? what is the steps involved in oracle disk migration?
1613.
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
1614.
Why more redos are generated when the oracle database is in begin backup mode?
1615.
What is PTO and ATO? Their functionality. How can we differentiate between them?
1616.
Explain What is ORDER_TO_CASH cycle?
1617.
Explain shipping process along with some screen shots?
1618.
Explain What should be done when sales order lines are closed but header is still in Booked status?
1619.
Explain What is the difference between a Purchase Order (PO) and Sales Order?
1620.
Explain What are the interface programs done in Order Management?
1621.
Explain the conversion of holds done using API? What are the tables affected? what are the fields to be passed and to which base tables?
1622.
Explain What are the APIs used in Order Management?
1623.
What is ONT stands for, as OE stands for Order Entry?
1624.
Explain Order Management Flow in detail?
1625.
Explain what are the setups involved in Drop Shipment Process?
1626.
What is oracle d2k? why we use it?
1627.
Were you involved in any data conversion, which one?
1628.
Which Oracle Apps version you are very confident in?
1629.
Total months of effort in Oracle Apps technical work?
1630.
Are you familiar with User exits in reports?
1631.
Do you know what are User Profiles in Apps. Any examples you can give?
1632.
How many concurrent programs you have customized, can you name some of them?
1633.
How to make the project as .exe file in oracle forms & reports(d2k)?
1634.
How do you run ms_batch file in forms?
what could be the value :system.mode?
1635.
How to get / select the nth row from the table?
how to select first n rows ,last n rows from a table?
1636.
Do you know what is APPLYSYS in Oracle application database schema, what is APPS?
1637.
Any work done in Oracle Workflow builder. Did you customize or build a new workflow?
1638.
Do you know table based value sets?
1639.
Which Flexfields you have customized?
1640.
Have you good knowledge on Java?
1641.
Have you used lexical parameters in reports?
1642.
Which directory will you copy your new reports, what would be its extension (.rdf or .rex)?
1643.
Which directory will you copy your new custom form, what would be its extension (.fmb or .fmx)?
1644.
In oracle application how do you debug or trace errors?
1645.
Are you familiar with internet architecture of Oracle Apps 11i?
1646.
Which Oracle applications PL/SQL standard APIs you are familiar, have you used most of them?
1647.
What are the new features in Release 11I?
1648.
How I can use SRW.RUN_REPORT in Reports6i?
1649.
How many different layouts are available in Reports6i? What are they?
in which sequence , form level trigger will fire? in which sequence, report trigger will fire?
how many types of canvas are there in form? what r they?
what are bind variables and lexical reference in oracle reports?
how many types of colums are there in Reports6i? what are they?
what is the purpose of placeHolder column in Report?
can u have a form with out a canvas?
what is confine mode and flex mode in reports?
how do u register report in oracleApps?
1650.
What is the Placeholder Column?
What is the Format Trigger?
1651.
I need to run a report at Scheduled timings only. I don?t want to run the report on Sundays. How to do this?
1652.
What is the Anchoring in Reports?
What is the difference between Frame and Repeating Frame?
1653.
What is the Page Protect in Reports?
1654.
Explain Can we delete tuples in a table based on date column? And how?
1655.
Explain What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command?
1656.
Explain What is Read-Only Transaction?
1657.
Explain What is Execution Plan?
1658.
Explain What is SAVE POINT?
1659.
Explain What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?
1660.
What is RULE-based approach to optimization?
1661.
Explain Transaction?
1662.
Explain What does COMMIT do?
1663.
Explain What is the function of Optimizer?
1664.
Explain What are the different approaches used by Optimizer in choosing an execution plan ?
1665.
Explain There is a field of type character in the table, but we are storing numeric values like (Roll number) in this field, so if we want to sort the field (in java) according to numbers. How?
1666.
Explain When does a Transaction end?
1667.
Explain What does ROLLBACK do?
1668.
What is COST-based approach to optimization?
1669.
Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?
1670.
Explain What are the factors that affect OPTIMIZER in choosing an Optimization approach?
1671.
Explain What are the values that can be specified for OPTIMIZER MODE Parameter?
1672.
Explain database clusters?
1673.
Explain What is a lookup table in database? where can we use these type of table?
1674.
Explain Different types of table join?
1675.
Explain When can hash cluster used?
1676.
Explain What is an Oracle sequence?
1677.
Explain What is an extent?
1678.
Explain What is a cursor? Why do you need them? What are the different kinds of cursor?
1679.
Explain What is hash cluster?
1680.
Explain What is a tablespace?
1681.
Explain What is index cluster?
1682.
Tell us Do you need a commit after DDL statements?
1683.
What is the difference between indexes,views,synonyms?
1684.
Explain What are the basic element of base configuration of an Oracle database?
1685.
Explain What is ORA-1555?
1686.
Explain How do we handle exceptions / errors in stored procedures?
1687.
Explain Do a view contain data?
1688.
Explain What are the different types of segments?
1689.
Explain What does a control file contains?
1690.
Explain What is a deadlock?
1691.
What is uses of rollback segment?
1692.
Explain some built-in functions that can be used in SQL queries?
1693.
What is Parallel Server in Oracle?
1694.
What are the types of synonyms in Oracle?
1695.
Explain What is a database instance?
1696.
Explain Can we decrease the Datafile size?
1697.
What is an Oracle Rollback Segment?
1698.
What are the uses of Oracle Rollback Segment?
1699.
What are Oracle Schema Objects?
1700.
What is an Oracle Data Block?
1701.
Can objects of the same Schema reside in different tablespaces?
1702.
What is the use of Oracle Control File?
1703.
Can a View based on another View in Oracle?
1704.
What is the function of Redo Log in Oracle?
1705.
Describe the different type of Integrity Constraints supported by ORACLE?
1706.
What is an Oracle Data Dictionary?
1707.
What is an Oracle SYSTEM tablespace and when is it Created?
1708.
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
1709.
How to define Data Block size in Oracle?
1710.
What is an Integrity Constrains in Oracle?
1711.
Can a Tablespace hold objects from different Schemes in Oracle?
1712.
What is an oracle database schema?
1713.
What is an Oracle Data Segment?
1714.
What is LDAP?
1715.
Explain What is user Account in Oracle database?
1716.
Explain What is Privilege Auditing?
1717.
What is a database security profile?
1718.
Explain What is Auditing? What are the different Levels of Auditing?
1719.
Explain What is a trace file and how is it created?
1720.
Explain What are Roles?
1721.
Explain What is Statement Auditing?
1722.
Explain What are the system resources that can be controlled through Profile?
1723.
Explain What is an Auditing?
1724.
Explain What is an Object Auditing?
1725.
Explain What are the responsibilities of a Database Administrator?
1726.
Explain What is default tablespace?
1727.
Explain What is a user Account in Oracle database?
1728.
Explain What are the roles and user accounts created automatically with the database?
1729.
Explain What are the steps to creating a password authentication file?
1730.
Explain What are the database administrators utilities avaliable?
1731.
Explain if you have database,then how can you tell the data in the "database is secured". And what is ment by "data validation"?
1732.
Explain What is Tablespace Quota?
1733.
What are the security features in Oracle?
1734.
Explain How you can secure our data in local area Network?
1735.
Explain What are roles? How can you implement roles?
1736.
Explain How can you specify the Archived log file name format and destination?
1737.
Explain How can we enable automatic archiving?
1738.
When using Oracle export/import what character set concerns might come up? How do you handle them?
1739.
How do you use automatic PGA memory management with Oracle 9i and above?
1740.
Explain two easy SQL optimizations.
1741.
Name three SQL operations that perform a SORT.
1742.
What is your favorite tool for day-to-day Oracle operation?
1743.
What is the difference between Truncate and Delete? Why is one faster?
Can we ROLLBACK both? How would a full table scan behave after?
1744.
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
1745.
What does the NO LOGGING option do? Why would we use it? Why would we be careful of using it?
1746.
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
1747.
What is the difference between RMAN and a traditional hotbackup?
1748.
What are bind variables and why are they important?
1749.
In PL/SQL, what is bulk binding, and when/how would it help performance?
1750.
Why is SQL*Loader direct path so fast?
1751.
What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
1752.
What is the difference between RAID 5 and RAID 10? Which is better for Oracle?
1753.
what is difference between Co-related sub query and nested sub query?
1754.
How do I write a cron which will run a SQL query and mail the results to a group?
1755.
What operator performs pattern matching
1756.
What is the use of the DROP option in the ALTER TABLE command?
1757.
Which date function is used to find the difference between two dates?
1758.
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
1759.
Which function is used to find the largest integer less than or equal to a specific value?
1760.
What operator tests column for the absence of data?
1761.
What are the steps involved in Database Start up?
1762.
What are the different modes of mounting a Database with the Parallel
Server?
1763.
What is Oracle Full Backup?
1764.
What is Oracle Partial Backup?
1765.
What is Oracle Archived Redo Log?
1766.
What are the advantages of operating a database in ARCHIVELOG mode
over operating it in NO ARCHIVELOG mode?
1767.
What is Oracle Log Switch?
1768.
What are the steps involved in Instance Recovery in Oracle?
1769.
Do you need a commit after DDL statements?
1770.
How would you pass hints to the SQL processor?
1771.
what is the difference between group by and order by?
1772.
A DBA had to remove some Archivelogs to free up space in filesystem. Now when the RMAN job starts to backup Archivelogs, it complains about missing Archivelogs that were deleted by DBA. To resolve the issue and continue backing up remainder of Archivelogs, which RMAN command can be used so it wo not complain about missing Archivelogs.
1773.
Which RMAN command is used to create an exact replica of a database in new host?
1774.
How do you install Statspack?
1775.
Process you follow to start looking into Performance issue at database level (If the application is running very slow, at what points do you need to go about the database in
order to improve the performance?)
1776.
Explain below wait events in STATSPACK report DB SCATTERED READ, DB SEQUENTIAL REAL, ENQUEUE?
1777.
List five most important parameter in 9i affecting performance?
1778.
What is PGA_AGGREGATE_TARGET?
1779.
How do you analyze table partition using Oracle provided package?
1780.
You see a wait on LMS process in statspack, what does that mean?
1781.
Explain procedure to Change CHARACTERSET of a database.
1782.
If you had a tablespace, TEST_TABLESPACE, which consists of three files: TEST01.dbf, TEST02.dbf, and TEST03.dbf, and someone accidentally used the Unix command "rm" to delete the file TEST02.dbf, what else would you need in order to recover all the data that was present in TEST_TABLESPACE at the time that TEST02.dbf was deleted?
1783.
How do you put database is ARCHIVELOG mode, explain procedure?
1784.
How can you tell if an index on particular table is USED or NOT USED in 9i?
1785.
Explain FORCE LOGGING feature in 9i.
1786.
When can Hash Cluster used?
1787.
Explain Database Link?
1788.
What are the types of Database Links?
1789.
What is Private Database Link?
1790.
What is Public Database Link?
1791.
What is Network Database link?
1792.
What is Data Block?
1793.
How to define Data Block size?
1794.
What are the components of Physical database structure of Oracle Database?
1795.
What are the components of Logical database structure of ORACLE database?
1796.
What is Tablespace?
1797.
What is SYSTEM tablespace and When is it Created?
1798.
Explain the relationship among Database, Tablespace and Data file?
1799.
What is schema?
1800.
What are Schema Objects?
1801.
Can a Tablespace hold objects from different Schemes?
1802.
Explain Table?
1803.
Explain View?
1804.
Explain Can a View based on another View?
1805.
Explain Do View contain Data?
1806.
Explain What are the advantages of Views?
1807.
What is Sequence?
1808.
Explain a Synonym?
1809.
Explain What are the type of Synonyms?
1810.
Explain a Private Synonyms?
1811.
What is a Public Synonyms?
1812.
Explain What are synonyms used for?
1813.
Explain an Index?
1814.
Explain How are Indexes Update?
1815.
Explain What are Clusters?
1816.
What is cluster Key?
1817.
What is Index Cluster?
1818.
What is Hash Cluster?
1819.
What is the maximum number of CHECK constraints that can be defined on a column?
1820.
What are the Limitations of a CHECK Constraint?
1821.
What is self-referential integrity constraint?
1822.
What is Row Chaining?
1823.
Explain an Extent?
1824.
Explain a Segment?
1825.
Explain What are the different type of Segments?
1826.
Explain a Data Segment?
1827.
Explain an Index Segment?
1828.
What is Rollback Segment?
1829.
Explain What are the uses of Rollback Segment?
1830.
What is a Temporary Segment?
1831.
What is Data File?
1832.
Explain What are the Characteristics of Data Files?
1833.
What is Redo Log?
1834.
What is the function of Redo Log?
1835.
What is the use of Redo Log Information?
1836.
Explain What does a Control file Contain?
1837.
Explain the use of Control File?
1838.
What is a Data Dictionary?
1839.
Explain an Integrity Constrains?
1840.
What constitute an ORACLE Instance?
1841.
What is SGA?
1842.
What are the components of SGA?
1843.
What do Database Buffers contain?
1844.
Describe two phases of Oracle Two-phase commit?
1845.
What is an oracle SNAPSHOT?
1846.
What is an Oracle SQL * NET?
1847.
Differentiate simple and complex, oracle snapshots?
1848.
How can you Enforce Referential Integrity in oracle snapshots?
1849.
What is an oracle snapshot log?
1850.
What is Oracle Two-Phase Commit?
1851.
How can we reduce the network traffic in Distributed Processing?
1852.
What are the various type of snapshots in Oracle?
1853.
What are the options available to refresh Oracle snapshots?
1854.
When will the data in the oracle snapshot log be used?
1855.
What is Oracle Distributed database?
1856.
What are the various tools? Name a few?
1857.
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
1858.
What is fact less fact table? where you have used it in your project?
1859.
Can we look-up a table from source qualifier transformation. ie. unconnected lookup?
1860.
Where do we use connected and un connected lookups?
1861.
What are the various tools? - Name a few?
1862.
What is the difference between Power Center & Power Mart?
1863.
What are the various transformation available?
1864.
What is ODS (operation data source)?
1865.
What is the difference between etl tool and olap tools?
1866.
What is the metadata extension?
1867.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in INFORMATICA?
1868.
I am new to SAS, can anybody explain the process of extracting data from source systems,storing in ODS and how data modelling is done?
1869.
Techniques of Error Handling - Ignore, Rejecting bad records to a flat file, loading the records and reviewing them (default values)?
1870.
What is Full load & Incremental or Refresh load?
1871.
How to determine what records to extract?
1872.
Do we need an ETL tool? When do we go for the tools in the market?
1873.
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?
1874.
Can we override a native sql query within Informatica? Where do we do it? How do we do it?
1875.
What are parameter files? Where do we use them?
1876.
How can we use mapping variables in Informatica? Where do we use them?
1877.
What is a mapping, session, worklet, workflow, mapplet?
1878.
What is Informatica Metadata and where is it stored?
1879.
How do we call shell scripts from informatica?
1880.
Can Informatica load heterogeneous targets from heterogeneous sources?
1881.
What are the different Lookup methods used in Informatica?
1882.
What are active transformation / Passive transformations?
1883.
What are the modules in Power Mart?
1884.
Compare ETL & Manual development?
1885.
When do we Analyze the tables? How do we do it?
1886.
What is partitioning? What are the types of partitioning?
1887.
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
1888.
What is the significance of structure id in key flexfields?
1889.
What is the maximum number of segments that can be defined for KFF?
1890.
Do we need to register Standard DFF?s?
1891.
Are the value sets mandatory for DFF segments?
1892.
How do I enable a database column to use it in a DFF segment?
1893.
What is the use of Group Flex field and where exactly we use?
1894.
How many flexfields are there in total modules?
1895.
Is it possible to enable/disable only few fields of any DFF?
1896.
What is the purpose of a flexfield qualifier? Why is it needed when you can have a unique name for a segment?
1897.
Can we disable/enable a whole DFF not few Attributes?
1898.
Give the complete process cycle for OE / AR?
1899.
What is the difference between flexfield qualifier and segment qualifier?
1900.
How do I enter the default value of Key flexfield or DFF segment?
1901.
What is concurrent prg?
1902.
What is the significance of reference field in a DFF?
1903.
What is the significance of cross validate segments in the Key flexfield structure screen?
1904.
Which procedure should be used to make the DFF read only at run time?
1905.
Can we use other columns (beside attributes) as segments for DFF?
1906.
What is the difference between key flexfield and Descriptive flexfield?
1907.
What are context sensitive segments in descriptive flexfields?
1908.
Explain What is the significance of PAGE 0 in forms 3.0?
1909.
Explain What is an Alert?
1910.
Explain What SYNCHRONIZE procedure does?
1911.
Explain How do we trap the error in forms 3.0 ?
1912.
Explain What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS?
1913.
How to execute the user defined triggers in forms 3.0?
1914.
Explain What are the types of Pop-up window?
1915.
Explain What Enter package procedure does?
1916.
Explain What package procedure used for invoke sql *plus from sql *forms?
1917.
Explain What is the difference between a POST-FIELD trigger and a POST-CHANGE trigger?
1918.
Explain What is an User Exits?
1919.
Explain What is an SQL *FORMS?
1920.
Explain What package procedure is used for calling another form?
1921.
Explain What are the types of TRIGGERS?
1922.
Explain Committed block sometimes refer to a BASE TABLE?
1923.
Explain What are the main types of TRIGGERS?
1924.
Explain What is a Package Procedure?
1925.
Explain What ERASE package procedure does?
1926.
Explain EXIT_FORM is a restricted package procedure?
a. True
b. False?
1927.
Explain What is the maximum size of a form?
1928.
Explain When does an on-lock trigger fire?
1929.
Explain What is the difference between NAME_IN and COPY?
1930.
Explain What does an on-clear-block Trigger fire?
1931.
Explain When is PRE-QUERY trigger executed?
1932.
Explain built-in routines for the controlling canvas views during run-time?
1933.
Explain How do you pass the parameters from one form to another form?
1934.
Explain the built-in routine used to count the no of rows in a group?
1935.
Explain How image_items can be populate to field in forms 4.0?
1936.
Explain What are the menu items that oracle forms 4.0 supports?
1937.
Can we change the default value of the radio button group at run time?
1938.
Explain What is a predefined exception available in forms 4.0?
1939.
How to Give built-in routine related to a record groups?
1940.
Explain What is a window?
1941.
Explain What are the types of canvas-views?
1942.
Explain some built-in routines used to manipulate images in image_item?
1943.
Can we attach an alert to a field?
1944.
Explain System.effective_date system variable is read only True/False?
1945.
Explain What are the triggers associated with a check box?
1946.
Explain What is the built-in function used for finding the alert?
1947.
Explain What is a Navigable item?
1948.
Can we change the color of the push button in design time?
1949.
Explain What is a Check Box?
1950.
Explain the Abbreviation for the following File Extension:
1. FMB
2. MMB
3. PLL
1951.
Explain what is a display item?
1952.
Explain What is a Layout Editor?
1953.
Explain What is the content view and stacked view?
1954.
What is the difference between discounts and adjustments?
1955.
What are cycles of GL, AP, and AR?
1956.
What are Summary Accounts and Rollup groups?
1957.
Get the following message on Drilldown - Function not available to this responsibility. Change responsibility or contact your system administrator?
1958.
Differences between VB.Net and C#, related to OOPS concepts?
1959.
What is Set of Books? What are the four conditions when you change your SOBs?
1960.
What are different period types?
1961.
Explain types of invoices are there in AP and AR?
1962.
What is the difference between cross-validation rules and security-rules?
1963.
In how many ways can you enter a journal in GL?
1964.
What are different types of invoices and what is a recurring invoice?
1965.
What id recurring invoices?What are AP setup steps?
1966.
What Subledgers does Oracle General Ledger 11i Drilldown support?
1967.
What are different types of Journal entries?
1968.
What is an Invoice? How man?
1969.
What is FSG and its use?
1970.
In GL there is no org id. So how can we differentiate the data different operating units when no other modules are given?
1971.
What is the difference between GL date and GL posted date in GL?
1972.
How do we integrate AP or AR to GL?
1973.
What are the setup steps for AP, AR, and GL?
1974.
I am confused about inter company journal balancing.
As far as I can tell, it does one or both of:
1) If you enable it you can post incorrect (i.e. imbalanced) journals. And if you disable it you ca not (i.e. all journals must balance - A GOOD THING, RIGHT)?
1975.
Can anyone tell me about MRC and Multi-Org?
1976.
Can I delete a budget?
1977.
Can I update/adjust an existing account range in my budget organization?
1978.
What is a funding budget?
1979.
Why do not my budget amounts appear on FSGs?
1980.
How many Current budgets can you have?
1981.
I was able to post a budget journal to a closed period, why?
1982.
Is there a limit to the number of periods in a budget year or how many years a budget can span?
1983.
Can you disable budgetary control for a set of books?
1984.
How can we integrate AR or AP to GL?
1985.
What is the difference between gl_date, gl_posted?
1986.
What are the journal entries in Procure to Pay Cycle?
1987.
How to import data to General Ledger by Feeder System?
1988.
What is Consolidation in GL?
1989.
What is planing budget in GL?
1990.
Can anyone please say me what is EDI and its functions?
1991.
What is meant by ADI?
1992.
Expain ADI and its features?
1993.
Why cant interest rates be set uniqely supplierwise in payables module. whereas interest rate is applied to all suppliers the same rate?
1994.
What is the MD form 50?
1995.
Can we change the profile value? How?
1996.
What is the difference between GL date and GL posted date?
1997.
At what stage is the subledger data posted to GL?
1998.
In GL there is no org id. So how do we differentiate the data from different operating units?
1999.
What is the significance of having storage clause?
2000.
What is the functionality of SYSTEM table space?
2001.
How does Space allocation table place within a block?
2002.
What is the role of PCTFREE parameter is storage clause?
2003.
What is the OPTIMAL parameter?
2004.
What is a shared pool?
2005.
What is mean by Program Global Area (PGA)?
2006.
What is a data segment?
2007.
What are the factors causing the reparsing of SQL statements in SGA?
2008.
What is Database Buffers?
2009.
What is dictionary cache?
2010.
Which parameter in Storage clause will reduce number of rows per block?
2011.
What is meant by free extent?
2012.
How will you force database to use particular rollback segment?
2013.
How can we organize the tablespaces in Oracle database to have maximum performance?
2014.
How will you swap objects into a different table space for an existing database?
2015.
What is redo log buffer?
2016.
What is meant by recursive hints?
2017.
How can we plan storage for very large tables?
2018.
How will you estimate the space required by a non-clustered tables?
2019.
It is possible to use raw devices as data files and what are the advantages over file system files?
2020.
What is a Control file?
2021.
How will you monitor rollback segment status?
2022.
How will you monitor the space allocation?
2023.
Why query fails sometimes?
2024.
How the space utilization takes place within rollback segments?
2025.
How will you create multiple rollback segments in a database?
2026.
What is a rollback segment entry?
2027.
What is hit ratio?
2028.
What are disadvantages of having raw devices?
2029.
What is use of rollback segments in Oracle database?
2030.
What is advantage of having disk shadowing / mirroring?
2031.
How redo logs can be achieved?
2032.
What is redo log file mirroring?
2033.
How to implement the multiple control files for an existing database?
2034.
What is SGA? How it is different from Ver 6.0 and Ver 7.0?
2035.
What is a Shared SQL pool?
2036.
What is mean by Program Global Area (PGA)?
2037.
List the factors that can affect the accuracy of the estimations?
2038.
What are the different kind of export backups?
2039.
What is cold backup? What are the elements of it?
2040.
What is a logical backup?
2041.
What is hot backup and how it can be taken?
2042.
What is the use of FILE option in EXP command?
2043.
What is the use of GRANT option in EXP command?
2044.
What is the use of INDEXES option in EXP command?
2045.
What is the use of ROWS option in EXP command?
2046.
What is the use of PARFILE option in EXP command?
2047.
What is the use of ANALYSE ( Ver 7) option in EXP command?
2048.
What is the use of FULL option in EXP command?
2049.
What is the use of OWNER option in EXP command?
2050.
What is the use of TABLES option in EXP command?
2051.
What is the use of RECORD LENGTH option in EXP command?
2052.
What is the use of INCTYPE option in EXP command?
2053.
What is the use of RECORD option in EXP command?
2054.
What is the use of ROWS option in IMP command?
2055.
What is the use of INDEXES option in IMP command?
2056.
What is the use of GRANT option in IMP command?
2057.
What is the use of SHOW option in IMP command?
2058.
What is the use of FILE option in IMP command?
2059.
What is use of LOG (Ver 7) option in EXP command?
2060.
What is difference b/w stored procedures and application procedures, stored function and application function?
2061.
Explian rowid, rownum?what are the psoducolumns we have?
2062.
what is the starting oracle error number?
what is meant by forward declaration in functions?
2063.
In a Distributed Database System Can we execute two queries simultaneously? Justify?
2064.
How we can create a table in PL/SQL block. insert records into it? is it possible by some procedure or function? please give example?
2065.
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
2066.
State the difference between implict and explict cursors?
2067.
How to know the last executed procedure?
2068.
How can a function retun more than one value in oracle with proper example?
2069.
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
2070.
What is the basic structure of PL/SQL?
2071.
What are the components of a PL/SQL block?
2072.
What are the datatypes a available in PL/SQL?
2073.
What are % TYPE and % ROWTYPE? What are the advantages of using these over datatypes?
2074.
What is difference between % ROWTYPE and TYPE RECORD?
2075.
What will the Output for this Coding>
Declare
Cursor c1 is select * from emp FORUPDATE;
Z c1%rowtype;
Begin
Open C1;
Fetch c1 into Z;
Commit;
Fetch c1 in to Z;
end;
2076.
What are the Restrictions on Cursor Variables?
2077.
Can we declare a column having number data type and its scale is larger than pricesion
ex: column_name NUMBER(10,100),
column_name NUMBAER(10,-84)
2078.
What will happen after commit statement?
2079.
Explain the usage of WHERE CURRENT OF clause in cursors?
2080.
What is a database trigger? Name some usages of database trigger?
2081.
How many types of database triggers can be specified on a table? What are they?
2082.
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
2083.
What are two virtual tables available during database trigger execution?
2084.
What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
2085.
Write the order of precedence for validation of a column in a table?
i. done using Database triggers.
ii. done using Integarity Constraints
2086.
What is an Exception? What are types of Exception?
2087.
What is Pragma EXECPTION_INIT? Explain the usage?
2088.
What is Raise_application_error?
2089.
What are the return values of functions SQLCODE and SQLERRM?
2090.
Where the Pre_defined_exceptions are stored?
2091.
What is an oracle stored procedure?
2092.
What is a cursor for loop?
2093.
What are the cursor attributes used in PL/SQL?
2094.
What are the PL/SQL Statements used in cursor processing?
2095.
Explain the two type of Cursors?
2096.
What is a cursor ? Why Cursor is required?
2097.
What is PL/SQL table?
2098.
What is difference between a PROCEDURE & FUNCTION?
2099.
What are advantages fo Stored Procedures?
2100.
What are the modes of parameters that can be passed to a procedure?
2101.
What are the two parts of a procedure?
2102.
Give the structure of the procedure?
2103.
Give the structure of the function?
2104.
Explain how procedures and functions are called in a PL/SQL block?
2105.
What is Overloading of procedures?
2106.
What are two parts of package?
2107.
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification?
2108.
How packaged procedures and functions are called from the following?
a. Stored procedure or anonymous block
b. an application program such a PRC *C, PRO* COBOL
c. SQL *PLUS
2109.
Name the tables where characteristics of Package, procedure and functions are stored?
2110.
Give the Types of modules in a form?
2111.
Explain What are the advantages of having a Package?
2112.
Explain What is difference between Procedures and Functions?
2113.
Explain What are Oracle Schema Objects?
2114.
Explain the uses of Database Trigger?
2115.
Explain What is a Package?
2116.
Explain What is Database Trigger?
2117.
Explain What are the uses of Oracle Rollback Segment?
2118.
Explain What is a Procedure?
2119.
Explain What is an Oracle Data Block?
2120.
Explain What are the differences between Database Trigger and Integrity constraints?
2121.
Explain What are the different types of PL/SQL program units that can be defined and stored in ORACLE database?
2122.
Explain If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?
2123.
We are regularly changing the package body part. How will we create or what will we do before creating that package?
2124.
Explain What is spooling?
2125.
Can we create procedures to fetch more than one record?
2126.
Schema A has some objects and created one procedure and granted to Schema B.
Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?
2127.
Explain If the entire disk is corrupted how will you and what are the steps to recover the database?
2128.
If All the users are complaining that their application is hanging. How we will resolve this situation in OLTP?
2129.
Explain the total process of eim?
2130.
Explain How do we increase the performance of %LIKE operator?
2131.
Explain If the SQL * Plus hangs for a long time, what is the reason?
2132.
Tell us In which situation whether peak time or off peak time we will execute the ANALYZE TABLE command and Why?
2133.
Explain What is bulk SQL?
2134.
Explain What is mutated trigger, is it the problem of locks. In single user mode we got mutated error, as a DBA how you will resolve it?
2135.
Explain How to do the scheduled task/jobs in Unix platform?
2136.
Explain the Dual table. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get and Why?
2137.
Explain What are the differences you have seen while installing Oracle on NT and Unix platform?
2138.
Explain What are the differences between database designing and database modeling?
2139.
Explain In exception handling we have some NOT_FOUND and OTHERS. In inner layer we have some NOT_FOUND and OTHERS. While executing which one whether outer layer or inner layer will check first?
2140.
Explain How can we see the source code of the package?
2141.
Explain What is Testing Scenario? What is scenario based testing? can u explain with an example?
2142.
Explain about the oracle disaster recovery scenarios?
2143.
Explain What is difference between SQL and SQL*PLUS?
2144.
What is is a cursor?
2145.
Explain What are various joins used while writing SUBQUERIES?
2146.
Explain Difference between database triggers and form triggers?
2147.
Explain me can the default values be assigned to actual parameters?
2148.
How to pass cursor variables in PL/SQL 2.2?
2149.
Explain What is difference between SUBSTR and INSTR?
2150.
Explain What is an UTL_FILE.What are different procedures and functions associated with it?
2151.
Explain Which is more faster - IN or EXISTS?
2152.
How to find out nth highest salary from emp table?
2153.
Explain What should be the return type for a cursor variable. Can we use a scalar data type as return type?
2154.
Select the Nth lowest value from a table?
2155.
Explain What is the purpose of a cluster?
2156.
Explain Difference between procedure and function.?
2157.
Explain Which datatype is used for storing graphics and images?
2158.
Explain Difference between an implicit and an explicit cursor?
2159.
Please Explain Connect by Prior?
2160.
Explain ROWID?
2161.
Explain Explicit Cursor attributes?
2162.
Explain What is a database link?
2163.
Explain What is a corelated subquery?
2164.
Explain How to drop the index?
2165.
What is a join in Oracle? Explain the different types of joins?
2166.
Explain What are the data types allowed in a table?
2167.
Explain How do we replace a comma (,) with a blank in a select statement?
2168.
Explain Can a view be updated/inserted/deleted?
2169.
Explain What are the different types of SQL?
2170.
Explain some PL/SQL Exceptions?
2171.
Explain What is a Cartesian product?
2172.
Explain What is an Integrity Constraint?
2173.
Explain How do we eliminate the duplicate rows?
2174.
Explain What is meant by SORTING and GROUPING?
2175.
Explain What is the maximum number of triggers, can apply to a single table?
2176.
How to use SQL to build SQL, what is this called and give an example?
2177.
Explain What is the output of SIGN function?
2178.
Explain What is meant by Scrollable cursor?
2179.
What is the format of oracle table?
2180.
How to Use Delegated Administration Services (DAS), which task can you accomplish?
A. manage OracleAS Single Sign-On server
B. manage Oracle Internet Directory processes
C. register applications that are created using OracleAS Portal
D. manage user and group entries in Oracle Internet Directory (OID)
E. monitor system components in an Oracle Application Server 10g installation
2181.
Suppose You require a certificate for your Web server. Which tool would you use to create a
certificate request?
A. OCA User pages
B. Oracle Wallet Manager
C. Application Server Control
D. Oracle Enterprise Security Manager
2182.
What is oracle application certification?
2183.
Suppose You execute the following command in your Oracle Application Server 10g installation
to start the Oracle Internet Directory (OID) Server Instance with a new instance ID:
$ oidctl connect=infra server=oidldapd instance=1 host=edtdr5p1.us.oracle.com start
The command does not error out. But while trying to locate the server instance using the
Process Status (ps) operating system utility, you realize that the instance has not started.
What could be the reason?
A. The OID Listener process has not started.
B. The OID server processes have not started.
C. The Oracle HTTP Server process has not started.
D. The Oracle Internet Directory (OID) Monitor process has not started.
E. The Oracle Enterprise Manager 10g Application Server Control page has not started.
2184.
Suppose You need to save a certificate request in a file system directory by using Oracle Wallet
Manager. What would you do?
A. export the certificate request
B. use the File > Save As option
C. import the certificate request and save it
D. upload the certificate request to the Directory Service
2185.
Explain Can we give DML statements inside a function?
2186.
How to enable automatic archiving?
2187.
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?
2188.
What are roles? How can we implement roles?
2189.
What are the minimum parameters should exist in the parameter file (init.ora)?
2190.
Tell me What are the database administrators utilities avaliable?
2191.
Can you explain What are the roles and user accounts created automatically with the database?
2192.
What are the main responsibilities of a Database Administrator?
2193.
Explain What are the dictionary tables used to monitor a database spaces?
2194.
How to enforce security using stored procedures?
2195.
Tell me What is user Account in Oracle database?
2196.
What is a profile in Oracle Security?
2197.
What is Tablespace Quota in Oracle Security?
2198.
What is default tablespace in Oracle Security?
2199.
How to prevent unauthorized use of privileges granted to a Role?
2200.
What is meant by physical order and logical order in clustered index and non clustered index?
2201.
What is the step for rmanbackup?
2202.
Tell me What is different between view and sequence?
2203.
Explain What are the benefits of distributed options in databases?
2204.
Explain When will the data in the snapshot log be used?
2205.
Explain snapshot log?
2206.
Explain What are the options available to refresh snapshots?
2207.
How to Enforce Refrencial Integrity in snapshots?
2208.
What is dynamic data replication?
2209.
Differentiate the simple and complex, snapshots?
2210.
Do you know What are the various type of snapshots?
2211.
What is snapshots?
2212.
How to reduce the network traffic?
2213.
Explain What is the use of ANALYZE command?
2214.
How to specify the Archived log file name format and destination?
2215.
What is PTO and ATO?
2216.
What is ORDER_TO_CASH cycle?
2217.
Explain Oracle Technology Network?
2218.
Explain Some useful sections on OTN?
2219.
In addition to comprising several community-oriented Web sites explain about OTN?
2220.
What OTN is sponsoring?
2221.
How to switch between virtual terminals on your computer?
A. Fx
B. SHFT-Fx
C. CTRL-Fx
D. CTRL-ALT-Fx
E. The TAB key
2222.
You have made the following entries on your da10 server:
da10:- #umask 033
da10:- # mkdir training
Which correctly reflect the permissions on the training directory?
A. drwx------
B. drwxr--r--
C. drw---x--x
D. drw--w--w-
E. drwx-rw-rwF. drwx--wx-wx
2223.
Explain When booting up a Linux computer, which loads the kernel and the initrd to memory?
A. init
B. BIOS
C. Kernel
D. initramfs
E. Boot manager
2224.
Previously user temps account was locked, but you cannot remember if it is still locked. As the
root user, when entering the command grep geeko /etc/shadow, what is displayed to help you
identify if the account is still locked?
A. If it is still locked, nothing will display.
B. If it is still locked, a # will appear before the password hash.
C. If it is still locked, an ! will appear before the password hash.
D. If it is still locked, the # symbol will appear for every value of the password hash.
E. if it is still locked, the * symbol will appear for every value of the password hash.
2225.
Explain Which is the configuration file for init?
A. /etc/inittab
B. /sys/inittab
C. /root/inittab
D. /sbin/inittab
E. /boot/inittab
2226.
From a terminal window, which command will allow you to change system wide defaults?
(Choose 2.)
A. gconfd-2
B. gconftool-2
C. gconf-editor
D. config-source
E. gconf-defaults
2227.
What is the command to rename a file on your SLED 10 computer?
A. rn
B. mv
C. ren
D. move
E. rename
2228.
When a user submits a print job, which directory contains the actual data to print?
A. /etc/cups/
B. /proc/cups/
C. /home/cups/
D. /var/spool/cups/
E. /srv/spool/cups/
2229.
Which command sets the sticky bit to the /tmp directory?
A. chmod +s /tmp
B. chmod 0777 /tmp
C. chmod 1777 /tmp
D. chmod 7770 /tmp
E. chmod +s 777 /tmp
2230.
Which keystroke switches the vi editor from insert mode back to command mode?
A. $
B. #
C. :
D. >
E. ~
F. Esc
2231.
Shown below is results from the ls -l progress command:
-rw-rw-r-- 1 rtracy users 0 2007-02-07 15:30 progress
Which statement is true?
A. The group has read only rights to this file.
B. User rtracy has read only rights to this file.
C. User rtracy has read and write rights to this file.
D. All other users have read and write rights to this file.
E. All other users have read only rights to this directory
F. The group has read and write rights to this directory.
2232.
With CUPS, each print queue is registered with its name in which file?
A. /etc/cups/printers.conf
B. /proc/cups/printers.conf
C. /home/cups/printers.conf
D. /var/spools/cups/printers.conf
E. /srv/spools/cups/printers.conf
2233.
Which directory allows you see which services are loaded in runlevel 5?
A. /var/init/rc5/
B. /sys/init/rc5/
C. /etc/init.d/rc5.d/
D. /boot/inittab/rc5/
E. /root/init.d/rc5.d/
2234.
You are logged is as user wparker and want to change the priority of process 1824. It is currently
at a nice value of 5. Being logged in as wparker, which command will change the priority?
A. renice -10 1824
B. renice -1 1824
C. renice 0 1824
D. renice 3 1824
E. renice 7 1824
F. Only root can change the nice value of a process.
2235.
Which command shows who is currently on the system and their processes?
A. w
B. who
C. last
D. finger
E. lastlog
2236.
Bash stores commands in a history file so you can have easy access to them gain later when
needed. In SUSE Linux Enterprise 10 Desktop, what is default maximum number of entries that
this file is set to?
A. 100
B. 250
C. 500
D. 1,000
E. 10,000
2237.
There are several versions of grep in your system. You would like to find out which grep
command is being used when you run that command without specifying a path. Which command
will provide you this information?
A. grep
B. man grep
C. list grep
D. find grep
E. which grep
2238.
What is the yast command to enter the software installation module from the command line?
A. yast sw_single
B. yast /sw_single
C. yast -l sw_single
D. yast -i sw_single
E. yast --i sw_single
2239.
What GID number is assigned to system groups?
A. GID 0
B. GID 1 to 99
C. GID 100 to 199
D. GID 200 to 299
E. GID 300 and above
2240.
Which will restart the Novell Client tray application from the command line?
A. /opt/novell//ncl/bin/tray
B. /opt/novell/ncl/bin/n_tray
C. /opt/novell/ncl/bin/ncl_tray
D. /opt/novell/ncl/bin/novell_tray
E. /opt/novell/ncl/bin/nclient_tray
2241.
Explain The primary configuration of the automount program is contained in which file?
A. /etc/fstab
B. /etc/auto.misc
C. /etc/auto.home
D. /etc/auto.master
E. /root/automount.ldif
2242.
Sample Novell CLE 9 Certification Exam Questions!
2243.
How to install SLES 9?
2244.
Explain function keys?
2245.
Explain authentication method?
2246.
What is Initial requirements for Novell Certification?
2247.
How to take my NCLP exam. Can give me some pointers?
2248.
How does someone become a novell certified linux professional?
2249.
How to prepare for novell CLP certification?
2250.
Explain Which ZENworks for Desktop 3 policy is a General category policy that can be applied to any Windows
95, 98, NT, or 2000 workstation that a user logs into?
A. Help Desk
B. User Extensible
C. NT User System
D. Dynamic Local User
E. Windows Terminal Server?
2251.
Explain What is the console command to load the print server manager?
A. LOAD NDPS MANAGER
B. LOAD PSM
C. LOAD NDPS
D. LOAD NDPSM
E. LOAD BROKER
2252.
Tell me Which eDirectory property right is only available on container objects?
A. Read
B. Write
C. Compare
D. Inheritable
E. Supervisor
F. Add/Remove self
2253.
Suppose You have an alias object in your eDirectory tree with the name of Alias referring to a printer object with
the name of Certking 1.
What is a valid attribute type and value of the alias object?
A. A= Certking 1
B. P= Certking 1
C. CN= Certking 1
D. A=Alias
E. P=Alias
F. CN=Alias
2254.
Tell me Which objects with eDirectory are leaf objects? (Choose two)
A. Tree
B. Group
C. Security
D. NDPS Broker
E. License container
2255.
Tell me To set up iPrint, which objects must exist in your eDirectory tree? (Choose three)
A. Print queue
B. Print server
C. NDPS printer
D. NDPS broker
E. NDPS gateway
F. NDPS manager
2256.
Explain The object class definitions within the schema define what?
A. Object placement within the tree.
B. The syntax structure of an attribute
C. The synchronization rules between replicas.
D. The types of objects that can exist in the tree.
E. The types of replicas that can exist in the tree.
2257.
Explain Which firewall technology allows 2 or more hosts to exchange data over a public network using a secure
channel?
A. NAT
B. VPN
C. Packet filtering
D. IPX/IP gateway
E. Internet object caching
2258.
Suppose You have deleted a file in the USERSCOMMON directory and have not changed any Netware defaults.
From which directory can you salvage this file?
A. DELETED.SAV
B. USERSCOMMON
C. SYSTEMDELETED
D. From the root of the volume.
E. It cannot be salvaged because it was immediately purged.
2259.
Explain When assigning file system rights, which order is recommended?
A. Public, users, security equivalence, containers, groups
B. Public, containers, groups, users, security equivalence
C. Containers, groups, users, Public, security equivalence
D. Containers, groups, users, security equivalence, Public
E. Users, security equivalence, groups, containers, Public
2260.
Tell me Which is a feature of the GroupWise 6 server?
A. Client caching mode
B. AutoComplete addressing
C. Multiple account signatures
D. Public Key Infrastructure support
2261.
Tell me Which objects can you assign as object trustees that grant access to multiple users at once? (Choose three)
A. Tree
B. Group
C. Server
D. Volume
E. Security Container
F. Organizational role
2262.
Explain Which objects are container objects? (Choose three)
A. Group
B. Server
C. Volume
D. Domain
E. Country
F. Organization
2263.
Explain Which NetWare directory is available to users before logging into a NetWare server?A. ETC
B. LOGIN
C. PUBLIC
D. README
E. NETBASIC
2264.
Explain Which Internet delivery components purpose is to create a system that prevents unauthorized users from
accessing proprietary information?
A. Router
B. Firewall
C. Proxy server
D. Cache server
2265.
Explain Which is a workstation requirement for iFolder?
A. Internet Explorer 5 or 5.5.
B. At least 4 MB of free space.
C. At least 256 MB of memoery.
D. Windows 95, 98, 2000, NT, Me, or UNIX.
2266.
Explain Which security feature of NetWare is a primary defense against password
hackers?
A. DSTRACE
B. Intruder lookout
C. SECURE CONSOLE
D. Console screensaver
2267.
Explain Which allows users to send and receive email with international character
sets?
A. MTA
B. POA
C. MIME
D. POP3
E. IMAP4
2268.
Tell me What can you assign to a GroupWise user object to identify this user with
a role, such as Travel?
A. Rule
B. Resource
C. Nickname
D. External entity
2269.
Explain Which can you configure by selecting the Custom option when installing the Novell client? (Choose two)
A. DHCP
B. The default users login name.
C. The IP address that the client will use.
D. The network protocol for the client to use.
E. The type of connection the client should establish: NDS or bindery.
2270.
Tell me Which statement is true of a user objects being moved?
A. All trustees assignments will have to be re-created.
B. If the user is a member of a group, that membership will be retained.
C. The context on the client workstation will automatically be changed to reflect the move.
D. If the user is an occupant of an organizational role, that occupancy will be lost.
E. If a user is security equivalent to another object, the security equivalence will need to be re-established.
2271.
Tell me Which NetWare directory contains NetWare installation files?
A. NI
B. ETC
C. NSN
D. LOGIN
E. SYSTEM
2272.
What is a function of the MTA?
A. To monitor disk space.
B. To store email messages.
C. To execute GroupWise client rules.
D. To transfer email messages between post offices and other domains.
2273.
Suppose You are using the default configuration on your server. To access Web Manager from your workstation, you
open a browser, enter the servers IP address, and then enter which port number?
A. 443
B. 636
C. 2200
D. 8008
E. 8009
2274.
Tell me When leaf objects can be configured to contain other leaf objects as members or occupants? (Choose two)
A. Alias
B. Group
C. Organizational Unit
D. Security Container
E. Organizational role
2275.
Explain When setting up NDPS, which objects must be created?
A. Manager only
B. Manager and printer only
C. Broker and manager only
D. Broker, manager, and printer only
E. Broker, manager, gateway, and printer
2276.
Explain Which NSS volume attribute maintains an inventory of all files on the
volume that have had their contents changed at some point since the last backup operation?
A. Backup
B. Salvage
C. Migration
D. Compression
E. Directory Quotas
F. Modified File List
G. User Space Restrictions
H. Flush Files Immediately on Close
2277.
Suppose You need to access your NetWare 6.5 servers console. However, youre
currently in a different building. You decide to use Remote Manager to access the server from a
Windows XP workstation. Your servers DNS name is da5.da.com. What URL should use to access
Remote Manager? (Choose 2.)
A. http://da5.da.com:81
B. http://da5.da.com:8008
C. https://da5.da.com:444
D. https://da5.da.com:8009
E. http://da5.da.com/nps/RemoteManager.html
F. https://da5.da.com:443/nps/RemoteManager.html
2278.
Tell me Where is the ConsoleOne utility located, by default, on a NetWare 6.5
server?
A. SYS:PUBLICMGMT
B. SYS:PUBLICCONSOLEONE
C. SYS:PUBLICMGMTCONSOLEONE
D. SYS:PUBLICCONSOLEONE1.2BIN
E. SYS:PUBLICMGMTCONSOLEONEBIN
F. SYS:PUBLICMGMTCONSOLEONE1.2
G. SYS:PUBLICMGMTCONSOLEONE1.2BIN
2279.
Suppose You have a Novell Distributed Print Services (NDPS) Broker object in your
tree named Broker.SLC.DA. Which command would you use to load the Broker on a NetWare 6.5
server?
A. BROKER SLC.DA
B. BROKER BROKER.SLC.DA
C. BROKER CONTEXT=SLC.DA
D. BROKER -N BROKER.SLC.DA
E. NDPSBROKER BROKER.SLC.DA
F. NDPSBROKER CONTEXT=SLC.DA
G. NDPSBROKER -N BROKER.SLC.DA
2280.
Tell me Which NetWare loadable module provides the iPrint service on a NetWare
6.5 server?
A. IPP.NLM
B. IPRINT.NLM
C. NPRINT.NLM
D. IPPSRVR.NLM
E. PSERVER.NLM
F. IPRINTSRVR.NLM
2281.
Tell me Which product can be used to track eDirectory security issues? (Choose 2.)
A. Rsync
B. OpenSSH
C. BindView
D. NMAP.EXE
E. BURGLAR.NLM
F. SETPASS.NLM
G. CRACKER.NLM
H. Novell Branch Office Server
I. Novell Advanced Audit Service
2282.
Tell me In NetWare 6.5, which file extension is used for network board drivers?
A. .NCF
B. .LAN
C. .HAM
D. .CDM
E. .NLM
2283.
Explain Which web-based services does Virtual Office provide? (Choose 3.)
A. Chat
B. Calendar
C. Bookmarks
D. Spreadsheet
E. Word processor
F. Project management charts
2284.
Suppose Drive G: is currently mapped to DA1DATA:. You need to remove this
drive mapping. To do this you would enter __________ at your workstations DOS prompt.
2285.
Suppose During the installation of NetWare 6.5, the server files are installed on the
__________ volume.
2286.
Explain Which utilities can you use to manage directory and file attributes on a
NetWare 6.5 server? (Choose 2.)
A. ICE
B. FLAG
C. iManager
D. iMonitor
E. NDS Manager
F. Remote Manager
2287.
The __________ feature of NSS allows the sum of the sizes of each volume in
a partition to exceed the size of the partition itself.
2288.
Explain Which describes the role of the Novell Distributed Print Services (NDPS)
printer agent?
A. It downloads the correct print driver to the workstation.
B. It responds to queries from clients about the status of a print job.
C. It provides a platform for printer objects that reside on the server.
D. It allows NDPS clients to sent print jobs to printers that are not NDPS-aware.
E. It redirects print jobs to directory on the server while waiting for the printer to become available.
F. It takes application-specific data from the application creating the print job and reformats it to work with the
printer it is being sent to.
2289.
Tell me Which utility can be used to create NSS volumes in NetWare 6.5? (Choose
2.)
A. NSSMU
B. iMonitor
C. NWCONFIG
D. ConsoleOne
E. NDS Manager
F. NetWare Administrator
2290.
Suppose Youve just installed a new content management application on your
NetWare 6.5 server. You installed it on the APPS volume in the KNOWLEDGE directory. To manage
the application, you must remember the full path to this directory. You want to create a search drive so
you dont have to remember the full path. Which command would you enter at the server console to do
this?
A. SEARCH APPS:KNOWLEDGE
B. MAP S1:=APPS:KNOWLEDGE
C. SEARCH ADD APPS:KNOLWEDGE
D. ADD SEARCH APPS:KNOWLEDGE
E. SEARCH APPS:KNOWLEDGE ADD
F. ADD APPS:KNOWLEDGE SEARCH
G. MAP INS S16:=APPS:KNOWLEDGE
2291.
Tell me Which of the following are system files used by DR-DOS? (Choose 3.)
A. NTLDR
B. IO.SYS
C. MSDOS.SYS
D. IBMBIO.COM
E. IBMDOS.COM
F. COMMAND.COM
G. NTDETECT.COM
H. PAGEFILE.SYS
2292.
Tell me By default, where does the STARTUP.NCF file reside?
A. C:
B. SYS:
C. SYS:ETC
D. C:NWSERVER
E. SYS:SYSTEM
F. SYS:PUBLIC
G. SYS:STARTUP
H. C:NWSERVERSTARTUP
I. C:NWSERVERDRIVERS
2293.
Tell me Which tasks can be performed with ConsoleOne? (Choose 2.)
A. Manage licensing.
B. Assign rights to objects.
C. Browse very large trees.
D. Configure NDPS Brokers.
E. Change the servers IP address.
2294.
Suppose Youre implementing a network for your company from scratch. Youve
just completed installing the CAT-5 wiring, RJ-45 jacks, and Fast Ethernet switches that will service
your network. During the installation of NetWare 6.5, the only system connected to the network is the
server you are performing the installation on. As you have decided to use the IPX protocol on your
network, what frame type will be bound, by default, to your servers network board by the installation
program?
A. 802.2
B. 802.3
C. 802.5
D. 802.11b
E. Ethernet_II
F. Ethernet_SNAP
2295.
Suppose Youve just created an NSS volume on your NetWare 6.5 server named
SHARED. Your server name is WIDGET1. What will the volume object in eDirectory be named?
A. SHARED
B. WIDGET1_SHARED
C. WIDGET1~SHARED
D. WIDGET1#SHARED
E. WIDGET1&SHARED
F. NSS volumes dont have accompanying eDirectory objects.
2296.
Explain Which of the following technologies is used by NetWare 6.5 to prevent data
from being written to bad blocks on the hard disk drive by redirecting it to a reserved area of the
partition?
A. HPFS
B. iSCSI
C. Rsync
D. Hot Fix
E. Hot-Plug
F. Overbooking
G. Storage Pools
H. Block Suballocation
2297.
Which products does Virtual Office provide web-based access to? (Choose
3.)
A. eGuide
B. iFolder
C. NetStorage
D. WAN Manager
E. Remote Manager
F. Web Search Server
2298.
Explain Novell mcne certification?
2299.
What are benefits of mcne certification?
2300.
Explain Types of questions asked in Novell MCNE certification exam?
2301.
How to prepare for Novell MCNE certification?
2302.
What is Android?
2303.
What is BSD?
2304.
Who maintains OpenBSD?
2305.
What is new in OpenBSD 4.3?
2306.
Is OpenBSD really free?
2307.
Why is/is not ProductX included?
2308.
What is in the file /etc/ttys?
2309.
Who maintains the OpenBSD?
2310.
How do you change your shell to bash?
2311.
Explain the difference between SIGTERM