McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Computer Science SY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) .
Chapters
| 401. |
The connective tests for set membership, where the set is a collection of values produced by a select clause. The connective tests for the absence of set membership. |
| A. | or, in |
| B. | not in, in |
| C. | in, not in |
| D. | in, or |
| Answer» C. in, not in | |
| 402. |
The phrase “greater than at least one” is represented in SQL by |
| A. | < all |
| B. | < some |
| C. | > all |
| D. | > some |
| Answer» D. > some | |
| 403. |
SQL applies predicates in the clause after groups have been formed, so aggregate functions may be used. |
| A. | group by |
| B. | with |
| C. | where |
| D. | having |
| Answer» B. with | |
| 404. |
The keyword is used to access attributes of preceding tables or subqueries in the from clause. |
| A. | in |
| B. | lateral |
| C. | having |
| D. | with |
| Answer» B. lateral | |
| 405. |
Which of the following creates a temporary relation for the query on which it is defined? |
| A. | with |
| B. | from |
| C. | where |
| D. | select |
| Answer» A. with | |
| 406. |
Subqueries cannot: |
| A. | use group by or group functions |
| B. | retrieve data from a table different from the one in the outer query |
| C. | join tables |
| D. | appear in select, update, delete, insert statements. |
| Answer» C. join tables | |
| 407. |
Which of the following is not an aggregate function? |
| A. | avg |
| B. | sum |
| C. | with |
| D. | min |
| Answer» C. with | |
| 408. |
The EXISTS keyword will be true if: |
| A. | any row in the subquery meets the condition only |
| B. | all rows in the subquery fail the condition only |
| C. | both of these two conditions are met |
| D. | neither of these two conditions is met |
| Answer» A. any row in the subquery meets the condition only | |
| 409. |
How can you find rows that do not match some specified condition? |
| A. | exists |
| B. | double use of not exists |
| C. | not exists |
| D. | none of the mentioned |
| Answer» B. double use of not exists | |
| 410. |
Which one of the following deletes all the entries but keeps the structure of the relation. |
| A. | delete from r where p; |
| B. | delete from instructor where dept name= ’finance’; |
| C. | delete from instructor where salary between 13000 and 15000; |
| D. | delete from instructor; |
| Answer» D. delete from instructor; | |
| 411. |
The problem of ordering the update in multiple updates is avoided using |
| A. | set |
| B. | where |
| C. | case |
| D. | when |
| Answer» C. case | |
| 412. |
The condition allows a general predicate over the relations being joined. |
| A. | on |
| B. | using |
| C. | set |
| D. | where |
| Answer» A. on | |
| 413. |
Which of the join operations do not preserve non matched tuples? |
| A. | left outer join |
| B. | right outer join |
| C. | inner join |
| D. | natural join |
| Answer» C. inner join | |
| 414. |
What type of join is needed when you wish to include rows that do not have matching values? |
| A. | equi-join |
| B. | natural join |
| C. | outer join |
| D. | all of the mentioned |
| Answer» C. outer join | |
| 415. |
How many tables may be included with a join? |
| A. | one |
| B. | two |
| C. | three |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 416. |
Which are the join types in join condition: |
| A. | cross join |
| B. | natural join |
| C. | join with using clause |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 417. |
How many join types in join condition: |
| A. | 2 |
| B. | 3 |
| C. | 4 |
| D. | 5 |
| Answer» D. 5 | |
| 418. |
The operation which is not considered a basic operation of relational algebra is |
| A. | join |
| B. | selection |
| C. | union |
| D. | cross product |
| Answer» A. join | |
| 419. |
In SQL the statement select * from R, S is equivalent to |
| A. | select * from r natural join s |
| B. | select * from r cross join s |
| C. | select * from r union join s |
| D. | select * from r inner join s |
| Answer» B. select * from r cross join s | |
| 420. |
Which of the following creates a virtual relation for storing the query? |
| A. | function |
| B. | view |
| C. | procedure |
| D. | none of the mentioned |
| Answer» B. view | |
| 421. |
Materialised views make sure that |
| A. | view definition is kept stable |
| B. | view definition is kept up-to-date |
| C. | view definition is verified for error |
| D. | view is deleted after specified time |
| Answer» B. view definition is kept up-to-date | |
| 422. |
Updating the value of the view |
| A. | will affect the relation from which it is defined |
| B. | will not change the view definition |
| C. | will not affect the relation from which it is defined |
| D. | cannot determine |
| Answer» A. will affect the relation from which it is defined | |
| 423. |
Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause? |
| A. | with |
| B. | check |
| C. | with check |
| D. | all of the mentioned |
| Answer» C. with check | |
| 424. |
A consists of a sequence of query and/or update statements. |
| A. | transaction |
| B. | commit |
| C. | rollback |
| D. | flashback |
| Answer» A. transaction | |
| 425. |
In order to undo the work of transaction after last commit which one should be used? |
| A. | view |
| B. | commit |
| C. | rollback |
| D. | flashback |
| Answer» C. rollback | |
| 426. |
In case of any shut down during transaction before commit which of the following statement is done automatically? |
| A. | view |
| B. | commit |
| C. | rollback |
| D. | flashback |
| Answer» C. rollback | |
| 427. |
In order to maintain the consistency during transactions, database provides |
| A. | commit |
| B. | atomic |
| C. | flashback |
| D. | retain |
| Answer» B. atomic | |
| 428. |
A transaction completes its execution is said to be |
| A. | committed |
| B. | aborted |
| C. | rolled back |
| D. | failed |
| Answer» A. committed | |
| 429. |
Which of the following is used to get back all the transactions back after rollback? |
| A. | commit |
| B. | rollback |
| C. | flashback |
| D. | redo |
| Answer» C. flashback | |
| 430. |
will undo all statements up to commit? |
| A. | transaction |
| B. | flashback |
| C. | rollback |
| D. | abort |
| Answer» C. rollback | |
| 431. |
Which of the following is not an integrity constraint? |
| A. | not null |
| B. | positive |
| C. | unique |
| D. | check ‘predicate’ |
| Answer» B. positive | |
| 432. |
Domain constraints, functional dependency and referential integrity are special forms of |
| A. | foreign key |
| B. | primary key |
| C. | assertion |
| D. | referential constraint |
| Answer» C. assertion | |
| 433. |
Which of the following is the right syntax for the assertion? |
| A. | create assertion ‘assertion-name’ check ‘predicate’; |
| B. | create assertion check ‘predicate’ ‘assertion-name’; |
| C. | create assertions ‘predicates’; |
| D. | all of the mentioned |
| Answer» A. create assertion ‘assertion-name’ check ‘predicate’; | |
| 434. |
Data integrity constraints are used to: |
| A. | control who is allowed access to the data |
| B. | ensure that duplicate records are not entered into the table |
| C. | improve the quality of data entered for a specific property (i.e., table column) |
| D. | prevent users from changing the values stored in the table |
| Answer» C. improve the quality of data entered for a specific property (i.e., table column) | |
| 435. |
Dates must be specified in the format |
| A. | mm/dd/yy |
| B. | yyyy/mm/dd |
| C. | dd/mm/yy |
| D. | yy/dd/mm |
| Answer» B. yyyy/mm/dd | |
| 436. |
A 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. |
| A. | index |
| B. | reference |
| C. | assertion |
| D. | timestamp |
| Answer» A. index | |
| 437. |
Which of the following is used to store movie and image files? |
| A. | clob |
| B. | blob |
| C. | binary |
| D. | image |
| Answer» B. blob | |
| 438. |
The user defined data type can be created using |
| A. | create datatype |
| B. | create data |
| C. | create definetype |
| D. | create type |
| Answer» D. create type | |
| 439. |
Values of one type can be converted to another domain using which of the following? |
| A. | cast |
| B. | drop type |
| C. | alter type |
| D. | convert |
| Answer» A. cast | |
| 440. |
Which of the following closely resembles Create view? |
| A. | create table . . .like |
| B. | create table . . . as |
| C. | with data |
| D. | create view as |
| Answer» B. create table . . . as | |
| 441. |
In contemporary databases, the top level of the hierarchy consists of each of which can contain |
| A. | catalogs, schemas |
| B. | schemas, catalogs |
| C. | environment, schemas |
| D. | schemas, environment |
| Answer» A. catalogs, schemas | |
| 442. |
The database administrator who authorizes all the new users, modifies the database and takes grants privilege is |
| A. | super user |
| B. | administrator |
| C. | operator of operating system |
| D. | all of the mentioned |
| Answer» D. all of the mentioned | |
| 443. |
Which of the following is used to provide privilege to only a particular attribute? |
| A. | grant select on employee to amit |
| B. | grant update(budget) on department to raj |
| C. | grant update(budget,salary,rate) on department to raj |
| D. | grant delete to amit |
| Answer» B. grant update(budget) on department to raj | |
| 444. |
Which of the following is true regarding views? |
| A. | the user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view |
| B. | the user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view |
| C. | if a user creates a view on which no authorization can be granted, the system will allow the view creation request |
| D. | a user who creates a view receives all privileges on that view |
| Answer» C. if a user creates a view on which no authorization can be granted, the system will allow the view creation request | |
| 445. |
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the clause to the appropriate grant command. |
| A. | with grant |
| B. | grant user |
| C. | grant pass privelege |
| D. | with grant option |
| Answer» D. with grant option | |
| 446. |
Which of the following is used to avoid cascading of authorizations from the user? |
| A. | granted by current role |
| B. | revoke select on department from amit, satoshi restrict; |
| C. | revoke grant option for select on department from amit; |
| D. | revoke select on department from amit, satoshi cascade; |
| Answer» B. revoke select on department from amit, satoshi restrict; | |
| 447. |
The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation |
| A. | the privilege must be granted only by roles |
| B. | the privilege is granted by roles and users |
| C. | the user role cannot be removed once given |
| D. | by restricting the user access to the roles |
| Answer» A. the privilege must be granted only by roles | |
| 448. |
Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly? |
| A. | embedded sql |
| B. | dynamic sql |
| C. | sql declarations |
| D. | sql data analysis |
| Answer» B. dynamic sql | |
| 449. |
Which of the following header must be included in java program to establish database connectivity using JDBC ? |
| A. | import java.sql.*; |
| B. | import java.sql.odbc.jdbc.*; |
| C. | import java.jdbc.*; |
| D. | import java.sql.jdbc.*; |
| Answer» A. import java.sql.*; | |
| 450. |
Which of the following invokes functions in sql? |
| A. | prepared statements |
| B. | connection statement |
| C. | callable statements |
| D. | all of the mentioned |
| Answer» C. callable statements | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.