Oracle

1 SQL is:

A) non-procedural language
B) Procedural Language
C) Object Oriented Language
D) All of these

... Answer is A)

2 Long data type can store

A) 4GB
B) 5GB
C) 2GB
D) 3GB

... Answer is C)

3 Fixed length character data can be stored in:

A) VARCHAR2()
B) CHAR()
C) VARCHAR()
D) LONG

... Answer is B)

4 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

... Answer is B)

5 ORDER BY clause in SELECT statement is used for:

A) sorting
B) selection
C) projection
D) all of these

... Answer is A)

6 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

... Answer is C)

7 DISTINCT clause is used to:

A) all records
B) only one record
C) unique records
D) selected records

... Answer is C)

8 Which one is not aggregate function

A) SUM
B) CHECK
C) MAX
D) AVG

... Answer is B)

9 Which clause is used to restrict the groups?

A) WHERE
B) ORDER BY
C) GOUP BY
D) HAVING

... Answer is D)

10 Which clause use at lowest level in SELECT statement

A) GROUP BY
B) HAVING
C) WHERE
D) ORDER BY

... Answer is D)

11 ROLLUP used in SELECT statement

A) restrict column
B) restrict rows
C) calculate multiple levels of subtotals
D) calculate average

... Answer is C)

12 Which command is used to provide priviledge to different user

A) REVOKE
B) GRANT
C) RECALL
D) PROVIDE

... Answer is B)

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

A) internal model
B) external model
C) conceptual model
D) all of these

... Answer is A)

14 Which one is not a set operator

A) UNION
B) MINUS
C) ADD
D) INTERSECt

... Answer is C)

15 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

... Answer is C)

16 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

... Answer is A)

17 Which one is not RDBMS

A) VB
B) C++
C) JAVA
D) All of these

... Answer is D)

18 LIKE operator used with

A) CHAR
B) VARCHAR2
C) 1 and 2
D) none of these

... Answer is B)

19 '%' represents a sequence(s):

A) one character
B) zero character
C) zero or more character
D) one or more character

... Answer is C)

20 System date function in oracle

A) DATE
B) SYSDATE
C) SDATE
D) SYSTEMDATE

... Answer is B)

21 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

... Answer is C)

22 An Operator which check the existance of values

A) SOME
B) ALL
C) LIKE
D) EXISTS

... Answer is D)

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

A) FLOOR(n)
B) EXP(n)
C) CEIL(n)
D) ABS(n)

... Answer is C)

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

A) 0
B) -1
C) 1
D) none of these

... Answer is B)

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

A) UPPER(string)
B) INSTR(string)
C) ASC(string)
D) INITCAP(string)

... Answer is D)

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

A) LPAD
B) LTRIM
C) RTRIM
D) RPAD

... Answer is B)

27 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

... Answer is D)

28 Display the name of user:

A) uname
B) username
C) user
D) name

... Answer is C)

29 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

... Answer is B)

30 What DDL stands for:

A) data dclaration logic
B) data definition language
C) digital definiton logic
D) disk defrage language

... Answer is B)

31 Number of NOT NULL culumns in a Table

A) one
B) two
C) three
D) none of these

... Answer is D)

32 Table name contains

A) 30 characters
B) 31 characters
C) 32 characters
D) 40 characters

... Answer is A)

33 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

... Answer is A)

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

A) CHECK
B) DEFAULT
C) ASSIGN
D) All of these

... Answer is B)

35 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

... Answer is D)

36 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

... Answer is D)

37 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

... Answer is C)

38 Which command display all the tables on screen

A) DESC
B) SELECT * FROM TAB
C) SELECT * FROM TABLE
D) DISPLAY

... Answer is B)

39 Which command display the structure of table on screen

A) DESC
B) SELECT * FROM TABLE
C) SELECT * FROM TAB
D) LIST

... Answer is A)

40 View not contains at the time of definition

A) GROUP BY
B) WHERE
C) HAVING
D) ORDER BY

... Answer is D)

