Scribd
Upload
89 views1 page

Monthly Evaluation Test

This document contains a 10 question monthly evaluation test covering basic database and PHP concepts. It asks the test taker to define databases and DBMS, identify relationship types, describe database modeling concepts, write SQL queries to read and insert data, and identify the proper PHP code to connect to a database and write queries. It concludes by asking the test taker to outline the steps to create a PHP project.

Uploaded by

Abdisamad Muse
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
89 views1 page

Monthly Evaluation Test

This document contains a 10 question monthly evaluation test covering basic database and PHP concepts. It asks the test taker to define databases and DBMS, identify relationship types, describe database modeling concepts, write SQL queries to read and insert data, and identify the proper PHP code to connect to a database and write queries. It concludes by asking the test taker to outline the steps to create a PHP project.

Uploaded by

Abdisamad Muse
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Monthly evaluation test

1. Define a database?
2. Define a DBMS?
3. Mention three types of relationships?
4. Describe the following tables

Feature Conceptual Logical Physical


Entity Name
Entity Relationships
Attributes
Primary Keys
Foreign Keys
Table Name
Column Names
Column Data Types

5. Which of the following is correct to read all data from data table ?
A. Select * from student where ID=’1’
B. Select * from student
C. Select * from student where ID
D. Select * from student ID=’1’
6. What is an attribute?
A. Table feature
B. Table column
C. Database column
D. None
7. How to make a connection from database?
A. $conn=mysqli_connect(“localhost”,”root”,””,”LMS”);
B. $conn=mysqli_connect(“localhost”,”root”,””,”LMS”)
C. $conn=mysqli_connect(“localhost”,”root”””,”LMS”);
D. $conn=mysql_connect(“localhost”,”roo”,””,”LMS”);
8. Write insert code for PHP?
9. Write select code for PHP?
10. Mention steps to create a PHP project?

You might also like