Bachelor Of Computer Science

Database Systems MCQs

CS: Database Systems MCQs - Subtopic

Additional Basic Operations MCQ with Answers

Additional Basic Operations Multiple Choice Questions (MCQ) to practice additional basic operations quiz answers PDF, additional basic operations worksheets for online degrees. Solve introduction to sql Multiple Choice Questions and Answers (MCQs), "Additional Basic Operations Quiz Questions" and answers for online bachelor's degree computer science. Learn additional basic operations, aggregate functions, nested subqueries test prep for computer majors.

"An identifier, that is used to rename a relation is referred to as a" Multiple Choice Questions (MCQ) on additional basic operations with choices input variable, clone name, correlation name, and table alias for online bachelor's degree computer science. Solve additional basic operations quiz questions for merit scholarship test and certificate programs for master's degree in computer science.

MCQs on Additional Basic Operations

1.

An identifier, that is used to rename a relation is referred to as a

Input variable
Clone name
Correlation name
Table alias

2.

For renaming attributes, the as clause can appear in

Select clause
Where clause
From clause
Both A and C

3.

SQL provides a way of renaming the attributes of a result relation, taking the form

old-name to new-name
old-name as new-name
ALTER old-name to new-name
ALTER old-name at new-name

4.

The Asterisk symbol ?*? is used to denote all the attributes in a relation, and is used in

Select clause
Define clause
From clause
Where clause

5.

SQL expresses patterns by using the operator

Like
AS
"="
%