Which of the following is not a database object? Table View Index Antonym Which

Question

Which of the following is not a database object?

Table

View

Index

Antonym

Which statement is true regarding primary keys?

A primary key’s value is unique

A primary key’s value can contain duplicates

A primary key can only contain one field

A primary key does not have to contain a value

A department to employee is an example of what type of relationship?

One-to-one relationship

Two-to-two relationship

One –to-many relationship

Many-to-many relationship

What is the programming language that retrieves and manipulates data?

Sequenced Query Language

Structured Query Language

Standard Query Language

SQL*Plus

What is the basic SQL statement for viewing records?

Read

Retrieve

Select

Query

Explanation / Answer

Which of the following is not a database object?

Correct Option: Antonym

Explanation: Other given options (Table, View and Index) are part of a database. Table is a database object which represents a set of data values. View is a database object which can be imagined as a virtual table. Index is a database object that is used for increasing the performance of a query. Antonym means opposite word. Antonym is not part of database.

Which statement is true regarding primary keys?

Correct Option: A primary key’s value is unique.

Explanation: A primary key’s value always is unique. It cannot contain duplicate values. It may consist of more than one field. Primary key’s value cannot be NULL. So a primary key must have to contain a value. Hence only the first statement is true.

A department to employee is an example of what type of relationship?

Correct Option: One –to-many relationship

Explanation: In general one department has many employees and in general one employee belongs to only one department. So it is clear that first option, second option and fourth option is not correct. Third option is the correct option.

What is the programming language that retrieves and manipulates data?

Correct Option: Structured Query Language

Explanation: There is no such language called sequenced query language or standard query language for data retrieving and manipulating, so first and third options are incorrect. SQl* Plus is a batch query tool which has command line interface. It is not the programming language for data retrieving and manipulating; so fourth option is also incorrect. SQL (Structured Query Language) is the programming language which is used for data retrieving and data manipulation. Hence second option is the correct one.

What is the basic SQL statement for viewing records?

Correct Option: Select

Explanation: Select statement is used to fetch data from a database. It is the basic SQL statement for viewing records. Read, Retrieve and Query are not at all proper statements in SQL. Hence ‘Select’ is the correct option.

/*If this helps you, please let me know by giving a positive thumbs up. In case you have any queries, do let me know. I will revert back to you. Thank you!!*/

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.