Assistant System Manager

Assistant System Manager Interview Questions and Answers

Updated 1 Sep 2024

Q1. what is the difference between delete and truncate

Ans.

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 the table while truncate resets the identity of the table...read more

Ans.

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.

Ans.

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.
Java is better suited for large enterprise applications with ...read more

Ans.

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.

Are these interview questions helpful?

Ans.

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 PostgreSQL, while examples of NoSQL databases include MongoD...read more

Ans.

A router is a networking device that forwards data packets between computer networks.

Share interview questions and help millions of jobseekers 🌟

Ans.

A switch is a networking device that connects devices on a computer network by using packet switching to forward data to the appropriate destination.

Switches operate at the data link layer of the OSI model
They use MAC addresses to forward data to the correct destination
Switches can create multiple collision domains and improve network performance
Examples of switches include Cisco Catalyst series, Netgear ProSAFE series, etc.