What is a DATABLOCK
Set of Extents
Set of Segments
Smallest Database storage unit
None of the above
SNAPSHOT is used for
Dynamic data replication
Which command defines its columns, integrity constraint in create table:
Drop table command
Alter table command
All of the Mentioned
The system variable that records the select statement that SQL * FORMS most recently used to populate a block is __________
Which is not part of the Data Definiton Language ?
What does DLL stand for ?
Dynamic Link Library
Dynamic Language Library
Dynamic Load Library
None of the Mentioned
The Data Manipulation Language statements are
All of the above
The packaged procedure that makes data in form permanent in the Database is
It is very difficult to grant and manage common priveleges needed by different groups of database users using roles.
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
Data Definition Language(DDL)
Data Manipulation Language(DML)
DML and DDL
SYSTEM.EFFECTIVE.DATE varaible is
Read & Write
Identify the Odd one of the following statements ?
List of values
Identify the RESTRICTED packaged procedure from the following
Databases overall structure is maintained in a file called
Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
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
Which of the following is not correct about a View ?
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
What is the maximum size of the page ?
Characters wide & 265 characters length
Characters wide & 80 characters length
None of the above
The User can set Archive file name formats
What are the types of Calculated columns available ?
Summary, Place holder & Procedure column
Summary, Procedure & Formula columns
Procedure, Formula & Place holder columns
Summary, Formula & Place holder columns
Find the temperature in increasing order of all cities
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
Which of the following is not correct about User_Defined Exceptions ?
Must be declared
Must be raised explicitly
Raised automatically in response to an Oracle error
Find the ODD one out of the following
A transaction completes its execution is said to be
Which of the following keyword is used with Data Control Language (DCL) statements?
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.
Only 1 is TRUE
Only 2 is TRUE
Both 1 & 2 are TRUE
Both are FALSE
A column defined as PRIMARY KEY can have NULL's?
If the maximum records retrieved property of a query is set to 10, then a summary value will be calculated
Only for 10 records
For all the records retrieved
For all therecords in the referenced table
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A set of Dictionary tables are created
Once for the Entire Database
Every time a user is created
Every time a Tablespace is created
Is it possible to open a cursor which is in a Package in another procedure ?