Home › Quizzes › SQL Programming

SQL Programming

SQL Programming Test contains questions on programming for Database, IT to prepare for IT, UGC NET exams

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following processes is responsible for signaling database writer at the checkpoints and updating all the datafiles and control files of the database to indicate the most recent checkpoints?

  1. Registration
  2. Lock manager server
  3. Database writer
  4. Checkpoint process
  5. Log writer
Question 2 Multiple Choice (Single Answer)

Which of the following memory components of the system global area provides large memory allocations for oracle backup and restore operations, I/O server process, session memory, etc?

  1. Read Only
  2. Session memory
  3. Java pool
  4. Stream pool
  5. Large pool
Question 3 Multiple Choice (Single Answer)

Which of the following triggers provides a transparent way of modifying view that cannot be modified directly through DML statements?

  1. SHUTDOWN trigger
  2. Instead of trigger
  3. View
  4. AFTER DROP trigger
  5. LOGOFF trigger
Question 4 Multiple Choice (Single Answer)

Which of the following is a procedure that run implicitly when an INSERT, UPDATE or DELETE statement is issued against the associated table?

  1. Recover
  2. Mounting the database
  3. Trigger
  4. Member method
  5. Static method
Question 5 Multiple Choice (Single Answer)

In which of the following components of the recovery manager environment is the client application spawn server sessions on the target database to do work of backup or recovery?

  1. Client
  2. Media management catalog
  3. Logical standby database
  4. RMAN client
  5. Duplicate database
Question 6 Multiple Choice (Single Answer)

Which of the following types of triggers fires after a successful entry of a user within the system?

  1. LOGON trigger
  2. LOGOFF trigger
  3. AFTER DROP trigger
  4. BEFORE trigger
  5. Mounting the database
Question 7 Multiple Choice (Single Answer)

Which of the following types of trigger is fired each time, when the table is affected by the triggering statement?

  1. ROW trigger
  2. Before trigger
  3. Disabled trigger
  4. BEFORE DROP trigger
  5. Opening the database
Question 8 Multiple Choice (Single Answer)

Which of the following parts of the trigger specifies a boolean expression that must be true for the trigger to fire?

  1. Segment
  2. AFTER DROP trigger
  3. BEFORE trigger
  4. Trigger event
  5. Trigger restriction
Question 9 Multiple Choice (Single Answer)

Which of the following triggers runs its trigger action, even if a triggering statement is issued and the trigger restriction would evaluate to TRUE?

  1. Table
  2. LOGOFF trigger
  3. Enabled trigger
  4. Disabled trigger
  5. BEFORE DROP trigger
Question 10 Multiple Choice (Single Answer)

Which of the following file's informations is used only to recover the database from a media failure?

  1. Force
  2. Redo log file
  3. Parameter file
  4. Password file
  5. Instance creation
Question 11 Multiple Choice (Single Answer)

Which of the following processes cleans up temporary segments that are no longer in use and recovers terminated transactions skipped during recovery because of file-read?

  1. Mounting the database
  2. Queue monitor
  3. System monitor
  4. Log writer
  5. Database writer
Question 12 Multiple Choice (Single Answer)

Which of the following parts of trigger is the procedure that contains the SQL statements and code to be run when a trigger statement is issued?

  1. Trigger action
  2. Trigger event
  3. Before trigger
  4. SHUTDOWN trigger
  5. Registration
Question 13 Multiple Choice (Single Answer)

Which of the following types of trigger fires when the database is opened by an instance?

  1. STARTUP trigger
  2. SHUTDOWN trigger
  3. Disabled trigger
  4. BEFORE trigger
  5. Read Only
Question 14 Multiple Choice (Single Answer)

In which of the following redundant arrays of independent disks level, the single parity disk is a bottle-neck for writing, since every write requires updating the parity data?

  1. Registration
  2. Redundant arrays of independent level 3
  3. Redundant arrays of independent disks level 0
  4. Redundant arrays of independent disk level 1
  5. Two-very-safe
Question 15 Multiple Choice (Single Answer)

Which of the following nodes instructs all nodes to initiate a global abort of the transaction if there is an abort response?

  1. Instance creation
  2. Global coordinator
  3. Local coordinator
  4. Database server
  5. Client
← Back to Quizzes