Ch 26: SQL Data Definition Language (DDL)

Technical implementation of database schema creation, modifying live column types, dropping relations, and understanding TRUNCATE vs DROP.

12 Questions12 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 1 – 10 of 12 Questions

Page 1 of 2

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.3. Create Table StatementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following represents the correct standard SQL Data Definition Language (DDL) syntax to instantiate and create a new database table structure?

💻 sql Snippet

CREATE TABLE Student (
    stId CHAR(5) PRIMARY KEY,
    stName VARCHAR(50)
);

A.CREATE TABLE name;
B.CREATE RELATION name;
C.CREATE SCHEMA name;
D.CREATE DATABASE TABLE name;

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.3. Create Table StatementEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following represents the correct ANSI SQL Data Definition Language (DDL) syntax to instantiate and create a new database table schema?

💻 sql Snippet

CREATE TABLE Program (
    prName char(4),
    totSem tinyint,
    prCredits smallint
);

A.CREATE MYSQL TABLE name;
B.CREATE TABLE name;
C.CREATE TABLE;
D.TABLE name CREATE;

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.2. DDL Commands OverviewEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following is the correct SQL Data Definition Language (DDL) syntax to initialize and create a physical database named 'employee' on a database server?

💻 sql Snippet

CREATE DATABASE employee;

A.CREATE TABLE employee;
B.CREATE MYSQL DATABASE employee;
C.CREATE SQL DATABASE employee;
D.CREATE DATABASE employee;

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.2. DDL Commands OverviewEasy🔁⭐💡📄🎓VU🏛️VU

Under standard relational database query classifications, which of the following SQL statements is NOT classified as a Data Manipulation Language (DML) command?

💻 sql Snippet

CREATE DATABASE employee;

A.UPDATE
B.INSERT
C.SELECT
D.CREATE

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.2. DDL Commands OverviewEasy🔁⭐💡📄🎓VU🏛️VU

What is another alternate name for the Data Dictionary in a relational database management system?

💻 sql Snippet

-- Querying information schema columns from system catalog:
SELECT * FROM INFORMATION_SCHEMA.TABLES;

A.Index
B.Metadata
C.Data
D.System Catalog

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.2. DDL Commands OverviewMedium🔁⭐💡📄🎓VU🏛️VU

Which of the following database commands is formally classified as a Data Definition Language (DDL) command (or DDL hybrid) rather than a Data Manipulation Language (DML) command?

💻 sql Snippet

TRUNCATE TABLE Employee;

A.INSERT
B.UPDATE
C.GRANT
D.TRUNCATE

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.4. Specifying Integrity Constraints (Primary Key, Foreign Key)Medium🔁⭐💡🌟📄🎓VU🏛️VU

Which keyword is available in SQL to enforce referential integrity?

💻 sql Snippet

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT REFERENCES Customers(CustomerID)
);

A.Check
B.Primary Key
C.References (Foreign Key)
D.Unique

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.4. Specifying Integrity Constraints (Primary Key, Foreign Key)Medium🔁⭐💡📄🎓VU🏛️VU

Which of the following keywords or constraints is available in SQL to declare checking conditions and assist in enforcing referential and domain integrity within a table schema?

💻 sql Snippet

CREATE TABLE Student (
    stId CHAR(5) CONSTRAINT ST_PK PRIMARY KEY,
    CONSTRAINT ST_CK CHECK (stId LIKE 'S[0-9][0-9][0-9][0-9]')
);

A.Check
B.Primary Key
C.Set Default
D.Unique

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.1. SQL Server Installation and ConfigurationsEasy🔁⭐💡📄🎓VU🏛️VU

When installing Microsoft SQL Server during database administration setup, which of the following is the standard, default system instance authentication mode that combines both Windows Authentication and SQL Server logins?

💻 text Snippet

-- System Administrator login enabled in Mixed Mode:
-- Login Username: sa

A.Windows Only Authentication Mode
B.Mixed Mode Authentication
C.Active Directory Directory Integration Mode
D.Kerberos Single-Sign-On Mode

Q10

❓ MCQ📘 CS403📑 Lec 26🏷️ 26.1. SQL Server Installation and ConfigurationsEasy🔁⭐💡📄🎓VU🏛️VU

During the installation of Microsoft SQL Server, which security configuration authentication mode allows database administrators and applications to connect using both Windows local/domain accounts and native, database-specific SQL Server login credentials?

💻 text Snippet

-- Default System Administrator username enabled in Mixed Mode:
-- Username: sa

A.Windows Only Authentication Mode
B.Mixed Mode (Windows Authentication and SQL Server Authentication)
C.Active Directory Directory Integration Mode
D.Single Sign-On (SSO) Kerberos Authentication Mode

Ch 26: SQL Data Definition Language (DDL)

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units