Can we attach the same LOV to different fields in Design time ?
Yes
No
DCL Provides Commands To Perform Actions Like _____________
Change The Structure Of Tables
Insert, Update Or Delete Records And Data Values
Authorizing Access And Other Control Over Database
None of the Mentioned
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
DML
DDL and DCL
DCL and DML
The packaged procedure that makes data in form permanent in the Database is
Post
Post form
Commit form
None of the above
DCL stands for
Data Control Language
Data Console Language
Data Console Level
Data Control Level
Size of Tablespace can be increased by
Increasing the size of one of the Datafiles
Adding one or more Datafiles
Cannot be increased
A transaction completes its execution is said to be
Committed
Aborted
Rolled back
Failed
These following parameters are optional in init.ora parameter file DB_BLOCK_SIZE, PROCESSES
true
false
What does DLL stand for ?
Dynamic Link Library
Dynamic Language Library
Dynamic Load Library
What are the SQL clauses supported in the link property sheet ?
WHERE & START WITH
WHERE & HAVING
START WITH & HAVING
WHERE, START WITH & HAVING
Identify the RESTRICTED packaged procedure from the following
USER_EXIT
MESSAGE
BREAK
EXIT_FORM
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)
Which of the SQL statements is correct?
select fname and lname from users
select fname,lname from users
select fname,lname where fname = 'sam'
Databases overall structure is maintained in a file called
Redolog file
Data file
Control file
All of the above
The Data Manipulation Language statements are
INSERT
UPDATE
SELECT
In SQL, which command is used to add new rows to a table?
Alter Table
Add row
Insert
Append
Is it possible to use Transactional control statements in Database Triggers?
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
Is it possible to open a cursor which is in a Package in another procedure ?
Which of the following does not affect the size of the SGA
Database buffer
Redolog buffer
Stored procedure
Shared pool
Constraints cannot be exported through Export command?
A database trigger doesnot apply to data loaded before the definition of the trigger
A Database Language Concerned With The Definition Of The Whole Database Structure And Schema Is ________
DCL
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
Is it possible to Enable or Disable a Database trigger ?
Transactions per rollback segment is derived from
Db_Block_Buffers
Processes
Shared_Pool_Size
What is a RADIO GROUP ?
Mutually exclusive
Select more than one column
Above all TRUE
Above all FALSE
Multiple Tablespaces can share a single datafile
It is very difficult to grant and manage common priveleges needed by different groups of database users using roles.
TRUE
FALSE
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