Yathirajsolutions.com
HOME      EDUCATION      NEWS      SHOPING 

2nd PUC computer science
Chapter-14: SQL

Q1.which clause is used with select statement to display the detail in a sorted order with respect to a specifies column .
    a.where
    b.having
    c.order by
    d.distinct
    view Answer
    ans: c.order by

Q2.which defines the conceptual schema providing a link between the logical and physical structure of the database
    a.DML
    b.DDL
    c.DCL
    d.DQL
    view Answer
    ans:b.DDL

Q3.which define the physical characteristics of each record
    a.DML
    b.DDL
    c.DCL
    d.DQL
    view Answer
    ans:b.DDL

Q4.which provide data manipulation technique like selection,insertion,deletion,update
    a.DDL
    b.DML
    c.DCL
    d.DQL
    view Answer
    ans:b.DML

Q5.select command is belongs to
    a.DDL
    b.DML
    c.DCL
    d.DQL
    view Answer
    ans:d.DQL

Q6.which is not a DDl command
    a.delete
    b.create
    c.alter
    d.drop
    view Answer
    ans:a.delete

Q7.which is DML command

    a.create
    b.alter
    c.update
    d.drop
    view Answer
    ans:c.update

Q8.the rules enforced on data columns on table
    a.forms
    b.records
    c.constraints
    d.files
    view Answer
    ans:c.constraints

Q9.the table can be modified and changed by using the

    a.update
    b.alter
    c.drop
    d.insert
    view Answer
    ans:a.update

Q10.which command used to remove a table defination and all data,injdexes,triggers,constraints and permissions specificants for that table
    a.delete
    b.alter
    c.update
    d.drop
    view Answer
    ans:d.drop

Q11.which statement is used to add new rows if data to a table in the database
    a.create
    b.insert into
    c.update
    d.select
    view Answer
    ans:b.insert into

Q12.which statement is used to fetch the data from a database table which returns data in the form of result
    a.update
    b.select
    c.insert
    d.where
    view Answer
    ans:b.select

Q13.which operator is used to combine the multiple conditions in sql
    a.OR
    b.AND
    c.NOT
    d.none of the above
    view Answer
    ans: a.OR

Q14.which command is used to modify the existing records in a table
    a.grant
    b.update
    c.alter
    d.select
    view Answer
    ans:b.update

Q15.which is queue is used to delete the existing records from a table
    a.drop
    b.remove
    c.delete
    d.destroy
    view Answer
    ans:c.delete

Q16.which clause is used in collaboration with the select statement to arrange identical data into group
    a.order by
    b.having
    c.distinct
    d.group by
    view Answer
    ans:d.group by

Q17.the keyword is used in conjuction with select statement to eliminate all the puplicate records and fetching only unique records
    a.order by
    b.having
    c.distinct
    d.group by
    view Answer
    ans:c.distinct

Q18.which clause is used to combine records from two or more tables in a database
    a.group by
    b.order by
    c.join
    d.select
    view Answer
    ans:c.joint

Q19.it is the tansactional command is used to save chnages invked by a transaction to the database
    a.grant
    b.commit
    c.select
    d.update
    view Answer
    ans:b.commit

Q20.which Commands are used to enforce database security in a multiple user database environment
    a.DML
    b.DDL
    c.DCL
    d.DQL
    view Answer
    ans:c.DCL

Q21.which command is used to provide access or privilages on the datbase objects to the users
    a.ROLLBACK
    b.COMMIT
    c.grant
    d.revoke
    view Answer
    ans:c.grant

Q22.which command removes user access rights or privilages to the datbase objects
    a.delete
    b.drop
    c.revoke
    d.update
    view Answer
    ans:c.revoke

Q23.this is a single row and single columndummy table used to perform mathematical calculations witherest using a table
    a.single table in oracle
    b.RDBMS table
    c.dual table in oracle
    d.none of the above
    view Answer
    ans:c.dual table in oracle

Q24.SQL is
    a.sequentially querry language
    b.structured querry language
    c.special querry language
    d.systematic querry language
    view Answer
    ans:b.structured querry language

Q25.which is a DML command in SQL
    a.DELETE command
    b.CREATE command
    c.ALTER command
    d.GRANT command
    view Answer
    ans:a.DELETE command

Q26.in SQL____ command is an example for DDL
    a.UPDATE
    b.DELETE
    c.CREATE
    d.all of the above
    view Answer
    ans:c.CREATE

Q27.______command is used to display all the records in table
    a.UPDATE
    b.SELECT
    c.DROP
    d.ALTER
    view Answer
    ans:b.SELECT

Q28.in SQL ____ command is an example for DML
    a.UPDATE
    b.DELETE
    c.INSERT
    d.all of the above
    view Answer
    ans:d.all of the above

Q29.______language allows ebedding with other languages
    a.SQL
    b.SPL
    c.DBMS
    d.Querry language
    view Answer
    ans:a.SQL

Q30. in SQl____ command is used to remove the table defenition
    a.DROP
    b.DELETE
    c.CREATE
    d.querry language
    view Answer
    ans:a.DROP


Author: yathirajsolutions.com designed by Sathisha M

yathirajsolutions.com

Contact Us

Fill up the form below to send us a message.