Introduction To sql programming Mcqs

Our collections of Multiple choice questions and answers focuses on study of ” Introduction To sql programming “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate Introduction To sql programming comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. Introduction To sql programming Mcqs

Computer MCQS

Sciences MCQS

1.
We can test for the nonexistence of tuples in a subquery by using the _____ construct.

Not exist

Not exists

Exists

Exist

Answer Discus (0)

3.
An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

Index

Reference

Assertion

Timestamp

Answer Discus (0)

5.
The user defined data type can be created using

Create datatype

Create data

Create definetype

Create type

Answer Discus (0)

6.
Values of one type can be converted to another domain using which of the following ?

Cast

Drop type

Alter type

Convert

Answer Discus (0)

7.
Which of the following closely resembles Create view ?

Create table . . .like

Create table . . . as

With data

Create view as

Answer Discus (0)

8.
In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

Catalogs, schemas

Schemas, catalogs

Environment, schemas

Schemas, Environment

Answer Discus (0)

9.
Which of the following statements creates a new table temp instructor that has the same schema as instructor.

Create table temp_instructor,

Create table temp_instructor like instructor,

Create Table as temp_instructor,

Create table like temp_instructor,

Answer Discus (0)

11.
Which of the join operations do not preserve non matched tuples.

Left outer join

Right outer join

Inner join

None of the above

Answer Discus (0)

12.
What type of join is needed when you wish to include rows that do not have matching values?

Equi-join

Natural join

Outer join

All of the mentioned

Answer Discus (0)

14.
Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

Left outer join

Right outer join

Full outer join

Half outer join

Answer Discus (0)

15.
In SQL the statement select * from R, S is equivalent to

Select * from R natural join S

Select * from R cross join S

Select * from R union join S

Select * from R inner join S

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

0Shares
0
Scroll to Top