Data Processing Practice Tests – Relational Models and Constraints in Database


Hello and Welcome to Data Processing Practice Tests - Relational Models and Constraints in Database

  1. You are to attempt 5 random objectives questions ONLY.
  2. Supply Your Full Name and Location in the text box below and begin immediately.
  3. You can attempt as many times as possible
  4. Your time starts NOW!


The following are examples of modern database systems EXCEPT ________

A. Microsoft Excel      B. Oracle      C. Microsoft SQL Server      D. MySQL


A column in a database table that is designed to maintain specific information about every record in the database table is known as _______

A. field       B. record      C. tables      D. SQL


The ______ constraint provides a default value for a column when none is specified

A. NOT NULL     B. DEFAULT      C. UNIQUE      D. none of the above


The SQL component that is used to create tables and establish relationships among tables is known as ______

A. Data Definition Language - DDL
B. Data Manipulation Language - DML
C. Data Control Language - DCL
D. Transaction Control Language - TCL


What is the full meaning of SQL?

A. Structural Query Language
B. Standard Query Language
C. Structured Query Language
D. Standardised Query Language


 



error: Content is protected !!