SKILL BENCHMARK
Oracle Database 12c Administrator Certified Associate: RDBMS Concepts Literacy (Beginner Level)
- 18m
- 18 questions
The RDBMS Concepts Literacy benchmark measures whether a learner has fundamental knowledge of RDBMS concepts such as theoretical and physical aspects of a relational database, and retrieving and restricting data. A learner who scores high on this benchmark demonstrates that they have the skills to write basic SQL queries to retrieve and perform basic analysis of the data.
Topics covered
- add rows to a table in the database by using the INSERT SQL statement
- change data in a table using the UPDATE statement
- change the definition of a table using the ALTER TABLE SQL command
- define the Data Manipulation Language in SQL
- describe general functions when working with data and how it pertains to NULL values
- describe the purpose of data models
- describe when to use the WHERE clause
- display the structure of a table using the SQL*Plus DESCRIBE command
- identify the different Oracle database data types used when creating a table
- join tables with the ON clause
- list the features and benefits of a relational database
- list the various types of joins
- recognize the rules and guidelines for constructing valid SQL statements in SQL Developer and SQL*Plus
- use SQL to query a database
- use the comparison operators in a WHERE clause in a SQL statement
- use the CREATE TABLE SQL command to create new tables in the database
- use the NATURAL JOIN clause
- use the ORDER BY clause to sort the data returned by a SQL statement
RECENTLY ADDED COURSES
Rating 4.6 of 255 users
(255)
Rating 4.7 of 42 users
(42)
