CS409 Practical Quiz 10

Q1. Which of the following commands is used to create a database table and its structure?

1. DCL
2. DQL
3. DDL
4. DML

Correct answer: DDL

Q2. Which of the following is a correct syntax for creating a Database named employee?

1. CREATE MYSQL Database employee
2. CREATE DATABASE employee;
3. CREATE TABLE employee;
4. CREATE SQL DATABASE employee;

Correct answer: CREATE DATABASE employee;

Q3. Which of the following is NOT related to CREATE TABLE command?

1. Constraints
2. Attributes
3. Records
4. Data types

Correct answer: Records

Q4. Which of the following is the correct syntax for creating a database table?

1. TABLE name CREATE;
2. CREATE TABLE;
3. CREATE TABLE name;
4. CREATE MYSQL TABLE name;

Correct answer: CREATE TABLE name;

Q5. Which of the following command is used to insert data into tables?

1. DDL
2. DML
3. DQL
4. DDL

Correct answer: DML

Q6. Which of the following is the correct syntax for inserting some values into the employee table?

1. INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
2. INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)
3. INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)
4. INSERT into employee (col1, col2, col3), (val1, val2, val3)

Correct answer: INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)

Q7. ___________ in SQL table is used to uniquely identify individual rows of a given table.

1. Foreign key column
2. NOT NULL constraints
3. Primary key column
4. Secondary key column

Correct answer: Primary key column

Q8. The……… companions of holy Prophet (PBUH) received martyrdom in the battle of Uhud.

1. 14
2. 72
3. 70
4. 20

Correct answer: 70

Q9. Who was the first commander to lead the army in the battle of Muta?

1. Hazrat Zaid bin Ali R.A
2. Hazrat Zaid bin Sabit R.A
3. Hazrat Zaid bin Haritha R.A
4. Hazrat Zaid bin Aslam R.A

Correct answer: Hazrat Zaid bin Haritha R.A

Q10. The mount Uhud was at the………of Kuffar, in the battle of Uhud.

1. Left
2. Front
3. Back
4. Right

Correct answer: Left

Q11. How many Muslims participated in the battle of Badr?

1. 300
2. 323
3. 313
4. 333

Correct answer: 313

Q12. What is meant by "Aam-ul-Huzn' (?”)ععععع ععع

1. A canal of Paradise
2. The year of sorrow
3. Zam Zam
4. Heaven

Correct answer: The year of sorrow

Q13. In the time of which Caliph Rashid ( )عععع عععععwas the irrigation system established?

1. Hazrat Usman R.A۔
2. Hazrat Umar R.Aع
3. Hazrat Ali R.A۔
4. Hazrat Abu Bakar R.A۔

Correct answer: Hazrat Umar R.Aع

Q14. What was the actual name of Hazrat Abu Bakr R.A.?

1. Abu Marsad ۔۔۔۔ ۔۔۔
2. Abu Hurrairah ۔۔۔۔۔ ۔۔۔
3. Abdul Rahman ۔۔۔۔۔۔۔۔۔
4. Abdullah ععععععع

Correct answer: Abdullah ععععععع

Q15. How many companions pledged at the hand of the Prophet (PBUH) on the occasion of the treaty of Hudaybiyyah?

1. 3000
2. 2000
3. 1000
4. 1500

Correct answer: 1500

Q16. There were ....... communities in Madinah at the time of migration of Prophet (PBUH):

1. 6
2. 3
3. 5
4. 2

Correct answer: 3

Q17. Who falsely claimed to be a prophet?

1. Nasar Sharjil ۔۔۔۔۔ ۔۔۔
2. Talihah Bint al-Harith ۔۔۔۔۔۔ ۔۔۔ ۔۔۔۔۔
3. Musailma bin Younas عععع عع عععععع
4. Aswad Ansi ۔۔۔۔ ۔۔۔۔

Correct answer: Musailma bin Younas عععع عع عععععع

Q18. Among primitive societies the law was enforced through:

1. Formal means
2. Informal means
3. Formal Institutions
4. Legal agencies

Correct answer: Informal means

Q19. Feminist viewpoints on stratification in Pakistan are frequently linked to the ways in which women are oppressed and excluded from significant social, economic, and political realms.

1. False
2. True

Correct answer: True