Datadictionary can span across multiple Tablespaces
TRUE
FALSE
GET_BLOCK property is a
Restricted procedure
Unrestricted procedure
Library function
None of the above
SNAPSHOTS cannot be refreshed automatically
true
false
With which function of a summary item in the COMPUTE AT optio required ?
Sum
Standard deviation
Variance
% of Total function
Can we attach the same LOV to different fields in Design time ?
Yes
No
When do you get a .PLL extension ?
Save Library file
Generate Library file
Run Library file
It is very difficult to grant and manage common priveleges needed by different groups of database users using roles.
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
A Transaction ends
Only when it is Committed
Only when it is Rolledback
When it is Committed or Rolledback
When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT ?
Is it possible to Enable or Disable a Database trigger ?
The language used application programs to request data from the DBMS is referred to as __________
DML
DDL
Query language
All of the Mentioned
Which command is used for removing a table and all its data from the database:
Create command
Drop table command
Alter table command
A CONTROL BLOCK can sometimes refer to a BASETABLE ?
What is the maximum size of the page ?
Characters wide & 265 characters length
Characters wide & 80 characters length
In SQL, which command is used to add new rows to a table?
Alter Table
Add row
Insert
Append
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
In Oracle, which of the following package procedure is UNRESTRICTED ?
CALL_INPUT
CLEAR_BLOCK
EXECUTE_QUERY
USER_EXIT
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
What is a Built_in subprogram ?
Library
Stored procedure & Function
Collection of Subprograms
A database trigger doesnot apply to data loaded before the definition of the trigger
EXP command is used
To take Backup of the Oracle Database
To import data from the exported dump file
To create Rollback segments
Which command defines its columns, integrity constraint in create table:
Which of the following keyword is used with Data Control Language (DCL) statements?
SELECT
INSERT
DELETE
GRANT
TRUNCATE statement in SQL is a
DML statement
DDL statement
DCL statement
TCL statement
In an SQL statement, which of the following parts states the conditions for row selection?
Where
From
Order By
Group By
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
SNAPSHOT is used for
Synonym
Table space
System server
Dynamic data replication
What is the appropriate destination type to send the output to a printer ?
Screen
Previewer
Either of the above
Which of the following is TRUE. 1 Host variables are declared anywhere in the program 2 Host variables are declared in the DECLARE section
Only 1 is TRUE
Only 2 is TRUE
Both 1 & 2are TRUE
Both are FALSE