
استعلامات قاعدة البيانات
Authored by Ala' Jarrar
Computers
12th Grade
Used 1+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
5 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
الاستعلام الذي سترجع اسم العامل واسم المشروع الذين يعمل به هو
Select from employee_tbl;
Select project_name,emp_name from employee_tbl,project_tbl where project_tbl.proj_num=employee_tbl.proj_num;
Select emp_name,proj_name from employee_tbl,project_tbl where project_tbl.proj_num=employee_tbl.proj_num;
Select * from employee_tbl, priject_tbl where project_tbl.proj_num=employee_tbl.proj_num;
2.
DRAG AND DROP QUESTION
2 mins • 1 pt
استعلام يسترجع اسم القسم الذي يتم ادخال رقمه من قبل المستخدم
(a) dep_name (b) department_tbl where (c) =[ادخل رقم القسم];
3.
DROPDOWN QUESTION
2 mins • 1 pt
استعلام يظهر جميع بيانات المهندسين مرتبة حسب رقم المهندس تصاعديا
Select (a) from (b)
order (c) eng_num (d)
4.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
الاستعلام الذي سيعيد جميع أسماء المشاريع التي يعمل بها العامل هو
Select project_name from project_tbl;
Select emp_name, project_name from employee_tbl, project_tbl where employee_tbl.emp_id=project_tbl.emp_id;
Select project_name from employee_tbl, project_tbl where employee_tbl.emp_num=project_tbl.emp_num;
Select * from project_tbl where emp_id in (select emp_id from employee_tbl);
5.
MULTIPLE CHOICE QUESTION
30 sec • Ungraded
ما مدى رضاك عن لقاء اليوم
سئ
جيد
جيد جدا
رائع
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?