Size of Tablespace can be increased by
Increasing the size of one of the Datafiles
Adding one or more Datafiles
Cannot be increased
None of the above
To obtain the structure of an Oracle table, the command to use is:
STRUCTURE [Table Name]
DESCRIBE [Table Name]
DESCRIBE STRUCTURE [Table Name]
DESC TABLE [Table Name]
SMON process is used to write into LOG files
Multiple Tablespaces can share a single datafile
Identify the RESTRICTED packaged procedure from the following
The language used application programs to request data from the DBMS is referred to as __________
All of the Mentioned
What are the different file extensions that are created by Oracle Reports ?
RDF file & .RPX file
RDX file & .RDF file
REP file & .RDF file
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
Constraints cannot be exported through Export command?
What is the full form of SQL?
Structured Query Language
Structured Query List
Simple Query Language
With which function of a summary item in the COMPUTE AT optio required ?
% of Total function
The three language components of a database management system (DBMS) like DDL, DCL, DML.
Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?
DDL and DCL
DCL and DML
________clause is an additional filter that is applied to the result.
What does a COMMIT statement do to a CURSOR
Open the Cursor
Fetch the Cursor
Close the Cursor
Datadictionary can span across multiple Tablespaces
A Database Procedure is stored in the Database
In compiled form
As source code
Both A & B
What SYSTEM VARIABLE is used to refer DATABASE TIME ?
ENQUEUE resources parameter information is derived from
Processes or DDL_LOCKS and DML_LOCKS
Stack is also called __________
First In First Out
Last In First Out
First In Last Out
First Come First Served
List of Values (LOV) supports
Single or Multi column
A FORM is madeup of which of the following objects
block, fields only.
blocks, fields, pages only.
blocks, fields, pages, triggers and form level procedures.
These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES
Which is not part of the Data Definiton Language ?
A set of Dictionary tables are created
Once for the Entire Database
Every time a user is created
Every time a Tablespace is created
POST-BLOCK trigger is also a ?
Is it possible to modify a Datatype of a column when column contains data ?
Transactions per rollback segment is derived from
We can create SNAPSHOTLOG for
Neither A nor B
Sequence of events takes place while starting a Database is
Database opened, File mounted, Instance started
Instance started, Database mounted & Database opened
Database opened, Instance started & file mounted
Files mounted, Instance started & Database opened
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