MCQGeeks
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Science
Postgresql
Quiz 3
Solution
Q.1.
DDL commands are:-
DROP
CREATE
DELETE
Both A & B
Q.2.
Pattered matching in SELECT command can be done using:-
_
%
&
Both A & B
Q.3.
Examples of DBMS software are:-
MySQL
ORACLE
FOXPRO
All of above
Q.4.
Uniquely identifies the record ,includes NULL also
primary key
unique key
candidate key
alternate key
Q.5.
Delete * from empl;
Deletes all tuples.
updates the table emp with null.
Destroys the table.
Q.6.
When you want to use a join between columns that are in the same table, you use what type of join?
UNION
OUTER JOIN
LEFT JOIN
SELF JOIN
Q.7.
When retrieving data in a particular table, we use the_____________ statement.
ORDER BY
FETCH
SELECT DISTINCT
SELECT FROM
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page