In Oracle, which of the following package procedure is UNRESTRICTED ?
USER_EXIT
Well Done. Your Answer is Correct Keep it Up!
EXECUTE_QUERY
CLEAR_BLOCK
CALL_INPUT
Category: Databases MCQs
Oracle server configuration is dedicated for
Oracle server configuration is dedicated for
One server process – One user process
Well Done. Your Answer is Correct Keep it Up!
Many server processes – One user process
One server process – Many user processes
Many server processes – Many user processes
What are the valid Oracle database schemas?
What are the valid Oracle database schemas?
Logical and Physical Schema
Well Done. Your Answer is Correct Keep it Up!
Physical Schema
Logical Schema
None of the options are correct
Map entities, attributes and relations in Oracle is represented by_________
Map entities, attributes and relations in Oracle is represented by_________
Logical Schema
Well Done. Your Answer is Correct Keep it Up!
Conceptual Schema
Physical Schema
All options are correct
The Oracle environment of database is called as ___________
The Oracle environment of database is called as ___________
Database Instances
Well Done. Your Answer is Correct Keep it Up!
Database Schema
Data Structure
All options are correct
Which is the smallest unit of storage in an Oracle database?
Which is the smallest unit of storage in an Oracle database?
Data Block
Well Done. Your Answer is Correct Keep it Up!
Segment
Extent
Data File
What is the use of extent in Oracle?
What is the use of extent in Oracle?
Minimize the amount of wasted (empty) storage
Well Done. Your Answer is Correct Keep it Up!
Stores user data within the database
Stores rollback information used when data must be rolled back
All options are correct
Which of the following components comprise an Oracle architecture?
Which of the following components comprise an Oracle architecture?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Database related background processes
Tablespaces
Datafiles
Which processes is an instance made of Oracle?
Which processes is an instance made of Oracle?
Oracle background processes
Well Done. Your Answer is Correct Keep it Up!
Memory processes
Data processes
All options are correct
If you’re writing a client using the C language API, your source code should include the following line at the top:
If you’re writing a client using the C language API, your source code should include the following line at the top:
#include
Well Done. Your Answer is Correct Keep it Up!
use mysql;
include (“mysql.h”);
import com.mysql.*;