iHKCL | MCQ Practice


Q1 SQL is: A. non-procedural language B. Procedural Language C. Object Oriented Language D. All of these 0 0 Correct Answer A
Q2 Long data type can store A. 4GB B. 5GB C. 2GB D. 3GB 0 0 Correct Answer C
Q3 Fixed length character data can be stored in: A. VARCHAR2() B. CHAR() C. VARCHAR() D. LONG 0 0 Correct Answer B
Q4 HAVING clause in SELECT statement is used to A. restrict the column of table B. restrict the rows of grouped result C. restrict the rows of ungrouped table D. none of these 0 0 Correct Answer B
Q5 ORDER BY clause in SELECT statement is used for: A. sorting B. selection C. projection D. all of these 0 0 Correct Answer A
Q6 What will be the output of query "select * from emp;" A. Display * on the screen B. Display Name of employes only C. Display all the record of emp table D. none of these 0 0 Correct Answer C
Q7 DISTINCT clause is used to: A. all records B. only one record C. unique records D. selected records 0 0 Correct Answer C
Q8 Which one is not aggregate function A. SUM B. CHECK C. MAX D. AVG 0 0 Correct Answer B
Q9 Which clause is used to restrict the groups? A. WHERE B. ORDER BY C. GOUP BY D. HAVING 0 0 Correct Answer D
Q10 Which clause use at lowest level in SELECT statement A. GROUP BY B. HAVING C. WHERE D. ORDER BY 0 0 Correct Answer D
Q11 ROLLUP used in SELECT statement A. restrict column B. restrict rows C. calculate multiple levels of subtotals D. calculate average 0 0 Correct Answer C
Q12 Which command is used to provide priviledge to different user A. REVOKE B. GRANT C. RECALL D. PROVIDE 0 0 Correct Answer B
Q13 Which data model describes how the data is actually stored? A. internal model B. external model C. conceptual model D. all of these 0 0 Correct Answer A
Q14 Which one is not a set operator A. UNION B. MINUS C. ADD D. INTERSECt 0 0 Correct Answer C
Q15 Two tables are joined together using equality of values in one or more columns, with A. Self join B. Cartestion join C. Equi join D. Outer join 0 0 Correct Answer C
Q16 Which clause used to merge the outputs of two or more queries into single set of rows and columns A. UNION B. MINUS C. INTERSECT D. none of these 0 0 Correct Answer A
Q17 Which one is not RDBMS A. VB B. C++ C. JAVA D. All of these 0 0 Correct Answer D
Q18 LIKE operator used with A. CHAR B. VARCHAR2 C. 1 and 2 D. none of these 0 0 Correct Answer B
Q19 '%' represents a sequence(s): A. one character B. zero character C. zero or more character D. one or more character 0 0 Correct Answer C
Q20 System date function in oracle A. DATE B. SYSDATE C. SDATE D. SYSTEMDATE 0 0 Correct Answer B
Q21 Which condition is not true in case of inner query A. The inner query must be enclosed in parentheses. B. The inner query may not have an order by clause C. The inner query must have use groupby clause D. all of these 0 0 Correct Answer C
Q22 An Operator which check the existance of values A. SOME B. ALL C. LIKE D. EXISTS 0 0 Correct Answer D
Q23 The function finds the smallest integer greater than or equal to n A. FLOOR(n) B. EXP(n) C. CEIL(n) D. ABS(n) 0 0 Correct Answer C
Q24 The output of SIGN(n) if n is negtive A. 0 B. -1 C. 1 D. none of these 0 0 Correct Answer B
Q25 The function which capitalizes the first character of each word in string A. UPPER(string) B. INSTR(string) C. ASC(string) D. INITCAP(string) 0 0 Correct Answer D
Q26 The function removes all blank spaces from the left of string A. LPAD B. LTRIM C. RTRIM D. RPAD 0 0 Correct Answer B
Q27 Output of NEXT_DAY(date,day) is : A. next day of the given date B. Last day of the month C. last day of the year D. date of next specified day of the week 0 0 Correct Answer D
Q28 Display the name of user: A. uname B. username C. user D. name 0 0 Correct Answer C
Q29 Output of LAST_DAY(d) is : A. date of next specified day of the week B. The date of the last day of the month specified C. next day of the given date D. Last day of the month 0 0 Correct Answer B
Q30 What DDL stands for: A. data dclaration logic B. data definition language C. digital definiton logic D. disk defrage language 0 0 Correct Answer B
Q31 Number of NOT NULL culumns in a Table A. one B. two C. three D. none of these 0 0 Correct Answer D
Q32 Table name contains A. 30 characters B. 31 characters C. 32 characters D. 40 characters 0 0 Correct Answer A
Q33 Primary key defines as: A. Only a key which uniquely identify the records of table B. The first field in the table C. Which contains duplicate values D. none of these 0 0 Correct Answer A
Q34 Which constraint used to to assign default value to the column A. CHECK B. DEFAULT C. ASSIGN D. All of these 0 0 Correct Answer B
Q35 Which statement is wrong A. INSERT INTO EMP VALUES(111,'TECHNICAL EDUCATION',000); B. INSERT INTO EMP VALUES(&SRNO,'&DNAME',&VALUE); C. INSERT INTO EMP VALUES(&1,'&2',&3); D. none of these 0 0 Correct Answer D
Q36 State wrong one: A. DELETE command is used to delete rows from a table B. specific columns cannot be deleted from table with DELETE command C. DROP TABLE is used to delete table alongwith its structure D. none of these 0 0 Correct Answer D
Q37 Select wrong statement regarding VIEW A. VIEW does not store any data B. VIEW restricts access to the database C. VIEW can be created without base table D. all of these 0 0 Correct Answer C
Q38 Which command display all the tables on screen A. DESC B. SELECT * FROM TAB C. SELECT * FROM TABLE D. DISPLAY 0 0 Correct Answer B
Q39 Which command display the structure of table on screen A. DESC B. SELECT * FROM TABLE C. SELECT * FROM TAB D. LIST 0 0 Correct Answer A
Q40 View not contains at the time of definition A. GROUP BY B. WHERE C. HAVING D. ORDER BY 0 0 Correct Answer D
Q41 Which command used to replace existing value of the column A. REPLACE B. TRANSLATE C. UPDATE D. none of these 0 0 Correct Answer A
Q42 Which condition(s) necessary to make view read only A. It must no have columns that are aggregate function B. It must not use DISTINCT in its definition C. It must not use subqueries D. All of these 0 0 Correct Answer D
Q43 Which clause specifies that INSERT and UPDATE performed through the view are not allowed to create rows which the view cannot select A. CHECK B. START WITH C. HAVING D. WITH CHECH OPTION 0 0 Correct Answer D
Q44 A table is Key-preserved table A. if primary key contain numeric value only B. if primary key contain character value only C. if every key of table can also be a key of the result of the join D. none of these 0 0 Correct Answer C
Q45 Which clause allows the reciptent user to give further grants on the objects A. WITH UPDATE OPTION B. GRANT C. REVOKE D. WITH GRANT OPTION 0 0 Correct Answer D
Q46 Indexing: A. organise the table in proper way B. assign primary key to the table C. speed up the processes D. none of these 0 0 Correct Answer C
Q47 To delete the index from the table A. DELETE INDEX B. DROP INDEX C. COMMIT INDEX D. all of these 0 0 Correct Answer B
Q48 Display the list of ROLES created by users A. select * from user_roles B. select * from roles C. select * from user-roles D. select * from tab 0 0 Correct Answer A
Q49 Step(s) for creating clusters A. creating cluster B. createing cluster table C. creating cluster index D. all of these 0 0 Correct Answer D
Q50 Clustering means A. method of storing tables that are related and accessed togather B. assigning validation check to the table C. creating backup of the table D. none of these 0 0 Correct Answer A
Q51 Maximum length of all the cluster columns combined is : A. 237 B. 238 C. 239 D. 240 0 0 Correct Answer C
Q52 START WITH clause is used in A. indexing B. sequences C. clustering D. view 0 0 Correct Answer B
Q53 The command used to make changees to permanent: A. COMMIT B. ROLLBACK C. GRANT D. REVOKE 0 0 Correct Answer A
Q54 The command used to discard part or all work the user has done in current transaction A. COMMIT B. ROLLBACK C. GRANT D. REVOKE 0 0 Correct Answer B
Q55 The statement used to discard or commit all the changes upto a point A. COMMIT B. ROLLBACK C. SAVEPOINTS D. none of these 0 0 Correct Answer C
Q56 Which is/are the advantage of PL/SQL A. Integration B. Modularity C. Portability D. all of these 0 0 Correct Answer D
Q57 Which one is not the section of the PL/SQL program A. Declaration section B. Execution section C. Error section D. Exception Handing section 0 0 Correct Answer C
Q58 %rowtype is used A. provide a record type that represents a row in the table B. access datatype of the specified column C. declare specified data type to a variable D. all of these 0 0 Correct Answer A
Q59 Which operator have the higher precedence A. ** B. + C. LIKE D. OR 0 0 Correct Answer A
Q60 EXIT WHEN A. alterative B. iterative C. used in loops D. none of these 0 0 Correct Answer C
Q61 SELECT statement in PL/SQL must return A. five records B. four records C. three records D. one records 0 0 Correct Answer D
Q62 Which clause used with SELECT statement to store values from the table into variables A. GOTO clause B. INTO clause C. UPTO clause D. none of these 0 0 Correct Answer B
Q63 Which command is used to compile and execute the PL/SQL program A. RUN filename B. @filename C. &filename D. SQL filename 0 0 Correct Answer B
Q64 Command used to print on the screen A. PRINT B. WRITE C. dbms_output.put_line() D. DISPLAY 0 0 Correct Answer C
Q65 variable declaration is done in : A. declaration section B. execution section C. exception handling section D. none of these 0 0 Correct Answer A
Q66 Which on is not acomposite datatype: A. record B. table C. varray D. string 0 0 Correct Answer D
Q67 SQLERRM A. SQL server massage B. SQL memory information C. error massage D. non of these 0 0 Correct Answer C
Q68 Which varable attribute is used to define a column type variable A. %rowtype B. %type C. %columntype D. all of these 0 0 Correct Answer B
Q69 Private SQL area to execute SQL statements and store information A. Table B. Record C. View D. Cursor 0 0 Correct Answer D
Q70 Which clause excluded in cursor A. OPEN B. CLOSE C. FETCH D. EXECUTE 0 0 Correct Answer D
Q71 Run time error are known as: A. Exception B. syntax error C. grammetical error D. non of these 0 0 Correct Answer A
Q72 Cursor not supported by A. VB B. JAVA C. c D. all of these 0 0 Correct Answer D
Q73 Which one is not predefined exception A. NO_DATA_FOUND B. TOO_MANY_ROWS C. STORAGE_ERROR D. OTHERS 0 0 Correct Answer D
Q74 In PL/SQL a function returns A. one value B. all values C. non value D. none of theses 0 0 Correct Answer A
Q75 Function required A. GOTO clause B. JUMP clause C. RETURN clause D. all of these 0 0 Correct Answer C
Q76 Which argument mode lets the user to pass the value to called subprogram. A. OUT B. IN OUT C. IN D. all of these 0 0 Correct Answer C
Q77 Which one is not the part of trigger A. Trigger Event B. Trigger method C. Trigger action D. Trigger constrait 0 0 Correct Answer B
Q78 Which part is optional A. Trigger Event B. Trigger action C. Trigger constrait D. none of these 0 0 Correct Answer C
Q79 SQLJ : A. Translator which converts all SQL calls into JAVA calls B. SQL for JAVA C. SQL Jobs D. non of these 0 0 Correct Answer A
Q80 Which command used to close a file A. FFLUSH B. FCLOSE C. CLOSE D. none of these 0 0 Correct Answer B
Q81 Which command used to open a file A. FFLUSH B. FOPEN C. OPEN D. EDIT 0 0 Correct Answer B
Q82 NCLOB stands for A. Fixed width multi byte character large object B. No change in large object C. non-complement large object D. none of these 0 0 Correct Answer A
Q83 BFILE stands for : A. Big file B. Basic file C. Binary file D. non of these 0 0 Correct Answer C
Q84 Which is not an oracle process A. DBWR B. SMON C. RECO D. DBA 0 0 Correct Answer D
Q85 Which is/are provided NCA A. The development of a robust reliable architecture B. provide flexibility C. offers extensibility D. all of these 0 0 Correct Answer D
Q86 which one is not a oracle product A. SQL *Plus B. Oracle report builder C. JDK D. Developer2000 0 0 Correct Answer C
Q87 Which is oracle case tool A. SQL Plus B. Developer2000 C. Designer2000 D. SQL loader 0 0 Correct Answer C
Q88 JVM stands for A. JAVA virtual machine B. Joint value machine C. JAVA variable manipulation D. none of these 0 0 Correct Answer A
Q89 Which one is not th content of Program global area A. Stack space B. session information C. shared area D. parallel area 0 0 Correct Answer D
Q90 Which tool should you use to display the structure of the DEPARTMENT table? A. Data Manager B. Oracle Expert C. Schema Manager D. storage Manager 0 0 Correct Answer C
Q91 You want to understand why Oracle Expert has suggested a particular change toyourtavlespace storage parameters.How can you find more information. A. Run the Trace Assistant B. Generate a summary report C. View the information in the Analysis tab D. View the information in the Implement tab 0 0 Correct Answer B
Q92 Indicate which describes the term "Software" A. systems programs only B. Application program only C. Both a and b D. All of the above 0 0 Correct Answer C
Q93 User JAIN owns the EMP table. Which privilege does user SCOTT need to modify data in two of the columns in this table? A. UPDATE B. DELETE C. SELECT D. EXECUTE 0 0 Correct Answer A
Q94 Given this formula: number of blocks that contain rows, number of blocks below the high-water mark, Which value should be your target for non-empty tables? A. 0 B. 1 C. 25 D. 100 0 0 Correct Answer D
Q95 For which purpose should the SYSTEM tablespace ber used? A. to hold sorted data B. to store personal user objects C. to prevent data file fragmentation D. to keep track of all created objects 0 0 Correct Answer D
Q96 Which SQL command would you use to permanently remove all of the rows of data from a table and reduce its storage space? A. DROP B. ALTER C. DELETE D. TRUNCATE 0 0 Correct Answer D
Q97 You are using ORM to disable some constrains prior to a direct path data load. Which two constraint types should be disabled? A. check B. not null C. primary key D. foregin key 0 0 Correct Answer D
Q98 When is the best time to pin a procdure in the shared pool? A. just before the database is shut down B. right after the procedure is executed C. right after the database is started up D. when system rollback 0 0 Correct Answer C
Q99 In which parameter would a higher values reduce the wait time for free transaction space? A. NEXT B. PCTUSED C. INITRANS D. MAXEXTENTS 0 0 Correct Answer C
Q100 You are attempting to create a table space with the SIZE parameter when you receive this error?ORA-59 Maximum number of DB_FILES exceeded What is the best way to solve this problem? A. Recreate the Database B. Increase the DB_FILES parameter C. Create the table space with a smaller file size D. Reduce the number of datafilesassociated with each tablespace in the database. 0 0 Correct Answer B
Q101 Which of the following actions will alwayscause the DBWR process tlo write dirty buffers to disk? A. The data base shutdown in normal mode. B. A dirty buffer is moved to the dirty list. C. A SELECT operation requires a logical read. D. A SELECT operation reques a physical read 0 0 Correct Answer A
Q102 Which is the type of the table that may be a good candidate for clustering? A. often joined B. frequently updated C. many uniquevalues within a column D. no common columns with other tables 0 0 Correct Answer A
Q103 If you wanted to termiante a user's session, which are the two of the following values that must be included in the KILL SESSION clause? A. dba password B. session ID indeed C. serial number of user session D. b and c 0 0 Correct Answer D
Q104 Which of the following types of of storage structurewould you use to create three tables that will be frequently joined based oln similar key column values? A. LOB B. hash cluster C. nested table D. Index cluster 0 0 Correct Answer D
Q105 You altered the NLS_SORT parametre by altering the parameter file. Which data dictionary view would you query to display the current NLS_SORT parameter value? A. DBA_CATALOG B. NLS_SESSION_PARAMETERS C. NLS_DATABASE_PARAMETERS D. NLS_INSTANCE_PARAMETERS 0 0 Correct Answer D
Q106 You are monitoring the distribution of space allocated to the DEPT table owned by the Human Resources Application. Which data dictionary view could you query to display the number of blocks used by the table in each data file? A. DBA_USERS B. DBA_EXTENTS C. DBA_OBJECTS D. DBA_SEGMENTS 0 0 Correct Answer B
Q107 Which SQL clause should be used when it is possible to avoid sorting? A. UNION B. MINUS C. UNION ALL D. INTERSECT 0 0 Correct Answer C
Q108 Which two SELECT statement clauses return all the rows of a table when combined? A. SELECT B. FROM dept. C. SELECT ALL D. FROM COUNT(*) 0 0 Correct Answer D
Q109 If you have exceeded the total allocation to the buffer pools by setting the DB_BLOCK_BUFFERS and/or the DB_BLOCK_LRU_LATCHES parameters too high, what would happen? A. An error would occur and the database would not be mounted B. An error would occur and the database would be mounted but no opened C. The database would open, but theDB_BLOCK_BUFFERS and DB_BLOCK_LRU_LATCHES parameters would be ignored D. The database would open and the DB_BLOCK_BUFFERS and DB-BLOCK_LRU_LATCHES parameters would be resized byOracle to fit into memory. 0 0 Correct Answer A
Q110 You have been given the task of determining how many roolback segments to be allocated to an application> What do you need to accomplish this task? A. files in the tablespace B. available database buffers C. users who will be logged into the application D. transactions likely to be active at any given time 0 0 Correct Answer D
Q111 Which SQL operation requires a sort? A. SELECT * FROM item B. SELECT item_no, item_desc, status FROM item C. SELECT item_no, item_desc, status FROM item ORDER by item_no; D. SELECT item_no, item_desc, status FROM item WHERE item_desc BETWEEN 'Pen AND "Box; 0 0 Correct Answer C
Q112 Which Oracle diagonistic tool can display chart with realtime information on users throughput tablespaces andI/O? A. Oracle Trace B. Oracle Expert C. Oracle Look Manager D. Oracle Performance Manager 0 0 Correct Answer D
Q113 Your database has these tablespace:USERS,.TEMP,SYSTEM,RBS,Which table space should be usedto store application indexes? A. RBS B. USERS C. TEMP D. SYSTEM 0 0 Correct Answer C
Q114 Roundrobin scheduling A. allows interactive tasks quicker access to the processor B. is quite complex to implement C. gives each task the same chance at the processor D. allows processor-bound tasks more time in the processor 0 0 Correct Answer C
Q115 In which of the following two data dictionary views all the space in a data file, except for the header black, can be accounted for? A. DBA_EXTENTS B. DBA_SEGMENTS C. DBA_FREE_SPACE D. A and C 0 0 Correct Answer D
Q116 For which task would you use the OEM Console Lauch Palette? A. Hide the navigator B. Open theInstance Manager C. Configure a paging service D. View the hierachy of Oracle services in your network 0 0 Correct Answer B
Q117 When does paging occur ? A. when a process needs a large block of memory that isin real memory B. when there is inadequate disk space to temporarily hold memoryblocks C. when a process needs a large block of memory that is in virtual memory D. when the entire memory space being used by a process is removed from memory 0 0 Correct Answer C
Q118 A characteristic of an on-line real-time system is A. More than one CPU B. No delay in processing C. Off line batch processing D. All of the above 0 0 Correct Answer B
Q119 Which of the following statements is false? A. a process scheduling algorithm is preemptive if the CPU Can be forcibly removed from a process B. time sharing systems generally use premptive CPU scheduling C. response time are more predicatable in preemptive systems than in non preemptive systems D. real time stystem generally use nonpreemptive CPU scheduling 0 0 Correct Answer D
Q120 Which of the following modules does not incorporate initialization of values changed by the module? A. none reuseable module B. serially reusable module C. reenterable module D. all of the above 0 0 Correct Answer A
Q121 Indicate whether the statement LDA B is a statement in A. Machine Language B. Assembly language C. High level language D. All of the above 0 0 Correct Answer B
Q122 A critical region is A. a program segment that has not been proved bug-free B. a program segment that often causes unexpected system crashes C. a program segment where shared resources are accessed D. one which isenclosed by a pair of P and V operations an semaphores 0 0 Correct Answer D
Q123 Which of the following addressing modes, facilitates access ot an operand whoe location is defined relative to the beginning of the data structure in which it appears A. assending B. sorting C. index D. indirect 0 0 Correct Answer C
Q124 Which of the following is/are the advantage(s) of modular programming? A. The program is much easier to change B. Modules can be reused in other programs C. Easy debugging D. easy to compile 0 0 Correct Answer A
Q125 The capacity planning A. requires detailed system performance information B. is indendent of the operating system C. does not depend on the monitoring tools available D. is not needed in small installation 0 0 Correct Answer B
Q126 The computational technique used to computer the disk storage address of individual records is called: A. bubble memory B. key fielding C. dynamic reallocation D. hashing 0 0 Correct Answer D
Q127 A process is another name for A. a job B. a task C. paging D. the operating system dispatcher 0 0 Correct Answer B
Q128 Thrashing A. is a natural consequence of virtual memory systems B. can always be avoided by swapping C. always occurs on large computers D. can be caused by poor paging algorithms 0 0 Correct Answer D
Q129 Which type ofadminstrative operation isrecoerded in the alert file? A. network errors B. application errors C. shutting down the database D. identity of users logging in and out of the database. 0 0 Correct Answer C
Q130 Fork is A. the dispatching of task B. the creation of new job C. the creation of a new process D. the creation of a new process 0 0 Correct Answer C
Q131 The register or main memory location which contains the effective address of the operand is known as A. pointer B. indexed register C. special location D. scratch pad 0 0 Correct Answer A
Q132 Situations where two or more processes are reading or writing some shared data and the final result depends on who runs precisely when are called A. race conditions B. critical sections C. mutual exclusions D. message passing 0 0 Correct Answer A
Q133 In which situation would it be most appropriate to use a self join query A. The EMPLOYEE and REGION tables have correspondingcolumns. B. The EMPLOYEE and REGION tables have no corresponding columns. C. The EMPLOYEE tables has two columns that coorespond to each other. D. The EMPLOYEE table columns that corresponding to the REGION table contains null values for rows that need to be displayed. 0 0 Correct Answer C
Q134 You used the TRUNCATE command on the INVENTORY table which two results are true? A. The TRUNCATE command can be rolled back. B. The INVENTORY table definition still exists. C. The storage space held by the INVENTORY table wass released . D. b and d 0 0 Correct Answer D
Q135 You are using a procedure that quesries customer information. Where is this data processed? A. table B. data files C. memory structure D. roll back segments 0 0 Correct Answer C
Q136 In which addressing mode the effective address of the operand is the contents of a register specified in the instruction and after accesing the operand, the contents of this register is incremented to point to the next item in the list? A. index addressing B. indirect addressing C. auto increment D. auto decrement 0 0 Correct Answer C
Q137 The paging rate A. should never be greater than 100 per second B. is greater for large programs C. is the number of I/O interrupts each second D. increase as the number of page faults increase 0 0 Correct Answer D
Q138 What type of failure wiould hazve occurred if a user modifying the EMPOLYEE table inadvertently set all employee salaries to the same amount? A. media B. process C. instance D. user error 0 0 Correct Answer D
Q139 Moving process from main memory to disk is called A. scheduling B. caching C. swapping D. spooling 0 0 Correct Answer C
Q140 Which of the following is not a part of the operating system? A. supervisor B. performance monitor C. job-control program D. input/output control program 0 0 Correct Answer B
Q141 You are creating an index on the EMPNO column ion the EMPOLYEE TABLE. Which statement will you use? A. CREATE INDEX emp_empno_idx ON employee.empno; B. CREATE INDEX emp_empno_id FOR employee.empno; C. CREATE INDEX emp_empno_idx ON employee(empno); D. CREATE emp_empno_idx INDEX ON employee (empno); 0 0 Correct Answer C

