Select the most correct answer

associated with a set of locations of the tulips. D. An index is a data structure used to speed access to tuples of a relation, given values of one or more attributes.

A. An index is not a data structure used to speed access to tuples of a relation, given values of one or more attributes.

B. The key to index cannot be any attribute or set of attributes, and need not be the key to the relation.

C. We can think of the index as a binary search tree of (key, locations) pairs in which a key a is not associated with a set of locations of the tulips

Consider the relation: OrderDetail (orderNumber, productCode, productName, quantity, dateOrdered, sales Discount)And FDs{ orderNumber, productCode->quantity,orderNumber->dateOrdered,productCode->productName, sales Discount} And the key of OrderDetail is {orderNumber, productCode} Which of the following is full dependency on the key?

A. orderNumber, productCode->quantity

D. productCode->productName, sales Discount

In SQL, ERD use three types of principle elements to form relationships:

C. Entity sets, Attributes, and Relationships

A. Entity sets, Constraints and Relationships

B. Attributes, Constraints, and Relationships

D. Entity sets, Attributes and Constraints

In an ERD, what role does a primary key play?

A. It uniquely identifies each record in a table

B. It establishes relationships between tables

C. It determines the data type of attributes

D. It defines the cardinality of relationships

Which of the following statements is correct when converting from the ERD model to the relational model?

A. The order of the columns is not important

B. The order of both rows and columns is important

C. The order of the rows is important

D. The order of the columns is important

Which of the following is expressed by an E-R diagram? A. Relation between process and relationship B. Relation between entity and process C. Relation between processes D. Relation between entities

A. Relation between process and relationship

B. Relation between entity and process

How are many-to-many relationships typically represented in the relational model?

B. By creating a new table with foreign keys from both related tables

A. By adding attributes to one of the related tables

C. By denormalizing the database

D. By creating a new table for each related entity

In SQL query, choose the correct statement about the order of execution.

A. SELECT-FROM-WHERE - GROUP BY - HAVING - ORDER BY

B. SELECT - FROM - GROUP BY - WHERE - HAVING - ORDER BY

C. SELECT-FROM-HAVING - GROUP BY - WHERE-ORDER BY

D. SELECT-FROM-OREDER BY - WHERE HAVING - GROUP BY

The SQL keyword BETWEEN is used:

A. None of the above is correct.

C. to limit the columns displayed.

Which of the following belongs to DDL (data definition language)?

B. Insert, update, delete, select

The DROP TABLE statement:

B. deletes the table structure along with the table data.

A. deletes the table structure only.

C. works whether or not referential integrity constraints would be violated.

What is the main disadvantage of having too many indexes on a table?

D. Fast data modification operations

A. An index is a database table attribute, which speeds-up data search within a table.

B. An index is the same as alias.

C. An index is a special way to join 2 or more tables.

D. An index is a database row attribute, which speeds-up data search within a table

What happens if an error occurs during a transaction and it is not explicitly handled or rolled back?

B. The transaction is automatically rolled back

A. The transaction is automatically committed

C. The database becomes read-only

D. The transaction remains in a pending state

What is the difference between a view and a table in SQL?

C. Tables are created with the CREATE TABLE statement, while views use CREATE VIEW

A. Tables can be updated, while the view is displaying data from the query

B. Views can store data permanently, while tables are temporary

D. Views and tables are functionally equivalent in SQL

In SQL, what is a view?

A. A virtual table based on the result of a SELECT query

B. A physical table containing aggregated data

C. A temporary table used for transactions

D. A stored procedure with read-only access

Which of the following is used to define code that is fired when certain actions or event occur?

A. You use an application Trigger to fire when certain actions or event occur.

B. You use an application Cursor to fire when certain actions or event occur.

C. You use an application Replace to fire when certain actions or event occur.

D. You use an application Keyword to fire when certain actions or event occur.

Which of the following describes an SQL cursor?

A. It allows you to traverse the result set of a query and process each row individually

B. is a precompiled collection of one or more SQL statements that can be executed as a single unit

D. Cursors are not related to SQL

