UTA INSY 3304 EXAM QUESTIONS AND ANSWERS LATEST UPDATE (ALREADY GRADED A+)

UTA INSY 3304 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE (ALREADY GRADED A+)
Data definition language

DDL

Data manipulation language

DML

CREAT SCHEMA AUTHORIZATION

Creates a database schema

CREATE TABLE

Creates a new table in the user's databse schema

NOT NULL

Ensures that a column will not have null values

UNIQUE

Ensures that a column will not have duplicate values

PRIMARY KEY

Defines a primary key for a table

FOREIGN KEY

Defines a foreign key for a table

DEFAULT

Defines a default value for a column ( when no value is give)

CHECK

validates data in an attribute

CREATE INDEX

Creates an index for a table

CREATE VIEW

Creates a dynamic subset of rows and column from on or more tables

ALTER TABLE

, Modifies a table's definition (adds, modifies, or deletes attributes or constraints)

CREATE TABLE AS

Creates a new table based on a query in the user's database schema

DROP INDEX

Permanently deletes an index

DROP VIEW

Permanently deletes a view

Authentications

the process DBMS uses to verify that only registered users access the database

Numeric

Number( L, D) or Numeric(L, D)

Character

Char (L)

Date (DATE)

Stores dates in the Julian format

iNSERT: Command to insert data into table

INSERT INTO tablename VALUES();

COMMIT Syntax

COMMIT [WORK];

SELECT Syntax

Command to list the content
SELECT columnlist FROM tablename;

UPDATE

Command to modify data
Syntax - UPDATE tablename SET columnname = expression [, columnname = expression] [WHERE
conditionlist];

ROLLBACK

Syntax -ROLLBACK;
Undoes the changes since last COMMIT
command