Database - Oracle - Oracle

DCL stands for

A.  Data Control Language

B.  Data Console Language

C.  Data Console Level

D.  Data Control Level

View Answer  

TCL stands for

A.  Transaction control languages

B.  Transaction command languages

C.  Transaction connect languages

D.  None of the Mentioned

View Answer  

What file is read by ODBC to load drivers ?

A.  ODBC.INI

B.  ODBC.DLL

C.  ODBCDRV.INI

D.  None of the above

View Answer  

_________commands in SQL allow controlling access to data within database.

A.  Database

B.  Database

C.  Data

D.  Data control

E.  All of the Mentioned

View Answer  

Explicitly we can assign transaction to a rollback segment 

A.  TRUE

B.  FALSE

C.  

D.  

View Answer  

In an SQL statement, which of the following parts states the conditions for row selection?

A.  Where

B.  From

C.  Order By

D.  Group By

View Answer  

A transaction completes its execution is said to be

A.  Committed

B.  Aborted

C.  Rolled back

D.  Failed

View Answer  

The status of the Rollback segment can be viewed through

A.  DBA_SEGMENTS

B.  DBA_ROLES

C.  DBA_FREE_SPACES

D.  DBA_ROLLBACK_SEG

View Answer  

Which of the following keyword is used with Data Control Language (DCL) statements?

A.  SELECT

B.  INSERT

C.  DELETE

D.  GRANT

View Answer  

It is very difficult to grant and manage common priveleges needed by different groups of database users using roles.

A.  TRUE

B.  FALSE

C.  

D.  

View Answer  

DCL Provides Commands To Perform Actions Like _____________

A.  Change The Structure Of Tables

B.  Insert, Update Or Delete Records And Data Values

C.  Authorizing Access And Other Control Over Database

D.  None of the Mentioned

View Answer  

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

D.  Both are FALSE

View Answer  

What is SQL * FORMS ?

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

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

C.  SQL * FORMS is a reporting tool

D.  None of the Mentioned

View Answer  

What does DLL stand for ?

A.  Dynamic Link Library

B.  Dynamic Language Library

C.  Dynamic Load Library

D.  None of the Mentioned

View Answer  

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

D.  None of the above

View Answer  

Multiple Tablespaces can share a single datafile

A.  true

B.  false

C.  

D.  

View Answer  

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

A.  Data Definition Language(DDL)

B.  Data Manipulation Language(DML)

C.  DML and DDL

D.  None of the Mentioned

View Answer  

Which of the following 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

D.  Both 1 & 2 are FALSE

View Answer  

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_RECORD

C.  SYSTEM.CURSOR_FIELD

D.  SYSTEM.LAST_QUERY

View Answer  

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

D.  Both 1 and 2 are FALSE

View Answer  

POST-BLOCK trigger is also a ?

A.  Navigational Trigger

B.  Key Trigger

C.  Transaction Trigger

D.  All of the Mentioned

View Answer  

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 

D.  None of the above 

View Answer  

In Oracle, which of the following package procedure is UNRESTRICTED ?

A.  CALL_INPUT

B.  CLEAR_BLOCK

C.  EXECUTE_QUERY

D.  USER_EXIT

View Answer  

LGWR process writes information into

A.  Database files

B.  Control files

C.  Redolog files

D.  All the above

View Answer  

What is the full form of SQL?

A.  Structured Query Language

B.  Structured Query List

C.  Simple Query Language

D.  None of the Mentioned

View Answer  

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.

D.  Only blocks. 

View Answer  

In SQL, which command is used to SELECT only one copy of each set of duplicable rows

A.  SELECT DISTINCT

B.  SELECT UNIQUE

C.  SELECT DIFFERENT

D.  All of the Mentioned

View Answer  

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

D.  None of the above

View Answer  

Which of the following is/are the DDL statements?

A.  Create

B.  Drop

C.  Alter

D.  All of the Mentioned

View Answer  

What are the SQL clauses supported in the link property sheet ?

A.  WHERE & START WITH

B.  WHERE & HAVING

C.  START WITH & HAVING

D.  WHERE, START WITH & HAVING

View Answer