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

Authored by Hải .

Other

University

Used 10+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

50 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

A. Array structure

B. Table structure

C. Tree structure

D. Pointers structure

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

A. Locks are used to maintain transactional integrity and consistency.

B. Cursors are used to maintain transactional integrity and consistency.

C. Procedures are used to maintain transactional integrity and consistency.

D. Functions are used to maintain transactional integrity and consistency.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the full form of DBMS?

A. Data of Binary Management System

B. Database Management System

C. Database Management Service

D. Data Backup Management System

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

A. Because a database is created to suit the format of the data, it cannot respond flexibly to data format changes.

B. The procedure for making backups is complicated.

C. It is difficult to share data between operations due to an exclusive control function.

D. It can be accessed by multiple users at the same time due to an exclusive control function.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a database?

A. Organized collection of information that cannot be accessed, updated, and managed

B. Collection of data or information without organizing

C. Organized collection of data or information that can be accessed, updated, and managed

D. Organized collection of data that cannot be updated

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The ACID Properties of transactions refer to

A. Atomicity, consistency, isolation, database

B. Atomicity, consistency, isolation, durability

C. Atomicity, consistency, inconsistent, durability

D. Atomicity, concurrency, isolation, durability

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does an RDBMS consist of?

A. Collection of Tables

B. Collection of Records

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

BL M-02 FIRE CODE FLASHCARDS 01

Quiz

•

University - Professi...

50 questions

DSM2604 DECISION MAKING AND CONTROL TEST

Quiz

•

University

45 questions

Mulok kelas 5 semester 1 2024

Quiz

•

5th Grade - University

48 questions

Cátedra Wadhwnai 1228-1232

Quiz

•

University

50 questions

Philippine Electrical Code (Subject 4) - Nth

Quiz

•

University

45 questions

Administrasi Pajak

Quiz

•

10th Grade - University

50 questions

Science

Quiz

•

10th Grade - Professi...

50 questions

Revision on Research Methodology

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

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Other

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - 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

5 questions

Inherited and Acquired Traits of Animals

Interactive video

•

4th Grade - University

5 questions

Examining Theme

Interactive video

•

4th Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

7 questions

Comparing Fractions

Interactive video

•

1st Grade - University

DBI FE RETAKE

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