IBPS SO IT Officer is amongst the most reputed jobs in the Banking Sector and many Aspirants work hard to get this job. The exam for this post consists of various subjects other than the common subjects in Bank exams. Here we are providing you with a quiz based on Information Technology which will cover DBMS. Practice with the questions based on the most updated pattern.
Q1. In which clause tuple variables are define in SQL?
Group BY clause
All of the above
Tuple variables are defined in the FROM clause in SQL.
Q2. Which of the following allows you to specify multiple values in a WHERE clause?
The IN operator allows you to specify multiple values in a WHERE clause.
WHERE column_name IN (value1, value2, ...);
Q3. Which transaction property ensure that multiple transactions can occur concurrently without leading to inconsistency of database state?
Not any property ensures the transaction independency
If there are multiple transactions executing simultaneously, then all the transaction should be processed as if they are single transaction. But individual transaction in it should not alter or affect the other transaction. That means each transaction should be executed as if they are independent.
Q4. Which of the following allows to create complex entities from existing entities and relationships?
Aggregation allows creating complex entities from existing entities and relationship. Aggregation is the way used to abstracting a larger amount object.
Q5. which of the following is a view of the database that appears to an application program?
A sub-schema is a subset of the schema having the same properties that a schema has. It identifies a subset of areas, sets, records and data names defined in the database schema available to user sessions. The sub-schema allows the user to view only that part of the database that is of interest to him.
Q6.'REVOKE' command is used in which category of SQL statement?
None of these
DCL is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.
GRANT to allow specified users to perform specified tasks.
REVOKE to cancel previously granted or denied permissions.
Q7. Which clause is used to specify condition while retrieving data from table in SQL?
The WHERE clause is used to extract only those records that fulfill a specified condition.
Q8. Derived attribute in E-R Diagram represented by:
A derived attribute is based on another attribute. For example, an employee's monthly salary is based on the employee's annual salary.
Q9. Which of the following type of anomalies are not found in relational database?
None of these
Anomalies are problems that can occur in poorly planned, un-normalized databases where all the data is stored in one table (a flat-file database). There is three types of anomalies in database- Insertion Anomalies, Update Anomalies and Deletion Anomalies.
Q10. Which normal form is considered suitable for design a normal relational database?
A relational database table is often described as “normalized” if it is in the 3rd Normal Form because most of the 3NF tables are free of insertion, update, and deletion anomalies.
Q11.How can you return all the records from a table named "Student" sorted descending by "FirstName", in SQL?
SELECT * FROM Student ORDER BY FirstName DESC
SELECT * FROM Student SORT BY 'FirstName'DESC
SELECT * FROM Student ORDER FirstName DESC
SELECT * FROM Student SORT 'FirstName'DESC
SELECT ALL FROM Student ORDER FirstName DESC
The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.
ORDER BY column1,column2.....ASC|DESC
Q12.The ability to modify the internal schema without causing any change to the external schema:
Physical data independence
Logical data independence
External data independence
Both Physical and External data independence
None of these
Physical Data Independence the ability to modify the way database stored (data structures, file organization, etc. - internal view of a database) without affecting the next higher level conceptual schema is the physical data independence.
Q13. Which key is representing relationship between tables?
None of these
All of these
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.
Q14.Which level of database architecture representing total view of database?
None of these
Conceptual level describes the structure of the whole database for a group of users. Conceptual schema is a representation of the entire content of the database. These schemas contain all the information to build relevant external records. It hides the internal details of physical storage.
Q15.Which operator is used to select values within a range?
The BETWEEN operator selects values within a given range. The values can be numbers, text, or dates.
WHERE column_name BETWEEN value1 AND value2;