DBMS-9/4/24

What is the syntax of PL/SQL Loop?

• 1. LOOP
     END LOOP;
     Sequence of statements;

• 1. END LOOP;
     LOOP
     Sequence of statements;

  
  

• 1. LOOP
     Sequence of statements; END LOOP;

• 1. END LOOP;
     Sequence of statements; LOOP

Which is a join condition contains an equality operator:

• Equi joins

• Cartesian

• Both Equijoins and Cartesian

• None of the mentioned

Answer explanation

An equi-join is a specific type of comparator-based join, that uses only equality comparisons in the join-predicate

The ^{___ clause imposes a condition on the group by clause}

• None of the above

• Where

• Order by

• Having

Which type of data can be stored in the database?

• Image oriented data

• Text, files containing data

• Data in the form of audio or video

• All of the above

Primary key can be?

• NULL

• NOT NULL

• Unique

• BOTH NOT NULL AND UNIQUE

What does the following statement in SQL do?

TRUNCATE TABLE student;

• Creates a table called student

• Deletes records of a table called student

• Check if there is table called student

• none of the above

The ......... function converts a value of a date datatype to char value

• TO_CHAR

• TO_CHARACTER

• TO_STRING

• TO_VARCHAR

What does the following code snippet do?

ALTER TABLE STUDENT ADD(ADDRESS VARCHAR2(20));

• Invalid syntax

• Checks if a column ADDRESS is present in the table or not

• Add a column called ADDRESS in the student table

• None of the above

Which of the following are valid SQL constraints?

• Not Null

• Check

• Unique

• All of the above

The SQL expression Select distinct T.branch_name from branch T. branch S where T.assets>S.assets andS.branch_city= "PONDICHERRY" Finds the name of the

• All the branches that have graeter assets than any other branch loacted in Pondicheery

• The branch that have greater assets in Pondicheery

• the branch that have lower assets in Pondicheery

• Any branches that have graeter assets than any other branch loacted in Pondicheery