1 / 5

Decoding Database Concepts and SQL Statements

Explore the world of databases with a focus on hierarchical structures, organized information, and SQL statements. Identify different database types, acronyms, and evaluate SQL statements for accuracy. Understand the importance of good database information quality.

mikaia
Download Presentation

Decoding Database Concepts and SQL Statements

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. GOD is watching…

  2. A. Identify the following: It was a prominent network and hierarchical database. A collection of an organise information frompieces of data that are easily and quicklyaccessed. Kind of databasethat information isarranged in uniform format. Type of databasethatis a staticwherein data israrelymodified. It isdesigned to create, maintain, manipulate, modify and delete information in a relationaldatabase.

  3. B. What does the acronym stands for?1. RAM2. DBMS3. RDBMS4. SQL5. DDL

  4. C. Tell whether the SQL statement is TRUE or FALSE. Write Data is the statement is true, otherwise, write Base.1. SELECT column_name operator value WHERE column _name(s) FROM table_name2. SELECT * FROM <table1>3. SELECT * FROM Table1 WHERE CellNo = ‘123456789’4. SELECT DISTINCT Address FROM Table15. SELECT [Last Name], [First Name] FROM Table1

  5. D. Give 5 qualities of good database information and explain each in one sentence. (2 points each

More Related