General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   Sort: Rank

dba.FYIcenter.com Links
Collections: DBA Jobs Interview Questions DBA Articles Oracle Tutorials SQL Server Tutorials Transact-SQL Tutorials MySQL Tutorials Site Map Other Resources: Software QA Resources Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Regul... 2020-12-02, 1018👍, 0💬

Oracle Database Tutorials
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for Oracle DBAs and Oracle database application developers. Clear explanations and simple examples provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether yo... 2020-12-02, 9553👍, 1💬

💬 2017-07-10 sasi: Nice tutorial..

What Is a Database Schema in Oracle
What Is a Database Schema in Oracle? A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include: tables, views, ... 2020-11-22, 932👍, 0💬

Relations of a User Account and a Schema in Oracle
What Is the Relation of a User Account and a Schema in Oracle? User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) ... 2020-11-22, 897👍, 0💬

What Is a Table Index in Oracle
What Is a Table Index in Oracle? Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster acce... 2020-11-22, 842👍, 0💬

What Is a Database Table in Oracle
What Is a Database Table in Oracle? A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, such as employee_id, last_name, a... 2020-11-22, 838👍, 0💬

What Is a User Role in Oracle
What Is a User Role in Oracle? A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials 2020-11-22, 734👍, 0💬

Oracle Database Basic Concepts
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle database. Here is a list of frequently asked questions and their answers on Oracle basic concepts compiled by FYIcenter.com DBA team about Oracle database basic concepts: What Is Oracle in Oracle What Is... 2020-11-11, 1622👍, 0💬

What Is a Parameter File in Oracle
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation. Oracle supports the following two types of parameter f... 2020-11-11, 1395👍, 1💬

💬 2016-12-04 mm: mm

What Is Oracle in Oracle
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while deliver... 2020-11-11, 1206👍, 0💬

What Is an Oracle Instance in Oracle
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes.... 2020-11-11, 1104👍, 0💬

What Is an Oracle Database in Oracle
What Is an Oracle Database in Oracle? An Oracle database is a collection of data treated as a big unit in the database server.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials 2020-11-11, 977👍, 0💬

What Is an Oracle Tablespace in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. Each tablespace in an Oracle database consists of one or more files called dataf... 2020-10-26, 1017👍, 1💬

💬 2018-10-15 taj mure: Nicerere

What Is a Static Data Dictionary in Oracle
What Is a Static Data Dictionary in Oracle? Data dictionary tables are not directly accessible, but you can access information in them through data dictionary views. To list the data dictionary views available to you, query the view DICTIONARY. Many data dictionary tables have three corresponding vi... 2020-10-26, 868👍, 0💬

What Is an Oracle Data File in Oracle
What Is an Oracle Data File in Oracle? An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace.   ⇒Oracle Database Basic Concepts ⇒⇒Oracle Database Tutorials 2020-10-26, 844👍, 0💬

What Is a Dynamic Performance View in Oracle
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open an... 2020-10-26, 825👍, 1💬

💬 2019-10-16 Aninda: Best tutorial

What Is a Recycle Bin in Oracle
What Is a Recycle Bin in Oracle? Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle database recycle save the same purpose as the... 2020-10-26, 803👍, 0💬

Shutdown 10g XE Server in Oracle
How To Shutdown Your 10g XE Server in Oracle? If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server. Select OracleServiceXE, and use the right mouse click t... 2020-10-10, 989👍, 0💬

Start 10g XE Server from Command Line in Oracle
How To Start Your 10g XE Server from Command Line in Oracle? You can start your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StartDB.bat. The batch file StartDB.bat contains: net start OracleXETNSListener net... 2020-10-10, 792👍, 0💬

Shutdown 10g XE Server from Commmand Line in Oracle
How To Shutdown Your 10g XE Server from Command Line in Oracle? You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The batch file StopDB.bat contains: net stop OracleServiceXE   ⇒I... 2020-10-10, 733👍, 0💬

Start 10g XE Server in Oracle
How To Start Your 10g XE Server in Oracle? Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.   ⇒Introduction to Oracle Database 10g Express Edition ⇒⇒Oracle Database Tutorials 2020-10-10, 727👍, 0💬

Memory Usage of 10g XE Server in Oracle
How Much Memory Your 10g XE Server Is Using in Oracle? Your 10g XE Server is using about 180MB of memory even there is no users on the server. The server memory usage is displayed on your server home page, if you log in as SYSTEM.   ⇒Introduction to Oracle Database 10g Express Edition ⇒⇒Oracle Data... 2020-10-10, 715👍, 0💬

StartDB.bat Failed to Start the XE Instance in Oracle
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not be started. One good approach to start the default instance is... 2020-09-30, 1085👍, 0💬

Change Program Global Area (PGA) in Oracle
How To Change Program Global Area (PGA) in Oracle? Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. If you think your session will be short with a small amount o... 2020-09-30, 950👍, 0💬

1 2 3 4 5 6 … > >>   Sort: Rank

General MySQL Oracle SQL Server