SKILL BENCHMARK

Oracle Database 12c Administrator Certified Associate: RDBMS Concepts Literacy

  • 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