Oracle 10g
Settings
Total number of questions : 45 Time :1 hour
- 1.Consider the following code snippet: declare flag boolean; begin flag:=true; begin flag:=NOT flag; if(flag)then DBMS_OUTPUT.PUT_LINE('Hai'); else DBMS_OUTPUT.PUT_LINE('Hello'); end if; end; end; Which of the following gives the outcome of the above code snippet
- A.
The code segment prints Hai.
- B.
The code segment prints NULL.
- C.
The code segment prints Hello.
- 2.RMZ corporation is expanding its operations.They are in the process of recruting 1000 employees for their organization. vimal, database develoer, is asked to list out th names of responding candidates who are not refrred by anyone. Using the table Candidate_Details(Candidate_name,referredby) Which of the following SQL statement will help him accomplish the above task?
- A.
1.select Candidate_name from Candidate_Details where referredby IS NULL
- B.
2.select Candidate_name from Candidate_Details where referredby NOT LIKE '%NULL'
- C.
3.select Candidate_name from Candidate_Details where referredby =NULL
- D.
4.select Candidate_name from Candidate_Details where referredby IN NULL
- 3.Examine the Emloyee table emp(emp_id,ename,salary,depno,job). The job column has value of 'salesman' in all rows Which of the following sql satements will remove man from job column of the rows ? [Example job = salesman remove man and return 'sales'].
- A.
1.select job, LPAD(job,man) from emp
- B.
2.select job, RTRIM(job,man) from emp
- C.
3.select job, RPAD(job,man) from emp
- D.
4.select job, LTRIM(job,man) from emp
- 4.Consider an empployee table emp(empno,ename,sal). Devika has been given the task to retrive the emloyee names and salaries from emp table sorted by the salary in desending order. If two names match fo a salary then two names must be displayed in alphabatical order. Which of the following statements will produce the required results for her?
- A.
1.SELECT ename,sal FROM emp order by ename,sal
- B.
2.SELECT ename,sal FROM emp order by sal,ename
- C.
3.SELECT ename,sal FROM emp order by sal DESC,ename
- D.
4.SELECT ename,sal FROM emp SORT by sal DESC,ename
- 5.Which of the following information contain in a control file ?(CHOOSE 3)
- A.
1. Data associated with a schema object in tablespace
- B.
2. Size of Database
- C.
3. Names and locations of datafiles and redo log files
- D.
4. Time stamp of database creation
- E.
5. Database name
- 6.Veena is working on patient table of Hospital database. she needs to retrieve the list of patient names and wants the first letter of name to be converted to a capital letter. Which of the following functions in SQL will accomplish her the above task?
- A.
1.UPPER
- B.
2.DECODE
- C.
3.INITCAP
- D.
4.LOWER
- 7.Which of the following are correct gidelines for naming database tables?(CHOOSE 2)
- A.
1.Must contain atleast one Null character
- B.
2.Must contain only A-Z,a-z,0-9,_,*,and #
- C.
3.Must be 1-30 characters long
- D.
Cannot be an oracle server reserved word
- 8.Which of the following are main types of files used in the physical architecture of an oracle Database?(CHOOSE 3)
- A.
1.Parameter files
- B.
2.Redo log files
- C.
3.Trace files
- D.
4.Control files
- E.
5.Data files
Back to top