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

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

Tes Wawasan Kebangsaan LPDP 2021

Quiz

•

University

50 questions

9º ANO - QUIZIZZ EEBA

Quiz

•

8th Grade - University

55 questions

Ôn tập giữa học kì i môn GDQP-AN

Quiz

•

11th Grade - University

50 questions

Manajemen Pemasaran lanjutan

Quiz

•

University

54 questions

Familias SUD

Quiz

•

KG - Professional Dev...

50 questions

Sustainable Development

Quiz

•

University

50 questions

Cuestionario_Fotografía_TFPD_2998350

Quiz

•

University

50 questions

Latihan UP PPG 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 Other

7 questions

How James Brown Invented Funk

Interactive video

•

10th Grade - University

5 questions

Helping Build the Internet: Valerie Thomas | Great Minds

Interactive video

•

11th Grade - University

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

23 questions

Subject Verb Agreement

Quiz

•

9th Grade - University

7 questions

Renewable and Nonrenewable Resources

Interactive video

•

4th Grade - University

19 questions

Review2-TEACHER

Quiz

•

University

15 questions

Pre2_STUDENT

Quiz

•

University

20 questions

Ch. 7 Quadrilateral Quiz Review

Quiz

•

KG - 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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Other