Q1 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

Q2 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

Q3 DISTINCT clause is used to:

A. all records

B. only one record

C. unique records

D. selected records

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

Q5 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

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

A. COMMIT

B. ROLLBACK

C. GRANT

D. REVOKE

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

A. UPPER(string)

B. INSTR(string)

C. ASC(string)

D. INITCAP(string)

Q8 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

Q9 Number of NOT NULL culumns in a Table

A. one

B. two

C. three

D. none of these

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

A. internal model

B. external model

C. conceptual model

D. all of these

Q11 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

Q12 Which part is optional

A. Trigger Event

B. Trigger action

C. Trigger constrait

D. none of these

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

Q14 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

Q15 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

Q16 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

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

Q18 START WITH clause is used in

A. indexing

B. sequences

C. clustering

D. view

Q19 Run time error are known as:

A. Exception

B. syntax error

C. grammetical error

D. non of these

Q20 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

MCQ Questions, ihkcl.in
MCQ Questions, ihkcl.in
MCQ Questions, ihkcl.in
MCQ Questions, ihkcl.in
MCQ Questions, ihkcl.in
MCQ Questions, ihkcl.in