
УПР 31-60
Authored by Нұрдәулет Қазбеков
Information Technology (IT)
University
Used 4+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of a foreign key in a relational database?
To increase query speed
To enforce referential integrity between tables
To store unique values only
To generate primary keys automatically
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which postgresql command is used to permanently delete a table and all its data?
DROP TABLE table_name;
DELETE FROM table_name;
REMOVE TABLE table_name;
TRUNCATE TABLE table_name;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You need to update multiple rows in a postgresql table at once Which SQL statement should you use?
ALTER TABLE
INSERT INTO
UPDATE table_name SET column_name = value WHERE condition
MODIFY TABLE
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the function of the GROUP BY clause in SQL?
It groups rows with the same values in specified columns for aggregate functions
It filters results based on a given condition
It sorts records in descending order
It creates a backup of grouped rows
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How can you prevent duplicate records in a postgresql table column?
By using a FOREIGN KEY constraint
By enabling indexing on the column
By defining the column as UNIQUE
By using the AUTO_INCREMENT property
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is a key difference between the DELETE and TRUNCATE commands in postgresql?
DELETE allows filtering with WHERE, while TRUNCATE removes all rows instantly
TRUNCATE removes specific rows based on conditions
DELETE is faster than TRUNCATE
TRUNCATE locks the database permanently
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL function is used to return the number of rows in a table?
SUM()
AVG()
COUNT()
LENGTH()
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
25 questions
Kuis Teknologi Kesehatan Digital
Quiz
•
University
26 questions
Software Engineering Quiz
Quiz
•
University
26 questions
BBI Internal Practice Quiz
Quiz
•
University
28 questions
ĐỀ CƯƠNG ÔN TẬP KTCK II - TIN 12 (KNTT) - ĐỀ CƯƠNG SỐ 1
Quiz
•
12th Grade - University
35 questions
UH Materi Ms. Word
Quiz
•
7th Grade - University
29 questions
Kuis di PostgreSQL
Quiz
•
University
30 questions
Form 4 - CSEC Information Technology Quiz
Quiz
•
10th Grade - University
30 questions
Data Warehouse Intro and Architecture
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
29 questions
Alg. 1 Section 5.1 Coordinate Plane
Quiz
•
9th Grade
22 questions
fractions
Quiz
•
3rd Grade
11 questions
FOREST Effective communication
Lesson
•
KG
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
12 questions
IREAD Week 4 - Review
Quiz
•
3rd Grade - University
7 questions
Fragments, Run-ons, and Complete Sentences
Interactive video
•
4th Grade - University
7 questions
Renewable and Nonrenewable Resources
Interactive video
•
4th Grade - University
10 questions
DNA Structure and Replication: Crash Course Biology
Interactive video
•
11th Grade - University
5 questions
Inherited and Acquired Traits of Animals
Interactive video
•
4th Grade - University
5 questions
Examining Theme
Interactive video
•
4th Grade - University
20 questions
Implicit vs. Explicit
Quiz
•
6th Grade - University
7 questions
Comparing Fractions
Interactive video
•
1st Grade - University