In oracle, the following is used to declare the record.
function
Well Done. Your Answer is Correct Keep it Up!
procedure
1 and 2
package
Category: Oracle MCQs
Choose the RDBMS which supports full fledged client server application development
Choose the RDBMS which supports full fledged client server application development
Oracle 7.1
Well Done. Your Answer is Correct Keep it Up!
dBase V
FoxPro 2.1
Ingress
What SYSTEM VARIABLE is used to refer DATABASE TIME ?
What SYSTEM VARIABLE is used to refer DATABASE TIME ?
$$datetime$$
Well Done. Your Answer is Correct Keep it Up!
$$time$$
$$dbtime$$
All options are correct
Database management systems are intended to _____________
Database management systems are intended to _____________
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Eliminate data redundancy
Establish relationship among records in different files
Manage file access
Report generators are used to
Report generators are used to
Retrieve information from files and Answer queries
Well Done. Your Answer is Correct Keep it Up!
Store data input by a user
Retrieve information from files
All options are correct
To obtain the structure of an Oracle table, the command to use is:
To obtain the structure of an Oracle table, the command to use is:
DESCRIBE [TableName].
Well Done. Your Answer is Correct Keep it Up!
STRUCTURE [TableName].
DESCRIBE STRUCTURE [TableName].
DESC TABLE [TableName].
DCL Provides Commands To Perform Actions Like _____________
DCL Provides Commands To Perform Actions Like _____________
Authorizing Access And Other Control Over Database
Well Done. Your Answer is Correct Keep it Up!
Insert, Update Or Delete Records And Data Values
Change The Structure Of Tables
All options are correct
In an SQL statement, which of the following parts states the conditions for row selection?
In an SQL statement, which of the following parts states the conditions for row selection?
Where
Well Done. Your Answer is Correct Keep it Up!
Group-by
Order by
Having
A type of query that is placed within a WHERE or HAVING clause of another query is called
A type of query that is placed within a WHERE or HAVING clause of another query is called
Sub query
Well Done. Your Answer is Correct Keep it Up!
Master query
Super query
Multi-query
___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
Constraint
Well Done. Your Answer is Correct Keep it Up!
Column
Index
Trigger