Oracle

Q1 SQL is:

Q2 Long data type can store

Q3 Fixed length character data can be stored in:

Q4 HAVING clause in SELECT statement is used to

Q5 ORDER BY clause in SELECT statement is used for:

Q6 What will be the output of query "select * from emp;"

Q7 DISTINCT clause is used to:

Q8 Which one is not aggregate function

Q9 Which clause is used to restrict the groups?

Q10 Which clause use at lowest level in SELECT statement

Q11 ROLLUP used in SELECT statement

Q12 Which command is used to provide priviledge to different user

Q13 Which data model describes how the data is actually stored?

Q14 Which one is not a set operator

Q15 Two tables are joined together using equality of values in one or more columns, with

Q16 Which clause used to merge the outputs of two or more queries into single set of rows and columns

Q17 Which one is not RDBMS

Q18 LIKE operator used with

Q19 '%' represents a sequence(s):

Q20 System date function in oracle

Q21 Which condition is not true in case of inner query

Q22 An Operator which check the existance of values

Q23 The function finds the smallest integer greater than or equal to n

Q24 The output of SIGN(n) if n is negtive

Q25 The function which capitalizes the first character of each word in string

Q26 The function removes all blank spaces from the left of string

Q27 Output of NEXT_DAY(date,day) is :

