Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel

Identify the DBMS among the following. (1) MS-Access (2) MS-Power Point (3) PL/SQL (4) MS-Excel
by

1 Answer

Answer :

PL/SQL
by

Related questions

The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most open source DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : MySQL

The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Description : The most popular commercial DBMS. A) Microsoft SQL Server B) Microsoft Access C) MySQL D) Oracle

Last Answer : Oracle

.docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Description : .docx is the file extension for: a) MS Power Point b) MS Excel c) MS Word d) None of These

Last Answer : c) MS Word

Slides prepares in: a) MS Word b) MS Power Point c) MS Excel d) None of These

Description : Slides prepares in: a) MS Word b) MS Power Point c) MS Excel d) None of These

Last Answer : a) Data Base Management System

Presentations made on: a) MS Word b) MS Excel c) MS Power Point d) None of These

Description : Presentations made on: a) MS Word b) MS Excel c) MS Power Point d) None of These

Last Answer : c) MS Power Point

I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?

Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?

Does anyone here have experience working with PL/SQL? I need some help getting started...

Description : Does anyone here have experience working with PL/SQL? I need some help getting started...

Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.

What is the basic structure of PL/SQL ?

Description : What is the basic structure of PL/SQL ?

Last Answer : PL/SQL uses block structure as its basic structure. Anonymous blocks or nested blocks can be used in PL/SQL.

What are the datatypes a available in PL/SQL ?

Description : What are the datatypes a available in PL/SQL ?

Last Answer : Some scalar data types such as NUMBER, VARCHAR2, DATE, CHAR, LONG, BOOLEAN. Some composite data types such as RECORD & TABLE.

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Description : You have just compiled a PL/SQL package but got errors, how would you view the errors?

Last Answer : SHOW ERRORS

What command would you use to encrypt a PL/SQL application?

Description : What command would you use to encrypt a PL/SQL application?

Last Answer : WRAP

How you were passing cursor variables in PL/SQL 2.2?

Description : How you were passing cursor variables in PL/SQL 2.2?

Last Answer : In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Description : Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

Last Answer : No, a cursor variable points a row which cannot be stored in a two- dimensional PL/SQL table.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

Last Answer : Procedures and Functions,Packages and Database Triggers.

What are the cursor attributes used in PL/SQL ?

Description : What are the cursor attributes used in PL/SQL ?

Last Answer : %ISOPEN - to check whether cursor is open or not % ROWCOUNT - number of rows fetched/updated/deleted. % FOUND - to check whether cursor has fetched any row. True if rows are ... featched. These attributes are proceeded with SQL for Implicit Cursors and with Cursor name for Explicit Cursors.

What are the components of a PL/SQL block ?

Description : What are the components of a PL/SQL block ?

Last Answer : A set of related declarations and procedural statements is called block.

What are the components of a PL/SQL Block ?

Description : What are the components of a PL/SQL Block ?

Last Answer : Declarative part, Executable part and Exception part.Datatypes PL/SQL

What are the PL/SQL Statements used in cursor processing ?

Description : What are the PL/SQL Statements used in cursor processing ?

Last Answer : DECLARE CURSOR cursor name, OPEN cursor name, FETCH cursor name INTO or Record types, CLOSE cursor name.

Explain how procedures and functions are called in a PL/SQL block ?

Description : Explain how procedures and functions are called in a PL/SQL block ?

Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');

Question What is PL/SQL ?

Description : Question What is PL/SQL ?

Last Answer : PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching.

What are the two panes that Appear in the design time pl/sql interpreter?

Description : What are the two panes that Appear in the design time pl/sql interpreter?

Last Answer : 1. Source pane. 2. Interpreter pane

What are three panes that appear in the run time pl/sql interpreter?

Description : What are three panes that appear in the run time pl/sql interpreter?

Last Answer : 1. Source pane. 2. interpreter pane. 3. Navigator pane.

Where is a procedure return in an external pl/sql library executed at the client or at the server?

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Python has a SQL-like querylanguage called ________- a) GQL b) PL SQL c) NOSQL d) JDBC

Description : Python has a SQL-like querylanguage called ________- a) GQLb) PL SQL c) NOSQL d) JDBC

Last Answer : GQL

What is the significance of the & and && operators in PL SQL ?

Description : What is the significance of the & and && operators in PL SQL ?

Last Answer : The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously ... span across different rollback segments or will it terminate ? It will terminate (Please check ).

Can you have two functions with the same name in a PL/SQL block

Description : Can you have two functions with the same name in a PL/SQL block

Last Answer : Yes.

Does PL/SQL support “overloading”? Explain

Description : Does PL/SQL support “overloading”? Explain