41 Which command used to replace existing value of the column

A) REPLACE
B) TRANSLATE
C) UPDATE
D) none of these

... Answer is A)

42 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

... Answer is D)

43 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

... Answer is D)

44 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

... Answer is C)

45 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

... Answer is D)

46 Indexing:

A) organise the table in proper way
B) assign primary key to the table
C) speed up the processes
D) none of these

... Answer is C)

47 To delete the index from the table

A) DELETE INDEX
B) DROP INDEX
C) COMMIT INDEX
D) all of these

... Answer is B)

48 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

... Answer is A)

49 Step(s) for creating clusters

A) creating cluster
B) createing cluster table
C) creating cluster index
D) all of these

... Answer is D)

50 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

... Answer is A)

51 Maximum length of all the cluster columns combined is :

A) 237
B) 238
C) 239
D) 240

... Answer is C)

52 START WITH clause is used in

A) indexing
B) sequences
C) clustering
D) view

... Answer is B)

53 The command used to make changees to permanent:

A) COMMIT
B) ROLLBACK
C) GRANT
D) REVOKE

... Answer is A)

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

A) COMMIT
B) ROLLBACK
C) GRANT
D) REVOKE

... Answer is B)

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

A) COMMIT
B) ROLLBACK
C) SAVEPOINTS
D) none of these

... Answer is C)

56 Which is/are the advantage of PL/SQL

A) Integration
B) Modularity
C) Portability
D) all of these

... Answer is D)

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

A) Declaration section
B) Execution section
C) Error section
D) Exception Handing section

... Answer is C)

58 %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

... Answer is A)

59 Which operator have the higher precedence

A) **
B) +
C) LIKE
D) OR

... Answer is A)

60 EXIT WHEN

A) alterative
B) iterative
C) used in loops
D) none of these

... Answer is C)

61 SELECT statement in PL/SQL must return

A) five records
B) four records
C) three records
D) one records

... Answer is D)

62 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

... Answer is B)

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

A) RUN filename
B) @filename
C) &filename
D) SQL filename

... Answer is B)

64 Command used to print on the screen

A) PRINT
B) WRITE
C) dbms_output.pu t_line()
D) DISPLAY

... Answer is C)

65 variable declaration is done in :

A) declaration section
B) execution section
C) exception handling section
D) none of these

... Answer is A)

66 Which on is not acomposite datatype:

A) record
B) table
C) varray
D) string

... Answer is D)

67 SQLERRM

A) SQL server massage
B) SQL memory information
C) error massage
D) non of these

... Answer is C)

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

A) %rowtype
B) %type
C) %columntype
D) all of these

... Answer is B)

69 Private SQL area to execute SQL statements and store information

A) Table
B) Record
C) View
D) Cursor

... Answer is D)

70 Which clause excluded in cursor

A) OPEN
B) CLOSE
C) FETCH
D) EXECUTE

... Answer is D)

71 Run time error are known as:

A) Exception
B) syntax error
C) grammetical error
D) non of these

... Answer is A)

72 Cursor not supported by

A) VB
B) JAVA
C) c
D) all of these

... Answer is D)

73 Which one is not predefined exception

A) NO_DATA_FOUND
B) TOO_MANY_ROWS
C) STORAGE_ER ROR
D) OTHERS

... Answer is D)

74 In PL/SQL a function returns

A) one value
B) all values
C) non value
D) none of theses

... Answer is A)

75 Function required

A) GOTO clause
B) JUMP clause
C) RETURN clause
D) all of these

... Answer is C)

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

A) OUT
B) IN OUT
C) IN
D) all of these

... Answer is C)

77 Which one is not the part of trigger

A) Trigger Event
B) Trigger method
C) Trigger action
D) Trigger constrait

... Answer is B)

78 Which part is optional

A) Trigger Event
B) Trigger action
C) Trigger constrait
D) none of these

... Answer is C)

79 SQLJ :

A) Translator which converts all SQL calls into JAVA calls
B) SQL for JAVA
C) SQL Jobs
D) non of these

