Consider the two relations,
Supplier (S_no, S_name, Contact_No, Address) and
Supply (S_no, Item_no).
Which of the following statements give(s) a list of supplier names supplying the item with Item_no ‘555’?
SELECT S_name FROM Supplier WHERE Item_no=’555’
GRANT command belongs to which type of classification?
DCL
The ________ operator allows to use wild cards in the where clause of an SQL statement.
LIKE
We should not compromise ________ over efficiency.
All of the above /Privacy
An effective user interface minimizes the----------- users require to learn and implement the system.
Time
Is the given SQL Statement prompt error?
Select * from relation1;
No Error
In SQL, which command is used to modify the rows of tables.
UPDATE
The maximum PL/SQL size of data type “VARCHAR2” in DBMS is _____________ bytes.
32767
Normalization of database is used to __________.
Eliminate redundancy
Thanks everone