Last Answer : The concept of overloading in PL/SQL relates to the idea that you can define procedures and functions with the same name. PL/SQL does not look only at the referenced name, however, ... Prefacing a procedure or function name with the package name fully qualifies any procedure or function reference.

It is better to use files than a DBMS when there are (A) Stringent real-time requirements. (B) Multiple users wish to access the data. (C) Complex relationships among data. (D) All of the above. t

Description : It is better to use files than a DBMS when there are (A) Stringent real-time requirements. (B) Multiple users wish to access the data. (C) Complex relationships among data. (D) All of the above.

Last Answer : (B) Multiple users wish to access the data.

Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Description : Which of the following is a programming language? A) Lotus B) Pascal C) MS-Excel D) Netscape

Last Answer : Answer : B

The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Description : The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Last Answer : (C) Visicalc

Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Description : Ctrl + Page up (In Ms - Excel) is used for: a) Move to the previous worksheet in the workbook b) Insert a new worksheet into the current workbook c) Select the current worksheet and the next worksheet d) None of These

Last Answer : a) Move to the previous worksheet in the workbook

In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Description : In MS - Excel, Move to the next worksheet in the workbook can be done through: a) Ctrl + Page Down b) Ctrl + Page Up c) Ctrl + F3 d) None of These

Last Answer : a) Ctrl + Page Down

In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Description : In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Last Answer : a) Ctrl + Shift + Down Arrow Key

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Description : In MS -Excel, option of NEW is available under which of the following menu: a) Insert b) Home c) File d) None of These

Last Answer : c) File

Ms Excel version 5 was launched in: a) 1992 b) 1993 c) 1995 d) None of These

Description : Ms Excel version 5 was launched in: a) 1992 b) 1993 c) 1995 d) None of These

Last Answer : b) 1993

What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Description : What is created when you use F11 shortcut key while creating a chart in MS Excel: a) A default chart b) A 2 dimensional column chart c) A 2 dimensional bar chart d) A 3 dimensional line chart e) None of The Above

Last Answer : b) A 2 dimensional column chart

In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Description : In MS-EXCEL, for Moves the current selected range down a row, you will press: a) Shift + Up Arrow Key b) Shift + Down Arrow Key c) Ctrl + Down Arrow Key d) None of These

Last Answer : b) Shift + Down Arrow Key

In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Description : In MS-Excel, ______ provide a visual representation of the values in a worksheet. (1) Charts (2) Formulae (3) Templates (4) Views

Last Answer : Charts

. Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Description : . Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Last Answer : d. SQL Injection attack

Why can I not install MS SQL Server Express 2008 R2?

Description : Why can I not install MS SQL Server Express 2008 R2?

Last Answer : Please provide details on what and how it fails the precheck.

Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

MS-SQL stores data in a ........................ file format. A) .DAT B) .MDB C) .MSSQL D) .OBJ

Description : MS-SQL stores data in a ........................ file format. A) .DAT B) .MDB C) .MSSQL D) .OBJ

Last Answer : A) .DAT

Which of the following is an example of presentation software? a. Ms-Access b. Spreadsheet c. Power-point d. Word processing

Description : Which of the following is an example of presentation software? a. Ms-Access b. Spreadsheet c. Power-point d. Word processing

Last Answer : c. Power-point

Which of the following is an example of presentation software? a. Ms-Access b. Spreadsheet c. Power-point d. Word processing

Description : Which of the following is an example of presentation software? a. Ms-Access b. Spreadsheet c. Power-point d. Word processing

Last Answer : c. Power-point

Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Description : Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Last Answer : What kind of results are you looking for ? I.e. what are you comparing between test1 and test2 ? Also, I’m not sure I understand what are ‘value points’ ? And when you say ‘group all the students’ do you mean counts of students that got that level of score on the test?

MS Excel Help: Calculate Amount of Time?

Description : MS Excel Help: Calculate Amount of Time?

Last Answer : If your timestamps are in columns A and B, I'd imagine this would do the trick: =B1-A1 and then make sure to set the cell format to time, showing the difference in minutes and seconds. Just tested with this: timestamp A ... = custom: dd/mm/yyyy hh:mm:ss) =B-A: 0:29:57 (cell format = custom: h:mm:ss)

How do I automatically add the date to a MS Excel cell?

Description : How do I automatically add the date to a MS Excel cell?

Last Answer : You would want a macro, or if you hit Ctrl+; it automatically puts in the current date in the selected cell, and you can add the called left message afterward If you want to do a macro, you can record ... need to edit the macro to work for each line. So it might be easier to use the Ctrl+; shortcut

How to track timings in MS Excel?

Description : How to track timings in MS Excel?

Last Answer : Use a Custom format of ‘hh:mm:ss.000’