Exam passing tips | uCertify.com

OCP 1Z0-047 Short Notes: Exam passing tips

Retrieving data using the SQL SELECT statement and using single row functions to customize the output

/*…*/ and — are used to put comments in an Oracle program.
The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
Name of a table cannot start with @ special character.
Knowing about the GROUP BY clause.

Using sub queries and set operators to solve queries, as well as DDL statements to create and manage tables

+ (unary), – (unary), *, /, ||, =, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN, NOT, AND, OR is the correct order of operators precedence.

Creating User Services

The identity object of the IIdentity interface is used during the authentication process, when a user’s identity is verified. It contains information about a user who is being validated, such as username and password.
The principal object of the IPrincipal interface is used during the authentication process, when the application determines the data that can be accessed by a user and code to be executed. It contains information about a user’s identity, such as username and password, as well as information about a user’s role, such as manager or associate.
The correct sequence of the classes of the System.Windows.Forms namespace in descending order is as follows:
1. Control
2. ScrollableControl
3. ContainerControl
4. Forms
The MinimumSize property of the Form class is used to get or set the minimum size up to which a form can be resized.

Creating User Services

The identity object that implements the IIdentity interface, is used during the authentication process, when a user’s identity is verified. It contains information about a user who is being validated, such as username and password.
The principal object that implements the IPrincipal interface, is used during the authentication process when the application determines the data that can be accessed by a user and the code to be executed. It contains information about a user’s identity, such as username and password, as well as information about a user’s role, such as manager or associate.
Setting the MinimizeBox property of a Windows form to false prevents the minimize button from being displayed in the caption bar of the form.

Creating and Managing Microsoft Windows(r) Services, Serviced Components, .NET Remoting Objects, and XML Web Services

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.