INTERVIEW QUS ON PL-SQL

-

 

1> In the context of data warehousing, data map or 'data about data' is known as ....a) tupleb) attributec) metadatad) teradataAns: C) metadata

2> Which of the following normal form deals with the anomaly of multivalue dependency?a) 1NFb) 2NFc) 4NFd) 5NFAns: c) 4NF

3> Which of the following normal form deals with the repeating group anomaly?a) 1NFb) 2NFc) 4NFd) 5NFAns: a) 1NF

4> ___ is a database language used to define data structures in SQL?a) Sybaseb) Oraclec) DDLd) MySQLAns: c) DDL

5> The ___ is a database file that contains metadata.a) data indexb) data repositoryc) data dictionaryd) noneAns: a) data index

6> Which of the following is not the state of a transaction in the database?a) Activeb) Committedc) Terminatedd) NullifiedAns: d) Nullified

7> The __ file saves the recovery scenario in Quick Test Professional (QTP) environment.a) QRSb) JPEGc) DOCd) TSRAns: a) QRS

8> Which of the following is not a command in SQL?a) WHEREb) ORDER BYc) REMOVEd) SELECTAns: c) REMOVE

9> How should we traverse an oracle database to retrieve a row in the quickest possible time?a) Full table scanb) Unique indexc) Primary keyd) Table access by row idAns: d) Table access by row id

10> Which of the following is a concurrency control protocol?a) Locked-based protocolb) two-phase locking protocolc) Timestamp ordering protocold) allAns: d) all

11> Which of the following normal forms deals with the anomaly of partial functional dependency on the composite key?a) 1NFb) 2NFc) 4NFd) 5NFAns: b) 2NF

12> ___ represents the structure of the database in a formal language acceptable by the DBMS.a) Database Schemab) ER diagramc) Database tabled) NoneAns: a) Database Schema   

13> Which of the following statements are used to create indexes in the database?a) Create Indexb) build Indexc) Write Indexd) NoneAns: a) Create Index

14> Which of the following is a database recovery technique?a) Check-pointingb) Transaction rollbackc) Shadow pagingd) AllAns: d) All

15> Which of the following is a foreign key constraint?a) Referential integrityb) Domain integrityc) Entity integrityd) AllAns: a) Refernital intefrity

16> Which of the following trains are important to select a primary key?a) Uniqueb) Not nullc) Fully functional dependencyd) Indexede) AllAns: e) All

17> Which are various types of DBMS?a) ORDBMSb) Client server DBMSc) Distributed DBMSd) OODBMSe) ALLAns: e) All

18> Which of the following are the types of integrity constraints enforced by RDBMS?a) Entity integrityb) Domain integrityc) Referential Integrityd) AllAns: d) All

Read online for FREE.

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

WRITE A 8085 ASSEMBLY LANGUAGE PROGRAM TO DIVIDE TWO 8-BIT NUMBERS USING 8085 MICROPROCESSOR AND PERFORM THE OPERATION BETWEEN PREDEFINED LOCATION. 3:2

-
  THEORY :       In 8085 microprocessor, There is no division operation. To get the result of the division, we should use the repetitive subtraction method. By using this program, we will get the quotient and the reminder. Here we also can be store the carry value. Then store the value of that performed resultant value. ALGORITHM : Step 1: LXI H,2000h; to point source memory location, register pair H-L is initialized.Step 2: MOV A, M; to move the value of memory to the accumulator.Step 3: INX H; to increment the value by 1 for the H-L register pair.Step 4:  MOV B, M; to move the value of memory to the B register.Step 5: MVI C,00h; to load the value 00h in register C.Step 6: CMP B; to compare the value of the accumulator and the B register.Step 7: JC ; to jump on carry in step 11.Step 8: SUB B; to subtract the accumulator and B register value.Step 9: INR C; to increment the value of C register.Step 10: JMP; to jump on step 6 Step 11: INX H; to incre...
Read more