... Answer is A)

80 Which command used to close a file

A) FFLUSH
B) FCLOSE
C) CLOSE
D) none of these

... Answer is B)

81 Which command used to open a file

A) FFLUSH
B) FOPEN
C) OPEN
D) EDIT

... Answer is B)

82 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

... Answer is A)

83 BFILE stands for :

A) Big file
B) Basic file
C) Binary file
D) non of these

... Answer is C)

84 Which is not an oracle process

A) DBWR
B) SMON
C) RECO
D) DBA

... Answer is D)

85 Which is/are provided NCA

A) The development of a robust reliable architecture
B) provide flexibility
C) offers extensibility
D) all of these

... Answer is D)

86 which one is not a oracle product

A) SQL *Plus
B) Oracle report builder
C) JDK
D) Developer2000

... Answer is C)

87 Which is oracle case tool

A) SQL *Plus
B) Developer2000
C) Designer2000
D) SQL *loader

... Answer is C)

88 JVM stands for

A) JAVA virtual machine
B) Joint value machine
C) JAVA variable manipulation
D) none of these

... Answer is A)

89 Which one is not th content of Program global area

A) Stack space
B) session information
C) shared area
D) parallel area

... Answer is D)

90 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

... Answer is C)

91 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

... Answer is B)

92 Indicate which describes the term "Software"

A) systems programs only
B) Application program only
C) Both a and b
D) All of the above

... Answer is C)

93 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

... Answer is A)

94 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

... Answer is D)

95 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

... Answer is D)

96 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

... Answer is D)

97 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

... Answer is D)

98 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

... Answer is C)

99 In which parameter would a higher values reduce the wait time for free transaction space?

A) NEXT
B) PCTUSED
C) INITRANS
D) MAXEXTENTS

... Answer is C)

100 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 datafilesassociate d with each tablespace in the database.

... Answer is B)

101 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
D) A SELECT operation reques a physical read

... Answer is A)

102

A)
B)
C) logical read.
D)

... Answer is )

103 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

... Answer is A)

104 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

... Answer is D)

105 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

... Answer is D)

106 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_PAR AMETERS
C) NLS_DATABAS E_PARAMETE RS
D) NLS_INSTANCE_ PARAMETERS

... Answer is D)

107 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

... Answer is B)

108 Which SQL clause should be used when it is possible to avoid sorting?

A) UNION
B) MINUS
C) UNION ALL
D) INTERSECT

... Answer is C)

109 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(*)

... Answer is D)

110 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_LR U_LATCHES parameters would be ignored
D) The database would open and the DB_BLOCK_BUF FERS and DB- BLOCK_LRU_LAT CHES parameters would be resized byOracle to fit into memory.

... Answer is A)

111 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

... Answer is D)

112 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;

... Answer is C)

113 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

... Answer is D)

114 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

... Answer is C)

115 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

... Answer is C)

116 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_SP ACE
D) A and C

... Answer is D)

117 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

... Answer is B)

118 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

... Answer is C)

119 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

... Answer is B)

120 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

... Answer is D)

121 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

... Answer is A)

122 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

... Answer is B)

123 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

... Answer is D)

124 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

... Answer is C)

125 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

... Answer is A)

126 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

... Answer is B)

127 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

... Answer is D)

128 A process is another name for

A) a job
B) a task
C) paging
D) the operating system dispatcher

... Answer is B)

129 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

... Answer is D)

130 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.

... Answer is C)

131 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

... Answer is C)

132 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

... Answer is A)

133 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

... Answer is A)

135 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.

... Answer is C)

136 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

... Answer is D)

137 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

... Answer is C)

138 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

... Answer is C)

139 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

... Answer is D)

140 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

... Answer is D)

141 Moving process from main memory to disk is called

A) scheduling
B) caching
C) swapping
D) spooling

... Answer is C)

142 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

... Answer is B)

143 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_id x ON employee (empno);
D) CREATE emp_empno_idx INDEX ON employee (empno);

... Answer is C)