What is NOT true about the cursor in SQL?

A. It is considered the best practice to use when we want insert, update, or delete data in a table of SQL Server.

B. The cursor allows users to process data from a result set, one row at a time.

C. Cursors are an alternative to commands, which operate on all rows in a result set at the same time.

D. Unlike commands, cursors can be used to update data on a row-by-row basis.

When does the Deleted temporary trigger table become populated?

D. With DELETE and UPDATE triggers

A. With DELETE and INSERT triggers

C. With DELETE, UPDATE, and INSERT triggers

Which of the following represents Armstrong's Axiom of Transitivity?

B. If A B and B → C, then A → C

In a functional dependency A → B, what can be said about B?

C. B is functionally dependent on A

What are some benefits of normalization when converting an ERD to a relational model?

A. Increased storage space efficiency

In SQL, Which of the following statements is correct? A. All relations in 2NF are also in BCNF B. All relations in 1NF are also in BCNF C. All relations in 3NF are also in BCNF D. For any relation schema, there is a dependency-preserving decomposition into 3NF

D. For any relation schema, there is a dependency-preserving decomposition into 3NF

A. All relations in 2NF are also in BCNF

B. All relations in 1NF are also in BCNF

C. All relations in 3NF are also in BCNF

How can you delete a user-defined function in SQL?

A. DELETE FUNCTION function_name

B. REMOVE FUNCTION function_name

D. ERASE FUNCTION function_name

What data types can a user-defined function return? A. Number type, string type, date and time type, table type B. Number type, string type, date type, time type C. Number type, string type, binary file type (binary), table type

A. Number type, string type, date and time type, table type

B. Number type, string type, date type, time type

C. Number type, string type, binary file type (binary), table type

The ability to query data, as well as insert, delete, and alter tuples, is offered by

D. DML (Data Manipulation Language)

A. TCL (Transaction Control Language)

C. DDL (Data Definition Language)

DBI FE RETAKE

Quiz

•

Other

•

University

•

Practice Problem

•

Easy

Hải .

Used 10+ times

FREE Resource

C. Collection of Keys

D. Collection of Fields

Create a free account and access millions of resources

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

Tests olimpiade

Quiz

•

University

50 questions

PRELIM EXAM SOCIAL SCIENCE AND PHILOSOPHY

Quiz

•

University

50 questions

SOAL UJIAN BAHASA BALI

Quiz

•

12th Grade - University

50 questions

Journeyman 10 - Nth

Quiz

•

University

50 questions

Pre-test Copywriting Magang UNS 2023

Quiz

•

University

50 questions

ЄДКІ 50 тестів

Quiz

•

University

50 questions

UH teks Prosedur

Quiz

•

11th Grade - University

46 questions

Kalėdų tradicijos pasaulyje

Quiz

•

KG - Professional Dev...

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

11 questions

How well do you know your Christmas Characters?

Lesson

•

3rd Grade

14 questions

Christmas Trivia

Quiz

•

5th Grade

20 questions

How the Grinch Stole Christmas

Quiz

•

5th Grade

Discover more resources for Other

26 questions

Christmas Movie Trivia

Lesson

•

8th Grade - Professio...

20 questions

christmas songs

Quiz

•

KG - University

20 questions

Holiday Trivia

Quiz

•

9th Grade - University

15 questions

Holiday Movies

Quiz

•

University

14 questions

Christmas Trivia

Quiz

•

3rd Grade - University

20 questions

Christmas Trivia

Quiz

•

University

8 questions

5th, Unit 4, Lesson 8

Lesson

•

KG - Professional Dev...

20 questions

Disney Trivia

Quiz

•

University

DBI FE RETAKE

50 questions

What data structure will be represented for the hierarchical data model?

According to the technology deployed by the database management system, which of the following is correct?

What is the full form of DBMS?

Which of the following is the appropriate characteristic of a database?

What is a database?

The ACID Properties of transactions refer to

What does an RDBMS consist of?

Select the most correct answer

If there is more than one key for relation schema in DBMS then each key relation schema is classified as

To modify the schema of an existing relation use

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other