It is a graphical user interface that allows you to issue SQL commands to interact with the server and any databases you create.

Oracle Database Express Edition

Which statement removes the records of the teachers under the IT department?

DELETE FROM Teachers WHERE Department = 'IT';

DELETE FROM Teachers BETWEEN Department = 'IT';

DELETE FROM Teachers LIKE Department = 'IT';

ERASE FROM Teachers IN Department = 'IT';

Which of the following is not an objective of normalization?

Each row contains multiple values.

Each table represent a single entity.

No data item will be unnecessary stored in more than one table.

Each table has no data anomalies.

Which statement removes the record of the employees under the Marketing department?

DELETE FROM Employees WHERE Department = 'Marketing';

DELETE FROM Employees BETWEEN Department = 'Marketing';

ERASE FROM Employees IN Department = 'Marketing';

DELETE FROM Employees LIKE Department = 'Marketing';

Which of the following statements deletes the Age column from the Students table?

ALTER TABLE Students DROP COLUMN Age;

ALTER TABLE Students DROP COLUMN Age:

DROP COLUMN Age ALTER TABLE Students:

Which of the following is NOT a basic scenario as to how data can be modified?

Inserting new columns into a table

Inserting new rows into a table

Updating existing data in specific rows and columns in a table

Which of the following is NOT the importance of Normalization

Checking and proper referencing of foreign key

Correct duplicate data and database anomalies.

Prevent unwanted deletions of data.

Which of the following statements is NOT TRUE about SQL?

SQL can set permission on tables and views only.

SQL can execute queries against a database.

SQL can create stored procedures in a database.

SQL can create new table in a database.

Which retrieves the unique values in the Color column of the Car table?

SELECT DISTINCT Color FROM Car;

SELECT DISTINCT Color FROM Car:

What does the CREATE TABLE statement do in the provided SQL command?

Defines a new table structure in the database

Inserts data into an existing table

Deletes a table from the database

In the CREATE TABLE statement, what is the purpose of the PRIMARY KEY constraint on StudID?

To ensure that StudID uniquely identifies each row and cannot be NULL

To allow duplicate values in the StudID column

To link the StudID column with another table

To automatically populate StudID with default values

What does the identity(1,1) clause in the StudID column do?

Sets StudID to increment by 1 for each new row, starting at 1

Makes the StudID column a foreign key

Ensures that StudID can accept NULL values

Specifies a default value of 1 for the StudID column

What is the purpose of the INSERT INTO statement in the given commands?

To add a new row of data to the tblStudents table

To create a new table named tblStudents

To delete rows from the tblStudents table

To update existing rows in the tblStudents table

What does the SELECT * FROM tblStudents; command do?

Retrieves all rows and columns from the tblStudents table

Deletes all data from the tblStudents table

Updates specific rows in the tblStudents table

Creates a backup of the tblStudents table

What does the PRIMARY KEY constraint ensure in a CREATE TABLE statement?

Ensures that each row in the table has a unique and non-NULL value for the column

Allows duplicate and NULL values in the column

Restricts data modifications in the table

Automatically adds foreign key constraints

Which of the following is the correct syntax to insert a row of data into a table?

INSERT INTO table_name(column1, column2) VALUES(value1, value2);

ADD ROW INTO table_name VALUES(value1, value2, value3);

INSERT INTO table_name(value1, value2, value3);

ADD DATA TO table_name(column1, column2) VALUES(value1, value2);

Which of the following SQL commands is used to retrieve all rows and columns from a table named Customers?

SELECT ALL COLUMNS FROM Customers;

In the INSERT INTO command, what must match between the inserted values and the table structure?

The column names and the data types

How do you select specific columns, such as FirstName and LastName, from a table named Users?

SELECT FirstName, LastName FROM Users

GET FirstName, LastName FROM Users;

SELECT (FirstName, LastName) FROM Users;

SELECT ALL FirstName AND LastName FROM Users

