Search Header Logo

BTEC National ICT U2 - Database Theory Lesson 1-3

Authored by Sarah Rodgers

Computers

12th Grade

Used 15+ times

BTEC National ICT U2 - Database Theory Lesson 1-3
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is Open Source Software?

Software that is owned by a commercial organisation which develops and sells a licence to the software.

It is a special purpose programming language used for managing data in relation to databases

Software that has its source code available for the general public to use and modify free of charge.

It is used in database development as the definition for the type of data that is to be stored

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is Proprietary Software?

Software that is owned by a commercial organisation which develops and sells a licence to the software.

It is a special purpose programming language used for managing data in relation to databases

Software that has its source code available for the general public to use and modify free of charge.

It is used in database development as the definition for the type of data that is to be stored

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is meant by the term datatype?

Software that is owned by a commercial organisation which develops and sells a licence to the software.

It is a special purpose programming language used for managing data in relation to databases

Software that has its source code available for the general public to use and modify free of charge.

It is used in database development as the definition for the type of data that is to be stored in a field. The most common types are text and number.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stand for

Standard Qualitative Layout

Secure Question Library

Structured Query Language

Specific Queue Latency

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL can only be used on Microsoft Access

True

False

6.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

Which of the following are relational algebra operations that can be applied to tables? (Choose all that apply)

Intersect

Merge

Union

Select

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What SQL operation does this symbol represent?

Select

Join

Intersect

Union

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?