OCP 1Z0-045 Short Notes: Exam passing tips

General high availability technologies in 10g

  • The ORDER BY clause sorts the records in ascending order and it comes last in the SELECT statement.
  • The Online redo log files and the operating system flat file are used to store a copy of a data dictionary.
  • RMAN can be used to take an incremental backup for tablespaces and data files.
  • The rman target/ command is used to maintain backup copies by connecting to the target database and returns the RMAN prompt to issue further backup commands.
  • The NLS_LANG parameter must be set to specify the language, territory, and character set used in an application.
  • CONFIGURE is an RMAN command that configures an RMAN environment.
  • CONFIGURE RETENTION POLICY CLEAR is a command that will configure the retention policy to the default of REDUNDANCY 1.
  • RMAN is used to migrate the database files from conventional file system storage to ASM storage.
  • The control file, target database catalog, and Recovery catalog are used to store the RMAN’s persistent settings.
  • The redo files are opened after executing the ALTER DATABASE OPEN command on a database when it is in MOUNT mode.
  • RMAN can be used to move database objects from a non-ASM disk location to an ASM disk group.
  • The V dynamic performance view includes the status, the location where the block change tracking file is stored, and the size in bytes of the file.
  • Continue reading “OCP 1Z0-045 Short Notes: Exam passing tips”

CompTIA EK0-002 Short notes: Exam Passing Tips

e-business Infrastructure

  • File Transfer Protocol (FTP) is an Internet service that helps in transferring files from one computer to another over the Internet.
  • Layer 2 Tunneling Protocol (L2TP) is a more secure version of Point-to-Point Tunneling Protocol (PPTP). It provides tunneling, address assignment, and authentication.
  • Virtual private network (VPN) uses a tunneling protocol to span public networks, such as the Internet, without security risk. VPN enables remote users to access corporate networks securely by using a tunneling protocol such as PPTP or L2TP.
  • TCP/IP is the primary protocol of the Internet.
  • SMTP uses port 25 by default.
  • Address Resolution Protocol (ARP) is a network maintenance protocol of the TCP/IP protocol suite. It is responsible for the resolution of IP addresses to media access control (MAC) addresses of a network interface card (NIC).
  • FTP uses port 20 and 21 by default.
  • MIME stands for Multipurpose Internet Mail Extensions. It is a standard for multi-part, multimedia electronic mail messages and World Wide Web hypertext documents on the Internet.
  • The TCP/IP protocol should be bound to the dial-up adapter for Internet access on a Windows 98 computer.
  • Continue reading “CompTIA EK0-002 Short notes: Exam Passing Tips”

OCA 1Z0-042 Short Notes: Exam passing tips

Oracle architecture

  • The size of the shared pool can be changed dynamically. The data dictionary cache of the shared pool holds the most recently accessed data dictionary information. The shared pool consists of a library cache and data dictionary cache.
  • Control file, redo log file, and data file are part of an Oracle database.
  • An SGA and Oracle background processes constitute an Oracle instance. An SGA is ended when an Oracle instance is shut down. Multiple users can share data in an SGA.
  • While making modifications in SPFILE, the instance should be in open and running state, whereas in the case of PFILE, the instance will have to be first shut down and restarted before making any modifications in it.
  • V is a dynamic performance view that is used to display the names and the location of all the control files.
  • Following is the correct sequence of the processes that occur when a database is opened:
    1. An initialization parameter file is read.
    2. Continue reading “OCA 1Z0-042 Short Notes: Exam passing tips”

OCP 1Z0-040 Short Notes: Exam passing tips

New Features of Oracle 10g, Oracle 10g Installation, Server Configuration, and Maintenance of the Software

  • Memory – 512MB, Temp space – 400MB of free space in the /tmp directory applicable for the Unix operating system, Swap space – 1GB or twice the amount of RAM, Free disk space – 1.5GB are the minimum hardware requirements to install Oracle 10g.
  • The Installation Type list box is used to decide the type of installation.
  • Oracle Management Agent (OMA) is a centralized administrative tool that is capable of administering the database server and an application server.
  • The location (/u01/app/oracle) will be considered as the base of Optimal Flexible Architecture (OFA).
  • The password file is used to authenticate the administrative tasks from remote locations.
  • An Oracle 10g client can be used to connect to an Oracle 8i or 9i database by using the following syntax:
    Continue reading “OCP 1Z0-040 Short Notes: Exam passing tips”

E-Commerce Architect Short Notes: Exam Passing Tips

Overview of Electronic Commerce

  • B2C and B2B are types of e-commerce.
  • B2C stands for business-to-consumer. B2C involves transactions conducted between businesses and consumers over the Internet. For example, placing an order for a book or a home appliance by a consumer to a business over the Internet.
  • B2B stands for business-to-business. B2B involves transactions conducted between businesses over the Internet. It is used to exchange products, services, or information between businesses. B2B is also known as e-biz.
  • The World Wide Web Consortium (W3C) is an international industry consortium that develops common standards for the World Wide Web to promote its evolution and interoperability.
  • E-commerce sites offer a wide access to existing markets. Moreover, they give new access to undiscovered markets. Online stores have many advantages over the traditional stores.
  • Continue reading “E-Commerce Architect Short Notes: Exam Passing Tips”