When using the INSERT INTO statement, what happens if you omit the column names but provide the values?

The command will insert the values based on the default order of columns in the table

The command will insert the values into all columns automatically in alphabetical order

The command will fail with an error

The command will prompt the user to specify the column names

When using the INSERT INTO statement, what happens if you omit the column names but provide the values?

The command will insert the values based on the default order of columns in the table

The command will insert the values into all columns automatically in alphabetical order

The command will fail with an error

The command will prompt the user to specify the column names

Which of the following SQL statements will create a table with three columns: ID, Name, and Age?

CREATE TABLE Persons(ID INT, Name VARCHAR(50), Age INT);

CREATE TABLE Persons(ID INT, Name VARCHAR(50), Age);

CREATE Persons(ID INT PRIMARY, Name CHAR(50), Age INT);

TABLE Persons(ID INT PRIMARY KEY, Name CHAR(50), Age);

Final Exam Review: Information Management

Authored by IECEP UDM

Information Technology (IT)

University

Used 4+ times

Final Exam Review: Information Management

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

51 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is a major component of SQL that enables you to create and modify the database itself.

Data Control Language

Data Manipulation Language

Data Definition Language

Transaction Control Language

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is the process of organizing data to minimize redundancy in the design of a relational database management system.

Normalization

Functional Dependency

Transitive Dependency

Full Functional Dependency

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A process of minimizing the differences between entities by identifying their common features.

Superclass

Generalization

Subtype

Specialization

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A normal form wherein the partial dependency is being eliminated.

1NF

2NF

3NF

BCNF

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This statement is used to edit data in a table.

CHANGE

EDIT

UPDATE

ALTER

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following SQL commands is not an example of Data Manipulation Language?

SELECT

COUNT

FROM

RENAME

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A normal form where all underlying simple domains contain atomic values only.

1NF

2NF

3NF

BCNF

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

UAS Pemodelan Proses Bisnis

Quiz

•

University

50 questions

Data Mining Quiz

Quiz

•

University

50 questions

LET Reviewer – TLE ICT Major (Extracted MCQs)

Quiz

•

University

50 questions

Digital Transformation Quiz

Quiz

•

University

50 questions

1-50

Quiz

•

University

50 questions

CC104 SUMMATIVE TEST

Quiz

•

University

50 questions

Ôn tập HKI Tin học 12

Quiz

•

12th Grade - University

50 questions

Quiz Kewirausahaan & Pemrograman Web

Quiz

•

11th Grade - University

Popular Resources on Wayground

8 questions

Spartan Way - Classroom Responsible

Quiz

•

9th - 12th Grade

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

14 questions

Boundaries & Healthy Relationships

Lesson

•

6th - 8th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

3 questions

Integrity and Your Health

Lesson

•

6th - 8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

9 questions

FOREST Perception

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

Discover more resources for Information Technology (IT)

20 questions

Disney Trivia

Quiz

•

University

7 questions

Fragments, Run-ons, and Complete Sentences

Interactive video

•

4th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

10 questions

DNA Structure and Replication: Crash Course Biology

Interactive video

•

11th Grade - University

7 questions

Force and Motion

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

14 questions

Ch.3_TEACHER-led

Quiz

•

University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

Final Exam Review: Information Management

It is a major component of SQL that enables you to create and modify the database itself.

It is the process of organizing data to minimize redundancy in the design of a relational database management system.

A process of minimizing the differences between entities by identifying their common features.

A normal form wherein the partial dependency is being eliminated.

This statement is used to edit data in a table.

Which of the following SQL commands is not an example of Data Manipulation Language?

A normal form where all underlying simple domains contain atomic values only.

It is a graphical user interface that allows you to issue SQL commands to interact with the server and any databases you create.

It is used to connect to any of the SQL Server components.

It is the key field that serves as the unique identifier of a specific tuple in a relation.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Information Technology (IT)