18 Jul by Leondre Morris

Making Read-Only Tables- Tables and Constraints

You can place individual tables in read-only mode. Doing so prevents any INSERT, UPDATE, or DELETE statements from running against a table. An alternate way to do this is to make the tablespace read-only and use this tablespace for the tables that are static for read-only.There are several reasons why you may require the read-only […]

Managing Default Users Oracle Certification

18 Apr by Leondre Morris

Creating a Heap-Organized Table- Tables and Constraints

To create a heap-organized table, you use the CREATE TABLE statement and data types and lengths associated with the columns. The Oracle default table type is heap organized. The term heap means that the data are not stored in a specific order in the table; instead, they are a heap of data. If you do […]

Managing Default Users NVARCHAR2 and NCHAR Oracle Certification

18 Dec by Leondre Morris

Character- Tables and Constraints

Use a character data type to store characters and string data. The following character data types are available in Oracle:• VARCHAR2• CHAR• NVARCHAR2 and NCHAR VARCHAR The VARCHAR2 data type is what you should use in most scenarios to hold character/ string data. A VARCHAR2 allocates space based only on the number or characters in […]

Managing Default Users Marking Architectural Decisions Oracle Certification

18 Aug by Leondre Morris

Dropping Users- Users and Basic Security

Before you drop a user, it is recommended that you first lock the user. Locking the user prevents others from connecting to a locked database account. This allows you to better determine whether someone is using the account before it is dropped. Here is an example of locking a user: Any user or application attempting […]

Dropping Users Making Read-Only Tables Managing Default Users Oracle Certification

18 May by Leondre Morris

Assigning Default Permanent and Temporary Tablespaces- Users and Basic Security

Ensuring that users have a correct default permanent tablespace and temporary tablespace helps prevent issues of inadvertently filling up the SYSTEM or SYSAUX tablespaces, which could cause the database to become unavailable as well as create performance problems. The USERS tablespace is normally the default tablespace. When maintaining a database, you should verify the default […]

Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions Oracle Certification

18 Apr by Leondre Morris

Understanding Schemas vs. Users- Users and Basic Security

A schema is a collection of database objects (such as tables and indexes). A user is an account to connect to the database with the username and password. Users can also own objects, which then the owner is the schema of the objects. Already discussed was how there are default schemas created to own database […]

Dropping Users Making Read-Only Tables Managing Default Users Marking Architectural Decisions NVARCHAR2 and NCHAR Oracle Certification

18 Mar by Leondre Morris

Configuring a Centrally Managed User- Users and Basic Security

A centrally managed user is considered to be a user in one place, such as Active Directory or another LDAP service. The user can be managed for authentication and authorizations centrally, such that a user in Active Directory will have authentication managed via password or another type of key and, with the use of security […]

Managing Default Users Oracle Certification

18 Dec by Leondre Morris

Managing Default Users- Users and Basic Security

When you create a database, there are default users such as SYS and SYSTEM, and the passwords are set when the database is created. The passwords can be changed and managed with security policies.Here is the list of the administrative user accounts:• SYS• SYSTEM• SYSBACKUP• SYSDG• SYSKM• SYSRAC Administrative accounts have special permissions required to […]

Dropping Users Managing Default Users Oracle Certification

18 Aug by Leondre Morris

Setting the Archive Redo File Locations- Managing Control Files, Online Redo Logs,and Archivelogs

Before you set your database mode to archiving, you should specifically instruct Oracle where you want the archive redo logs to be placed. You can set the archive redo log file destination with the following techniques: • Set the LOG_ARCHIVE_DEST_N database initialization parameter. • Implement FRA. These two approaches are discussed in detail in the […]

Making Read-Only Tables Managing Default Users Oracle Certification