ORACLE MCQ SET

ORACLE Multiple Choice Question Material
[1] We can create SNAPSHOTLOG for[DBA]
(A) => Simple snapshots
(B) => Complex snapshots
(C) => Both
Answer =>> Simple snapshots
[2] Transactions per rollback segment is derived from[DBA]
(A) => Db_Block_Buffers
(B) => Processes,
(C) => Shared_Pool_Size
Answer =>> Processes,
[3] ENQUEUE resources parameter information is derived from[DBA]
(A) => Processes or DDL_LOCKS and DML_LOCKS
(B) => LOG_BUFFER,
(C) => DB__BLOCK_SIZE
Answer =>> Processes or DDL_LOCKS and DML_LOCKS
[4] LGWR process writes information into
(A) => Database files
(B) => Control files
(C) => Redolog files
Answer =>> Redolog files
[5] SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace
(A) => True
(B) => False
(C) => none
Answer =>> False
[6] Databases overall structure is maintained in a file called
(A) => Redolog file
(B) => Control file
(C) => All of the above.
Answer =>> Control file
[7] These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES
(A) => True
(B) => False
(C) => none
Answer =>> False
[8] Constraints cannot be exported through EXPORT command
(A) => True
(B) => False
(C) => none
Answer =>> False
[9] It is very difficult to grant and manage common privileges needed by different groups of database users using the roles
(A) => True
(B) => False
(C) => none
Answer =>> False
[10] What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW regarding moving the window with respect to the application window
(A) => Both windows behave the same way as far as moving the window is concerned
(B) => A document window can be moved outside the application window while a dialog window cannot be moved
(C) => A dialog window can be moved outside the application window while a document window cannot be moved
Answer =>> A dialog window can be moved outside the application window while a document window cannot be moved
[11] What is the difference between a MESSAGEBOX and an ALERT
(A) => A messagebox can be used only by the system and cannot be used in user application while an alert can be used in user application also
(B) => A alert can be used only by the system and cannot be use din user application while an messagebox can be used in user application also.
(C) => An alert requires an response from the userwhile a messagebox just flashes a message and only requires an acknowledment from the user
Answer =>> An alert requires an response from the userwhile a messagebox just flashes a message and only requires an acknowledment from the user
[12] Which of the following is not an reason for the fact that most of the processing is done at the server ?
(A) => To reduce network traffic
(B) => For application sharing
(C) => None of the above
Answer =>> None of the above
[13] Can a DIALOG WINDOW have scroll bar attached to it ?
(A) => Yes
(B) => No
(C) => none
Answer =>> No
[14] In a CLIENT/SERVER environment , which of the following would not be done at the client ?
(A) => User interface part
(B) => Data validation at entry line
(C) => None of the above
Answer =>> None of the above
[15] Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
(A) => Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked
(B) => Because the stored procedure occupies more space in the database than a integrity constraint definition
(C) => Because a stored procedure creates more network traffic than a integrity constraint definition
Answer =>> Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked
[16] Which of the following is not an advantage of a client/server model ?
(A) => A client/server model allows centralised control of data and centralised implementation of business rules.
(B) => A client/server model increases developer;s productivity
(C) => A client/server model is suitable for all applications
Answer =>> A client/server model is suitable for all applications
[17] What does DLL stands for ?
(A) => Dynamic Language Library
(B) => Dynamic Link Library
(C) => Dynamic Load Library
Answer =>> Dynamic Link Library
[18] POST-BLOCK trigger is a
(A) => Navigational trigger
(B) => Key trigger
(C) => Transactional trigger
Answer =>> Navigational trigger
[19] The system variable that records the select statement that SQL * FORMS most recently used to populate a block is
(A) => SYSTEM.LAST_RECORD
(B) => SYSTEM.CURSOR_FIELD
(C) => SYSTEM.LAST_QUERY
Answer =>> SYSTEM.LAST_QUERY
[20] Which of the following is TRUE for the ENFORCE KEY field A.ENFORCE KEY field characterstic indicates the source of the value that SQL*FORMS uses to populate the field B. A field with the ENFORCE KEY characterstic should have the INPUT ALLOWED charaterstic turned off
(A) => Only 1 is TRUE
(B) => Only 2 is TRUE
(C) => Both 1 and 2 are TRUE
Answer =>> Only 1 is TRUE
[21] What is the maximum size of the page ?
(A) => Characters wide & 265 characters length
(B) => Characters wide & 265 characters length
(C) => Characters wide & 80 characters length
Answer =>> Characters wide & 265 characters length
[22] A FORM is madeup of which of the following objects
(A) => block, fields only
(B) => blocks, fields, pages only,
(C) => blocks, fields, pages, triggers and form level procedures,
Answer =>> blocks, fields, pages, triggers and form level procedures,
[23] For the following statements which is true 1 Page is an object owned by a form 2 Pages are a collection of display information such as constant text and graphics
(A) => Only 1 is TRUE
(B) => Only 2 is TRUE
(C) => Both 1 & 2 are TRUE
Answer =>> Only 2 is TRUE
[24] The packaged procedure that makes data in form permanent in the Database is
(A) => Post
(B) => Post form
(C) => Commit form
Answer =>> Commit form
[25] Which of the following is TRUE for the SYSTEM VARIABLE $$date$$
(A) => Can be assigned to a global variable
(B) => Can be assigned to any field only during design time
(C) => Can be assigned to any variable or field during run time
Answer =>> Can be assigned to any field only during design time
[26] Which of the following packaged procedure is UNRESTRICTED ?
(A) => CALL_INPUT
(B) => CLEAR_BLOCK
(C) => USER_EXIT
Answer =>> USER_EXIT
[27] Identify the RESTRICTED packaged procedure from the following
(A) => USER_EXIT
(B) => MESSAGE
(C) => EXIT_FORM
Answer =>> EXIT_FORM
[28] What is SQL*FORMS
(A) => SQL*FORMS is a 4GL tool for developing & executing Oracle based interactive applications.
(B) => SQL*FORMS is a 3GL tool for connecting to the Database
(C) => SQL*FORMS is a reporting tool
Answer =>> SQL*FORMS is a 4GL tool for developing & executing Oracle based interactive applications.
[29] What is a trigger
(A) => A piece of logic written in PL/SQL
(B) => Executed at the arrival of a SQL*FORMS event
(C) => Both A & B
Answer =>> Both A & B
[30] Which of the folowing is TRUE for a ERASE packaged procedure. 1.ERASE removes an indicated Global variable & releases the memory associated with it 2.ERASE is used to remove a field from a page
(A) => Only 1 is TRUE
(B) => Only 2 is TRUE
(C) => Both 1 & 2 are TRUE
Answer =>> Only 1 is TRUE
[31] All datafiles related to a Tablespace are removed when the Tablespace is dropped
(A) => TRUE
(B) => FALSE
(C) => none
Answer =>> FALSE
[32] Size of Tablespace can be increased by
(A) => Increasing the size of one of the Datafiles
(B) => Adding one or more Datafiles
(C) => Cannot be increased
Answer =>> Adding one or more Datafiles
[33] Multiple Tablespaces can share a single datafile
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[34] A set of Dictionary tables are created
(A) => Once for the Entire Database
(B) => Every time a user is created
(C) => Every time a Tablespace is created
Answer =>> Once for the Entire Database
[35] Datadictionary can span across multiple Tablespaces
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[36] Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint
(A) => Yes
(B) => No
(C) => None
Answer =>> No
[37] A column defined as PRIMARY KEY can have NULL?A column defined as PRIMARY KEY can have NULL?
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[38] A Transaction ends
(A) => Only when it is Committed
(B) => Only when it is Rolledback
(C) => When it is Committed or Rolledback
Answer =>> When it is Committed or Rolledback
[39] A Database Procedure is stored in the Database
(A) => In compiled form
(B) => As source code
(C) => Both A & B
Answer =>> Both A & B
[40] A database trigger doesnot apply to data loaded before the definition of the trigger
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> TRUE
[41] Dedicated server configuration is
(A) => One server process - Many user processes
(B) => Many server processes - One user process
(C) => One server process - One user process
Answer =>> One server process - One user process
[42] Which of the following does not affect the size of the SGA
(A) => Database buffer
(B) => Redolog buffer
(C) => Stored procedure
Answer =>> Stored procedure
[43] What does a COMMIT statement do to a CURSOR
(A) => Open the Cursor
(B) => Fetch the Cursor
(C) => None of the above
Answer =>> None of the above
[44] Which of the following is TRUE 1 Host variables are declared anywhere in the program 2 Host variables are declared in the DECLARE section
(A) => Only 1 is TRUE
(B) => Only 2 is TRUE
(C) => Both 1 & 2are TRUE
Answer =>> Only 2 is TRUE
[45] Which of the following is NOT VALID is PL/SQL
(A) => Bool boolean;
(B) => NUM1, NUM2 number
(C) => deptname dept.dname%type;
Answer =>> NUM1, NUM2 number
[46] Which of the following is not correct about an Exception ?
(A) => Raised automatically / Explicitly in response to an ORACLE_ERROR
(B) => An exception will be raised when an error occurs in that block
(C) => Process terminates after completion of error sequence.
Answer =>> Process terminates after completion of error sequence.
[47] Which of the following is not correct about User_Defined Exceptions ?
(A) => Must be declared
(B) => Must be raised explicitly
(C) => Raised automatically in response to an Oracle error
Answer =>> Raised automatically in response to an Oracle error
[48] A Stored Procedure is a
(A) => Sequence of SQL or PL/SQL statements to perform specific function
(B) => Stored in compiled form in the database
(C) => All of the above
Answer =>> All of the above
[49] Which of the following statement is false
(A) => Any procedure can raise an error and return an user message and error number
(B) => Error number ranging from 20000 to 20999 are reserved for user defined messages
(C) => Oracle checks Uniqueness of User defined errors
Answer =>> Oracle checks Uniqueness of User defined errors
[50] Is it possible to open a cursor which is in a Package in another procedure ?
(A) => Yes
(B) => No
(C) => none
Answer =>> Yes
[51] Is it possible to use Transactional control statements in Database Triggers?
(A) => Yes
(B) => No
(C) => none
Answer =>> No
[52] Is it possible to Enable or Disable a Database trigger ?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[53] PL/SQL supports datatype(s)
(A) => Scalar datatype
(B) => Composite datatype
(C) => All of the above
Answer =>> All of the above
[54] Find the ODD datatype out
(A) => VARCHAR2
(B) => RECORD
(C) => BOOLEAN
Answer =>> RECORD
[55] Which of the following is not correct about the |TABLE| datatype ?
(A) => Can contain any no of columns
(B) => Simulates a One-dimensional array of unlimited size
(C) => Column datatype of any Scalar type
Answer =>> Can contain any no of columns
[56] Find the ODD one out of the following
(A) => OPEN
(B) => CLOSE
(C) => INSERT
Answer =>> INSERT
[57] Which of the following is not correct about Cursor ?
(A) => Cursor is a named Private SQL area
(B) => Cursor holds temporary results
(C) => Cursor is used for retrieving multiple rows
Answer =>> Cursor holds temporary results
[58] Which of the following is NOT VALID in PL/SQL ?
(A) => Select ? into
(B) => Create
(C) => Update
Answer =>> Create
[59] What is the Result of the following ?VIK?||NULL||?RAM? ?
(A) => Error
(B) => VIK RAM
(C) => VIKRAM
Answer =>> VIKRAM
[60] Is it possible to modify a Datatype of a column when column contains data ?
(A) => No
(B) => Yes
(C) => none
Answer =>> No
[61] Which of the following is not correct about a View ?
(A) => To protect some of the columns of a table from other users
(B) => Ocuupies data storage space
(C) => To hide complexity of a query
Answer =>> Ocuupies data storage space
[62] Which is not part of the Data Definiton Language ?
(A) => CREATE
(B) => ALTER
(C) => ALTER SESSION
Answer =>> ALTER SESSION
[63] The Data Manipulation Language statements are
(A) => INSERT
(B) => UPDATE
(C) => All of the above
Answer =>> All of the above
[64] What are the different events in Triggers ?
(A) => Define, Create
(B) => Drop, Comment
(C) => Insert, Update, Delete
Answer =>> Insert, Update, Delete
[65] What built-in subprogram is used to manipulate images in image items ?
(A) => Zoom_out
(B) => Zoom_in?
(C) => Image_zoom
Answer =>> Image_zoom
[66] Can we pass RECORD GROUP between FORMS ?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[67] SHOW_ALERT function returns
(A) => Boolean
(B) => Number
(C) => Character
Answer =>> Number
[68] What SYSTEM VARIABLE is used to refer DATABASE TIME ?
(A) => $$dbtime$$
(B) => $$time$$
(C) => $$datetime$$
Answer =>> $$dbtime$$
[69] SYSTEM.EFFECTIVE.DATE varaible is
(A) => Read only
(B) => Read & Write
(C) => Write only
Answer =>> Write only
[70] How can you CALL Reports from Forms4.0 ?
(A) => Run_Report built_in
(B) => Call_Report built_in
(C) => Run_Product built_in
Answer =>> Run_Product built_in
[71] When do you get a .PLL extension ?
(A) => Save Library file
(B) => Generate Library file
(C) => Run Library file
Answer =>> Save Library file
[72] What is built_in Subprogram ?
(A) => Stored procedure & Function
(B) => Collection of Subprogram
(C) => None of the above
Answer =>> None of the above
[73] GET_BLOCK property is a
(A) => Restricted procedure
(B) => Library function
(C) => None of the above
Answer =>> None of the above
[74] A CONTROL BLOCK can sometimes refer to a BASETABLE ?
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[75] What do you mean by CHECK BOX ?
(A) => Two state control
(B) => One state control
(C) => Three state control
Answer =>> One state control
[76] List of Values (LOV) supports
(A) => Single column
(B) => Multi column
(C) => Single or Multi column
Answer =>> Single or Multi column
[77] What is Library in Forms 4.0 ?
(A) => Collection of External field
(B) => Collection of built_in packages
(C) => Collection of PL/SQl functions, procedures and packages
Answer =>> Collection of PL/SQl functions, procedures and packages
[78] Can we use a RESTRICTED packaged procedure in WHEN_TEXT_ITEM trigger ?
(A) => Yes
(B) => No
(C) => None
Answer =>> No
[79] Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
(A) => Yes
(B) => No
(C) => None
Answer =>> No
[80] What type of file is used for porting Forms 4.5 applications to various platforms ?
(A) => FMB file
(B) => FMX file
(C) => FMT file
Answer =>> FMT file
[81] What built_in procedure is used to get IMAGES in Forms 4.5 ?
(A) => READ_IMAGE_FILE
(B) => GET_IMAGE_FILE
(C) => READ_FILE
Answer =>> READ_IMAGE_FILE
[82] When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT ?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[83] Can we attach the same LOV to different fields in Design time ?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[84] How do you pass values from one form to another form ?
(A) => LOV
(B) => Parameters
(C) => Local variables
Answer =>> Parameters
[85] Can you copy the PROGRAM UNIT into an Object group ?
(A) => Yes
(B) => No
(C) => None
Answer =>> No
[86] Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[87] When is a .FMB file extension is created in Forms 4.5 ?
(A) => Generating form
(B) => Executing form
(C) => Save form
Answer =>> Save form
[88] What is a Built_in subprogram ?
(A) => Library
(B) => Stored procedure & Function
(C) => None of the above
Answer =>> None of the above
[89] What is a RADIO GROUP ?
(A) => Mutually exclusive
(B) => Select more than one column
(C) => Above all TRUE
Answer =>> Mutually exclusive
[90] Identify the Odd one of the following statements ?
(A) => Poplist
(B) => Tlist
(C) => List of values
Answer =>> List of values
[91] What is an ALERT ?
(A) => Modeless window
(B) => Modal window
(C) => Both are TRUE
Answer =>> Modal window
[92] Can we create an LOV without an RECORD GROUP ?
(A) => Yes
(B) => No
(C) => None
Answer =>> No
[93] How many no of columns can a RECORD GROUP have ?
(A) => 10
(B) => 20
(C) => None of the above
Answer =>> None of the above
[94] Oracle precompiler translates the EMBEDDED SQL statemens into
(A) => Oracle FORMS
(B) => Oracle REPORTS
(C) => None of the above
Answer =>> None of the above
[95] Kind of COMMENT statements placed within SQL statements ?
(A) => Asterisk(*) in column ?
(B) => ANSI SQL style statements(?)
(C) => All the above
Answer =>> All the above
[96] What is the appropriate destination type to send the output to a printer ?
(A) => Screen
(B) => Previewer
(C) => None of the above
Answer =>> None of the above
[97] What is TERM ?
(A) => TERM is the terminal definition file that describes the terminal from which you are using R20RUN ( Reports run time )
(B) => TERM is the terminal definition file that describes the terminal from which you are using R20DES ( Reports designer )
(C) => There is no Parameter called TERM in Reports 2.0
Answer =>> TERM is the terminal definition file that describes the terminal from which you are using R20RUN ( Reports run time )
[98] If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated
(A) => Only for 10 records
(B) => For all the records retrieved
(C) => For all therecords in the referenced table
Answer =>> Only for 10 records
[99] With which function of a summary item in the COMPUTE AT optio required ?
(A) => Sum
(B) => Standard deviation
(C) => % of Total function
Answer =>> % of Total function
[100] For a field in a repeating frame, can the source come from a column which does not exist in the datagroup which forms the base of the frame ?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[101] What are the different file extensions that are created by Oracle Reports ?
(A) => . RDF file & .RPX file
(B) => . RDX file & .RDF file
(C) => . REP file & .RDF file
Answer =>> . REP file & .RDF file
[102] Is it possible to Disable the Parameter form while running the report?
(A) => Yes
(B) => No
(C) => None
Answer =>> Yes
[103] What are the SQL clauses supported in the link property sheet ?
(A) => WHERE & START WITH
(B) => WHERE & HAVING
(C) => WHERE, START WITH & HAVING
Answer =>> WHERE, START WITH & HAVING
[104] What are the types of Calculated columns available ?
(A) => Summary, Place holder & Procedure column
(B) => Procedure, Formula & Place holder columns
(C) => Summary, Formula & Place holder columns
Answer =>> Summary, Formula & Place holder columns
[105] If two groups are not linked in the data model editor, what is the hierarchy between them?
(A) => There is no hierarchy between unlinked groups
(B) => The group that is right ranks higher than the group that is to theleft
(C) => The group that is above or leftmost ranks higher than the group that is to right or below it
Answer =>> The group that is above or leftmost ranks higher than the group that is to right or below it
[106] Sequence of events takes place while starting a Database is
(A) => Database opened, File mounted, Instance started
(B) => Instance started, Database mounted & Database opened
(C) => Database opened, Instance started & file mounted
Answer =>> Instance started, Database mounted & Database opened
[107] SYSTEM TABLESPACE can be made off-line
(A) => Yes
(B) => No
(C) => None
Answer =>> No
[108] ENQUEUE_RESOURCES parameter information is derived from
(A) => PROCESS or DDL_LOCKS & DML_LOCKS
(B) => LOG BUFFER
(C) => DB_BLOCK_SIZE
Answer =>> PROCESS or DDL_LOCKS & DML_LOCKS
[109] SMON process is used to write into LOG files
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[110] EXP command is used
(A) => To take Backup of the Oracle Database
(B) => To import data from the exported dump file
(C) => To create Rollback segments
Answer =>> To take Backup of the Oracle Database
[111] SNAPSHOTS cannot be refreshed automatically
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[112] The User can set Archive file name formats
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> TRUE
[113] The following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESS
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[114] NOARCHIEVELOG parameter is used to enable the database in Archieve mode
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[115] Constraints cannot be exported through Export command?
(A) => TRUE
(B) => FALSE
(C) => None
Answer =>> FALSE
[116] It is very difficult to grant and manage common priveleges needed by different groups of database users using roles
(A) => FALSE
(B) => TRUE
(C) => None
Answer =>> FALSE
[117] The status of the Rollback segment can be viewed through
(A) => DBA_SEGMENTS
(B) => DBA_ROLES
(C) => DBA_ROLLBACK_SEG
Answer =>> DBA_ROLLBACK_SEG
[118] Explicitly we can assign transaction to a rollback segment
(A) => FALSE
(B) => TRUE
(C) => None
Answer =>> TRUE
[119] What file is read by ODBC to load drivers ?
(A) => ODBC.INI
(B) => ODBC.DLL
(C) => ODBCDRV.INI
Answer =>> ODBC.INI