Articles for Introduction to Oracle: SQL and PL/SQL 1Z0-001
How is top-n analysis performed?
Top-n analysis is performed using a top-n analysis query. Following is the structure of a top-n analysis query:
SELECT [column_list], ROWNUM
FROM (SELECT [column_list] FROM table
ORDER BY top-n_column)
WHERE ROWNUM <= n;
A top-n analysis query comprises the following elements:
A......
continue reading "How is top-n analysis performed?" »
Skills required for Oracle test 1Z0-001.
Oracle has specified more than twenty objectives for 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test. Following are some important areas over which one should have good command before taking the test:
Overview of relational databases, SQL, and PL/SQL.
Writing basic SQL statements.......
continue reading "Skills required for Oracle test 1Z0-001." »
Things to practice for Oracle test 1Z0-001.
One should have a good knowledge about RDBMS concepts, SQL, and PL/SQL before taking the 1Z0-001 (Introduction to Oracle: SQL and PL/SQL) test, as this test focuses on one's capability to design relational databases and write various types of SQL and PL/SQL statements to interact with databases.......
continue reading "Things to practice for Oracle test 1Z0-001." »
What is a constraint?
A constraint enforces the integrity of a database. It defines rules regarding the values allowed in the columns of a table. A constraint is the standard mechanism for enforcing integrity. Using constraints is preferred to using triggers, rules, and defaults. Most of the RDBMS databases support......
continue reading "What is a constraint?" »
What is a primary key?
A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This......
continue reading "What is a primary key?" »
What is a role?
A role is a named group of privileges such as object, system, and role privileges, which can be granted to a user or to another role. A user can be assigned several roles, and a single role can be granted to several users. A role is created using the CREATE ROLE statement.
Syntax:
CREATE......
continue reading "What is a role?" »
What is a trigger?
Trigger
A trigger is a kind of procedure that executes implicitly when a table or view is modified or some user actions or database system actions occur. Similar to a stored procedure, a trigger stored in the database can include SQL and PL/SQL or Java statements to run as a unit and can......
continue reading "What is a trigger?" »
What is DDL?
Data Definition Language (DDL) is a category of SQL statements that are used to define, alter, or delete database objects such as tables or views. Statements such as CREATE, ALTER, DROP, RENAME, TRUNCATE etc., are included in this category....
continue reading "What is DDL?" »
What is denormalization?
Denormalization is usually done to decrease the time required to execute complex queries. Drawbacks of a normalized database are mostly in performance. In a normalized database, more joins are required to gather all the information from multiple entities, as data is divided and stored in multiple......
continue reading "What is denormalization?" »
What is DML?
Data Manipulation Language (DML) is a category of SQL statements that query and update data in a database. Statements such as SELECT, UPDATE, INSERT, DELETE etc., are included in this category. These statements can be grouped with Data Control Language (DCL) statements. ...
continue reading "What is DML?" »
In Stock (
US$ 79.99 39.99
)
Download and try this PrepKit for free. As soon you place the order, we will send you the registration code. Use it to unlock the PrepKit and start learning. Its that easy!
1Z0-001 PrepKit at a Glance
| Includes | Free | Buy |
|---|---|---|
| Version | 8.01.05 | |
| Practice Tests | 1 | 4 |
| 45 | 300 | |
| Quiz | 15 | 100 |
| Final Test | No | Yes |
| Articles, How Tos.., Tips | Yes | Yes |
| Study Notes | 21 | 102 |
Tips and How Tos for 1Z0-001 exam
