What are the different file extensions that are created by
Oracle ?
Answers were Sorted based on User's Feedback
Answer / chandan
SQL*Plus files
.sql - scripting language
PL/SQL files
.pls - PL/SQL source
.plb - PL/SQL binary
.pks - Package source or package specification
.pkb - Package binary or package body
.pck - Combined package specification plus body
Oracle database files
.dbf - database file
.log - Redo Log
.arc - Archive log
SQL*Net files
.ora -
tnsnames.ora
sqlnet.ora
SQL*Loader files
.ctl - Control file
.dat - Data file
.bad - Bad file
.dsc - Discard file
Forms files
.fmb - Forms binary
.fmt - Forms text
.fmx - Forms executable
Reports files
.rdf
.rep
.rex
| Is This Answer Correct ? | 2 Yes | 1 No |
Define cursor.
What is meant by system analysis?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode ?
What is the purpose of queries in a database?
What is end users in dbms?
Can you explain insert, update and delete query?
What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?
Explain a checkpoint and when does it occur?
What is a SQL * NET?
What is a join in the sql?
Which database is faster?
write a query to retrieve the last day of next month in oracle.
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)