Name two files used for network connection to a database.
Answers were Sorted based on User's Feedback
Explain CREATE DATABASE syntax?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
How many memory layers are in the shared pool?
how can you schedule a job in database?
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.
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What are the steps you will take, if you are tasked with securing an SQL Server?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What authentication modes does sql server support? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
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)