أهداء إلى احلى فريق
MTA Team Sohag
From : Maysa Hassan
WHERE
THAT
GROUP BY
HAVING
Rate this question:
Select
Output
Read
Get
Rate this question:
Primary
Local
Superkey
Foreign
Candidate
Rate this question:
All columns
Only the last column
Only the first column
Only the first and last columns
Rate this question:
Primary
foreign
Local
Superkey
Rate this question:
DROP TABLE
DELETE TABLE
REMOVE TABLE
UPDATE TABLE
Rate this question:
No change is needed
Composite keys
Duplicate rows
Foreign keys
Rate this question:
Data type
Format
Key
Validator
Rate this question:
Denormalization
Fragmentation
Normalization
Defragmentation
Rate this question:
Option A
Option B
Option C
Option D
Rate this question:
1
2
3
4
Rate this question:
0
2
3
6
Rate this question:
0
1
2
3
4
Rate this question:
Stored procedure
Formula
Subroutine
Method
Rate this question:
Option A
Option B
Option C
Option D
Rate this question:
SET Product Name = 'glass'
LET Product Name = 'glass'
EXEC ProductName = 'glass'
ASSIGN ProductName = 'glass'
Rate this question:
EXECUTE
ALLOW
CALL
RUN
Rate this question:
4
5
6
7
An error stating that NULL values are not allowed
A new row in the table
An error stating that duplicate IDs are not allowed
A syntax error
Rate this question:
WHERE
UNION
ORDER BY
FROM
Rate this question:
DELETE VIEW EmployeeView
DELETE EmployeeView
DROP EmployeeView
DROP VIEW EmployeeView
Rate this question:
No Change is needed
Zero
Three
Six
Rate this question:
B. Limit access to specific rows or columns of data in a table.
Save an extra copy of data stored in a separate table.
C. Ensure referential integrity.
Save historical data before deleting it from the base table
Rate this question:
Stored procedure
Trigger
Data dictionary
View
Rate this question:
User to a database.
Row of data to a table.
Table to a database.
Column to a table definition.
Rate this question:
Option A
Option B
Option C
Option D
Rate this question:
Option A
Option B
Option C
Option E
Option D
Rate this question:
Option A
Option B
Option C
Option D
Option A
Option B
Option C
Option D
Rate this question:
Must return a value
Must be called from a trigger
Cannot contain a transaction .
Cannot accept parameters
Rate this question:
Name
A data type
An index
A key
Rate this question:
PRIMARY KEY
SEQUENTIAL
FOREIGN KEY
DISTINCT
Rate this question:
Insert
Commit
Delete
Output
Update
Rate this question:
UPDATE Volunteer SET given name = ' Kimberly' WHERE given name = ' Tia'
SET Volunteer TO given name = ' Kimberly' where given name = ' Tia'
UPDATE given name = ' Kimberly' From Volunteer WHERE given name = ' Tia'
SET given name = ' Kimberly' From Volunteer where given name = ' Tia'
Rate this question:
The var char data type contains only numeric characters
The numeric data type contains only numbers that have decimal
The INT data type contains only whole numbers
Rate this question:
Stored procedures
Data types
Queries
Tables
Rate this question:
Cascade delete
Inherited delete
Functional delete
Waterfall delete
Domino delete
Rate this question:
No change is needed
Save an extra copy of data stored in a separate table.
Limit access to specific rows or columns of data in a table.
Save historical data before deleting it from the base table.
Rate this question:
Option A
Option B
Option C
Option D
Rate this question:
9
0
3
6
Rate this question:
No change is needed
Data type
View
Column
Rate this question:
Data type
Row
Column
View
Rate this question:
Improve performance of select statements.
Decrease storage space
Improve performance of insert statements
Decrease storage space.
Rate this question:
Table
Role
Trigger
User
Stored procedure
Rate this question:
Repeating groups
Foreign keys
Composite keys
Duplicate rows
Rate this question:
Cohort
Compositional
Functionally dependent
Deterministic
Relationally dependent
Rate this question:
All orders for Customer ID 209 are deleted from the Order table.
The first order for Customer ID 209 is deleted from the Order table.
All orders for Customer ID 209 are deleted from the Order table, and Customer ID 209 is deleted from the Customer table.
Customer ID 209 is deleted from the Customer table.
Rate this question:
Data definition language (DDL)
Data control language (DCL)
Data manipulation language (DML)
Data access language (DAL)
Rate this question:
Quiz Review Timeline (Updated): Jun 10, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Database Basic Knowledge Quiz! Trivia
Here we are with a database basics knowledge quiz. A database is a collection of data that makes it easy to access through a computer system. Databases are broken down into...
Questions:
10 |
Attempts:
1047 |
Last updated:
Mar 21, 2023
|
True / False Exercise -Database Concepts
This True\/False exercise delves into fundamental Database concepts, assessing understanding of object properties, DBMS efficiency, data sharing, query constraints, and uniqueness...
Questions:
5 |
Attempts:
1827 |
Last updated:
Mar 21, 2023
|
Multiple Choice Questions -Database Concepts
This quiz focuses on fundamental database concepts within relational models, including cardinality, schema, and data records, emphasizing data independence and management...
Questions:
15 |
Attempts:
1685 |
Last updated:
Mar 21, 2023
|
Unit 6 Introduction To Databases Part 1
Explore the basics of databases in 'Unit 6 Introduction to Databases Part 1'. This quiz covers data types, data warehouses, queries, database structures, and more, providing...
Questions:
15 |
Attempts:
735 |
Last updated:
Mar 21, 2023
|
Data And Databases Trivia Quiz!
Explore the world of databases with the Data and Databases Trivia Quiz! Test your knowledge on DBMS, metadata, and data structure management. Ideal for learners interested in...
Questions:
15 |
Attempts:
385 |
Last updated:
Mar 21, 2023
|
Database
This Database quiz evaluates understanding of SQL commands and their functionalities, focusing on query complexity, command syntax, and transaction control. It is ideal for...
Questions:
107 |
Attempts:
1258 |
Last updated:
Mar 21, 2023
|
Wait!
Here's an interesting quiz for you.