|
|
|
|
|
guenter (May 31 2008 15:56 GMT) - Domain Abfrage für guenter |
SAPTechies.com Top Articles
|
Oracle Interview Question Set 1 (May 31 2008 15:56 GMT) - Question 1 what is difference between Corelated sub query and nested sub query Answer Corelated sub query is one in which inner query is evaluated only once and from that result outerquery is evaluatedNested query is one in which Inner query is evaluated for multiple times for getting one row of thatouter queryex Query used with IN clause is Corelated queryQuery used with operator is Nested queryQuestion 2 How do I write a cron which will run a SQL query and mail the results to a groupAnswer Use DBMSJOB for scheduling a cron job and DBMSMAIL to send the results through emailQuestion 3 What operator performs pattern matchingAnswer LIKE operatorQuestion 4 What is the use of the DROP option in the ALTER TABLE commandAnswer It is used to drop constraints specified on the tableQuestion 5 Which date function is used to find the difference between two datesAnswer MONTHSBETWEENQuestion 6 What is the advantage of specifying WITH GRANT OPTION in the GRANT commandAnswer The privilege receiver can further grant the privileges heshe has obtained from the owner to any other userQuestion 7 What is the use of CASCADE CONSTRAINTSAnswer When this clause is used with the DROP command a parent table can be dropped even when a child table existsQuestion 8 Which function is used to find the largest integer less than or equal to a specific valueAnswer FLOORQuestion 9 What operator tests column for the absence of dataAnswer IS NULL operatorQuestion 10 What are the steps involved in Database StartupAnswer Start an instance Mount the Database and Open the DatabaseQuestion 11 What are the steps involved in Database ShutdownAnswer Close the Database Dismount the Database and Shutdown the InstanceQuestion 12 What is Restricted Mode of Instance StartupAnswer An instance can be started in or later altered to be in restricted mode so that when the database is open connections are limited only to those whose user accounts have been granted the RESTRICTED SESSION system privilegeQuestion 13 What are the different modes of mounting a Database with the Parallel ServerAnswer Exclusive Mode If the first instance that mounts a database does so in exclusive mode only that Instance can mount the databaseParallel Mode If the first instance that mounts a database is started in parallel mode other instances that are started in parallel mode can also mount the databaseQuestion 14 What is Full BackupAnswer A full backup is an operating system backup of all data files online redo log files and control file that constitute ORACLE database and the parameterQuestion 15 Can Full Backup be performed when the database is openAnswer NoQuestion 16 What is Partial BackupAnswer A Partial Backup is any operating system backup short of a full backup taken while the database is open or shut downQuestion 17 144 What is Online Redo LogAnswer The Online Redo Log is a set of tow or more online redo files that record all committed changes made to the database Whenever a transaction is committed the corresponding redo entries temporarily stores in redo log buffers of the SGA are written to an online redo log file by the background process LGWR The online redo log files are used in cyclicalfashionQuestion 18 What is Mirrored online Redo LogAnswer A mirrored online redo log consists of copies of online redo log files physically located on separate disks changes made to one member of the group are made to all membersQuestion 19 What is Archived Redo LogAnswer Archived Redo Log consists of Redo Log files that have archived before being reusedQuestion 20 What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG modeAnswer Complete database recovery from disk failure is possible only in ARCHIVELOG mode Online database backup is possible only in ARCHIVELOG modeampnbspampnbspContinue |
http://studiobassplayer.com
|
The Best Bass DVDs on the market (May 31 2008 15:56 GMT) - Slapping basics/ Slapping 1/ Slapping2 takes you through right & left hand exercises to improve coordination/ dexterity/ speed & accuracy with the thumb & finger/ slapping techniques / How to double pop in between strings/ slapping chops /motor slapping/ timing/ ghost notes/ 1/2 1/4 1/8 note triplets/ Double thumb and right hand excercises and more.. |
PcWorld Community - Technology With Masti
|
HIRING ?OLD? PEOPLE (May 31 2008 15:55 GMT) - Does age really matter or is it just a state of mind?In recruiting candidates, is there a necessary age in mind? Of course, discrimination in any form during a selection process should be out of the question. Though that is the case, there are certain positions which needs young candidate while some positions demand that the person assigned to that should be an "old" |
Menéame: comentarios
|
#1 Hay que echarles una mano (May 31 2008 15:54 GMT) - Yo estoy muy a favor de la solidaridad... pero me pregunto ¿por qué siempre nos la tienen que pedir a nosotros -que apenas llegamos a fin de mes-, y no a los que realmente tienen recursos para solucionar ésos problemas? Harto me tienen las empresas "generosas y magnánimas" que tienen que esperar a Navidad para hacer sus " |
|