What does First Normal Form (1NF) primarily address in relational database design?

Eliminating unnecessary repeating groups of data.

Ensuring all columns have unique values.

Defining links between tables with foreign keys.

Allowing a single car to be bought and sold multiple times.

How does the relational paradigm model data?

As two-dimensional tables consisting of rows and columns.

As hierarchical structures with parent-child relationships.

As object-oriented structures with user-defined types.

As single, unbounded text documents.

Which international bodies manage the SQL standard?

Microsoft and PostgreSQL Global Development Group.

McGraw-Hill Education and Oracle University.

Which of the following are Data Manipulation Language (DML) commands in SQL?

SELECT, INSERT, UPDATE, DELETE, MERGE.

SQL is described as a set-oriented language. What does this imply about its capabilities for application development?

It is purely a data access language and needs to work with a procedural language for application development.

It provides complete solutions including user interface facilities.

It can directly handle flow control, conditional branching, and iteration.

It processes rows one by one through embedded calls.

What is a key difference between SQLPlus and SQL Developer in terms of their interface requirements?

SQL Developer offers more functionality and needs a graphical terminal, whereas SQLPlus can be used on character mode devices.

SQLPlus offers more functionality, while SQL Developer is simpler.

SQLPlus requires a graphical terminal, while SQL Developer can be used on character mode devices.

Both tools require an Oracle WebLogic Server to operate.

In Oracle terminology, what defines a database schema?

All the objects in the database owned by one user.

A person who can log on to the database.

A construct that makes an object accessible to other users without requiring its schema name.

A predefined set of tables like HR or OE.

If an object (e.g., a table) does not exist in a user's own schema, how must it be accessed?

The object name must be qualified with the name of the schema in which it resides (e.g., HR.EMPLOYEES).

It is impossible to access the object.

A CREATE SCHEMA command must be run first.

Only the database administrator can access it.

What is the primary purpose of the HR and OE demonstration schemas provided by Oracle?

To store example data for illustrating the use of SQL and advanced Oracle development facilities.

To enforce strict security protocols in production databases.

To replace actual business application data.

To benchmark database performance without actual user data.

What is the fundamental effect of a SQL SELECT statement on data stored in the database?

It provides a read-only method of extracting information and never alters the data.

It always alters information, ensuring data modification.

It can insert, update, or delete data depending on the clauses used.

It permanently removes duplicate records from tables.

Which three concepts from relational theory encompass the capabilities of the SELECT statement?

Projection, Selection, Joining.

Committing, Rolling back, Saving.

What is the primary function of the DISTINCT keyword in a SELECT statement?

To eliminate duplicate values from the results set.

To sort the results in ascending order.

To count all rows, including duplicates.

To project only specific columns.

Why should caution be exercised when executing a statement like SELECT * FROM huge_table;?

It may cause performance issues if the table contains millions of rows of data.

It might accidentally delete all data.

It always returns an error if the table is too large.

It automatically converts all data types, which can lead to inconsistencies.

In the Oracle data dictionary, how is metadata about different database objects typically stored by default?

In mixed case, preserving original input.

In a binary format, without case sensitivity.

How is a NULL value formally defined in SQL?

As a value that is unavailable, unassigned, unknown, or inapplicable.

What is the result when performing arithmetic operations with a NULL value?

The arithmetic operation always yields a NULL result.

The operation ignores the NULL and proceeds with other values.

The operation results in an error.

What is the primary function of the WHERE clause in a SELECT statement?

To limit or restrict the rows returned based on one or more conditions.

To sort the rows retrieved by a query.

To define new columns in the result set.

To combine results from multiple queries.

Which two wildcard characters are used with the LIKE operator for pattern matching?

% (percentage symbol) and _ (underscore character).

* (asterisk) and ? (question mark).

! (exclamation mark) and & (ampersand).

How does the ORDER BY clause affect the rows returned by a SELECT statement?

It only affects the presentation (ordering) of the results, not the specific rows returned.

It changes the specific records that are selected from the table.

It influences the records returned by a query by filtering them.

It restricts the number of rows to a maximum limit.

When sorting data using the ORDER BY clause, how can rows with NULL values in the sorting column be positioned?

They can be explicitly listed first (NULLS FIRST) or last (NULLS LAST).

They are always listed first by default.

They are always listed last by default.

NULL values cause an error when sorting.

What is the purpose of ampersand substitution variables in SQL?

To allow user input to restrict and sort output at runtime.

To permanently replace a value in the database.

To define new data types for columns.

To combine multiple queries into a single result set.

What is a function defined as in SQL?

A program written to optionally accept input parameters, perform an operation, and return a single value.

A program that can accept input parameters and always returns multiple values.

A program that is explicitly written to alter data in tables.

A set of SQL commands used to create database objects.

What is the key difference between single-row functions and multiple-row (group) functions?

Single-row functions execute once for each row selected, while multiple-row functions execute once for the entire set of rows queried.

Single-row functions always return numeric values, while multiple-row functions return characters.

