- Study guides, Class notes & Summaries

©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...

-

5 pages

Written in 2024/2025

Grade A+

TheStar

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 ...

-

75 pages

Written in 2025/2026

Grade A+

wangithiannaw

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...

-

81 pages

Written in 2025/2026

Grade A+

wangithiannaw

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 ...

-

35 pages

Written in 2025/2026

Grade A+

wangithiannaw

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...

-

8 pages

Written in 2024/2025

Grade A+

Everly

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.

-

3 items

TopGradess

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

0.0

(1)

2 pages

Written in 2020/2021

Grade A

TopGradess

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).

-

6 pages

Written in 2020/2021

Grade A

TopGradess

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 ...

4.0

(1)

6 pages

Written in 2020/2021

Grade A

TopGradess