NEW
Font size
Worksheetscpe.120.fe
Total questions: 40
Worksheet time: 30mins
Why the following statement is erroneous?
SELECT dept_name, ID, avg(salary)
FROM instructor
GROUP BY dept_name;
Dept_id should not be used in group by clause
Group by clause is not valid in this query
Avg(salary) should not be selected
None of the choices
Which of the following is not the utility of DBMS?
i) Backup ii) Loading iii) Process Organization iv) File organization
i, ii, and iv only
i, ii and iii only
i, iii and iv only
i, iii and iv only
Which of the following is not correct according to the technology deployed by DBMS?
i) Pointers are used to maintain transactional integrity and consistency
ii) Cursors are used to maintain transactional integrity and consistency
iii) Locks are used to maintain transactional integrity and consistency
iv) Triggers are used to maintain transactional integrity and consistency
i, ii, and iv only
i, ii, and iii only
all i, ii, iii, and iv
ii, iii, and iv only
Evaluate the statements issued by the DBA in the given sequence if OE and SCOTT are the users and the ORDERS table is owned by OE.
CREATE ROLE r1;
GRANT SELECT, INSERT ON oe.orders TO r1;
GRANT r1 TO scott;
GRANT SELECT ON oe.orders TO scott;
REVOKE SELECT ON oe.orders FROM scott;
What would be the outcome after executing the statements?
The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1
The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1
SCOTT would be able to query the OE.ORDERS table
SCOTT would not be able to query the OE.ORDERS table
What is the correct sequence to create a database connection?
i. Import JDBC packages.
ii. Open a connection to the database.
iii. Load and register the JDBC driver.
iv. Execute the statement object and return a query resultset.
v. Create a statement object to perform a query.
vi. Close the resultset and statement objects.
vii. Process the resultset.
viii. Close the connection.
i, ii, iii, v, iv, vii, viii, vi
i, iii, ii, v, iv, vii, vi, viii
ii, i, iii, iv, viii, vii, v, vi
i, iii, ii, iv, v, vi, vii, viii
What does setAutoCommit(false) do?
It will not commit transactions automatically after each query
It explicitly commits the transaction.
It never commits the transactions.
It does not commit transaction automatically after each query.
What should be the correct order to close the database resource?
Connection, Statements, and then ResultSet
ResultSet, Connection, and then Statements
Statements, ResultSet, and then Connection
ResultSet, Statements, and then Connection
Which of the following is not a type of ResultSet object?
TYPE_FORWARD_ONLY
CONCUR_WRITE_ONLY
TYPE_SCROLL_INSENSITIVE
TYPE_SCROLL_SENSITIVE
Which of the following is the correct to register a JdbcOdbcDriver?
jdbc.odbc.JdbcOdbcDriver obj = new sun.jdbc.odbc.JdbcOdbcDriver();
odbc.JdbcOdbcDriver obj = new sun.odbc.JdbcOdbcDriver();
jdbc.JdbcOdbcDriver obj = new sun.jdbc.JdbcOdbcDriver();
jdbc.odbc.JdbcOdbc obj = new sun.jdbc.odbc.JdbcOdbc();
Which statement is correct if we want to connect the Oracle database using the thin driver provided by Oracle Corp.?
getConnection("jdbc::thin@localhost:1521:oracle", "scott", "tiger");
getConnection("jdbc:thin@localhost:1522:oracle", "scott", "tiger");
getConnection("jdbc::thin@localhost:1522:oracle", "scott", "tiger");
getConnection("jdbc::oracle@localhost:1521:thin", "scott", "tiger");
Are ResultSets updateable?
Yes, but only if we call the method openCursor() on the ResultSet and if the driver and database support this option.
Yes, but only if we indicate a concurrency strategy when executing the statement, and if the driver and database support this option.
Yes, but only if the ResultSet is an object of class UpdateableResultSet and if the driver and database support this option.
No, ResultSets are never updateable. We must explicitly execute a DML statement to change the data in the underlying database.
Which statement(s) is/ are true about transactions?
i. A transaction is a set of one or more SQL statements that make up a logical unit of work.
ii. A transaction ends with either a commit or a rollback, depending on whether there are any problems with data consistency or data concurrency.
iii. A lock is a mechanism that allows two transactions from manipulating the same data at the same time.
iv. To avoid conflicts during a transaction, a DBMS uses locks, mechanisms for blocking access by others to the data that is being accessed by the transaction.
Only i and ii
Only i and iii
Only i, ii, and iv
All the choices
What is the purpose of Alt + W key in Tally?
Change the financial period
Invoke tally reference manual
Open default web browser
Exist tally without confirmation
Which of the following browsers were/are available for Macintosh?
Opera
Safari
Netscape
All of the choices
Which of the following are alternative names for mobile browsers?
Microbrowser
Wireless internet browser
Minibrowser
All of the choices
Which of the following browser has high speed browsing capacity
Chrome
Opera
UC browser
Lynx
Which of the following is a traditional method for emulating the processor?
SDS
ICE
CPU simulator
Low-level language simulator
Which of the following allow access to all the hardware within the system?
Debugger
JTAG
Onboard debugger
Simulator
How the additional registers are accessed in the OnCE?
Parallel port
Serial port
JTAG
Address register
Which of the following emulators can provide its own circuit emulation facility?
Simulator
Debugger
SDS
OnCE
Which of the following takes the processor, when the processors enters the BDM mode?
Address code
High-level microcode
Low-level microcode
Data code
Which of the following has the additional circuitry which supports the background debug mode?
Memory
Input
Peripheral
Processor
The local operating system on the server machine passes the incoming packets to the
Server client stub
Client stub
Server stub
Client operating system
A database server is responsible for which of the following?
Database storage
Data processing logic
Data presentation logic
All of the choices
A server cannot serve on which of the following levels?
Client layer
Business layer
Database layer
All of the choices
Which of the following is true concerning the mainframe?
It is the same thing as client/server.
Requires someone to decide which code should be on the workstation or the server.
Mission-critical systems have tended to remain there
All of the choices
Which of the following web applications can be deployed with Azure?
A company wants to use cloud services in the future. What needs to be done first?
Ask the IT department to work out a plan to reduce capital expenses using cloud services.
Analyze existing business processes and determine which of them can be realized using cloud services.
Use cloud migration services to move their production workload into a managed cloud.
Ask the IT department to order multiple virtual machines from different cloud service providers and test them for performance.
Which of these should a company consider before implementing cloud computing technology?
Employee satisfaction
Potential cost reduction
Information sensitivity
All of the choices
Big Five personality characteristics are for cloud computing
Agreeableness, Conscientiousness, Value conscious, Physical Strength, Kindness
Agreeableness, Conscientiousness, Extraversion, Emotional range, Openness
Extraversion, Emotional range, Openness, Kindness, Social values
Conscientiousness, Extraversion, Emotional range, Kindness
What is comprised of millions of smart devices and sensors connected to the internet?
IoT
Cloud Computing
Block Chain
Artificial Intelligence
What type of device could allow a refrigerator to place a replacement order for an item
contained within it?
Sensor
Actuator
Battery
Switch
…………… is a computer which can do all the operations like a conventional computer.
Sensor
Actuator
Amplifier
Switch
Which of these is NOT related to IoT scalability?
Flexible within the Internet
Large scale deployment
Real-time connectivity of billions of devices
Range of Sensor node
Which of the following is true?
IoT is a subset of M2M
M2M is a subset of IoT
IoT is a subset of CPS
CPS is a subset of Web of Things (WoT)
Which of these statements regarding sensors are TRUE?
Sensors are input devices
Sensors can be analog or digital
Sensors respond to some external stimuli
All the choices
IoT refers to:
Interconnections of devices in a network
Exchange of data between devices in a network/span>
An ecosystem of devices, accessible through internet
All the choices
……………… was First IoT enabled device appeared in the Market
Refrigerator
Toaster
Television
Radio
Who invented the term the Internet of Things?
Bill Gates
Steve Jobs
Kevin Ashton
McDonald
What allows digital devices to interconnect and transmit data?
a sensor
a global positioning sensor
a smart phone
a network