Single-row functions can only be used in SELECT statements, while multiple-row functions can be used in WHERE clauses.

Single-row functions cannot accept input parameters, but multiple-row functions can.

What does the INITCAP function do?

Accepts a string of characters and returns each word in title case (first letter capitalized).

Converts a string of characters to all lowercase.

Converts a string of characters to all uppercase.

Extracts the initial characters of a string.

What does the LENGTH function return?

The number of characters in a character string.

The number of bytes in a character string.

The length of a numeric expression in bytes.

Whether a string contains any null values.

What does the MONTHS_BETWEEN function compute?

The number of months between two given date parameters.

The number of days between two dates.

The number of years between two dates.

What value does the SYSDATE function typically return?

The system date and time when the function is executed.

The last day of the current month.

The number of months since the database was installed.

The start date of the current transaction.

What is implicit data type conversion?

When the Oracle server automatically converts data from one data type to another to complete an operation.

Converting data types using explicit functions like TO_CHAR or TO_NUMBER.

Manually changing a column's data type using ALTER TABLE.

Defining a column with a flexible data type that accepts various input types.

What is the main purpose of the NVL function?

To replace a NULL value with a specified alternative value.

To convert a non-NULL value to NULL.

What kind of logic do CASE expressions provide in SQL queries?

If-then-else conditional logic.

Joining multiple tables based on conditions.

What would TO_CHAR(123.56, '999.9') return in Oracle SQL?

An error, as the format mask is shorter than the number.

What are group functions also known as?

Summary or aggregate functions.

When AVG(COMMISSION_PCT) is calculated, what values are considered?

All values, treating NULL as zero.

Only the distinct non-null values.

It always returns NULL if any NULL exists.

What does COUNT(*) return?

The number of rows in the group, including those with NULL values in any column.

The number of rows with non-null values in a specific column.

The number of unique rows in a table or group.

The sum of all numeric values in a column.

Can multiple group functions be used in the same SELECT list?

Yes, multiple group functions may be used in the same SELECT list.

No, only one group function is allowed per SELECT statement.

Yes, but only if they operate on the same column.

Only if a HAVING clause is also present.

Relational Database Design Quiz

Authored by rizal broer

Mathematics

University

Used 4+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

73 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What components make up the Oracle server technologies?

Oracle database, Oracle WebLogic Server, Oracle Enterprise Manager, and application development tools and languages.

Oracle database and SQL*Plus only.

Oracle WebLogic Server and Java only.

Oracle Enterprise Manager and Cloud Control only.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the primary role of the Oracle database within the Oracle product set?

To generate web user interfaces.

To run application servers centrally.

To serve as the repository for data and the engine that manages access to it.

To provide comprehensive administration tools.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the client-server processing model implemented by the Oracle server, what is the role of the client tier?

To execute SQL commands directly against the database.

To manage the data exclusively.

To generate the user interface and much of the application logic, including SQL commands.

To run all applications centrally on application servers.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which analogy is often used to describe how computing resources are provided to end users in a cloud environment?

A local area network connection.

Delivery of domestic electricity, supplied on demand without knowing the source.

A client-server split across different geographical locations.

A single, dedicated server managing all IT operations.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is SQL primarily used for in the context of application development?

Developing complete user interfaces.

Manipulating rows individually with procedural structures.

Data access, but not for developing complete applications.

Writing system-level code like C or Java.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is critical to understanding SQL and involves modeling business data into a form suitable for storing in relational tables?

Cloud Computing.

Oracle WebLogic Server.

Normalization.

Object-oriented database design.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What problem does unnecessary duplication of data in a database design typically indicate, and what can it lead to?

Efficient data storage, leading to improved performance.

Poor design, leading to wasteful storage and potential integrity errors (anomalies).

Optimal balance between storage and access, ensuring long-term cost savings.

Flexibility in data manipulation, enabling faster retrieval.

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

77 questions

İstatistikte Değişkenler

Quiz

•

University

75 questions

Nguyên Lý

Quiz

•

University

71 questions

Practice Test -ACT 120

Quiz

•

University

71 questions

Area of Parallelograms Practice - B

Quiz

•

7th Grade - University

75 questions

congruent -similar figures

Quiz

•

7th Grade - University

75 questions

Math Spiral Review: Quarter 1

Quiz

•

3rd Grade - University

69 questions

DESAFÍO POLIMATÍAS PRINCIPAL

Quiz

•

University

75 questions

GT2-Chương 1

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Mathematics

20 questions

Ch. 7 Quadrilateral Quiz Review

Quiz

•

KG - University

7 questions

Introduction to Fractions

Interactive video

•

1st Grade - University

18 questions

Exam Review

Quiz

•

University

16 questions

Parallel, Perpendicular, and Intersecting Lines

Quiz

•

KG - Professional Dev...

25 questions

Math College Placement Practice #2

Quiz

•

11th Grade - University

10 questions

One Step Equations Multiply and Divide

Quiz

•

University