- Study guides, Class notes & Summaries

Looking for the best study guides, study notes and summaries about ? On this page you'll find 9 study documents about .

All 9 results

Sort by:

Exam (elaborations)

Oracle 12C SQL (ICT 3722) Exam with Questions and Verified Answers
-

-

-

75

May 2026

2025/2026

A+
It covers key domains which include; Constraints, Data Definition Language (DDL), Data Manipulation Language (DML), Subqueries, Joins and Set Operators. A database developer is creating a simple view in Oracle 12c to display employee names and salaries from the Employees table. Which SQL statement correctly creates a basic view? a. CREATE TABLE emp_view AS SELECT name, salary FROM employees b. CREATE VIEW emp_view AS SELECT name, salary FROM employees c. CREATE OR REPLACE TABLE emp_view AS ...
wangithiannaw
$20.99 More Info

Exam (elaborations)

Oracle 12C SQL (ICT 3722) Exam with Questions and Solutions
-

-

-

35

May 2026

2025/2026

A+
It covers key domains which include; Database Objects, Controlling User Access (DCL) and Advanced SQL Features (12c Specifics). Which statement best describes the primary purpose of a sequence in Oracle 12c SQL? a. To enforce referential integrity between tables b. To automatically generate unique numeric values c. To store temporary data during transactions d. To define relationships between primary and foreign keys Correct Answer: b Rationale: A sequence in Oracle 12c SQL is a database ...
wangithiannaw
$20.99 More Info

Exam (elaborations)

Oracle 12C SQL (ICT 3722) Exam with Questions and Answers
-

-

-

81

May 2026

2025/2026

A+
It covers key domains which include; Introduction to Relational Databases, Basic Data Retrieval (The SELECT Statement), Restricting and Sorting Data, Single-Row Functions and Aggregating Data Using Group Functions. A SQL developer is evaluating the following expression in an Oracle 12c SELECT statement: SELECT 1000 + 200 * 2 FROM dual; What will be the result of the expression? a) 2400 b) 1400 c) 2000 d) 1200 Correct Answer: b) 1400 Rationale: In Oracle SQL, multiplication has higher p...
wangithiannaw
$20.99 More Info

Exam (elaborations)

Oracle 12c SQL (ICT 3722) Exam Questions And Answers |Latest 2025 | Guaranteed Pass.
-

-

1

5

February 2025

2024/2025

A+
©THESTAR 2024/2025 ALL RIGHTS RESERVED 9:50PM. 1 Oracle 12c SQL (ICT 3722) Exam Questions And Answers |Latest 2025 | Guaranteed Pass. Intelligent Key or Natural Key - Answerwhen data that already exists for example a book's ISBN is used as a primary key. Surrogate Key or Artificial Key - Answerif there is no data that exists that could be used as a primary key, a system generated ID is used as a primary key Database Management System - AnswerIts functions of a DBMS 1)Data Storage 2...
TheStar
$10.99 More Info

Exam (elaborations)

Oracle 12c SQL (ICT 3722) Exam Questions And Answers (Guaranteed A+)
-

-

-

8

January 2025

2024/2025

A+
Oracle 12c SQL (ICT 3722) Exam Questions And Answers (Guaranteed A+) Intelligent Key or Natural Key - Answerwhen data that already exists for example a book's ISBN is used as a primary key. Surrogate Key or Artificial Key - Answerif there is no data that exists that could be used as a primary key, a system generated ID is used as a primary key Database Management System - AnswerIts functions of a DBMS 1)Data Storage 2)Security 3)Multiple User Access 4)Backups 5)Data Access Language...
Everly
$10.99 More Info

Package deal

THIS BUNDLE CONTAINS ICT3722 ASSIGNMENT SEMESTER 1 & 2 DATABASE PRACTICE WITH ANSWERS + SQL CODES ALL TOGETHER TO SUBMITTED ON 2 - 08 - 2021.
-

-

-

3

August 2021
THIS BUNDLE CONTAINS ICT3722 ASSIGNMENT SEMESTER 1 & 2 DATABASE PRACTICE WITH ANSWERS + SQL CODES ALL TOGETHER TO SUBMITTED ON 2 - 08 - 2021. HOW FRUSTRATING IF YOU MISS THIS OUT.
TopGradess
$26.99 More Info

Exam (elaborations)

SQL CODES FOR ICT 3722 ASSINGMENT
0.0

(1)

0.0

-

2

July 2021

2020/2021

A
CREATE TABLE BOOK ( Book_id NUMERIC(5) NOT NULL PRIMARY KEY, AuthId NUMERIC(5) , Types_id NUMERIC(5), Name VARCHAR(20), Page_count NUMERIC(5) ); CREATE TABLE AUTHOR ( AuthId NUMERIC (5) NOT NULL PRIMARY KEY, Name CHAR(15), Surname CHAR(20), ); CREATE TABLE STUDENT( Student_id NUMERIC(5) NOT NULL PRIMARY KEY, Name VARCHAR(20), Surname VARCHAR (20), Gender VARCHAR(20), Date_of_birth DATETIME
TopGradess
$10.99 More Info

Exam (elaborations)

ICT3722ANSWERS TUTORIALS LETTER
-

-

-

6

July 2021

2020/2021

A
Write an SQL code that will generate the following tables: 1.Book table. 2.Author table Question 2 (5 Marks) The tables below in Appendix A shows the contents of the tables that you have generated in Question 1, populate these tables with data as shown in the relevant table by doing the following: 1.Write the code that populates the Book table. Submit this code. (5) Populate the rest of the tables as in Appendix A. (Do not submit the code).
TopGradess
$5.99 More Info

Exam (elaborations)

ICT3722 ASSIGNMENT SEMESTER 1 &2 DATABASE PRACTICE WITH ANSWERS 100%CORRECT INCLUSIVE OF SQL CODES
4.0

(1)

4.0

1

6

July 2021

2020/2021

A
Question 1. Write an SQL code that will generate the following tables: (8mks) 1 Book table. CREATE TABLE BOOK ( Book_id NUMERIC(5) NOT NULL PRIMARY KEY, AuthId NUMERIC(5) , Types_id NUMERIC(5), Name VARCHAR(20), Page_count NUMERIC(5) ); 2.Author table. CREATE TABLE AUTHOR ( AuthId NUMBER(5) NOT NULL PRIMARY KEY, Name CHAR(15), Surname CHAR(20), ); Question 2 (5 Marks) The tables below in Appendix A shows the contents of the tables that you have generated in ...
TopGradess
$18.99 More Info