Q28 Display the name of user:

Q29 Output of LAST_DAY(d) is :

Q30 What DDL stands for:

Q31 Number of NOT NULL culumns in a Table

Q32 Table name contains

Q33 Primary key defines as:

Q34 Which constraint used to to assign default value to the column

Q35 Which statement is wrong

Q36 State wrong one:

Q37 Select wrong statement regarding VIEW

Q38 Which command display all the tables on screen

Q39 Which command display the structure of table on screen

Q40 View not contains at the time of definition

Q41 Which command used to replace existing value of the column

Q42 Which condition(s) necessary to make view read only

Q43 Which clause specifies that INSERT and UPDATE performed through the view are not allowed to create rows which the view cannot select

Q44 A table is Key-preserved table

Q45 Which clause allows the reciptent user to give further grants on the objects

Q46 Indexing:

Q47 To delete the index from the table

Q48 Display the list of ROLES created by users

Q49 Step(s) for creating clusters

Q50 Clustering means

Q51 Maximum length of all the cluster columns combined is :

Q52 START WITH clause is used in

Q53 The command used to make changees to permanent:

Q54 The command used to discard part or all work the user has done in current transaction

Q55 The statement used to discard or commit all the changes upto a point

Q56 Which is/are the advantage of PL/SQL

Q57 Which one is not the section of the PL/SQL program

Q58 %rowtype is used

Q59 Which operator have the higher precedence

Q60 EXIT WHEN

Q61 SELECT statement in PL/SQL must return

Q62 Which clause used with SELECT statement to store values from the table into variables

Q63 Which command is used to compile and execute the PL/SQL program

Q64 Command used to print on the screen

Q65 variable declaration is done in :

Q66 Which on is not acomposite datatype:

Q67 SQLERRM

Q68 Which varable attribute is used to define a column type variable

Q69 Private SQL area to execute SQL statements and store information

Q70 Which clause excluded in cursor

Q71 Run time error are known as:

Q72 Cursor not supported by

Q73 Which one is not predefined exception

Q74 In PL/SQL a function returns

Q75 Function required

Q76 Which argument mode lets the user to pass the value to called subprogram.

Q77 Which one is not the part of trigger

Q78 Which part is optional

Q79 SQLJ :