A to Z Exams

  Cursor is a named Private SQL area

  Cursor holds temporary results

  Cursor is used for retrieving multiple rows

  SQL uses implicit Cursors to retrieve rows

  Update

  Insertion

  Deletion

  All of the Mentioned

  Only 1 is TRUE

  Only 2 is TRUE

  Both 1 & 2 are TRUE

  Both 1 & 2 are FALSE

  Yes

  No

  Db_Block_Buffers

  Processes

  Shared_Pool_Size

  None of the above

  STRUCTURE [Table Name]

  DESCRIBE [Table Name]

  DESCRIBE STRUCTURE [Table Name]

  DESC TABLE [Table Name]

  Must be declared

  Must be raised explicitly

  Raised automatically in response to an Oracle error

  None of the above

  DCL

  DML

  DDL

  All of the Mentioned

  Database

  Database

  Data

  Data control

  All of the Mentioned

  To take Backup of the Oracle Database

  To import data from the exported dump file

  To create Rollback segments

  None of the above

  Select

  Group-by

  Having

  Order by

  Navigational Trigger

  Key Trigger

  Transaction Trigger

  All of the Mentioned

  true

  false

  First In First Out

  Last In First Out

  First In Last Out

  First Come First Served

  To reduce network traffic.

  For application sharing

  To implement business rules centrally

  None of the above

  Save Library file

  Generate Library file

  Run Library file

  None of the above

  A piece of logic written in PL/SQL

  Executed at the arrival of a SQL*FORMS event

  Both A & B

  None of the above

  Stored procedure & Function

  Collection of Subprogram

  Collection of Packages

  None of the above

  SELECT city FROM weather ORDER BY temperature

  SELECT city, temperature FROM weather

  SELECT city, temperature FROM weather ORDER BY temperature

  SELECT city, temperature FROM weather ORDER BY city

  Can contain any no of columns

  Simulates a One-dimensional array of unlimited size

  Column datatype of any Scalar type

  None of the above

  true

  false

  Once for the Entire Database

  Every time a user is created

  Every time a Tablespace is created

  None of the above

  Increasing the size of one of the Datafiles

  Adding one or more Datafiles

  Cannot be increased

  None of the above

  Yes

  No

  Only 1 is TRUE

  Only 2 is TRUE

  Both 1 & 2are TRUE

  Both are FALSE

  Only for 10 records

  For all the records retrieved

  For all therecords in the referenced table

  None of the above 

  Yes

  No

  Single column

  Multi column

  Single or Multi column

  None of the above

  There is no hierarchy between unlinked groups

  The group that is right ranks higher than the group that is to theleft

  The group that is above or leftmost ranks higher than the group that is to right or below it

  None of the above

  SELECT

  INSERT

  DELETE

  GRANT

  Create command

  Drop table command

  Alter table command

  All of the Mentioned

  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

  Because the stored procedure occupies more space in the database than a integrity constraint definition

  Because a stored procedure creates more network traffic than a integrity constraint definition

  Yes

  No

  To protect some of the columns of a table from other users

  Ocuupies data storage space

  To hide complexity of a query

  To hide complexity of a calculations

  Where

  From

  Order By

  Group By

  DBA_SEGMENTS

  DBA_ROLES

  DBA_FREE_SPACES

  DBA_ROLLBACK_SEG

  Data Manipulation Language (DML)

  Data Definition Language (DDL)

  Data Control Language (DCL)

  Data Communication Language (DCL)

  Database files

  Control files

  Redolog files

  All the above

  Database opened, File mounted, Instance started

  Instance started, Database mounted & Database opened

  Database opened, Instance started & file mounted

  Files mounted, Instance started & Database opened

  Define, Create

  Drop, Comment

  Insert, Update, Delete

  All of the above

  INSERT

  UPDATE

  DELETE

  CREATE

  $$dbtime$$

  $$time$$

  $$datetime$$ 

  None of the above

  Master query

  Sub query

  Super query

  Multi-query

  Set of Extents

  Set of Segments

  Smallest Database storage unit

  None of the above

  true

  false

  Sequence of SQL or PL/SQL statements to perform specific function

  Stored in compiled form in the database

  Can be called from all client environmets

  All of the above

  CALL_INPUT

  CLEAR_BLOCK

  EXECUTE_QUERY

  USER_EXIT

  DDL

  DML

  DDL and DCL

  DCL and DML

  WHERE & START WITH

  WHERE & HAVING

  START WITH & HAVING

  WHERE, START WITH & HAVING

  true

  false

  Database buffer

  Redolog buffer

  Stored procedure

  Shared pool

  true

  false

  Restricted procedure

  Unrestricted procedure

  Library function

  None of the above

  SELECT DISTINCT

  SELECT UNIQUE

  SELECT DIFFERENT

  All of the Mentioned

  Committed

  Aborted

  Rolled back

  Failed

  Create command

  Drop table command

  Alter table command

  All of the Mentioned

  DML

  DDL

  Query language

  All of the Mentioned

  TRUE

  FALSE

  true

  false

  Transaction control languages

  Transaction command languages

  Transaction connect languages

  None of the Mentioned

  true

  false

  true

  false

  Column

  Constraint

  Index

  Trigger

  Data Definition Language(DDL)

  Data Manipulation Language(DML)

  DML and DDL

  None of the Mentioned

  Mutually exclusive

  Select more than one column

  Above all TRUE

  Above all FALSE

  Library

  Stored procedure & Function

  Collection of Subprograms

  None of the above

  CREATE

  ALTER

  ALTER SESSION

  Characters wide & 265 characters length

  Characters wide & 265 characters length

  Characters wide & 80 characters length 

  None of the above 

  Change The Structure Of Tables

  Insert, Update Or Delete Records And Data Values

  Authorizing Access And Other Control Over Database

  None of the Mentioned

  Create

  Drop

  Alter

  All of the Mentioned

  Yes

  No

  Screen

  Previewer

  Either of the above

  None of the above

  Structured Query Language

  Structured Query List

  Simple Query Language

  None of the Mentioned

  Boolean 

  Number 

  Character 

  None of the above

  Insert

  Modify

  Look-up

  All of the Mentioned

  OPEN

  CLOSE

  INSERT

  FETCH

  SYSTEM.LAST_RECORD

  SYSTEM.CURSOR_RECORD

  SYSTEM.CURSOR_FIELD

  SYSTEM.LAST_QUERY

  Redolog file

  Data file

  Control file

  All of the above

  DML statement

  DDL statement

  DCL statement

  TCL statement

  Alter Table

  Add row

  Insert

  Append

  TRUE

  FALSE

  true

  false

  select fname and lname from users

  select fname,lname from users 

  select fname,lname where fname = 'sam'

  None of the Mentioned

  SQL * FORMS is a 4GL tool for developing and executing Oracle based interactive based application

  SQL * FORMS is a 3GL tool for connecting to a Database

  SQL * FORMS is a reporting tool

  None of the Mentioned

  DCL

  DML

  DDL

  All of the Mentioned

  Simple snapshots

  Complex snapshots

  Both A & B

  Neither A nor B

  SELECT SYSDATE – SYSDATE FROM DUAL;

  SELECT SYSDATE – (SYSDATE – 2) FROM DUAL;

  SELECT SYSDATE – (SYSDATE + 2) FROM DUAL;

  None of the Mentioned

  USER_EXIT

  MESSAGE

  BREAK

  EXIT_FORM

  Processes or DDL_LOCKS and DML_LOCKS 

  LOG_BUFFER 

  DB__BLOCK_SIZE 

  Can be assigned to a global variable

  Can be assigned to any field only during design time

  Can be assigned to any variable or field during run time

  None of the above

  TRUNCATE command

  Create command

  Drop table command

  Alter table command

  TRUE

  FALSE

  Yes

  No

  RDF file & .RPX file

  RDX file & .RDF file

  REP file & .RDF file

  None of the above

  Only 1 is TRUE

  Only 2 is TRUE

  Both 1 & 2 are TRUE

  Both are FALSE

  true

  false

  Yes

  No

  Poplist

  Tlist

  List of values

  Combo box

  block, fields only.

  blocks, fields, pages only.

  blocks, fields, pages, triggers and form level procedures.

  Only blocks. 

  Read only

  Read & Write

  Write only

  None of the above