IM101
Database Fundamentals Quiz
Test your knowledge on database concepts with our comprehensive quiz designed for students and professionals alike! Challenge yourself with carefully crafted questions covering various aspects of databases, from data models to SQL query language.
- Multiple choice questions
- Assess your understanding of database architecture
- Learn key terminology related to database management
The language for accessing and updating the data organized by the appropriate data model
DDL
DML
Database
SQL query language is nonprocedural.
True
False
A collection of interrelated data and a set of programs to access those data.
Database
DDL
Database Management System
The processing of data to draw conclusion, infer rule or decision procedures that are used to drive business decisions.
OLAP
Online transaction
Data Analytics
A database architecture that executes work on behalf of multiple client machines.
Client-Server
Web-Server
Application Server
It is a collection of operations that performs a single logical function in a database application
Transaction
Centralized databases
Instance
It is also known as query language
DDL
DML
It is the actual content of the database at a particular point in time.
Physical schema
Instance
Attribute
The primary mode of use for the vast majority of users of database applications
online transaction processing
business intelligence
Transaction
A collection of data, usually referred to as the database and contains information relevant to an enterprise.
DDL
Database
Database Management System
A database index provides pointers to those data items that hold a particular value.
True
False
Specification notation for defining the database schema
Logical Schema
Physical Schema
DDL
Some corporations are not valuable because of the information they own.
True
False
The architecture where the client machine acts as a front end and does not contain any direct database calls.
Three Tier
Fourth Tier
Two Tier
Data dictionary contains ______
Data
Words
Metadata
In the early days, database applications were built directly on top of file systems, which leads to: Data redundancy and inconsistency
True
False
A collection of tools for describing Data , Data relationships , Data semantics , Data constraints
Model
Data Model
Data Schema
All the data is stored in various tables.
Relational Model
Data Model
Data Schema
It is the overall logical structure of the database
Logical Schema
Physical Schema
Instance
It is the overall physical structure of the database
Logical Schema
Physical Schema
Instance
The ability to modify the physical schema without changing the logical schema
Physical Data Independence
Data Independence
Logical Data Independence
DDL compiler generates a set of table templates stored in a _____________
Dictionary
Word File
Data Dictionary
The only command in DDL
Create
Update
Delete
It is a class of language used for proving properties about computational power and for optimization
Commercial
Pure
Require a user to specify what data are needed and how to get those data.
Procedural DML
Declarative DML
Require a user to specify what data are needed without specifying how to get those data.
Procedural DML
Declarative DML
Declarative DMLs are usually easier to learn and use than are procedural DMLs.
True
False
The portion of a DML that involves information retrieval is called a query language.
True
False
SQL is NOT a Turing machine equivalent language
True
False
Are programs that are used to interact with the database in this fashion.
Software programs
Application Programs
Deciding on the database schema. Database design requires that we find a “good” collection of relation schemas
Logical Design
Physical Design
Deciding on the physical layout of the database
Logical Design
Physical Design
Translates DML statements in a query language into an evaluation plan consisting of low-level instructions that the query evaluation engine understands
DDL Interpreter
DML Compiler
The application resides at the client machine, where it invokes database system functionality at the server machine
Two Tier
Three Tier
The special value null is a member of every domain. Indicated that the value is “unknown”
True
False
Is a snapshot of the data in the database at a given instant in time.
Database Scheme
Database Instance
What are the Six basic operators of Relational Algebra?
Select,Project,Union,Set Difference,Cartesian Product,Rename
Select,Create,Update,Delete,Project,Rename
A unary operation that returns its argument relation, with certain attributes left out.
Project
Select
Create
It is the syntax for creating a table
CREATE (table name)
CREATE TABLE (table name)
MAKE (table name)
What happen if we use ALTER TABLE Employees ADD Email varchar(100);
Add attribute outside an entity employee, execute then do select from where
Add attribute inside an entity employee, execute then do select from where
What happen if we use ALTER TABLE employees DROP COLUMN Email;
Delete column inside an entity attributes
Delete row inside an entity attributes
What syntax is use to filter and select attributes in a table?
Select (attribute) from (table name);
Select (table name) from (attribute);
Syntax for displaying all records from one table
SELECT * FROM (table name);
SELECT / FROM (table name);
What happen if we use CREATE TABLE TestTable AS SELECT customername, contactname FROM customers;
Duplicate the table Customer
Add records in Customer
The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.
True
False
The ALTER TABLE statement is also used to add and drop various constraints on an existing table.
True
False
ALTER TABLE - ALTER/MODIFY COLUMN is use to change the data type of a column in a table, use the following syntax:
True
False
The PRIMARY KEY constraint uniquely identifies each record in a table.
True
False
A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).
True
False
Which of these operators selects only distinct values by default?
Union
Intersect
Union All
SQL command that will display all the records in MANAGERS table.
Select * from Managers;
Select ALL from Managers;
Which of the following functions can be used on both numeric as well as non-numeric data?
COUNT
MAX
MIN
Which clause is similar to “HAVING” clause in SQL?
WHERE
WHAT
What is returned by ROUND(789.8389, 2)?
789.83
789.84
In a column named "age", containing values 4, 5, 6, the SQL statement "SELECT SUM(age) FROM students;" will return,
14
15
16
Fill in the blanks . Be aware of the proper syntax. CREATE TABLE ITEM (ITEM_ID VARCHAR(10) NOT NULL UNIQUE, Product_Name VARCHAR(200), Unit_Price Numeric(8,2), PRIMARY KEY _____
(ITEM_ID) );
(ITEM_ID );
Fill in the blank with SQL command below if you want to delete the column named "Test" in the STAFF table: ALTER TABLE STAFF _____ Test;
Drop Table
Drop Column
Delete Column
What is returned by SUBSTR(‘BADET MACARAIG’, -1, 1)?
G
MACARAIG
B
SELECT column_name(s) FROM _____ _____ table2 ON _____.column_name = _____.column_name _____ condition;
Table1,full outer join,table1,table2
Table2,full outer join,table2,table1
Fill in the black with the correct JOIN clause to select all records from the two tables where there is a match in both tables. SELECT * FROM instructor _____ ON instructor.dept_name=department.dept_name;
Inner Join
Outer Join
Can you perform Inner Join in a table that doesn't have matching records?
True
False
RIGHT OUTER JOIN is equivalent to LEFT OUTER JOIN if order of tables are reversed
True
False
Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
Left outer join
Right outer join
A_____ is a query that retrieves rows from more than one table or view
Start
End
Join
Which of the following conditions has to be satisfied for INNER JOIN to work?
Columns used for joining must have same name
Columns used for joining can have same or different name
Columns used for joining must have different names
Which join is equivalent to Cartesian Product?
Inner join
Outer Join
Cross Join
Which of the join operations do not preserve non matched tuples.
Inner Join
Outer Join
Full Join
The____condition allows a general predicate over the relations being joined.
On
Where
Set
How many tables may be included with a join?
1
2
3
All of the above
{"name":"IM101", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge on database concepts with our comprehensive quiz designed for students and professionals alike! Challenge yourself with carefully crafted questions covering various aspects of databases, from data models to SQL query language.Multiple choice questionsAssess your understanding of database architectureLearn key terminology related to database management","img":"https:/images/course2.png"}