State Bank of India Assistant System Manager Interview Questions, Process, and Tips

Delete removes specific rows from a table while truncate removes all rows from a table.

• Delete is a DML command while truncate is a DDL command.

• Delete is slower than truncate as it logs each row deletion while truncate does not.

• Delete can be rolled back while truncate cannot be rolled back.

• Delete can have a WHERE clause to specify which rows to delete while truncate deletes all rows.

• Delete does not reset the identity of...read more

Node.js is faster, more scalable, and easier to learn than Java.

• Node.js is built on Chrome's V8 JavaScript engine, which is faster than Java's JVM.

• Node.js uses an event-driven, non-blocking I/O model, making it more scalable than Java.

• Node.js has a simpler and more intuitive syntax, making it easier to learn than Java.

• Node.js has a large and active community, with many open-source libraries and frameworks available.

• Jav...read more

The latest version of Oracle is Oracle Database 21c.

• Oracle Database 21c was released in January 2021.

• It includes new features such as blockchain tables and persistent memory support.

• It also has improved security and performance enhancements.

• Previous versions include Oracle Database 19c and Oracle Database 18c.

Namespace is a way to organize code and avoid naming conflicts in Python.

• A namespace is a mapping between names and objects.

• Python uses namespaces to avoid naming conflicts and to provide a way to access objects.

• Namespaces can be nested, and objects can be accessed using dot notation.

• Python has built-in namespaces, such as the global namespace and local namespace.

• Modules and classes also have their own namespaces.

SQL databases are relational and structured, while NoSQL databases are non-relational and unstructured.

• SQL databases use tables with predefined schema, while NoSQL databases use documents, key-value pairs, or graphs.

• SQL databases are better suited for complex queries and transactions, while NoSQL databases are better for handling large amounts of unstructured data.

• Examples of SQL databases include MySQL, Oracle, and Po...read more