A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
DCL
DML
DDL
All of the Mentioned
The status of the Rollback segment can be viewed through
DBA_SEGMENTS
DBA_ROLES
DBA_FREE_SPACES
DBA_ROLLBACK_SEG
If two groups are not linked in the data model editor, what is the hierarchy between them?
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
Which of the following is not correct about the |TABLE| datatype ?
Can contain any no of columns
Simulates a One-dimensional array of unlimited size
Column datatype of any Scalar type
A Stored Procedure is a
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
TRUNCATE statement in SQL is a
DML statement
DDL statement
DCL statement
TCL statement
SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Tablespace
true
false
A set of Dictionary tables are created
Once for the Entire Database
Every time a user is created
Every time a Tablespace is created
What is SQL * FORMS ?
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
What is a Built_in subprogram ?
Library
Stored procedure & Function
Collection of Subprograms
These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES
What is the maximum size of the page ?
Characters wide & 265 characters length
Characters wide & 80 characters length
POST-BLOCK trigger is also a ?
Navigational Trigger
Key Trigger
Transaction Trigger
Which of the following is not included in DML (Data Manipulation Language)
INSERT
UPDATE
DELETE
CREATE
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
Yes
No
SNAPSHOTS cannot be refreshed automatically
_________commands in SQL allow controlling access to data within database.
Database
Data
Data control
GET_BLOCK property is a
Restricted procedure
Unrestricted procedure
Library function
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
Only 1 is TRUE
Only 2 is TRUE
Both 1 and 2 are TRUE
Both 1 and 2 are FALSE
What does a COMMIT statement do to a CURSOR
Open the Cursor
Fetch the Cursor
Close the Cursor
Identify the RESTRICTED packaged procedure from the following
USER_EXIT
MESSAGE
BREAK
EXIT_FORM
Is it possible to use Transactional control statements in Database Triggers?
The language used application programs to request data from the DBMS is referred to as __________
Query language
When do you get a .PLL extension ?
Save Library file
Generate Library file
Run Library file
The User can set Archive file name formats
TRUE
FALSE
Which of the following is not a type of SQL statement?
Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Control Language (DCL)
Data Communication Language (DCL)
In Oracle, which of the following package procedure is UNRESTRICTED ?
CALL_INPUT
CLEAR_BLOCK
EXECUTE_QUERY
SYSTEM.EFFECTIVE.DATE varaible is
Read only
Read & Write
Write only
Can we pass RECORD GROUP between FORMS ?
Is it possible to open a cursor which is in a Package in another procedure ?