Provide an example of a shell script which logs into SQLPLUS
as SYS, determines the current date, changes the date format
to include minutes & seconds, issues a drop table command,
displays the date again, and finally exits.
No Answer is Posted For this Question
Be the First to Post Answer
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Give two examples of how you might determine the structure of the table DEPT.
how can you initialize log miner?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what r the types of backup?
How to start SQL Server in minimal configuration mode?
what is the purpose of catlaog in oracle rman?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How would you determine what sessions are connected and what resources they are waiting for?
What are the different ways you can create databases in sql server? : sql server DBA
You have just compiled a PL/SQL package but got errors, how would you view the errors?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Oracle (3259)
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)