Search Header Logo

sql/pl

Authored by Миракл виауан

English

10th Grade

Used 18+ times

sql/pl
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

37 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which command allows you to change the structure of the database?

ALTER

cascade

serial

constant

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How to add an auto-incremented primary key to an existing table. We use keyword ...

CASCADE

SERIAL

INCREMENT

CONSTRAINT

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Advantages of hierarchical database:I Promotes data sharing.II Database security is enforced.III It is conceptually simple due to the parent-child relationship.IV Organizational Disunity and Rigid structure.

a. I, III, IV

b. II, III, IV

c. I, II, IV

d. I, II, III

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To remove all data from multiple tables, we use

a. TRUNCATE

b. CASCADE

c. DROP

d. ALTER

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a super key?

a. set of one or more attributes (columns), which can uniquely identify a row in a table) with no redundant attribute

b. is a column or a group of columns in a table that reference the primary key of another table.

c. is a set of attributes that recognizes the tuples in relation or table.

d. set of one or more attributes (columns), which can uniquely identify a row in a table

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How we call managment system for related data

a. DBMS

RDBMS

HDBMS

NDBMS

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You can use aggregate functions as expressions only in the following clauses:

LIMIT and DISTINCT clauses

GROUP BY and JOIN clauses

WHERE and ORDER BY clauses

SELECT and HAVING clauses

CREATE and DELETE clauses

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?