QUIZ 1 BASIC SQL BCA 3rd Year

The language used application programs to request data from the DBMS is referred to as __________

• DDL

• DML

• Query Language

• All of the mentioned

Match SQL language with SQL commands

1)DDL i)Revok, Grant

2)DML ii)rename a table

3)TCL iii)insert, update

4)DCL iv)rollback , commit

• 1-iii,2-i,3-ii,4-iv

• 1-iii,2-ii,3-iv,4-i

• 1-ii,2-iii,3-iv,4-i

• 1-i,2-iii,3-ii,4-iv

Which of the following is not a type of SQL statement?

• Data Manipulation Language (DML)

• Data Definition Language (DDL)

• Data Control Language (DCL)

• Data Communication Language (DCL)

SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

• DELETE FROM table_name;

• DELETE TABLE table_name;

• DROP TABLE table_name;

• None

Correct syntax query syntax to drop a column from a table is

• DELETE COLUMN column_name;

• DROP COLUMN column_name;

• ALTER TABLE table_name DROP COLUMN column_name;

• None is correct.

Which command is used for removing a table and all its data from the database:

• Create command

• Drop table command

• Alter table command

• All of the mentioned

Which of the following language is used to specify database Schema ?

• DDL

• DML

• DCL

• None

DDL Stands for ___________.

• Data Management Language

• Data Manupulation Language

• Data Development Language

• Data Definition Language

How do we Insert a new patient record with name, age, gender, and diagnosis having the values ('Anna Cruz', 35, 'F', 'Diabetes') using SQL? refer to the table structure below

CREATE DATABASE HospitalDB;

CREATE TABLE Patients (

    PatientID INT PRIMARY KEY AUTO_INCREMENT,

    Name VARCHAR(100),

    Age INT,

    Gender CHAR(1),

    Diagnosis VARCHAR(255)

);

• INSERT INTO patients(Name, Age, Gender, Diagnosis) VALUES ('Anna Cruz', 35, 'F', 'Diabetes');

• INSERT INTO Patients (Name, Age, Gender, Diagnosis) VALUES ('Anna Cruz', 35, 'F', 'Diabetes');

• INSERT INTO PATIENTS (Name, Age, Gender, Diagnosis) VALUES ('Anna Cruz', 35, 'F', 'Diabetes');

• INSERT INTO Patient (Name, Age, Gender, Diagnosis) VALUES ('Anna Cruz', 35, 'F', 'Diabetes');

How do we Update the GPA of a student whose ID is 10234 using SQL? refer to the table structure below

CREATE DATABASE UniversityRecords;

CREATE TABLE Students (

    StudentID INT PRIMARY KEY,

    Name VARCHAR(100),

    GPA DECIMAL(3,2)

);

• UPDATE student SET GPA = 3.85 WHERE StudentID = 10234;

• UPDATE Student SET GPA = 3.85 WHERE StudentID = 10234;

• UPDATE STUDENTS SET GPA = 3.85 WHERE StudentID = 10234;

• UPDATE Students SET GPA = 3.85 WHERE StudentID = 10234;