Q: What is Cross Outer Join? A: Cross outer join returns the number of rows in the first table multiplied by a number of rows in the second table. Syntax: Select * from TableName1 cross join TableName2 ; #innerandouterjoin

What is normalization and its structural point of view? It is the tool to validate a logically designed data to satisfy certain constraints that minimizes data redundancy& anomalies. In the general structural point of view of NFs, higher NF are better than lower NF #normalization

Q: What is COUNT() function in SQL? A: SQL COUNT() which is the database function that returns the number of rows SELECT COUNT(aggregate_expression) FROM tables [WHERE conditions]; #functionandjoin

Q: What is SELECT statement in Oracle database and its general syntax? A: SELECT statement is used for queries of data in single or multiple tables. The SELECT statement syntax for Oracle database is this: SELECT expressions FROM tables [WHERE conditions]; #sqlSELECT

Q: What is how can a table be considered as a relation in relational database? A: For a table to be qualified as a relation, then it must have a unique name, its attributes should be atomic, and the order of the columns and rows must be irrelevant. #relationalmodel

Q: What are the subtype discriminators? A: Disjoint and Overlapping. Disjoint is used for a simple attribute with different possible values indicating the subtype. Overlapping is used for a composite attribute having a boolean value to determine each subtype #eerd

Q: What is the difference between Simple and Composite attributes in ERD? A:Simple attribute: Attribute that cannot be subdivided. E.g. Student ID Composite attribute: Attribute that can be subdivided to yield additional attributes. E.g. Student Name(Last,First,Middle) #erd

Q: What and how to use the UPDATE statement in Oracle SQL? A: UPDATE statement modifies the data in an existing row. You can use this by following this syntax UPDATE table SET column_n = expression_n [WHERE conditions] #basicsql

Q: What and how to use the UPDATE statement in Oracle SQL? A: UPDATE statement modifies the data in an existing row. You can use this by following this syntax UPDATE table SET column1 = expression1, column2 = expression2, ... column_n = expression_n [WHERE conditions]

Q: What is Data Dictionary in SQL database? A: It stores collection of names, definitions, and attributes about data elements that are being used or captured in a database. It provides a centralized place for metadata about data elements. #basicSQL

Q: What is relational model in database? A: Relational model represents how data is stored in relational databases. It is structural independent where it is promoted using independent tables. This improves implementation and management simplicity. #datamodels

Q: Is there a difference between Database and Database Management System? A: Yes. Database is any collection of data, while DBMS is a piece of software that manages databases and lets you create, edit and delete databases, their tables and their data. #databaseConcepts

Q: Disadvantages of file management system? A: Data Redundancy Data Inconsistency Limited Data Sharing Integrity Problems Security Problems #databaseConcepts

Q: Why well-designed database is really important? A: Properly designed database are easy to maintain, improves data consistency and are cost effective in terms of disk storage space. #databaseConcepts

#oracleAPEX has a latest tutorial on how to build a working application for managing projects and tasks using some of the latest features of Oracle Application Express. #databaseConcepts

I'm excited to learn how to convert applications from Oracle Forms to Oracle Application Express. I bet it is much easier and user-friendly. #oracleAPEX #databaseConcepts

The latest version of APEX totally rocks. I suggest you read the documentation of latest oracle APEX because it has important information including configuration requirements, new features, changed behavior, deprecated and de-supported features, open bugs, known issues and more.

Q: What is the difference between data and information? A: Information is a processed, organised data presented in a given context while data is just an individual unit that contains raw fact material which does not carry any specific meaning. #databaseConcept

I love fiesta 💦💦💦

No classes 😂