XAMPP PL/SQL INSERT, UPDATE, DELETE & SELECT INTO [ SET 3]

-
  In this tutorial, we are going to learn how to use SQL in PL/SQL . SQL is the actual component that takes care of fetching and updating of data in the database whereas PL/SQL is the component that processes these data. Further, in this article, we will also discuss how to combine the SQL within the PL/SQL block. YOU MIGHT LIKE: https://www.shoutcoders.com/xamppsqlset2/ https://www.shoutcoders.com/sqlexampleset1/ EXAMPLE 3: 1> Create the following tables: i ) Hotel (H_no, Name, Address) create table Hotel (H_no char(4), Name varchar(20), address varchar(20)) OUTPUT: Table created. ii) Room (R_no, Rtype, H_no, Price) create table Room (R_no char(4), Rtype char(6), H_no char(4), Price int(6)); OUTPUT: Table Created. iii) Book (H_no, G_no, R_no, Dt_from, Dt_to ) create table Book (H_no char(4), G_no char(4), R_no char(6), dtfrom date, dtto date) OUTPUT: Table Created. iv) Guest (G_no, G_name, G_address) create table guest (...
Read more

INFIX TO POSTFIX AND POSTFIX EVALUATION (PYTHON)

-
 Stack Expressions : INFIX TO POSTFIX AND POSTFIX EVALUATION Infix to Postfix Conversion  Infix expression: The expression of the form a op b. When an operator is in-between every pair of operands.  Postfix expression: The expression of the form a b op. When an operator is followed for every pair of operands.  Algorithm: 1. Scan the infix expression from left to right. 2. If the scanned character is an operand, output it. 3. Else,     3.1 If the precedence of the scanned operator is greater than the precedence of the     operator in the stack(or the stack is empty or the stack contains a ‘(‘ ), push it.     3.2 Else, Pop all the operators from the stack which are greater than or equal to in     precedence than that of the scanned operator. After doing that Push the scanned operator     to the stack. (If you encounter parenthesis while popping then stop there and push the  ...
Read more

OPERATING SYSTEM MCQ

-
  Which of the following is an example of a spooled device? a. A line printer used to print the output of a number of jobs. b. The terminal used to enter the input data for a Fortran program being executed. c. The secondary memory device in a virtual memory system. d. The swapping area on a disk used by the swapper. In spooling (Simultaneous Peripheral Operation On Line), a buffer is interposed between a running program and a slow-speed device involved with the program for input/output. For example, instead of writing lines directly to the line printer, the lines are written (temporarily) onto a disk. Thus, the program is allowed to run to completion without waiting for the (slow) printer to finish. When the printer becomes free, the lines can be printed from the disk file. 2. Which of the following is not normally contained in the directory entry of a file? a. Creation date. b. Access control list. c. A count of the number of free blocks in the disk. d. Filename an...
Read more

AUTOMATA DEFINITIONS

-
 AUTOMATA DEFINITIONS THIS SUBJECT IS FULLY BASED ON EXAMPLES, DEFINITIONS, GRAMMAR RULES, DIAGRAMS AND THEOREMS. IMPORTANT DEFINITIONS:  DFA:    A Deterministic Finite State Automaton (DFSA) is denoted by M and it is a set of 5-tuples i.e. M=(Q, Σ, δ, q 0 , F) where, * Q is a non-empty finite set of states * Σ is a non-empty finite set of input symbols *  q 0 is the initial state or starting state. (q0 ∈ Q) * F is a non-empty finite set of final state. (F ⊆ Q). * δ (pronounce delta) is the transition function. Q x Σ → Q. δ(q,a) = p means, if  the automation is in state q and reading a symbol a, it goes to state p in the next instant, moving the pointer one cell to the right. NDFA:    A Non-Deterministic Finite State Automaton (NFSA) is denoted by M and it is a set of 5-tuples i.e. M=(Q, Σ, δ, q 0 , F) where, * Q is a non-empty finite set of states * Σ is a non-empty finite set ...
Read more

Survey Paper

-
 Websites:   scholar.google, microsoft academic, scienceDirect, Publmed, ieee, refseek, web of science  Smartphone based human activity monitoring and recognition using ML and DL: a comprehensive survey => my goal to make this,,, 1st.2nd.3rd.etc Gen, Desc, pic, how communication done, pros and cons, diagram of users, top algorithms used to improvements, most useful sensors and benefit of it, top inventors, diagram of users, Machine learning and Data analysis how much improves , ... future plans in improvement from Google and big companies, conclusion , references from acticles and google search. Abstract POINTS * Human activity monitoring and recognition (HAMR) based on smartphone sensor data is a feld that promotes a lot of obsevation in current era due to its notable desire in various Ambient Intelligent applications such as healthcare, sports, surveillance, and remote health monitoring. *  In this context, many research works have unveiled incredible resul...
Read more

STACK DATA STRUCTURE

-
    What is Stack Data Structure? Stack is an abstract data type with a bounded(predefined) capacity. It is a simple data structure that allows adding and removing elements in a particular order. Every time an element is added, it goes on the top of the stack and the only element that can be removed is the element that is at the top of the stack, just like a pile of objects.  Basic features of Stack  1. Stack is an ordered list of similar data type. 2. Stack is a LIFO(Last in First out) structure or we can say FILO(First in Last out). 3. push() function is used to insert new elements into the Stack and pop() function is used to remove an element from the stack. Both insertion and removal are allowed at only one end of Stack called Top. 4. Stack is said to be in Overflow state when it is completely full and is said to be in Underflow state if it is completely empty.  Applications of Stack  The simplest application of a stack is to reverse a word. You pus...
Read more

MAKING POWERPOINT SLIDES

-
Making PowerPoint Slides Avoiding the Pitfalls of Bad Slides   Tips to be Covered    Outlines  Slide Structure  Fonts  Color  Background  Graphs  Spelling and Grammar  Conclusions  Questions   Outline    Make your 1 st or 2 nd slide an outline of your presentation – Ex: previous slide  Follow the order of your outline for the rest of the presentation  Only place main points on the outline slide – Ex: Use the titles of each slide as main points     Slide Structure – Good    Use 1-2 slides per minute of your presentation  Write in point form, not complete sentences  Include 4-5 points per slide  Avoid wordiness: use key words and phrases only     Slide Structure - Bad   This page contains too many words for a presentation slide. It is not written in point form, making it difficult both for your audience to read and for you to present each point. Although there are exactly the same number of points on this slide a...
Read more

Test Node js ( API Creating and Test in Postman )

-
  BACKEND MACHINE TEST F.M: 50 TIME: 1 HR 30 MIN Question: 1 You have a develop API with CRUD OPERATION and test that API using POSTMAN TOOL: NOTE: CREATE A NEW APP FOR THE API CREATION AND INSTALL THE DEPENDENCY REQUIRED FOR API CREATION. NOTE THE BELOW POINTS:  CREATE A MODAL SCHEMA FOR RAILINFO :  Fields :  { _id:’’ , train_no:’’ , train_name:’’ , src_station:’’,dest_station:’’,platform_no:’’,dep_time:’’,arr_time:’’}  CREATE THE CONTROLLER FOR THE BELOW OPERATIONS ON API :  FETCH ALL TRAIN INFO  FIND SPECIFIC TRAIN INFO based on src_station , dest_station  INSERT TRAIN INFO  UPDATE TRAIN INFO based on train_no  DELETE TRAIN INFO based on train _id  CREATE THE PROPER ROUTING FOR API.  TEST EACH ENDPOINTS USING POSTMAN and provide the screenshots Attached.  Task Overview: You need to develop an API that supports CRUD operations (Create, Read, Update, Delete) for train information. The API will be tested using the Postman tool. The steps below will guide you through...
Read more